Question: Income Statement All figures in USD thousands Cash Flow Statement 2023F 2024F 2025F All figures in USD thousands CASH FROM OPERATIONS Revenue 58,150 COGS
Income Statement All figures in USD thousands Cash Flow Statement 2023F 2024F 2025F All figures in USD thousands CASH FROM OPERATIONS Revenue 58,150 COGS (45,540) 65,570 (47,230) 73,230 (49,250) Net Income Gross Profit 12,610 18,340 23,980 SG&A Other EBITDA Depreciation EBIT Depreciation Deferred Tax Cash from Accounts Receivable Cash from Inventory (6,120) (7,310) (8,250) (1,940) (2,150) (2,250) Cash from Accounts Payable Subtotal 20,670 27,800 34,480 (4,120) (4,150) (4,190) 16,550 23,650 30,290 CASH FROM INVESTING Capital Expenditure Subtotal Interest Expense (5,930) (6,110) (6,180) CASH FROM FINANCING EBT 10,620 17,540 24,110 Current Tax Deferred Tax Total Tax Net Income Balance Sheet 2023F 2024F 2025F All figures in USD thousands 2022A 2023F 2024F 2025F ASSETS Cash 5,000 Accounts Receivable 6,000 5,150 4,100 3,000 Inventory 2,000 3,200 4,000 5,000 Property Plant & Equipment 65,000 66,000 67,500 69,500 Total Assets LIABILITIES Accounts Payable 3,000 3,950 5,000 5,950 Line of Credit 5,000 4,000 2,000 1,000 Term Loan 20,000 17,000 14,000 11,000 Deferred Taxes 1,000 1,000 1,000 1,800 Total Liabilities (120) Line of Credit Issue/(Repay) Term Loan Issue/(Repay) Equity Issue/(Buyback) Payment of Dividends Subtotal EQUITY CASH BALANCE Beginning Change in Cash Ending Equity Capital Retained Earnings Shareholders' Equity Total Liabilities & Equity Check 34,000 52,000 52,000 52,000 15,000 9,500 8,120 10,010 Linking the Three Financial Statements The most important aspect of this course is knowing the interconnectivity of the three core financial statements. Open the attached Excel file and go to the worksheet labeled: Model What are the dividends paid on the cash flow statement in 2025F? The most important aspect of this course is knowing the interconnectivity of the three core financial statements. Open the attached Excel file and go to the worksheet labeled: Model What is the Cash from Accounts Payable in 2024F? Linking the Three Financial Statements The most important aspect of this course is knowing the interconnectivity of the three core financial statements. Open the attached Excel file and go to the worksheet labeled: Model What is the Earnings Before Tax (EBT) in 2025F? Linking the Three Financial Statements The most important aspect of this course is knowing the interconnectivity of the three core financial statements. Open the attached Excel file and go to the worksheet labeled: Model What is the depreciation on the cash flow statement in 2024F?
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
