Question
Assume that you just had a child, and you are now planning for her college education. You would like to make 43 equal payments over
Assume that you just had a child, and you are now planning for her college education. You would like to make 43 equal payments over the next 21 years (the first payment to be made immediately, all other payments to be made at 6-month intervals, with the final payment to be made at her 21st birthday) so that you will be able to cover her expected expenses while in school. You expect to pay expenses on her 18th, 19th, 20th, and 21st birthdays. Assume that the current (time period 0) annual cost of college is $6,000, that you expect annual inflation to be 8 percent for the next 5 years, and then 5 percent thereafter. If you expect to be able to earn a return of 4 percent every 6 months on your investments (a simple rate of 8 percent with semiannual compounding), what will be the amount of each of the 43 payments? Selected Answer: Incorrectd. $785.72 Answers: a. $650.46 b. $705.86 Correctc. $731.93 d. $785.72 e. $692.15 Response Feedback: Rationale: Cash flow time line: Financial calculator solution: Calculate college cost at 8% growth for 5 years Inputs: N = 5; I = 8; PV = 6,000. Output: FV5 = $8.815.97. Calculate FV of tuition cost in Years 18 through 21 at 5% growth Inputs: N = 13; I = 5; PV = 8,815.97. Output: FV18 = $16,623.83 N = 14 FV19 = $17,455.02 N = 15 FV20 = $18.327.77 N = 16 FV21 = $19,244.16 Use cash flows to discount FVs to PV Inputs: = 0; = 0; N1 = 35; = 16,623.83; = 0; = 17,455.02; = 0; = 18,327.77; = 0; = 19,244.16; I = 4. Output: NPV = $15,506.49. Calculate payment based on PV of costs BEGIN mode. Inputs: N = 43; I = 4; PV = 15,506.49. Output: PMT = $731.93. Alternate solution for payment using END mode and FV of costs: Use cash flows to compound costs to NPV: Inputs: = 16,623.83; = 0; = 17,455.02; = 0; = 18,327.77; = 0; = 19,244.16; I = 4. Output: NFV = $80,521.83. END mode. Inputs: N = 43; I = 4; PV = 0; FV = 80,521.83. Output: MPT = $731.93.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started