Time Value of Money Test Time Value of Money Project Please work the problems in Excel or with a HP 10bII calculator. Please show all your work! Name _________________ 1. Mrs. Beach wants to invest a...

do assignment in excel


Time Value of Money Test Time Value of Money Project Please work the problems in Excel or with a HP 10bII calculator. Please show all your work! Name _________________ 1. Mrs. Beach wants to invest a lump sum of money today to have $250,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 need to have $150,000 for your children’s tuition. How much money do you need to set aside each month for this amount to be available in 15 years? a. If you were to invest the money in a savings account at 3% interest? b. If you were to invest the money in a bond fund at 6% interest? c. If you were to invest the money in an equity fund at 10% interest? 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 home from Mrs. Beach for $250,000 with a 10% down payment and 15 year mortgage at a 5% 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 5.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 $1750.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? a. First year $150,000 b. Second year $175,000 c. Third year$225,000 d. Forth year$275,000 What type of a problem is this? _______________ 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? _______________