All your answers are to be typed into the Yellow boxes. You can type in formulas on the spreadsheets if you wish for potential partial credit.

Do not touch the Blue boxes.

Formatting as lable Styles Brummet G H 1 J - Balance Sheet 12/31/18 B5 fx ABC Corp. Year end statements A B c ABC Corp. Yered statements Balance Sheet 12/31/19 5 8 ASSETS 2019 LIABILITIES 2019 Cash $ 3,000,000 Accounts Payable 1,700,000 Accounts Recievable 2,000,000 Current portion of LTD 900,000 9 Inventory 3,000,000 Accrued Liabilities 1,400,000 10 Total Current Assets 8,000,000 Total Current Liabilities $ 4,000,000 B ASSETS Cash Accounts Recievable Inventory Total Current Assets 2018 3,300,000 2,500,000 3,200,000 9,000,000 LIABILITIES Accounts Payable Current portion of LTD Accrued Liabilities Total Current Liabilitic 2018 2,000,000 1,000,000 1,000,000 4,000,000 12 Property Plant & Equipment, 8,000,000 Long Term Debt (LTD) 9,000,000 Property Plant & Equipment, net 8,000,000 Long Term Debt (LTD) 9,000,000 13 14 Other Assets 2,000,000 Shareholder's Equity 5,000,000 Other Assets 2,000,000 Shareholder's Equity 6,000,000 15 16 Total Assets $ 18,000,000 Total Liabilities & Equi 18,000,000 Total Assets $ 19,000,000 Total Liabilities & Equ: $ 19,000,000 17 18 19 Income Statement FY 12/31 Answers go in the yellow boxes 21 Revenue 22 Cost of Goods Sold 23 Gross Profit 2019 $ 15,000,000 5,000,000 10,000,000 2 2 25 Selling General & Admin Research and Development 27 Depreciation and Amortizatior 28 Total Operating expenses 3,000,000 1,500,000 1,500,000 6,000,000 Current ratio 12/31/19 Accounts Receivable Tumover (2019) Total Asset Tumover (2019) Inventory Tumover (2019) Debt to Equity 12/31/19 Revenue to Cash (2019) Days revenue in Cash (2019) Days Inventory (2019) Retum on Assets (2019) Retum on Equity (2019) 2 2 2 2 2 2 2 2 4,000,000 30 Operating Profit 31 32 Interest Income Interest Expense 100,000 700,000 20 35 Pre tax Profit 25 Tax (@21%) 37 Net income 3,400,000 714,000 S 2,686,000 Prob. 1 - Income Stmt Prob. 2 - Working Capital Prob. 3 - Ratios + Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Times New Roman abe V 14 A y A % Conditional Formatting Format as Table Cell Styles O 5 v Paste BIU Number a. Av Cells Editing y Ideas Sensitivity LI M34 fx B D E F H 1 K 1 M 2 Problcm 3 - 20 Points Given the following Information on ABC Corp, calculate the ratios below ABC Corp. Year end statements Balance Sheet 12/31/19 Balance Sheet 12/31/18 S 2019 3,000,000 2,000,000 3,000,000 LIABILITIES Accounts Payable Current portion of LTD Accrued Liabilities Total Current Liabilities 2019 1,700,000 900.000 1,400.000 ASSETS Cash Accounts Recievable 2018 3,300,000 2,500,000 3,200,000 9,000,000 LIABILITIES Accounts Payable Cument portion of LTD Accrued Liabilities Total Current Liabilities 2018 2,000,000 1.000.000 1.000.000 4,000,000 Laventory 8,000,000 $ 4,000,000 Total Current Assets 8 ASSETS 7 Cash a Accounts Recievable 9 Inventory 10 Total Current Assets 11 12 Property Plant & Equipment, net 13 14 Other Assets 15 16 Total Assets 17 10 19 Income Statement FY 12/31 8,000,000 Long Term Debt (LTD) 9,000,000 Property Plant & Tquipment, net 8,000,000 Long Term Debt (LTD) 9,000,000 2,000,000 Sharcholder's Equity 5.000.000 Other Assets 2,000,000 Shareholder's Equity 6,000,000 S 18,000,000 Total Liabilities & Tquity 18,000,000 Tatal Assets S 19,000,000 Total abilities & Equity $19,000,000 Answers go in the yellow boxes 2019 $ 15,000,000 5,000,000 10,000,000 21 Revenue 22 Cost of Goods Sold 29 Gross Profit 24 25 Selling General & Admin 26 Research and Development 27 Depreciation and Amortization 28 Total Operating expenses 2 2 2 2 3,000,000 1.500,000 1,500,000 6,000,0XX Current rutio 12/31/19 Accounts Receivable Tumover (2019) Total Asset Turnover (2019) Inventory Turnover (2019) Debt to Equity 12/31/19 Revenue to Cash (2019) Days revenue in Cash (2019) Days Inventory (2019) Retum on Assets (2019) Retum on Equity (2019) 2 2 2 2 2 30 Operating Profit 4.000.000 100,000 700.000 20 32 Interest Income 99 Interest Expense 341 30 Pre tax Profit 30 Tax (@21%) 97 Net income 3,400,000 714,000 2,686,000 $ 40 41 42 44 45 Prob. 1 - Income Stmt Prob. 2 al Prob. 3 - Ratios + FaceTime Formatting as lable Styles Brummet G H 1 J - Balance Sheet 12/31/18 B5 fx ABC Corp. Year end statements A B c ABC Corp. Yered statements Balance Sheet 12/31/19 5 8 ASSETS 2019 LIABILITIES 2019 Cash $ 3,000,000 Accounts Payable 1,700,000 Accounts Recievable 2,000,000 Current portion of LTD 900,000 9 Inventory 3,000,000 Accrued Liabilities 1,400,000 10 Total Current Assets 8,000,000 Total Current Liabilities $ 4,000,000 B ASSETS Cash Accounts Recievable Inventory Total Current Assets 2018 3,300,000 2,500,000 3,200,000 9,000,000 LIABILITIES Accounts Payable Current portion of LTD Accrued Liabilities Total Current Liabilitic 2018 2,000,000 1,000,000 1,000,000 4,000,000 12 Property Plant & Equipment, 8,000,000 Long Term Debt (LTD) 9,000,000 Property Plant & Equipment, net 8,000,000 Long Term Debt (LTD) 9,000,000 13 14 Other Assets 2,000,000 Shareholder's Equity 5,000,000 Other Assets 2,000,000 Shareholder's Equity 6,000,000 15 16 Total Assets $ 18,000,000 Total Liabilities & Equi 18,000,000 Total Assets $ 19,000,000 Total Liabilities & Equ: $ 19,000,000 17 18 19 Income Statement FY 12/31 Answers go in the yellow boxes 21 Revenue 22 Cost of Goods Sold 23 Gross Profit 2019 $ 15,000,000 5,000,000 10,000,000 2 2 25 Selling General & Admin Research and Development 27 Depreciation and Amortizatior 28 Total Operating expenses 3,000,000 1,500,000 1,500,000 6,000,000 Current ratio 12/31/19 Accounts Receivable Tumover (2019) Total Asset Tumover (2019) Inventory Tumover (2019) Debt to Equity 12/31/19 Revenue to Cash (2019) Days revenue in Cash (2019) Days Inventory (2019) Retum on Assets (2019) Retum on Equity (2019) 2 2 2 2 2 2 2 2 4,000,000 30 Operating Profit 31 32 Interest Income Interest Expense 100,000 700,000 20 35 Pre tax Profit 25 Tax (@21%) 37 Net income 3,400,000 714,000 S 2,686,000 Prob. 1 - Income Stmt Prob. 2 - Working Capital Prob. 3 - Ratios + Home Insert Draw Page Layout Formulas Data Review View Tell me Share 0 Comments Times New Roman abe V 14 A y A % Conditional Formatting Format as Table Cell Styles O 5 v Paste BIU Number a. Av Cells Editing y Ideas Sensitivity LI M34 fx B D E F H 1 K 1 M 2 Problcm 3 - 20 Points Given the following Information on ABC Corp, calculate the ratios below ABC Corp. Year end statements Balance Sheet 12/31/19 Balance Sheet 12/31/18 S 2019 3,000,000 2,000,000 3,000,000 LIABILITIES Accounts Payable Current portion of LTD Accrued Liabilities Total Current Liabilities 2019 1,700,000 900.000 1,400.000 ASSETS Cash Accounts Recievable 2018 3,300,000 2,500,000 3,200,000 9,000,000 LIABILITIES Accounts Payable Cument portion of LTD Accrued Liabilities Total Current Liabilities 2018 2,000,000 1.000.000 1.000.000 4,000,000 Laventory 8,000,000 $ 4,000,000 Total Current Assets 8 ASSETS 7 Cash a Accounts Recievable 9 Inventory 10 Total Current Assets 11 12 Property Plant & Equipment, net 13 14 Other Assets 15 16 Total Assets 17 10 19 Income Statement FY 12/31 8,000,000 Long Term Debt (LTD) 9,000,000 Property Plant & Tquipment, net 8,000,000 Long Term Debt (LTD) 9,000,000 2,000,000 Sharcholder's Equity 5.000.000 Other Assets 2,000,000 Shareholder's Equity 6,000,000 S 18,000,000 Total Liabilities & Tquity 18,000,000 Tatal Assets S 19,000,000 Total abilities & Equity $19,000,000 Answers go in the yellow boxes 2019 $ 15,000,000 5,000,000 10,000,000 21 Revenue 22 Cost of Goods Sold 29 Gross Profit 24 25 Selling General & Admin 26 Research and Development 27 Depreciation and Amortization 28 Total Operating expenses 2 2 2 2 3,000,000 1.500,000 1,500,000 6,000,0XX Current rutio 12/31/19 Accounts Receivable Tumover (2019) Total Asset Turnover (2019) Inventory Turnover (2019) Debt to Equity 12/31/19 Revenue to Cash (2019) Days revenue in Cash (2019) Days Inventory (2019) Retum on Assets (2019) Retum on Equity (2019) 2 2 2 2 2 30 Operating Profit 4.000.000 100,000 700.000 20 32 Interest Income 99 Interest Expense 341 30 Pre tax Profit 30 Tax (@21%) 97 Net income 3,400,000 714,000 2,686,000 $ 40 41 42 44 45 Prob. 1 - Income Stmt Prob. 2 al Prob. 3 - Ratios + FaceTime