Can You pls help solve this

For the purpose of developing the model, you have selected some initial values for the two independent variables. investment Required Percent Debt Financed 200,000 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 inciu de 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. Income Statement Finished Goods Expense Depreciation Labor Overhead EBIT Interest Income (5% interest rate) Prex Tax (30%tax rate) Net Income Balance sheet (change in account) Cash PPstE Debt Eduity Cash Flaw Smelnenl Net Income Depreciation Cash Flow from Operatluns CapEx cash Flow from Investing issues (Retirement) Debt Cash Flow from Financing Cash Generated 2020 2021 2022 2023 2024 2025 200,000 200,000 200,000 200,000 200,000 (50,000) (50,000) (50,000) (50,000) (50,000) (100,000) (100,000) (100,000) (100,000) (100,000) (10,000) (10,000) (10,000) (10,000) (10,000) 30,000 30,000 30 ,000 30,000 30,000 30,000 30,000 30 ,000 30,000 30,000 9,000 9,000 9,000 9,000 9,000 21,000 21,000 21,000 21,000 21,000 (1 50,000) 200,000 1 50,000 (200,000) (300,000) - - . . . 150,000 - . . . . (150,000) - . . . . Write a fomula that calculates the Net Present Value (N PV) of the cash flows in Row 51 using a 10% discount factor. H change the 'lnvestment Required ', cell D27, to $200,000 and enter the resulting va value (not the formula) in the yellow box below. H Keeping the $200,000 'lnvestment Required' change the 'Percent Debt Financed' to 0% and enter the resulting NPV in the yellow box below. H H Ink Shown as positive because it is an expense that will cease to exist Interest Income is based on a 5%interest rate applied to prior year Net Cash (cash minus Debt) 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 FiowStatementas negative) minus Depreciation Debt is equal to that of the previous year plus issues (Retirement) of Debt Ed uity is equal to that of the previous year plus Net Income (there are no Dividends) Net income from the income Statement Investment Required spread of the useful life (5 years) Debt based on Percent Debt Financed with 1/5th retired each year