Determine the npv at time period zero of the cash flows

Reference no: EM131514

Joe has two children, Sydney age 5 and William age 2, that he wants to provide for their education funding. Currently, tuition is $10,000 per year and tuition inflation is 6%. Joe expects to earn 10% on his investments and he expects the children to start college at age 18 and go to college for 4 years. Joe wants his last savings payment to be made when the oldest child starts college. How much must Joe save at the end of each year?

Step 1: Determine the NPV at time period zero of the cash flows. Recall that this step determines the amount that could be deposited today, to satisfy the education funding need.

Step 2: Determine the annual savings required to meet the education goal. Note: During this step it is important to determine two criteria: (1) How long does the client intend to save and (2) When will the savings payment be made? In this problem, Joe's oldest child is 5 and he intends to save until she starts college, which is in 13 years. He also indicates that he wants to "save at the end of each year" which indicates that this is an ordinary annuity problem.

Reference no: EM131514

Questions Cloud

Write a program using vectors and iterators : Create a program that uses at least two functions that will be called from your main. This program is a number game program that asks for parts of your phone and after manipulating it mathematically, eventually outputs your entire phone number. The d..

Economic profit in the short run bot : Why does rent control result in a shortage of rental units.

Implement security so that all users can view the informatio : Implement security so that all users can view the information about the projects, but only authenticated users

Evaluate the variation of hoop stresses : Evaluate the variation of hoop stresses across the wall of the compound cylinder.

Determine the npv at time period zero of the cash flows : Recall that this step determines the amount that could be deposited today, to satisfy the education funding need

Estimate annual fcff : Prepare an Excel spreadsheet containing Estimate annual FCFF

Internal and external growth strategy : What are the tradeoffs between an internal and an external growth strategy? Which method is best as an international strategy.

Net cashflows at the time of replacement : Net cashflows at the time of replacement and Incremental cashflows over the life of the new lathe

Solidify the concepts of client/server computing : One-way to solidify the concepts of client/server computing and interprocess communication is to develop the requirements for a computer game which plays "Rock, Paper, Scissors" using these techniques.

User Account

All Pages