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
Get step-by-step solutions from verified subject matter experts
