SOLVE USING EXCEL

Given the following cash flows: $$

Time

Time Cash Flow $($in periods PV Year $0$: $($$$2,250)$ Year $1$: $$750$ Year $2$: $$825$ Year $3$: $$750$ Year $4$: $$850$ Year $5$: $$750$

a$.$ Use the NPV function in an equation to find the Net Present Value of the following cash flows at the rate given above.

b$.$ Calculate the NPV without the NPV functions built in $($make your own algebraic formulas$).$ Did you get the same answer?

c$.$ Use the IRR function to find the IRR, what is it$?$

NPV using function $=$

NPV using NO function $=$ IRR $=$

Scratch Space below: