Free Cash Flows and Net Present Value calculation: $1.$ Open the spreadsheet $$Spreadsheet for FCF$.$ This spreadsheet contains a template you can use for computing the NPV and IRR of a hypothetical project. When entering numbers that involve multiples $($such as Revenue $=$ unit sales Price$/$unit x Quantity$)$ enter formulas so that you can change either Price$/$unit or Quantity and see how changes influence your final answer. $2.$ The details for the project are as follows: a$.$ All cash flows occur at the end of the year, today is time $0.$ All investment occurs today $($time $0).$ The first annual net cash flow occurs $1$ year from now at time $1.$ b$.$ $$200,000$ equipment cost $+$ $$12,000$ shipping $+$ $$32,000$ installation. c$.$ Economic life $=4$ years. d$.$ Salvage value at end of year $4=$ $$28,000.$ i$.$ Hint: The assets will be sold at the end of year $4.$ If the sale price exceeds the net book value of the assets at the end of year $4$ you must pay tax on the difference $($use the tax rate mentioned below$).$ e$.$ Depreciation Method for Tax Purposes: MACRS $3-$year class. Year MACRS factor X Initial Basis $($Total CapEx$)=$Depreciation $10\mathrm{.}333320\mathrm{.}444530\mathrm{.}148140\mathrm{.}0741$ f$.$ Annual unit sales $=1,300.$ g$.$ Sales price per unit $=$ $$210.$ h$.$ Cost per unit $=$ $$110.$ i$.$ Assume the sales price and the unit cost escalate at $3\%$ per year $($e$.$g$.$ at time $1$ the unit sales price is $$210$; it is $3\%$ greater at time $2,$ then $3\%$ greater at time $3,$ etc.$)$ j$.$ There are no other incremental cash costs k$.$ Net working capital at each date: i$.$ NWCt $=12\%($Salest$+1)[$e$.$g$.$ the net working capital investment at time $0$ equals $\mathrm{.}12$ times expected total sales at time $1]$ l$.$ Tax rate $=40\%.$ m$.$ The cost of capital for this project is $11\%.$ Please complete the free cash flow, NPV$,$ and IRR calculations in spreadsheet $$Spreadsheet for FCF$$