Michael Dundee is scheduling a savings education program for his son, Jimmy who is now 13 years old. Jimmy plans to enrol at the university in 5 years, and it should take him 4 years to complete his degree in Business Administration. Currently, the cost per year is RM12,500, but an increase in 5% rate in the education costs is forecasted annually. Jimmy recently received RM7,500 from his grandfather as a gift; this money, is invested in a unit trust paying 8% interest compounded annually, will be used to help meet the costs of the education. The rest of the costs will be met by money that Michael will deposit in the savings account. He will make equal deposits to the account in each year from now until Jimmy starts his university, for a total of 6 deposits. These deposits will begin today will also earn 8% interest. i.  What will the present value of the cost of 4 years of education at the time Jimmy turns 18? ii.  What will the value of RM7,500 that Jimmy received from his grandfather’s estate when he starts university at age 18? iii. If Michael is planning to make his first deposits today, how large must each deposit be for him to be able to put Jimmy through university?

Excel Applications for Accounting Principles
4th Edition
ISBN:9781111581565
Author:Gaylord N. Smith
Publisher:Gaylord N. Smith
Chapter27: Time Value Of Money (compound)
Section: Chapter Questions
Problem 6E
icon
Related questions
Question

Michael Dundee is scheduling a savings education program for his son, Jimmy who is now 13
years old. Jimmy plans to enrol at the university in 5 years, and it should take him 4 years to
complete his degree in Business Administration. Currently, the cost per year is RM12,500, but
an increase in 5% rate in the education costs is forecasted annually. Jimmy recently received
RM7,500 from his grandfather as a gift; this money, is invested in a unit trust paying 8%
interest compounded annually, will be used to help meet the costs of the education. The rest of
the costs will be met by money that Michael will deposit in the savings account. He will make
equal deposits to the account in each year from now until Jimmy starts his university, for a
total of 6 deposits. These deposits will begin today will also earn 8% interest.


i.  What will the present value of the cost of 4 years of education at the time Jimmy turns
18?


ii.  What will the value of RM7,500 that Jimmy received from his grandfather’s estate when
he starts university at age 18?

iii. If Michael is planning to make his first deposits today, how large must each deposit be
for him to be able to put Jimmy through university?

Expert Solution
trending now

Trending now

This is a popular solution!

steps

Step by step

Solved in 4 steps with 3 images

Blurred answer
Knowledge Booster
Checking Accounts
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.
Similar questions
  • SEE MORE QUESTIONS
Recommended textbooks for you
Excel Applications for Accounting Principles
Excel Applications for Accounting Principles
Accounting
ISBN:
9781111581565
Author:
Gaylord N. Smith
Publisher:
Cengage Learning
SWFT Comprehensive Vol 2020
SWFT Comprehensive Vol 2020
Accounting
ISBN:
9780357391723
Author:
Maloney
Publisher:
Cengage
SWFT Comprehensive Volume 2019
SWFT Comprehensive Volume 2019
Accounting
ISBN:
9780357233306
Author:
Maloney
Publisher:
Cengage
SWFT Individual Income Taxes
SWFT Individual Income Taxes
Accounting
ISBN:
9780357391365
Author:
YOUNG
Publisher:
Cengage
Cornerstones of Cost Management (Cornerstones Ser…
Cornerstones of Cost Management (Cornerstones Ser…
Accounting
ISBN:
9781305970663
Author:
Don R. Hansen, Maryanne M. Mowen
Publisher:
Cengage Learning