Download Mrs. Beach

Download:	http://solutionzip.com/downloads/mrs-beach/
Instructions:
Students may use either Microsoft Excel or a HP10BII calculator to solve the problems. If Excel is used, this document should be saved and uploaded in the appropriate assignment folder. If the financial calculator is used, all work must be shown and uploaded as appropriate. All work must be shown; simply providing an answer is not acceptable (in Excel, your equations will be adequate). Please ensure you appropriately identify each question and sub-question regardless of method used. Solutions that can’t be easily ties to the question will receive zero points.
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?
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?
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?
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 factory. You have $50,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 @ 6.5%, (your taxes will be $185.00 per month and insurance $600.00 a month), what is the amount you can pay for the house? (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 assuming you need a 14% return to make this deal?
a. First year $150,000
b. Second year $175,000
c. Third year $225,000
d. Forth year $275,000
10. How much would you pay for this business today assuming you needed a 18% return to make this deal? (Same problem as above.)
What type of a problem is this? ___________
Download:	http://solutionzip.com/downloads/mrs-beach/