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

Assignment Help Financial Management

Reference no: EM131909677

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? please show work and explain how to use the excel goal seek.

Reference no: EM131909677

Questions Cloud

Explore the concepts of a global mindset : Explore the concepts of a Global mindset further and is based the work of Martin Gannon and his tool of cultural metaphors. Student must complete the readings

Delta of at money six month european call option : Calculate the delta of an at the money six month European call option on a non dividend paying stok when the risk free interrest rate is 10% per annum

What factors influence your decision to buy something new : What factors influence your decision to buy something new? Who is Victor Lebow, and what did he say in the 1950's that is so important to us today?

Examples of medieval art and architecture : What examples of medieval art and architecture best display this fusion of ideas and forms? Make certain your examples display the influence of all three

What equal or end-of-year amount must you save each year : You want to accumulate enough money over the next 10 years to pay for your son's college.

Calculate the required return on fisher corps stock : If the risk free rate is 2.5% and the Market Risk Premium is 11.0%, what is the Expected/Required return on Fisher Corp's stock?

What is the italized cost of project : This cycle then starts all over again and repeats forever ear. What is the italized cost of this project?

Develop a financial leverage chart illustrating the project : How much dollar return of the LTV 50% scenario comes from borrowed money and from equity investment?

Discuss very clear identification of one behavioral variable : Discuss Very clear identification of at least one behavioral variable contributing to morbidity and/or mortality associated with the health behavior

User Account

All Pages