Font aragraph Task 4: 1) Using the company's financial data, calculate financial ratios for 2015 (projected) and compare them with industry average ratios. Interpret your results. Estimated 2015 2014 2013 Balance Sheets Assets Cash Accounts Receivable Inventores Total Current Assets Gross Fixed Assets Less accumulated depreciation Net Fixed Assets Total Assets 85,632 878,000 1,716,480 2,680,112 1,197, 160 380,120 817,040 3,497, 152 .7,282 57,600 632,160 351,200 1,287,360 715,200 1,926,802 1,124,000 1,202,950 491,000 263,160 146,200 939,790 344.800 2,866,592 1,468.800 Liabilities and Equity Accounts Payable Notes Payable Accruals Total Current Liabilities Long-term Debt Common Stock Retained Earnings Total Equity Total Liabilities and Equity 436,800 300,000 408,000 1,144.800 400.000 1,721, 176 231,176 1,952,352 3.497.152 524,160 636,808 489,600 1,650,568 723,432 460,000 32.529 492.529 2.866.529 145,600 200.000 136,000 481.600 323,432 460.000 203.768 663.768 1.468.800 Estimated 2015 7,035,600 5,875,992 550,000 2014 6,034,000 5,528,000 519,988 2013 3,432,000 2,864.000 358,672 Income Statements Sales COGS Other Expenses Total Operation Costs excl depreciation EBITDA Depreciation EBIT Interest Expense EBT Taxes, 40% 6,425,992 609,608 116,960 492,648 70,008 422,640 169,056 253 584 6,047,988 -13,988 116.960 -130,948 136.012 -266,960 -106.784 3,222,672 209,328 18,900 190.428 43.828 146,600 58,640 87 960 Net income -160.176 Estimated 2015 2014 1.17 0.39 2013 2.33 0.85 Industry Average 2.7 1 4.69 4.80 6.1 38.24 37.35 32 Ratio Analysis Current Quick Inventory Turnover Days SaleOutstandin g Fixed Assets Turnover Total Assets Tumover Debt Ratio Times Interest Earned Net Profit Margin (NPM) ROA ROE 6.42 9.95 7 2.6 2.10 0.83 2.34 0.55 50.00% -0.96 4.34 6.2 -0.03 -0.06 -0.33 0.03 0.06 0.13 3.50% 9.10% 18.20% 2) Determine the net operating profit after taxes for 2014. 3) What are the amounts of net operating working capital for 2014 and 2013? 4) Determine the amount of total investor-supplied operating capital (invested capital) for 2014 and 2013 5 What is the free cash flow for 2014