Comparative data for North Jordan Automotive for the two- year period 2017-2018 are presented below. Income Statement Data 2012 2017 Net Sale $1,500,000 $1,200,000 Cost of Goods Sold 934,000 741.000 Gross Profit S 566,000 S 459,000 Operating Expense 176,000 227.000 Operating Income S 190,000 S 182,000 (Other Expense (Interest Expense 15.000 12.00 Earnings Before Income Tax 175,000 $ 170,000 Income Taxes 65,00 71.00 Net Income S 109,000 S 99.000 Dividends Pad 48.000 420.000 Net Increase in Retained Earnings 61,000 57.000 Balance Sheet Data Assets 2018 2017 Cash 30,000$ 10,000 Marketable Securities 25,000 20.500 Receivables (net , less allowance of $15,000 130,000 90,000 Inventory 170,000 13.000 Current Assets 35.000 $213.500 Land, Buildings, and Equipment (net) 650,000 $47,000 Intangible Assets 20.000 20.000 Total Assets S1.625.000 SO.SK Liabilities and Stockholders' Equity 2018 2017 Trade Notes and Accounts Payables 100.000 S 40.000 Wages payable 17.000 14,500 Miscellaneous Current Liabilities 50,000 11,000 5% Bonds Payable 300,000 240,000 Income tax 8,000 6,000 Total Current liability S475.000 $311.500 Common Stock, S10 Par 100.000 100.000 Additional Paid-In Capital 51,000 51.000 Retained Earnings 199,000.00 Total Liabilitics and Stockholders' Equity 31.025.000 $0.500 Market price of stock end-of-each year: Basic Earning Per-share $10.9 $81 S68 $9.9 Required: Required: 2 a. :Compute the following ratios for 2018 1.1 Net profit margin 2. Total asset turnover 3. Return on assets 4. Account receivable turnover 5. Inventory turnover. 6. Current ratio. 7. Payout ratio 8.1 Return on total equity 9.1 Debt to total Assets ratio. Degree of financial leverage 11. Price/earnings ratio Dividend yield 13. Acid-Test ratio lalu 10. 12. .b Comment on the First 5 results. Income Statement Data 2018 2017 Net Sales S1,500,000 $1,200.000 Cost of Goods Sold 934.000 741.000 Gross Profits 566,000 $ 459,000 Operating Expense 376,000 277.000 Operating Income S 190,000 $ 182,000 (Other Expense (Interest Expense 15,000 12.000 Earnings Before Income Tax S 175,000 $ 170,000 Income Taxes 66,000 71.000 Net Income S 109,000 S 99.000 Dividends Paid 48.000 42.000 Net Increase in Retained Earnings 61,000 S_37.000 Balance Sheet Data Assets 2018 2017 Cash S 30,000 $ 10.000 Marketable Securities 25.000 20.500 Receivables (net , less allowance of $15,000) 130,000 90,000 Inventory 170,000 113,000 Current Assets $355.000 233.500 Land, Buildings, and Equipment (net) 650,000 547,000 Intangible Assets 20.000 20.000 Total Assets $1,025,000 $800,500 Liabilities and Stockholders' Equity 2018 2017 Trade Notes and Accounts Payable S 100,000 S 40,000 Wages payable 17,000 14,500 Miscellaneous Current Liabilities 50,000 11.000 5% Bonds Payable 300,000 240,000 Income tax 8,000 6,000 Total Current liability 5475.000 $311.500 Common Stock, SIO Par 100.000 100.000 Additional Paid In Capital 51.000 51,000 Retained Earnings 399,000 338.000 Total Liabilities and Stockholders' Equity 51.025.000 $800.500
