16 Mar Time Value of Money Project – Mrs. Beach wants to

Complete Excel and Finance Worksheet
Time Value of Money Project
Please work the problems in Excel or with a HP 10bII calculator. Please show all your work!
1. Mrs. Beach wants to invest a lump sum of money today to have $100,000 when she retires at 65 (she is 40 today).
a. How much of a deposit would she have to make if the interest rate on the C.D. was 5%?
b. What would Mrs. Beach have to deposit if she were to use high quality corporate bonds an earned an average rate of return of 7%.
c. What would Mrs. Beach have to deposit if she were to use common stock and earned an average rate of return of 11%.
d. What type of a problem is this? ___________
2. You have a payment that is due in 5 years for $50,000. You can earn a 5% safe rate of return on your money.
a. How much would you have to set aside today meet this payment in the future?
b. If your rate of return is 8%, how much would you have to set aside today?
c. If your rate of return is 10%, how much would you have to set aside today?
d. What type of a problem is this? ___________
3. You want to save enough money to retire as a millionaire.
a. If you could earn 10% with common stocks, how much would you have to set aside per year to have $1,000,000 when you are 65? Please use your own age.
b. If you were going to make deposit monthly, how much would you have to set aside per month to have $1,000,000 when you are 65? Please use your own age.
c. If you were able to earn 11%, how much would you have to set aside per month to have $1,000,000 when you are 65? Please use your own age.
d. What type of a problem is this? ___________
4. If you were going to buy your office from Mrs. Beach for $500,000 with a 10% down payment and 15 years with a 6% interest rate.
a. How much would your payments be each month?
b. What would be the principal and interest payment on the first payment?
c. What would be the principal and interest payment on the twelfth payment?
d. What type of a problem is this? ___________
5. Same problem as above, but assume that the loan was for 20 years?
a. What is the new payment?
b. What would be the principal and interest payment on the first payment?
c. What would be the principal and interest payment on the twelfth payment?
d. What type of a problem is this? ___________
6. You want to purchase a truck for $25,000 and you have $3,450 to put down.
a. How much will your payments be if you financed the truck for 60 months at 6%?
b. How much would the payment be if rate of interest is 5% and you only financed the truck for 48 months?
c. Assuming that you would only finance the truck for 4 years, how much would you need to put down to get your payment to $450.00?
d. What type of a problem is this? ___________
7. You have $350.00 per month to spend on a car payment. If your credit union charged 7.5% interest on a used car, how much car can you purchase if you will only finance for 4 years? __________
8. If you want to purchase a home. You have $25,000 to put down. All you can afford is $1500.00 per month and you do not want to finance for more than 15 years @ 4.5%. Your taxes will be $85.00 per month and insurance $60.00 a month. What is the amount you can pay for your home? (Show all your work)
9. You want to purchase a business with the following cash flows. How much would you pay for this business today? You need a 14% return to make this deal work. You will receive the cash at the end of the year?
First year $150,000
Second year $175,000
Third year $225,000
Forth year $275,000
10. How much would you pay for this business today assuming you need an 18% return to make this deal work? (Same problem as above.) What type of a problem is this? _______________