What equal end-of-year amount must you save each year

Assignment Help Financial Management

Reference no: EM131517343

You want to accumulate enough money over the next 10 years to pay for your son’s college. The total costs in 10 years are expected to be $200,000 that you want to pay in advance before the first semester. You currently have $10,000 that you plan to invest over the next 10 years to help pay for college costs. You want to put away an equal, end-of-year amount into an investment account at the end of each of the next 10 years. Earnings on all of the investments are expected to be 7% for the first 5 years and 9% thereafter. What equal, end-of-year amount must you save each year over the next 10 years to meet these needs? (Hint: Use Excel Solver or Goal Seek function) please show work and explain how to use the excel goal seek.

Reference no: EM131517343

Questions Cloud

What is and does the pass-through rate mean : Pick any Fannie Mae Prospectus and discuss the security. What is the pool number for the security? What is and does the pass-through rate mean?

Premium for financial risk : how much is the additional premium that Ethier's shareholders require to be compensated for financial risk?

What is portfolio return : The monthly returns for Company G, Company S, and Company N were 11.2 percent, -1.44 percent, and 9.4 percent. What is your portfolio return?

Withdraw in equal annual beginning-of- the-year case flows : How much money can you withdraw in equal annual beginning-of- the-year case flows if you invest the money at a rate of 7% for thirty years?

What equal end-of-year amount must you save each year : What equal, end-of-year amount must you save each year over the next 10 years to meet these needs?

What was the portfolio turnover rate : What was the portfolio turnover rate? What is the net asset value of the fund? What is your portfolio worth?

What is their nominal yield to maturity : What is their nominal yield to maturity? What is their nominal yield to call? What return should investors expect to earn on these bonds?

Economic conditions will strengthen-government spending : If you expect economic conditions will strengthen and government spending will increase.

Considering replacing a labor-intensive machine system : A farmer is considering replacing a labor-intensive machine system with a more capital-intensive one.

User Account

All Pages