An investment promises the following cash flow stream: $-$$$2,300$ at Time $0$;$$700$ at the end of Year $1$; $$1,200$ at the end of Year $2$; and $$900$ at the end of Year $3.$

a$.$ At a discount rate of $5\%,$ what is the present value of the cash flow stream?

b$.$ What is its future value at $5\%$ at the end of year $3?$

Directions:

Solve the problems in Excel. Use formula$-$driven approach. If no formulas $$ no credit.

Upload your Excel file to the Assignment prompt. The file must be in Excel format, so I can check your formulas. If any other format $$ no credit.