Chapter $14$: Applying Excel

Enter a formula or cell reference into each of the cells marked with a $"?".$

For example, in cell C$21$ enter the formula$=$ B$10$

$*$Use the following formulas:

Present value of $$1=\frac{1}{(1+r{)}^n}$

Present value of an annuity of $$1=(\frac{1}{r}{)}^{**}(1-(\frac{1}{(1+r{)}^n}))$

where $n$ is the number of years and $r$ is the discount rate