Investment Required 300,000 Percent Debt Financed 50% 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 come Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (5% interest rate) Pretax Tax (30%tax rate) Net Income 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 alance Sheet (change in account) Cash PP&E Debt Equity (150,000) 300,000 150,000 0 sh Flow Statement Net Income Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement) Debt Cash Flow from Financing Cash Generated 0 0 0 (300,000) (300,000) 150,000 150,000 (150,000) Investment Required 300,000 Percent Debt Financed 50% 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 come Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (5% interest rate) Pretax Tax (30%tax rate) Net Income 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 217,695 (60,000) (108,847) (10,000) 38,847 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 38,847 11,654 27,193 alance Sheet (change in account) Cash PP&E Debt Equity (150,000) 300,000 150,000 0 sh Flow Statement Net Income Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement) Debt Cash Flow from Financing Cash Generated 0 0 0 (300,000) (300,000) 150,000 150,000 (150,000)