## 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? _______________

Our website has a team of professional writers who can help you write any of your homework. They will write your papers from scratch. We also have a team of editors just to make sure all papers are of HIGH QUALITY & PLAGIARISM FREE. To make an Order you only need to click Ask A Question and we will direct you to our Order Page at WriteDemy. Then fill Our Order Form with all your assignment instructions. Select your deadline and pay for your paper. You will get it few hours before your set deadline.

Fill in all the assignment paper details that are required in the order form with the standard information being the page count, deadline, academic level and type of paper. It is advisable to have this information at hand so that you can quickly fill in the necessary information needed in the form for the essay writer to be immediately assigned to your writing project. Make payment for the custom essay order to enable us to assign a suitable writer to your order. Payments are made through Paypal on a secured billing page. Finally, sit back and relax.