1 Use the provided worksheet to calculate a set of ratios.

2 Complete the financial ratios for the company in the 2014 column.

3 there are thirteen (13) calculations in total.

Sheet1 Sheet2 Sheet3 Calculate the financial ratios below for the year 2014. Use the financial information given in the income statement and balance sheet below Industry Average 2007 1.70X Financial Ratios 2012 2013 2014 Current ratio 1.71X 1.65x 89x 60 days uick ratio 60 days 65 days Average collection period Inventory turnover Fixed asset turnover Total asset turnover Debt ratio Times interest earned Gross profit margin Operating profit margin Net profit mar Return on total assets Return on equity 4.20x 3.20x 1.40X 59.20% 4.20x 25.00% 12.50% 6.10% 8.54% 20.93% 3.90x 3.33x 1.35x 61 .00% 3.70x 23.00% 12.70% 6.00% 8.10% 20.74% 4.50x 137X 60.00% 4.75X 22.50 12.50 6.50% 8.91% 22.28% Income Statement for Balance Sheet Year Ended 12/31/14 at 12/31/14 Sales $1,500,000 Cash $125,000 275.000 325,000 $725,000 $420.000 1.145,000 $150,000 225,000 100,000 475,000 Cost of 1,200,000 Accounts receivable S300,000 Inventorv s sold Gross Profit ating expenses 100,000 Current Assets ating profit S200,000 Fixed assets (net) Interest expense Earnings before tax Income tax (0.4) 72.000 128,000 Accounts pavable 51.200 Notes payable Total Assets Accrued liabilities Current Liabilities n debt 400,00 Total Liabilities $875,000 270,000 S1.145,000 Net Income 76,800 Total Liabilities & Equity