E$5.3($LO $2,3,4)$ Computation of Future Values and Present Values

Using Excel's financial functions, answer each of the following questions. $($Each case is independent of the others.$)$

a$.$ What is the future value of $\backslash (\backslash$$ $7,000\backslash )$ at the end of $5$ periods at $\backslash (8\backslash \%\backslash )$ compounded interest?

b$.$ What is the present value of $\backslash (\backslash$$ $7,000\backslash )$ due $8$ periods hence, discounted at $\backslash (6\backslash \%\backslash )?$

c$.$ What is the future value of $15$ periodic payments of $\backslash (\backslash$$ $7,000\backslash )$ each made at the end of each period and compounded at $\backslash (10\backslash \%\backslash )?$

d$.$ What is the present value of $\backslash (\backslash$$ $7,000\backslash )$ to be received at the end of each of $20$ periods, discounted at $\backslash (5\backslash \%\backslash )$ compound interest?

NOTE: Enter a formula, a cell reference, or a value $($if you are unable to reference a cell$),$ into the yellow shaded input cells.

a$.$ Future value

b$.$ Present value

c$.$ Future value

d$.$ Present value