Apply the common size analysis method for the following income statement and balance sheet: 38 Exercise 3. 39 10 Income

[answerhappygod]

Apply The Common Size Analysis Method For The Following Income Statement And Balance Sheet 38 Exercise 3 39 10 Income 1 (34.24 KiB) Viewed 56 times

Apply the common size analysis method for the following income statement and balance sheet: 38 Exercise 3. 39 10 Income Statement Fiscal year is Jan-Dec USD mns Common size 2020 Common 2019 size 162,450 68,250 98 6,200 8,400 79,502 200 560 5,900 72,842 18,200 54,642 181,000 65,900 105 6,500 9,300 99,195 270 490 6,100 92,335 23,084 69,251 41 42 Sales 73 Cost of Goods Sold (COGS) 14 Gross Income 15 SG&A Expense 16 Research & Development 27 Operating profit 18 Non Operating Income/Expense 49 Non-Operating Interest Income 50 Interest Expense 51 Pretax Income 52 Income Tax 53 Consolidated Net Income 54 55 Balance sheet Fiscal year is Jan-Dec USD mns Common size 56 57 Cash & Short Term Investments 58 Total Accounts Receivable 59 Inventories 50 Total Current Assets 51 Net Property, Plant & Equipment 52 Total Investments and Advances 53 Intangible Assets 54 Tangible Other Assets 95 Total Assets 56 ST Debt & Current Portion LT Debt 2020 215,000 31,000 19,000 265,000 95,000 18,600 2,350 4,100 385,050 134,000 Common 2019 size 213,000 30,500 11,500 255,000 89,000 16,500 13,500 6,100 380,100 105,000
59 Inventories 19,000 50 Total Current Assets 265,000 51 Net Property, Plant & Equipment 95,000 52 Total Investments and Advances 18,600 53 Intangible Assets 2,350 54 Tangible Other Assets 4,100 55 Total Assets 385,050 56 ST Debt & Current Portion LT Debt 134,000 S7 Accounts Payable 11,500 58 Income Tax Payable 2,300 59 Total Current Liabilities 147,800 70 Long-Term Debt 18,750 71 Deferred Taxes 2,500 72 Other Liabilities 13,500 73 Total Liabilities 182,550 74 Common Equity (Total) 202,500 75 Liabilities & Shareholders' Equity 385,050 76 77 Share price 11 78 Number of shares outstanding 200,000 79 30 And calculate the following financial ratios: 31 2020 EPS Earning per share (Net 32 income / no. of shares 0.273212 83 P/E ratio price earning (share price / EPS) 40.26179 34 Net profit margin (Net Profit / Revenue) 35 Days in inventory (Inventory/365)/(COGS/365) 36 Debt ratio (Total liabilities/ Total assets) 37 Return on total assets (Net income / total assets) 38 Current ratio (Current assets CA / current liabilities CL) 89 Quick ratio (CA - inventories / CL) 11,500 255,000 89,000 16,500 13,500 6,100 380,100 105,000 6,200 3,000 114,200 59,500 2,000 14,000 189,700 190,400 380,100 9 200,000 2019 0.346256 25.99231