Note: Show workings

Chapter 12: Applying Excel Data Example E *Use the formulas from Appendix 13B: Present value of $1=1/(1+r)nn Present value of an annuity of $1=(1/r)(1(1/(1+r)n)) where n is the number of years and r is the discount rate