Answer question on word files and excel files
anna520
F19Hrt4740Assign3Fig1.xlsxOverview13
| HRT 4740 | Team Assignment #3 | Financial Overview Information | ||
| Fall | 2019 | Section | ||
| Country? | ||||
| Section | 2:30 PM | 4:00 PM | 5:30 PM | Highlight the time of your section |
| Name | Darden | Chosen Co. | Marriott | Sources |
| Stock Symbol | DRI | MAR | https://investor.darden.com/investors/investor-relations/default.aspx | |
| Traded on | NYSE | NASDAQ | Chosen company web site | |
| https://marriott.gcs-web.com | ||||
| Overview ( 5 pts) | Darden | Chosen Co. | Marriott | |
| Employees | https://finance.yahoo.com/quote/DRI/profile?p=DRI | |||
| Properties | Chosen company information on Yahoo Finance | |||
| Revenues | https://finance.yahoo.com/quote/MAR/profile?ltr=1 | |||
| Fiscal Year Ends | ||||
| Profitability & Management Effectiveness (4 pts) | Darden | Chosen Co. | Marriott | |
| Profit Margin % | https://finance.yahoo.com/quote/DRI/key-statistics?p=DRI | |||
| Operating Margin % | Chosen company information on Yahoo Finance | |||
| Return on Assets % | https://finance.yahoo.com/quote/MAR/key-statistics?p=MAR | |||
| Return on Equity % | ||||
| Valuation Measures (4 pts) | Darden | Chosen Co. | Marriott | You will continue to work with the Statistics pages for each company |
| Market Cap | ||||
| Classification (small, mid, or large) | https://www.investopedia.com/terms/s/small-cap.asp | |||
| Forward P/E (fye-fiscal year end) | ||||
| PEG Ratio (5 year expected) | https://www.investopedia.com/terms/p/pegratio.asp | |||
TradingBeta7
| HRT 4740 | Team Assignment #3 | Financial Trading Information | ||
| Fall | 2019 | Section | ||
| Country? | ||||
| Section | 2:30 PM | 4:00 PM | 5:30 PM | Highlight the time of your section |
| Name | Darden | Chosen Co. | Marriott | Sources |
| Stock Symbol | DRI | MAR | https://investor.darden.com/investors/investor-relations/default.aspx | |
| Traded on | NYSE | NASDAQ | Chosen company web site | |
| https://marriott.gcs-web.com | ||||
| Trading Information (4 pts) | Darden | Chosen Co. | Marriott | You will continue to work with the Statistics pages for each company |
| 52 Week Change | https://finance.yahoo.com/quote/DRI/key-statistics?p=DRI | |||
| Chosen company web site | ||||
| https://finance.yahoo.com/quote/MAR/key-statistics?p=MAR | ||||
| S&P 500 52 Week Change | The S&P 500 52 Week Change represents the change in the value of the S&P 500.This will be the same number for all three companies. | |||
| Shares Outstanding | ||||
| % Held by Institutions | ||||
| Beta Information (3 pts) | Darden | Chosen Co. | Marriott | Look at the Summary page |
| Beta | https://finance.yahoo.com/quote/DRI?p=DRI | |||
| Chosen company web site | ||||
| Date you looked up Beta | https://finance.yahoo.com/quote/MAR/?p=MAR |
Comparisons5
| HRT 4740 | Team Assignment #3 | Financial Comparisons Information | ||
| Fall | 2019 | |||
| Country? | ||||
| Section | 2:30 PM | 4:00 PM | 5:30 PM | Highlight the time of your section |
| DJIA | https://finance.yahoo.com/quote/%5EDJI/history?period1=1539586800&period2=1571122800&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 25,250.55 | |||
| 10/15/19 | $ 27,024.80 | |||
| $ change | $ 1,774.25 | |||
| % change | 7.03% | |||
| NASDAQ | https://finance.yahoo.com/quote/%5EIXIC/history?period1=1539586800&period2=1571122800&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 7,430.74 | |||
| 10/15/19 | $ 8,148.71 | |||
| $ change | $ 717.97 | |||
| % change | 9.66% | |||
| S&P 500 | https://finance.yahoo.com/quote/%5EGSPC/history?period1=1539586800&period2=1571122800&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 2,750.79 | |||
| 10/15/19 | $ 2,995.68 | |||
| $ change | $ 244.89 | |||
| % change | 8.90% | |||
| DRI | https://finance.yahoo.com/quote/DRI/history?period1=1539586800&period2=1571122800&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 103.77 | |||
| 10/15/19 | $ 110.29 | |||
| $ change | $ 6.52 | |||
| % change | 6.28% | |||
| MAR | https://finance.yahoo.com/quote/MAR/history?period1=1539586800&period2=1571122800&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 113.88 | |||
| 10/15/19 | $ 121.11 | |||
| $ change | $ 7.23 | |||
| % change | 6.35% | |||
| Your Company - Please complete and include link to the appropriate web page - 5 points | ||||
| Sample | Brinker International - Ticker Symbol -EAT | |||
| 1 point for the link plus one point for each of the four figures below: | ||||
| EAT | https://finance.yahoo.com/quote/EAT/history?period1=1519891200&period2=1551427200&interval=1d&filter=history&frequency=1d | |||
| 10/15/18 | $ 33.34 | sample | ||
| 10/15/19 | $ 45.47 | sample | ||
| $ change | $ 12.13 | sample | ||
| % change | 36.38% | sample |
CompBig4
| HRT 474 | Team Assignment #3 | Financial Comparisons Big Picture | ||
| Fall | 2019 | |||
| Country? | ||||
| Section | 2:30 PM | 4:00 PM | 5:30 PM | Highlight the time of your section |
| Dow Jones | Nasdaq | S & P 500 | ||
| Did DRI Outperform? | Yes or No | |||
| Did Your Chosen Company Outperform? | Yes or No | |||
| Did MAR Outperform? | Yes or No | |||
| Visit the Chart page and compare results for DRI, Your Company, and MAR for a 5Y period | ||||
| https://finance.yahoo.com/quote/MAR?p=MAR | ||||
| Describe in one sentence or two sentences what you liked about using the interactive chart? |
Competitors7
| HRT 4740 | Team Assignment #3 | Competitors Information | ||
| Fall | 2019 | |||
| Country? | ||||
| Section | 2:30 PM | 4:00 PM | 5:30 PM | Highlight the time of your section |
| Description (2 pts) | Darden (DRI) | Brinker (EAT) | Cheesecake(CAKE) | Please use the information from the Statistics page |
| Profit Margin | https://finance.yahoo.com/quote/DRI/key-statistics?p=DRI | |||
| Operating Margin | Chosen competitor company web site Statistics page | |||
| Return on Assets (ttm) | Chosen competitor company web site Statistics page | |||
| Return on Equity (ttm) | ||||
| Quarterly Revenue Growth (yoy) | ||||
| Quarterly Earnings Growth (yoy) | ||||
| Description (3 pts) | Your Company | Competitor1 | Competitor2 | Please use the information from the Statistics page |
| Profit Margin | Chosen company web site Statistics page | |||
| Operating Margin | Chosen competitor company web site Statistics page | |||
| Return on Assets (ttm) | Chosen competitor company web site Statistics page | |||
| Return on Equity (ttm) | ||||
| Quarterly Revenue Growth (yoy) | ||||
| Quarterly Earnings Growth (yoy) | ||||
| Description (2 pts) | Marriott (MAR) | Competitor1 | Competitor2 | Please use the information from the Key Statistics page |
| Profit Margin | https://finance.yahoo.com/quote/MAR/key-statistics?p=MAR | |||
| Operating Margin | Chosen company web site | |||
| Return on Assets (ttm) | ||||
| Return on Equity (ttm) | ||||
| Quarterly Revenue Growth (yoy) | ||||
| Quarterly Earnings Growth (yoy) |
PresentFood
| HRT 4740 - Sample Financial Statistics layout - Foodservice | |||||
| Statistics | CAKE | Comp1 | Comp2 | DRI | Measures |
| Profit Margin | 6.11% | 5.73% | Profitability | ||
| Operating Margin (ttm) | 8.76% | 9.32% | Profitability | ||
| Return on Assets | N/A | 7.80% | Management Effectiveness | ||
| Return on Equity | N/A | 18.45% | Management Effectiveness | ||
| Qtly Revenue Growth(yoy) | 6.30% | 3.20% | Growth rate | ||
| Qtly Earnings Growth(yoy) | 32.10% | N/A | Growth rate | ||
| Forward P/E | 17.36 | 14.56 | Valuation | ||
| PEG Ratio (5 yr expected) | 1.55 | 1.13 | Valuation | ||
| Price/Sales (ttm) | 1.11 | 1.11 | Valuation | ||
| date of info. | 10/30/16 | 10/30/16 | |||
| You will need to update the figures and change the date. | |||||
| Source Yahoo Finance - Statistics page | |||||
| Name | Web Link | ||||
| CAKE | http://finance.yahoo.com/quote/CAKE/key-statistics?p=CAKE | ||||
| Comp1 | Chosen competitor company web site Statistics page | ||||
| Comp2 | Chosen competitor company web site Statistics page | ||||
| DRI | http://finance.yahoo.com/quote/DRI/key-statistics?p=DRI | ||||
| As a reminder, if Yahoo Finance provides with you a figure of "N/A", | |||||
| please double check the other financial money sites: | |||||
| https://www.msn.com/en-us/money | |||||
| https://www.google.com/finance | |||||
| If all three sites (Yahoo, MSN, and Google provide you with the figure of N/A, | |||||
| please indicate that you checked each site and the dates of your review of each web site. |
PresentLodging
| HRT 4740 - Sample Financial Statistics layout - Lodging | |||||
| Statistics | IHG | Comp1 | Comp2 | MAR | Measures |
| Profit Margin | 61.12% | 30.36% | Profitability | ||
| Operating Margin | 39.51% | 48.72% | Profitability | ||
| Return on Assets | 13.85% | 13.58% | Management Effectiveness | ||
| Return on Equity | N/A | N/A | Management Effectiveness | ||
| Qtly Revenue Growth(yoy) | -8.40% | 3.30% | Growth rate | ||
| Qtly Earnings Growth(yoy) | -45.50% | 2.90% | Growth rate | ||
| Forward P/E | 17.72 | 16.53 | Valuation | ||
| PEG Ratio (5 yr expected) | 2.03 | 1.18 | Valuation | ||
| Price/Sales (ttm) | 4.64 | 5.93 | Valuation | ||
| date of info. | 10/30/16 | 10/30/16 | |||
| You will need to update the figures and change the date. | |||||
| Source Yahoo Finance - Key Statistics page | |||||
| Name | Web Link | ||||
| IHG | http://finance.yahoo.com/quote/IHG/key-statistics?p=IHG | ||||
| Comp1 | Chosen competitor company web site Statistics page | ||||
| Comp2 | Chosen competitor company web site Statistics page | ||||
| MAR | https://finance.yahoo.com/quote/MAR/key-statistics?p=MAR | ||||
| As a reminder, if Yahoo Finance provides with you a figure of "N/A", | |||||
| please double check the other financial money sites: | |||||
| https://www.msn.com/en-us/money | |||||
| https://www.google.com/finance | |||||
| If all three sites (Yahoo, MSN, and Google provide you with the figure of N/A, | |||||
| please indicate that you checked each site and the dates of your review of each web site. |
