Hansons Hoses Income Statement For the Year End December 31, 2013 Net Revenues Cost of Goods Sold Gross Profit Operating Expenses Net Income Hanson Hoses Statement of Shareholders Equity For the Year End December 31, 2013 2013 2012 600000 624000 430000 438000 170000 186000 35000 40000 135000 146000 Retained Capital Earnings Total Balance January 1, 2012 100000 140000 240000 Stock Issuance 20000 20000 Net Income 135000 135000 Balance December 31, 2013 120000 275000 395000 Note: The number of shares outstanding in 2012 was: 20000 The number of shares outstanding in 2013 is: 2000 No dividends were issued in either year. Current Assets Cash Hansons Hoses Balance Sheet December 31, 2013 Assets Accounts Recievable Inventory Investment Fund Plant Property and Equipment Trucks Equipment Land Building Intangibles Patents 2013 2012 13000 11000 26000 17000 54000 43000 25000 20000 118000 91000 * Total Assets Liabilities and Equity 22000 30000 75000 70000 40000 40000 100000 100000 237000 240000 97000 6000 452000 337000 Current Liabilities Salaries Payable 15000 12000 Accounts Payable 19000 22000 Current Portion of Mortgage Payable 3000 3000 37000 37000 Long Term Liabilities Mortgage payable Total Liabilities 20000 60000 57000 97000 Equity Common Shares Retained Earnings Total Equity Total Liabilities and Equity 120000 100000 275000 140000 395000 240000 452000 337000 *Plant Property and Equipment are reported net of amortization Required: Complete the following ratios for the 2013 fiscal year, write the ratio calculation below the ratio name then enter calculation in the blank cell beside. These are provided s starting in cell 03: Current Ratio Quick Ratio Cash Ratio Cash Conversion Cycle Gross Profit Margin Return on Assets Return on Equity Debt to Equity Ratio Earnings per Share