Question

You are a young personal financial adviser. Molly, one of your clients approached you for consultation about her plan to save aside $450,000 for her child’s higher education in United States 15 years from now. Molly has a saving of $120,000 and is considering different alternative options: Investment 1: Investing that $120,000 in a saving account for 15 years. There are two banks for her choice. Bank A pays a rate of return of 8.5% annually, compounding semi-annually. Bank B pays a rate of return of 8.45 annually, compounding quarterly. Investment 2: Putting exactly an equal amount of money into ANZ Investment Fund at the end of each month for 15 years to get 330 000 she still shorts of now. The fund is offering a rate of return 7% per year, compounding monthly.

Required:

a) Identify which Bank should Molly choose in Investment 1 by computing the effective annual interest rate (EAR)?

b) Calculate the amount of money Molly would accumulate in Investment 1 after 15 years if she chooses Bank B?

c) How much is the annual interest rate, assuming compounding annually Molly should aim at if she chooses to invest her $120 000 in a saving account to get the $450,000 ready in just 10 years from now?

d) Calculate the monthly payment Molly needs to contribute into ANZ Investment Fund to get $330,000 after 15 years in Investment 2?

e) In investment 2, if Molly changes to contribute $1200/month to that super fund at the beginning of each month, how much money she would have in ANZ Investment fund after 15 years?

f) Molly is offered an investment that will pay $12 000 each year forever. How much should she pay for this investment if the rate of return 12% applies? (1 mark)

No Financial Calculator, Excel Calculations and No Excel files are accepted. You are allowed only one attempt to submit your assignment.

Answer 1

a)

EAR = (1+(r/n))^n - 1

Bank A = (1+(8.5%/2))^2 - 1 = 8.68%

Bank B = (1+ (8.45%/2))^2 - 1 = 8.72%

Bank B should be selected because it has high EAR

b)

Future value = present value*(1+r)^n

r = EAR

n = number of years

Future value = 120000*(1+8.72%)^15 = $420,645.06

c)

Using the same Formula above:

450000 = 120000*(1+r)^10

r = (450000/120000)^(1/10) - 1

r = 14.13%

d)

Future value of annuity = P*[(1+r)^n - 1 / r ]

P = monthly deposits

r = rate of interest per month = 7% / 12 = 0.5833%

n = number of periods = 15 * 12 = 180

330,000 = P*[(1+0.5833%)^180 - 1 / 0.5833% ]

Monthly payments (P) = 330,000 / 316.9622967

Monthly payments = $1041.13

e)

Future value of annuity due = P*[(1+r)^n - 1 / r ]*(1+r)

Future value = 1500*[(1+0.5833%)^180 - 1 / 0.5833%]*(1+0.5833%)

= $478,216.87

f)

Present value of perpetuity = PMT / r

r = rate of return

PMT = annual payments

Value = 12000 / 12% = $100,000