Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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%?

image text in transcribed
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

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Basic Finance An Introduction To Financial Institutions, Investments, And Management

Authors: Herbert B. Mayo

12th Edition

1337691011, 978-1337691017

More Books

Students also viewed these Finance questions

Question

1. Too reflect on self-management

Answered: 1 week ago

Question

Food supply

Answered: 1 week ago