Q5. Using the information in the Balance Sheet and Profit and Loss Statement below, calculate the following ratios and answer the questions (8 points in total) 20X2 Piura Manufacturing Comparative Balance Sheets For the Years Ended June 30, 20Xland 20X2 20X1 Assets Cash $ 72,000 Accounts receivable 44.000 Inventory 64,000 Plant and equipment 104,000 Accumulated depreciation (52,000) Land 20,000 Total assets $252,000 Liabilities and equity Accounts payable $ 32,000 Wages payable 4.000 Bonds payable 24,000 Preferred stock (no par) 4,000 Common stock 30,000 Paid in capital in excess of par 50,000 Retained carnings 108,000 Total liabilities and equity $252,000 $ 146,400 48.000 44,000 112,000 (48,000) 20,000 $322,400 $ 48,00% 2,400 16,000 12,000 36,000 76,000 132,000 $322,400 (+/ %6(+)/ Particulars December 31, 20% December 31 20142 1,70,000 1,90,400 (+) 20,400 Net Sales (+) 12.00 Particulars %C+/ December 31 2017 December 31 2012 1,70,000 1,05,000 65,000 1,90,400 1,20,000 70,400 (+) 20,400 (+) 15,000 (+) 5,400 (+) 12.00 (+) 14.30 (+) 8.3 13,200 14,960 (+) 1,760 (+) 13.3 Net Sales Less: Cost of Goods Sold Gross Profit Administrative Expenses Selling Expenses: Advertisement Expenses Other Selling Expenses Total Selling Expenses Operating Expenses Operating Profit Other Incomes 3,000 40,800 43,800 4,000 41,800 45,800 (+) 1,000 (+) 1,000 (+) 2,000 (+) (+) (+) 33.3 2.5 4.6 57,000 60,760 (+) 3,760 8,000 9.640 (+) 1,640 (+) 20.5 6,400 9,200 (+) 2,800 (+) 43.8 Other Expenses 6,800 4,800 (-) 2,000 29.4 Profit Before Tax 7,600 14,040 (+) 6,440 84.7 Income Tax 3,800 6,200 (+) 2,400 63.2 Profit After Tax 3,800 7,840 (+) 4,040 (+) 106.3 1) Calculate the following Liqudity Ratios Current ratio in year 1 = Current ratio in year 2- Quick ratio in year 1- Quick ratio in year 2 2) Calculate the following Solvency Ratios Debt to Solvency ratios in year 1= Debt to Solvency ratios in year 2- Times interest Eamed Ratios in year 1 - Times interest Eamed Ratios in year 2= I 2) Calculate the following Profitability Ratios Return on Invested Capital (ROIC) ratio in year 1 Return on Invested Capital (ROIC) ratio in year 2 = Return on Owner's Equity (ROE) ratio in year 1= Return on Owner's Equity (ROE) ratio in year 2- Profit as Percentage of Sales ratio in year 1 = Focus 1) Calculate the following Liqudity Ratios Current ratio in year 1 = Current ratio in year 2 = Quick ratio in year 1= Quick ratio in year 2= 2) Calculate the following Solvency Ratios Debt to Solvency ratios in year 1= I Debt to Solvency ratios in year 2= Times interest Earned Ratios in year 1 = Times interest Earned Ratios in year 2= 2) Calculate the following Profitability Ratios Return on Invested Capital (ROIC) ratio in year 1 Return on Invested Capital (ROIC) ratio in year 2 = Return on Owner's Equity (ROE) ratio in year 1= Return on Owner's Equity (ROE) ratio in year 2= Profit as Percentage of Sales ratio in year 1 Profit as Percentage of Sales ratio in year 2 = 2) Calculate the following Profitability Ratios Return on Invested Capital (ROIC) ratio in year 1 Return on Invested Capital (ROIC) ratio in year 2 = Return on Owner's Equity (ROE) ratio in year 1= Return on Owner's Equity (ROE) ratio in year 2- Profit as Percentage of Sales ratio in year 1 = Profit as Percentage of Sales ratio in year 2 = I 3) Based on the above ratio analysis, what conclusions/observations can you make regarding the financial situation of this company. (if any)