Question: Please answer using Excel functions!!! a. Find the FV of $1,500 invested to earn 15% after 5 years. b. Find the PV of $1,500 due

Please answer using Excel functions!!!

a. Find the FV of $1,500 invested to earn 15% after 5 years.

b. Find the PV of $1,500 due in 5 years if the discount rate is 5%

c. Find the PV of an ordinary annuity that pays $2,000 each of the next 10 years if the interest rate is 10%. Then find the FV of that same annuity

d. A security has a cost of $1,500 and will return $2,000 after 10 years. What rate of return does the security provide?

e. Suppose Californias population is 38.5 million people, and its population is expected to grow by 2% annually. How long will it take for the population to double?

f. How will the PV and FV of the annuity change if it is an annuity due rather than an ordinary annuity.

g. Find the annual payments for an ordinary annuity and an annuity due for 10 years with a PV of $1,500 and an interest rate of 10%.

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!