Chapter 2 Using the below information for ABC Inc. 2019 2020 Cost of Goods Sold $...

Transcribed Image Text:

Chapter 2 Using the below information for ABC Inc. 2019 2020 Cost of Goods Sold $ 255,605.00 $ 322,742.00 Cash $ 36,884.00 $ 55,725.00 Depreciation $ 72,158.00 $ 81,559.00 Interest Expense S 15,687.00 $ 17,980.00 Selling & Administrative Expenses Accounts Payable Net Fixed Assets Sales $ SSSS S 50,268.00 $ 65,610.00 26,186.00 $ 44,318.00 $ 318,345.00 $ 387,855.00 501,441.00 $ 611,224.00 Accounts Receivable $ 26,136.00 $ 33,901.00 Notes Payable $ 29,712.00 $ 32,441.00 Long-Term Debt $ 160,689.00 $ 175,340.00 Inventory $ 50,318.00 $ 67,674.00 New Equity $ $ 19,500.00 Assuming that ABC Inc. pays out 40% of their net income as dividends and has a 21% tax rate, please answer the following questions in Excel. 1. Prepare a Income Statement for 2019 and 2020 2. Prepare a Balance Sheet for 2019 and 2020. 3. Calculate the Operating Cash Flows (OCF) for each year. 4. Using OCF approach, what is the CFFA in 2020? 5. Using the cash flow from creditors and stockholders approach, what is the CFFA for 2020? Chapter 2 Using the below information for ABC Inc. 2019 2020 Cost of Goods Sold $ 255,605.00 $ 322,742.00 Cash $ 36,884.00 $ 55,725.00 Depreciation $ 72,158.00 $ 81,559.00 Interest Expense S 15,687.00 $ 17,980.00 Selling & Administrative Expenses Accounts Payable Net Fixed Assets Sales $ SSSS S 50,268.00 $ 65,610.00 26,186.00 $ 44,318.00 $ 318,345.00 $ 387,855.00 501,441.00 $ 611,224.00 Accounts Receivable $ 26,136.00 $ 33,901.00 Notes Payable $ 29,712.00 $ 32,441.00 Long-Term Debt $ 160,689.00 $ 175,340.00 Inventory $ 50,318.00 $ 67,674.00 New Equity $ $ 19,500.00 Assuming that ABC Inc. pays out 40% of their net income as dividends and has a 21% tax rate, please answer the following questions in Excel. 1. Prepare a Income Statement for 2019 and 2020 2. Prepare a Balance Sheet for 2019 and 2020. 3. Calculate the Operating Cash Flows (OCF) for each year. 4. Using OCF approach, what is the CFFA in 2020? 5. Using the cash flow from creditors and stockholders approach, what is the CFFA for 2020?