Please help me plug in the data from the McDonalds income statement and balance

Question

Please help me plug in the data from the McDonalds income statement and balance sheets in order to calculate the financial ratios:

..ooo Verizon finance.yahoo.com My Portfolio My Quotes News Market Data Yahoo Originals Business & Finance Personal Finance CNBC Contributors Sat, May 14, 2016, 10 11PM EDT-U.S. Markets closed Report an Issue Nasdaq 40.4 ID ENTRADE at the same place. Fidelity WE PUT THE EDGE IN HEDGING McDonald's Corp. (MCD) , NYSE watchlist 128.83. 1.29(0.99%) May 13, 4:00PM EDT After Hours : 128.81 0.02 (0.02%) May 13, 7:29PM EDT Balance Sheet Get Balance Sheet for GO View: Annual Data | Quarterly Data A numbers in thousands Period Ending Dec 31, 2015 Dec 31, 2014 Dec 31, 2013 ssets Current Assets Cash And Cash Equivalents Short Term Investments 7,685,500 2,077,900 2,798,700 1,298,700 100,100 558,700 1,214.400 10,000 783,200 4,185,500 1,004,500 24,557,500 2,735,300 1,319,800 123,700 807,900 5,050,100 1,209,100 25,747,300 2,872,700 Inventory Other Current Assets Total Current Assets Long Term Investments Property Plant and Equipment Goodwill GE 792,700 23,117,600 2,516,300 Assets 1,869,100 1,744,600 1747,100 Other Assets Deferred Long Term Asset Charges Total Assets 37,938,700 34,227,400 36,626,300 Liabilities Current Liabilities 2,950.400 2,747,900 3,170,000 Accounts Short Current Long Term Debt Other Current Liabilities Total Current Liabilities Long Term Debt Other Liabilities Deferred Long Term Liability Charges Minority Interest Negative Goodwill Total Liabilities 2,950,400 24,122,100 2,074,000 1,704,300 2,747,900 14,935,7OD 2,065,900 1,624,500 3,170,000 1,669,100 1,647,700 30,850,800 21,374,000 20,616,600 Stockholders' Equity Misc Stocks Options Warrants Redeemable Preferred Stock Preferred Stock Common Stock Retained Earnings 16,600 4,594,500 41,751,200 6,533,400 (2,879,800) 6,239,100 (1,519,700) 12,853,400 10,118,100 5,994,100 Capital Surplus Other Stockholder Equity Total Stockholder Equity Net Tangible Assets 16,009,700 4,571,600 13,137,000 Sign Up for a Free Trial to EDGAR Online Premium! Get the critical business and financial information you need for more than 15,000 U.S. public companies Sign Up Now - Learn More Currency in USD Ad Topics That Might Interest You... 5. Current Annuity Rates

Explanation / Answer

I'm calculating the mentioned ratios for december 2015. For rest of the years, please calculate on your own.

Current Ratio = Current Assets / Current Liabilities
=> 9,643,000/2,950,450 = 3.268315

Acid Test Ratio = (Current assets – Inventory) / Current Liabilities
=> (9,643,000- 100,100) / 2,950,450 = 3.234388

Account Receivable Turnover = Sales/Account Receivable
=> 25,413,000/1,298,700 = 19.56803

Average Collection Period = 365/ Account Receivable Turnover
=> 365/19.56803 = 18.65287

Inventory Turnover = Cost of Goods sold / Average Inventory
Cost of Goods sold = Cost of Revenue = 15,623,800
Average Inventory = (Inventory of 2014 + Inventory of 2015)/2 = (110,000+100,100)/2 = 105,050
Inventory Turnover = 15,623,800/105,050 = 148.7272

Debt Ratio = Total Liabilities / Total Assets
=> 30,850,800/37,938,700 = 0.8131749

Times Interest Earned = EBIT / Interest Expense
=>As no intereset expense mentioned in the balance sheet, we can't calculate it.

Total Asset Turnover = Revenue / Total Assets
=> 25,413,000/37,938,700 = 0.6698437

Fixed Asset Turnover = Revenue / Net Fixed Asset
=> 25,413,000/(37,938,700 - 9,643,000) = 0.8981223

Gross Profit Margin = Gross Profit / Revenue
=> 9,789,200/25,413,000 = 0.3852044

Operating Profit Margin = Operating Profit / Revenue
=> 7,145,500/25,413,000 = 0.2811749

Net Profit Margin = Net Profit / Revenue
=> 4,529,300/25,413,000 = 0.1782276

Operating Return on Assets = EBIT / Average Total Assets     [Average total assets = (Assets of 2014 + Assets of 2015)/2]
=> 6,555,700 / (37,938,700 + 34,227,400)/2 = 0.1816836

ROE = Net Income / Shareholder's equity
=> 4,529,300/7,087,900 = 0.6390186

P/E Ratio = (Number of shares x current price)/Net Income
=>(16,600*$128.83) / 4,529,300 = 0.472165

Market to book-value = Market Value of shares / Book value of shares
=> (16600*128.83) / 7,087,900 = 0.3017223

Related Questions

Navigate

• Browse (All)
• Browse P
• Subjects

---