Question: How would I solve this question in excel? (1) What is the future value of $5,000 after 15 years when interest is 4%? Use this

How would I solve this question in excel?

(1) What is the future value of $5,000 after 15 years when interest is 4%?

How would I solve this question in excel? (1) What is the

Use this handout as your coversheet after filling in the blanks with values you make-up and attaching whatever spreadsheets you generate when solving the problems below. 1. What is the future value of $_ after 15 years when interest is 4%? See example. .8 2. What is the future value in the preceding problem if interest is compounded monthly ? 3. What is the future value after 22 years of year-end deposits of $_ earning 3%? 4. What is the future value in the preceding problem if deposits are year-beginning? 5. What is the most you should pay today for a piece of land which will be worth $500,000 in years if you want a 15% return? 6. What is the present value of an annuity due which pays $ per year for 10 years if a 12% discount rate is used? 7. How much would you have to pay today for a 25-year annuity paying $45,000 annually if it begins 15 years from now and you want a return? 8. If you want a o return, what is the most you should pay today for a stock that will trade at $75 in 5 years and pay a $2 annual dividend? 9. If you paid $750 for an investment years ago that is now worth $2000, what was your rate of return? 10. If you save $100 per month, what annual rate of interest must you earn in order to accumulate $10,000 after years? 11. If you borrow $250,000 for years and your monthly payment is $1000, what rate of interest are you paying? 12. If you bought a bond five years ago for $900 which paid annual interest of and sold it today for $950, what was your rate of return

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!