Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

15 years from now, your 2-year old son will be attending Harvard. You have determined he will need $85,000 per year for tuition and living

15 years from now, your 2-year old son will be attending Harvard. You have determined he will need $85,000 per year for tuition and living expenses. In 15 years, you will give him a lump sum payment for the entire amount he will need, assuming that he will be able to invest the money not yet needed at 4.5% interest. You have found an investment opportunity that will yield an annual return of 6.5% on your monthly payments. How much will you have to invest each month to give your son the money he needs for his education (assume his first year at Harvard is Year 0, and his final year is Year 3)? Please use excel formulas and show work! Thanks.

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_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

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

Get Started

Recommended Textbook for

Lords Of Finance The Bankers Who Broke The World

Authors: Liaquat Ahamed

1st Edition

0143116800, 978-0143116806

More Books

Students also viewed these Finance questions

Question

using signal flow graph

Answered: 1 week ago