Please find the balance sheet, income statement and cashflow attached with the question.
Solve these questions
Balance Sheet
Balance Sheet
Income Statement
Income Statement
Cashflow
3) Calculate the following ratios: 1) Profit margin 2) ROA 3) ROE 4) Receivables turnover 5) Inventory turnover 6) Total asset turnover 7) Current Ratio 8) Quick ratio 9) Earnings per shar (EPS) 4) Write a detailed summary about your opinion on the financial health of this company. Explain why you feel this way Tim Hortons Inc. 99.00 0.00 (0.00%) THI Balance Sheet 1 Annual Quarterly Collapse All 2013 29/12 Period Ending 2012 30/12 2012 01/01 2011 02/01 574.99 620.97 609.33 120.14 1009.12 574,35 50.41 126.5 50.41 120.14 126,5 574 35 177.31 183.81 194.55 210.83 122.4 109.46 144.84 136.2 126.05 90.38 94.59 85.81 13.94 12.41 10.95 14.9 209.42 139.51 Total Current Assets Cash and Short Term Investments Cash Cash & Equivalents Short Term Investments Total Receivables, Net Accounts Receivables - Trade, Net Total Inventory Prepaid Expenses Other Current Assets, Total Total Assets Property/Plant/Equipment, Total - Net Property/Plant/Equipment, Total - Gross Accumulated Depreciation, Total Goodwill, Net Intangibles, Net Long Term Investments Note Receivable - Long Term Other Long Term Assets. Total Other Assets. Total Total Current Liabilities Accounts Payable Payable/Accrued Accrued Expenses Notes Payable/Short Term Debt Current Port of LT Debt Capital Leases Other Current liabilities, Total 2433.82 1685.04 2736.1 -1051.06 204.87 2284.18 1553.31 2488,57 -93526 173.66 2203.95 1463.77 2291 33 -827 56 248152 1373.67 2099 53 -725 86 454 0.49 40.74 4.48 3.67 41.27 5.27 44.77 3.81 43.01 3.16 68.5 1.25 128.08 75.36 44.88 I 586.22 491.5 463.37 126. 12 476,65 145.99 142.13 116.88 321.85 262.8 232.76 232 29 30 9.94 17.78 7445 20.78 53.67 10 879 132.39 Tim Hortons Inc. 99.00 0.00 (0.00%) 1672.67 1044.71 1096.94 510.7 406.32 1051.4 447.29 964.07 843.02 427.41 352.43 344.73 121.05 104.38 94.86 4.61 9.93 10.4 2.85 82.69 8.24 5.64 0.36 1.89 112.09 109.61 120.97 111.93 761.15 1187.24 1152.55 1436.8 Total Liabilities Total Long Term Debt Long Term Debt Capital Lease Obligations Deferred Income Tax Minority Interest Other Liabilities, Total Total Equity Redeemable Preferred Stock, Total Preferred Stock - Non Redeemable, Net Common Stock, Total Additional Paid-In Capital Retained Earnings (Accumulated Deficit) Treasury Stock - Common ESOP Debt Guarantee Unrealized Gain (Loss) Other Equity, Total Total Liabilities & Shareholders' Equity Total Common Shares Outstanding Total Preferred Shares Outstanding 447.56 400.74 11.03 484.05 435.03 10.97 893.62 -13.36 474.41 6.38 836.97 -10.14 1105.88 -9.54 -12.92 - 112.1 -128.22 - 143.59 -139.03 2284.18 2433.82 2203.95 2481.52 141.33 153.4 157.81 170.66 in Millions of CAD (except for per share items) I Tim Hortons Inc. 99.00 0.00 (0.00%) THI Income Statement Annual Quarterly Collapse All 2013 29/12 2012 30/12 Period Ending 2012 01/01 2011 02/01 Total Revenue 3255.53 3120,5 2536.49 2852.97 2119.75 3255.53 2339.51 1849.46 780.99 733.22 687.04 2135.7 2076.06 1878.99 1619.15 230.31 1119.83 263,45 240.76 2634.44 2525.98 2283.49 1664.26 173.41 158.48 161.44 147.3 -29.25 - 14.69 -14.35 -375.72 28.3 33.67 18.5 0.37 320.91 257.04 245 24 Revenue Other Revenue, Total Cost of Revenue, Total Gross Profit Total Operating Expenses Selling/General/Admin. Expenses, Total Research & Development Depreciation / Amortization Interest Expense (Income) - Net Operating Unusual Expense (Income) Other Operating Expenses, Total Operating Income Interest Income (Expense). Net Non-Operating Gain (Loss) on Sale of Assets Other, Net Net Income Before Taxes Provision for Income Taxes Net Income After Taxes Minority Interest Equity in Affiliates US GAAP Adjustment Net Income Before Extraordinary Items Total Extraordinary Items 287 63 594.52 621.1 872.24 569.48 -25.87 -35.47 -30.41 -24.18 585.63 543.6 848.06 564.11 156,35 407.77 I 156.98 157.85 200.94 428.65 385.75 647.12 -4.28 4.88 -2.94 -23.16 424.37 402 88 382.81 623.96 Net Income 424.37 402 88 382.81 623.96 Total Adjustments to Net Income Tim Hortons Inc. 99.00 0.00 (0.00%) 424.37 402.88 382.81 623.96 402.88 382.81 623.96 Income Available to Common Excluding Extraordinary Items Dilution Adjustment Diluted Net Income Diluted Weighted Average Shares Diluted EPS Excluding Extraordinary Items DPS - Common Stock Primary Issue Diluted Normalized EPS 424.37 150.62 2.82 155.68 162.6 174.22 2.59 2.35 3.58 1.04 0.84 0.68 0.52 2.98 2.67 2.36 3.71 in Millions of CAD (except for per share items) THI Cash Flow Statement Anna Quarterly Colpo AB Ponad Ending 2013 29/12 2012 30/12 2012 01/01 2011 02/01 Pored Lang 12 Months 12 Months 428.65 598.74 407.77 559.29 132.17 12 Months 385.75 39147 115.87 12 Months 647.12 525 54 161.81 118.39 - 5.07 -5.43 4.88 21.99 1.28 328 33 11.86 10.92 Net Income/Starting Line Cash From Operating Activities Depreciation Depletion Amortization Deferred Taxes Non-Cash Items Cash Receipts Cash Payments Cash Taxes Paid Cash Interest Paid Changes in Working Capital Cash From Investing Activities - Capital Expenditures Other investing Cash Flow Items Total Cash From Financing Activities Financing Cash Flow Items Total Cash Dividends Paid Issuance (Retirement) of Stock. Net Issuance (Retirement) of Debt.Net Fornign Exchange Effects Net Change in Cash Beginning Cash Balance Ending Cath Balance Free Cash Flow Free Cash Flow Growth Free Cash Flow Yield 17588 31.45 243 -24221 -235.81 -6.4 207 14 29.81 - 115.64 - 152.73 -18127 28 54 1915 36.27 -8.83 -23726 -24297 571 43408 0.69 -156.14 -72055 44192 288 -32237 -108 -68782 -0.29 -110.19 158.65 2437 87 08 296.02 -13291 428 93 -36563 -22.52 -90.3 2466 -62 323 4527 .130.51 -2252 44.14 -1.07 636 -572.45 -489 1.22 447.86 -69.72 CAD
