Question: Problem 2.1: Please use Excel file to (1) build the income statement; (2) calculate the following questions. Layout your initial input separately and clearly

Problem 2.1: Please use Excel file to (1) build the income statement;

Problem 2.1: Please use Excel file to (1) build the income statement; (2) calculate the following questions. Layout your initial input separately and clearly and do all the calculation inside the Excel file. (Excel part: 10 points) Consider the following abbreviated financial statements for Cabo Wabo, Incorporated: Assets Current assets Net fixed assets CABO WABO, INCORPORATED Partial Balance Sheets as of December 31, 2021 and 2022 2021 2022 $ 3,133 $ 3,345 14,038 14,509 CABO WABO, INCORPORATED 2022 Income Statement Sales $ 44,970 Costs Depreciation Interest paid Liabilities and Owners' Equity Current liabilities Long-term debt 2021 $ 1,387 7,353 2022 $ 2,058 8,397 22,512 3,873 999 a. What is owners' equity for 2021 and 2022? Note: Do not round intermediate calculations and round your answers to the nearest whole number, e.g., 32. b. What is the change in net working capital for 2022? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. c-1. In 2022, the company purchased $8,020 in new fixed assets. The tax rate is 21 percent. How much in fixed assets did the company sell? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. c-2. What is the cash flow from assets for the year? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. d-1. During 2022, the company raised $2,467 in new long-term debt. What is the cash flow to creditors? Note: A negative answer should be indicated by a minus sign. Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32. d-2. How much long-term debt must the company have paid off during the year? Note: Do not round intermediate calculations and round your answer to the nearest whole number, e.g., 32.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!