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 boses below to develop the model.

Cash $200,000$

PP&E

Debt

Debt is equal to that of the previous year plus lssues $($Retirement$)$ of Debt

Equity is equal to that of the previous year plus Net lncome $($there are no Dividends$)$

Cash Flow Statement

Net Income

Depreciation

Cash Floy from Operations

CapEr

Cash Flow from Investing

Issues $($Retirement$)$ Debr

Cash Flow from Financing

Cash Generated

Net Income from the Income Statement

Investment Required spread of the useful life $(5$ years$)$

Debt based on Percent Debt Financed with $115$th retired each year. Must be a formula based on Q$52$ enabling changed assumptions of percent debt financed.

Write a fomula that calculates the Net Present Value $($NPV$)$ of the cash flows in Row $63$ using a $10\%$ discount factor

Change the 'Investment Required', cell $D28,$ to $$200,000$ and enter the resulting NPV value $($not the formula$)$ in the yellow bou below.

Keeping the $$200,000$ 'Investment Required' change the 'Percent Debt Financed' to $0\%$ and enter the resulting NPV value $($not the formula$)$ in the yellow bor below.