Please use excel to put these formulars in spreadsheets and in autosave

Section $1$: Value of an Investment

$(1)$ Present value of investment$($s$)$

Or

Or Prepare the following table $($v $=$ Total of the last column$)$

Year Cash Flow Present value Present Value

$($A$)$ factor $($B$)($A x B$)$

$1$

$2$

$3$

$4$ & so on

Total