Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Finance questions

Question

Can a team really simulate crises in a meaningful way?

Answered: 1 week ago