QUESTION $1$

Consider the following timeline detailing a stream of cash flows:

nato

flow

If the current market rate of interest is $6\%,$ the present value of this stream of cash flows is close to $

Asssuming the same market rate of interest, what would be the value of these cash flows in year $4?$ $

Assuming you would need to invest $20,000$ on year $0$ to have the cash flows above from years $1$ to $4,$ what would be your internal return of investment $($IRR$)?$

$\%$Solve using excel