Question: Any help on these using excel would be great Phil want to put money aside for his newborn son's college education. Phil estimate that the

Any help on these using excel would be great
 Any help on these using excel would be great Phil want

Phil want to put money aside for his newborn son's college education. Phil estimate that the education cost will cost a total of $125,000 dollars. Phil believes he can safely obtain a 9% return on his investment. How much will Phil need to invest monthly (at the end of each month) to achieve his goal in 18 years (assume Phil will pay all of education at the end of 18 years)? (Interest compounded monthly) Alice wants to buy a house in five years. She has $10,000 right now. She wants to have $30,000 for her down payment. Alice is an aggressive investor and believes she can get 12% return on her investments. How much will Alice need to invest annually (at the beginning) of each of the next five years to achieve her goal? (Interest compounded annually) Heather wants to purchase a vacation home in 10 years. Heather will invest her money at an expected return of 8%. Heather currently has $20,000. Heather will put $2,500 per month into investments at the beginning of each month) Heather does not want a mortgage. How much money will Heather have at the end of 10 years to purchase her vacation home? (Interest compounded monthly) Joshua wants to purchase a car for $28,000. The dealership quotes an interest rate of 6%. Joshua is willing to pay $2,000 down payment. How much monthly payment will Joshua have to purchase this car if he wants it paid off in 5 years? Steven wants to purchase a car for $32,000. The dealership quotes an interest rate of 6%. Steven is willing to make monthly payments of $300. How much down payment will Steven need to make? (Interest compounded monthly)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Accounting Questions!