Question

1. You estimate that you will owe $45,300 in student loans by the time you graduate. The interest rate is 4.25 percent. If you want to have this debt paid in full within ten years, how much must you pay each month?

2. Your insurance agent is trying to sell you an annuity that costs $230,000 today. By buying this annuity, your agent promises that you will receive payments of $1,225 a month for the next 30 years. What is the rate of return on this investment?

3. Today, you borrowed $6,200 on your credit card to purchase some furniture. The interest rate is 14.9 percent, compounded monthly. How long will it take you to pay off this debt assuming that you do not charge anything else and make regular monthly payments of $120?

4. Southern Tours is considering acquiring Holiday Vacations. Management believes Holiday Vacations can generate cash flows of $187,000, $220,000, and $245,000 over the next three years, respectively. After that time, they feel the business will be worthless. Southern Tours has determined that a 13.5 percent rate of return is applicable to this potential acquisition. What is Southern Tours willing to pay today to acquire Holiday Vacations?

5. You are the beneficiary of a life insurance policy. The insurance company informs you that you have two options for receiving the insurance proceeds. You can receive a lump sum of $200,000 today or receive payments of $1,400 a month for 20 years. You can earn 6 percent on your money. Which option should you take and why? (Compare PV on an annuity to the lump sum)

6. Your grandmother is gifting you $125 a month for four years while you attend college to earn your bachelor's degree. At a 6.5 percent discount rate, what are these payments worth to you on the day you enter college?

7. Holiday Tours (HT) has an employment contract with its newly hired CEO. The contract requires a lump sum payment of $10.4 million be paid to the CEO upon the successful completion of her first three years of service. HT wants to set aside an equal amount of money at the end of each year to cover this anticipated cash outflow and will earn 5.65 percent on the funds. How much must HT set aside each year for this purpose?

8. You are planning to save for retirement over the next 15 years. To do this, you will invest $1,100 a month in a stock account and $500 a month in a bond account. The return on the stock account is expected to be 7 percent, and the bond account will pay 4 percent. When you retire, you will combine your money into an account with a 5 percent return. How much can you withdraw each month during retirement assuming a 20-year withdrawal period?

Answer 1

1) first we have to convert period of repayment into no. of months and monthly interest rate,

and then calculate PVIFA (present value interest rate factor of annuity)

PVIFA = ((1+r)ⁿ -1)/((1+r)ⁿ *r)

where r = monthly interest rate

n = period of repayment (months)

payment per month = amount of loan/PVIFA

2)

the rate of return is found using RATE function in EXCEL

where nper = period of repayment (months)

pv = -cost of annuity

pmt = payment per month