You are responsible for developing a model that analyzes the potential investment, providing valuations of alternate strategies and a sensitivity analysis of the results.
The following model should include only the incremental impact on the Income Statement, Balance Sheet and Cash Flow Statement.
Please enter formula in the yellow boxes below to develop the model.

2021 2022 2023 2024 2025 2026 Hints Shown as positive because it is an expense that will cease to exist come Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (5% interest rate) Pretax Tax (30%tax rate) Net Income 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 Interest Income is based on a 5% interest rate applied to prior year Net Cash (Cash minus Debt) 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 alance Sheet (change in account) Cash PP&E (150,000) 300,000 150,000 Cash is equal to that of the previous year plus Cash Generated PP&E is equal to that of the previous year plus CapEx. (However, CapEx is shown as a negative on the Cash Flow Statement sor Debt is equal to that of the previous year plus Issues (Retirement) of Debt Equity is equal to that of the previous year plus Net Income (there are no Dividends) Debt Equity sh Flow Statement Net Income Net Income from the Income Statement Investment Required spread of the useful life (5 years) 0 0 0 0 0 Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement) Debt Cash Flow from Financing (300,000) (300,000) 150,000 150,000 (150,000) Debt based on Percent Debt Financed with 1/5th retired each year. Must be a formula based on D50 enabling changed assumpt Cash Generated 2021 2022 2023 2024 2025 2026 Hints Shown as positive because it is an expense that will cease to exist come Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (5% interest rate) Pretax Tax (30%tax rate) Net Income 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 360,000 (60,000) (180,000) (10,000) 110,000 Interest Income is based on a 5% interest rate applied to prior year Net Cash (Cash minus Debt) 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 110,000 33,000 77,000 alance Sheet (change in account) Cash PP&E (150,000) 300,000 150,000 Cash is equal to that of the previous year plus Cash Generated PP&E is equal to that of the previous year plus CapEx. (However, CapEx is shown as a negative on the Cash Flow Statement sor Debt is equal to that of the previous year plus Issues (Retirement) of Debt Equity is equal to that of the previous year plus Net Income (there are no Dividends) Debt Equity sh Flow Statement Net Income Net Income from the Income Statement Investment Required spread of the useful life (5 years) 0 0 0 0 0 Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement) Debt Cash Flow from Financing (300,000) (300,000) 150,000 150,000 (150,000) Debt based on Percent Debt Financed with 1/5th retired each year. Must be a formula based on D50 enabling changed assumpt Cash Generated