I'm attaching an example of the excel sheet of how it's supposed to look like and the company list on the bottom!
You have been hired as an independent financial analyst to evaluate the performance of a corporation. Please choose a company from the list (but not limited to) and analyze your company's financial statements.
Use the company's last 5 years quarterly or annual historical data to calculate the following (for each of the quarters or years):
- Liquidity ratios - Current ratio, quick (acid) ratio, and working capital.
- Turnover ratios - Inventory turnover and asset turnover ratios.
- Solvency ratios - Debt ratio, debt to equity ratio, and times interest earned
- Profitability ratios - Profit margin, return on assets, and return on equity.
- Investor ratios - P/E ratio, dividends payout ratio, and dividend yield.
- Evaluate historical stock price data.
Selected companies Choice Hotels International, Inc. Hyatt Hotels Corporation Hilton Worldwide Holdings Inc. InterContinental Hotels Group PLC (ADR) Marriott International, Inc. Marriott Vacation Worldwide Corp. MGM Resorts International Red Lion Hotels Corporation Starwood Hotels & Resorts Worldwide, Inc Wyndham Worldwide Corporation Wynn Resorts, Limited AFC Enterprises, Inc. Buffalo Wild Wings Chipotle Mexican Grill, Inc. Darden Restaurants, Inc. DineEquity Inc. Domino's Pizza, Inc. Dunkin Brands Group Inc. Mcdonald's Corporation Panera Bread Co. Papa John's Int'l, Inc. Starbucks Corporation Yum! Brands, Inc. Alaska Air Group, Inc. American Airlines Group Inc. Delta Air Lines Inc.Selected Financial Data 12/2008 12/2009 12/2010 12/2011 12/2012 Current Assets 120.2 127.9 163.6 194.8 233.5 Current liabilities 135.1 131.8 165.3 184.6 176.1 Inventories 0 0 0 0 0 Prepaid expenses 0 0 0 8.2 10.7 Cost of sales 339.9 308.5 332.4 352.5 388.3 Average inventory 0 0 0 0 0 Sales 641.7 564.2 596.1 638.8 691.5 Total assets 328.2 340 411.7 447.7 510.8 Fixed assets 155.3 162.6 169.3 165.1 151.3 Total debt 465.9 454.2 469.8 473.3 1059.7 Total equity -137.7 -114.2 -58.1 -25.6 -548.9 Earnings before interest and taxes 176 155 164.9 171 196.4 Interest expense 18.7 4.4 6.7 12.9 27.2 Net income 100.2 98.3 107.4 110.4 120.7 Stockholder's equity -137.7 -114.2 -58.1 -25.6 -548.9 Market price of common shares $ 30.06 $ 31.66 $ 38.27 $ 38.05 $ 33.62 Earnings per share 1.62 1.64 $ 1.80 $ 1.86 $ 2.08 Dividend per common share $ 0.88 $ 0.74 $ 0.74 $ 0.74 $ 11.15 Expected dividend for the coming year | $ 0.74 $ 0.74 $ 0.74 $ 11.15 $ 0.74 * *in millions, except for per share data** Source: ADVFN: http://www.advfn.com/exchanges/NYSE/CHH/ financials? btn=annual_reports&mode=company_dataKey Ratios 12/2008 12/2009 12/2010 12/2011 12/2012 Liquidity Ratios Current ratio 0.8897 0.9704 0.9897 1.0553 1.3260 Quick (acid) ratio 0.8897 0.9704 0.9897 1.0108 1.2652 Working capital -14.9000 -3.9000 -1.7000 10.2000 57.4000 Turnover ratio Inventory turnover Asset turnover 1.9552 1.6594 1.4479 1.4268 1.3538 Solvency ratios Debt-to-assets ratio 1.4196 1.3359 1.1411 1.0572 2.0746 Debt-to-equity ratio -3.3834 -3.9772 -8.0861 -18.4883 -1.9306 Times interest earned (Interest coverage) 9.4118 35.2273 24.6119 13.2558 7.2206 Profitability ratios Profit margin 0.1561 0.1742 0.1802 0.1728 0.1745 Return on assets 0.3053 0.2891 0.2609 0.2466 0.2363 Return on equity -0.7277 -0.8608 -1.8485 -4.3125 -0.2199 Investor ratios Price-to-earnings 18.5556 19.3049 21.2611 20.4570 16.1635 Dividends payout 0.5432 0.4512 0.4111 0.3978 5.3606 Dividend yield 0.0246 0.0234 0.0193 0.2930 0.0220 Historical stock prices $ 30.06 $ 31.66 $ 38.27 38.05 $ 33.62 Source: Yahoo! Finance (http://finance.yahoo.com/q/ hp? S=CHH&a=11&b=31&c=2008&d=11&e=31&f=2012&g=m)
