For the purpose of developing the model, you have selected some initial values for the two independent variables. Investment Required 300,000 10 Percent Debt Financed 50% You are responsible for developing a model that analyzes the patential 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 2020 2021 2022 2023 2024 2025 Hints Shown as positive because it is an expense that will cease to exist 200,000 (60,000) (100 000) (10,000) 30,000 200,000 (60,000) 1100,000) 200,000 160,000 (100,0001 (10,0001 30,000 200,000 (50,000 (100,000) Income Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (SX interest rate) Pretak Tax (30 tax rate) Net Income 200,000 (50,000) (100,000) (10,000) 30,000 (10,0001 110.000 30.000 30,000 Interest Income is based on a 5% interest rate applied to prior year Net Cash (Cash minus Debt 30 000 9000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 Balance 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 minus Capex (shown on Cash Flow Statement as negative) minus Depreciation Debt is equal to that of the previous year plus issues (Retirement of Debt Equity is equal to that of the previous yesur plus Net Income (there are no Dividends) Debt Equity Cash Flow Statement Net Income Net Income from the Income Statement Investment Required spread of the useful life (5 years) Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement Debt Cash Flow from Financing Cash Generated (300,000) (300,000) 150,000 150,000 (150,000) Debt based on Percent Deht Financed with 1/5th retired each year Write a fomula that calculates the Net Present Value INPV) of the cash flows in Row 61 using a 10% discount factor. Change the 'Investment Required', cell D27, ta $ 200,000 and enter the resulting NPV value (not the formulat in the yellow box below. Keeping the $200,000'investment Required' change the 'Percent Debt Financed' to OK and enter the resulting NPV in the yellow box below. For the purpose of developing the model, you have selected some initial values for the two independent variables. Investment Required 300,000 10 Percent Debt Financed 50% You are responsible for developing a model that analyzes the patential 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 2020 2021 2022 2023 2024 2025 Hints Shown as positive because it is an expense that will cease to exist 200,000 (60,000) (100 000) (10,000) 30,000 200,000 (60,000) 1100,000) 200,000 160,000 (100,0001 (10,0001 30,000 200,000 (50,000 (100,000) Income Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (SX interest rate) Pretak Tax (30 tax rate) Net Income 200,000 (50,000) (100,000) (10,000) 30,000 (10,0001 110.000 30.000 30,000 Interest Income is based on a 5% interest rate applied to prior year Net Cash (Cash minus Debt 30 000 9000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 30,000 9,000 21,000 Balance 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 minus Capex (shown on Cash Flow Statement as negative) minus Depreciation Debt is equal to that of the previous year plus issues (Retirement of Debt Equity is equal to that of the previous yesur plus Net Income (there are no Dividends) Debt Equity Cash Flow Statement Net Income Net Income from the Income Statement Investment Required spread of the useful life (5 years) Depreciation Cash Flow from Operations Capex Cash Flow from Investing Issues (Retirement Debt Cash Flow from Financing Cash Generated (300,000) (300,000) 150,000 150,000 (150,000) Debt based on Percent Deht Financed with 1/5th retired each year Write a fomula that calculates the Net Present Value INPV) of the cash flows in Row 61 using a 10% discount factor. Change the 'Investment Required', cell D27, ta $ 200,000 and enter the resulting NPV value (not the formulat in the yellow box below. Keeping the $200,000'investment Required' change the 'Percent Debt Financed' to OK and enter the resulting NPV in the yellow box below