1. What are the future values of the following:
a. $1,000 a year for 12 years compounded annually at 6% using financial calculator
b. $25,000 a year for 5 years compounded annually at 3%? using excel
c. $1,500 a year for 20 years compounded annually at 2%
d. $10,000 a year for 10 years compounded annually at 4%
e. $3,000 a year for 3 years compounded annually at 5%
2. What is the present value of the following using excel formula?
a. A $5,000 perpetuity discounted back to the present at 5%
b. A $2,000 perpetuity discounted back to the present at 6%
c. A $15,000 perpetuity discounted back to the present at 8%
d. A $7,000 perpetuity discounted back to the present at 9%
e. A $10,000 perpetuity discounted back to the present at 2%