Question

In: Finance

Advanced Time Value of Money Problems (Try to work this question WITHOUT using Excel, get calculation...

Advanced Time Value of Money Problems

(Try to work this question WITHOUT using Excel, get calculation in detail)

Question (College planning)

Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Financial Economics you decide to send your child to Hofstra University as well. You anticipate the annual tuition to be $60,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday every year starting today, the day of your child’s birth. No deposits will be made after starting college. The first tuition payment is due in exactly 18 years from today (the day your child turns 18 – no deposit required, i.e. last deposit is on 17th birthday). Assume the annual expected return on your investments is 10% over this period.

  1. (i) Calculate the annual deposit.

  2. (ii) Calculate the amount needed if only equal annual deposits are made on birthday’s 5-10 inclusive.

  3. (iii) Calculate the amount needed if two equal annual deposits are made on birthday’s 5 and 13.

  4. (iv) Answer part (i), now assume tuition rises 10% per year.

  5. (v) Answer part (i) assuming first deposit will be made on your child’s 1st birthday. All other information is the same. What is the annual tuition payment? How does it compare to part (i)? Is your answer surprising?

Solutions

Expert Solution

(i) Annual Tuition Fees = $ 60000, Tuition Fees is Required on the child's 18th,19th,20th and 21st birthday, Annual Interest Rate = 10%,Annual Deposits start at t=0 (current time) and continue upto t = 17 for a total of 17 deposits

Let the required annual deposits be $ p

Therefore, Future Value of 17 Deposits at the end of year 18 = PV of Annual Tuition Withdrawals at the end of Year 18

p x (1.1)^(18) + p x (1.1)^(17) +.........+ p x (1.1) = 60000 x (1/0.1) x [1-{1/(1.1)^(4)}] x (1.1)

p x [{(1.1)^(18)-1} / {1.1-1}] x (1.1) = 209211.12

p x 50.1591 = 209211.12

p = 209211.12 / 50.1591 = $ 4170.95

(ii) let the required annual deposits be y

If annual deposits are made on birthdays between 5-10 years, then deposits come in at the end of year 5,year 6,year 7,year 8,year 9 and year 10.

Therefore, y x (1.1)^(18-5) + y x (1.1)^(18-6) +.............+ y x (1.1)^(18-10) = 209211.12

y x 16.5391 = 209211.12

y = 209211.12 / 16.5391 = $ 12649.49

(iii) Let the required deposits be $ m

Two Deposits are made, one each at the end of Year 5 and Year 13

Therefore, m x (1.1)^(18-5) + m x (1.1)^(18-13) = 209211.12

m x 5.06278 = 209211.12

m = 41323.36

(iv) If tuition fees rise at a rate of 10 % per annum, the required tuition withdrawals constitute a growing annuity starting immediately.

Therefore, PV of Growing Annuity at the end of Year 18 = 60000 + 60000 x [(1.1)/(1.1)] + 60000 x [(1.1)^(2)/(1.1)^(2)] + 60000 x [(1.1)^(3)/(1.1)^(3)] = $ 240000

Let the required annual deposits be $ n

n x 50.1591 = 240000

n = 240000 / 50.1591 = $ 4784.77

(v) If first deposit is made on the child's 1st birthday, then the deposit stream resembles an ordinary annuity.

Let the required annual deposits be $ k

Therefore, k x (1.1)^(17) + k x (1.1)^(16) +..............+ k = 209211.12

k x [{(1.1)^(18)-1} / {1.1-1}] = 209211.12

k x 45.5992 = 209211.12

k = 209211.12 / 45.5992 = $ 4588.05


Related Solutions

Advanced Time Value of Money Problems (Try to work this question WITHOUT using Excel, get calculation...
Advanced Time Value of Money Problems (Try to work this question WITHOUT using Excel, get calculation in detail) Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years and leave...
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail)...
Question ( mortgage problem) (Try to work this question WITHOUT using Excel, get calculation in detail) You are considering the purchase of a $500,000 home. You plan to take a 30-year fixed mortgage after making a 20% downpayment to avoid PMI. Payments are to be made monthly (at the end of the month) and the APR is 8%. What is the monthly payment? During what month does the principal portion first exceed the interest portion? Are you surprised by your...
(Try to work this question WITHOUT using Excel, get answer by using the formula and show...
(Try to work this question WITHOUT using Excel, get answer by using the formula and show the calculations in detail) Question (Retirement planning) You have just graduated Hofstra University at age 22. You hard work has paid off as you already have a job as an investment banker at Goldman Sachs waiting for you. You plan to work continuously until age 65 and retire exactly on that day. You expect to live until exactly 90 and enjoy your golden years...
Advanced Time Value of Money Problems Question 2 (2nd mortgage problem) You are considering the purchase...
Advanced Time Value of Money Problems Question 2 (2nd mortgage problem) You are considering the purchase of a $500,000 home. You plan to take a 30-year fixed mortgage after making a 20% downpayment to avoid PMI. Payments are to be made monthly (at the end of the month) and the APR is 8%. What is the monthly payment? During what month does the principal portion first exceed the interest portion? Are you surprised by your answer? How long does it...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
Solve the following financial problems using the time value of money functions in Excel (PV, FV,...
Solve the following financial problems using the time value of money functions in Excel (PV, FV, PMT, NPER, RATE, EFFECT) OR using your financial calculator. Assume you deposit $3,000 today, and $300 at the end of each year, in an account earning 4% per year for 20 years. What is the future value? General Electric has an unfunded pension liability of $300 million that must be paid in 15 years. The CFO deposits $10 million in account today to help...
Advanced Time Value of Money Problems Your child was just born and you are planning for...
Advanced Time Value of Money Problems Your child was just born and you are planning for his/her college education. Based on your wonderful experience in Financial Economics you decide to send your child to Hofstra University as well. You anticipate the annual tuition to be $60,000 per year for the four years of college. You plan on making equal deposits on your child’s birthday every year starting today, the day of your child’s birth. No deposits will be made after...
QUESTION 5 In calculation of time value of money, the interest rate has a _________ relationship...
QUESTION 5 In calculation of time value of money, the interest rate has a _________ relationship to the present value and _________ relationship to the future value of an investment.              positive; negative             negative; negative            negative; positive           positive; positive             None of the options specified here 10 points   QUESTION 6 The present value of a single future sum:              is generally larger than the future sum.             depends upon the number of discount periods.            increases as...
Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and...
Time Value of Money Complete the following exercise using MS Excel. Using the Present Value and Future Value Equations 4. If you invested $200 at 5%, how much would it be worth in 30 years? 5. How many years does it take to double your money if it is invested at 6%? 6. If you invest $10,000 in a 20 year annuity paying 5%, what would be the annual payment made to you? 7. If you have a student loan...
This should be done in as an Excel file. Using the simple time value of money...
This should be done in as an Excel file. Using the simple time value of money concepts from Corporate Finance course: Calculate the price of an annual coupon‐bond with a par value of $1,000, time to maturity of 10 years, coupon rate of 10% and yield to maturity of 12% (bond DC). yield to maturity of 8% (bond PC). Do the sensitivity analysis on the price of these two bonds (bond DC & bond PC) by changing the following (one...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT