Question

In: Finance

You would like to purchase a vacation home when you retire 10 years from now. The...

You would like to purchase a vacation home when you retire 10 years from now. The current cost of the homes that interest you is $234,217; however, you expect their price to rise at 4.74% per year for the next 10 years. How much must you save each year in nominal terms (the same amount each year) for 15 years, starting next year, to just be able to pay for the vacation home if you earn 3.20% APR (compounded annually) on your investments?

Solutions

Expert Solution

Firstly, we need to calculate the cost of vacation house after 10 years.

Calculation is as follows:

Formulas:

Now, we need to calculate the amount required to be saved each year at an APR of 3.20% to be able to just buy the vacation house.assuming the cost of the house will remain constant after 10th year.

We can calculate this using PMT function in excel wherein FV will be the cost of the vacation house

Calculation is as follows:

Formulas:


Related Solutions

a. You would like to purchase a vacation home when you retire 7 years from now....
a. You would like to purchase a vacation home when you retire 7 years from now. The current cost of the homes that interest you is $290,581; however, you expect their price to rise at 2.13% per year for the next 7 years. How much must you save each year in nominal terms (the same amount each year) for 15 years, starting next year, to just be able to pay for the vacation home if you earn 4.54% APR (compounded...
You would like to purchase a vacation home when you retire 6 years from now. The...
You would like to purchase a vacation home when you retire 6 years from now. The current cost of the homes that interest you is $298,526; however, you expect their price to rise at 3.16% per year for the next 6 years. How much must you save each year in nominal terms (the same amount each year) for 6 years, starting next year, to just be able to pay for the vacation home if you earn 3.82% APR (compounded annually)...
You are now 25 years old. You would like to retire when you are 65 years old.
You are now 25 years old. You would like to retire when you are 65 years old. You want to receive starting at 65 an annual income of $150,000 per year until you are 95. How much money must you have in your retirement account when you are 65? Assume you can earn 4% per annum.
a) You would like to retire 30 years from now with $2 million dollars. If you...
a) You would like to retire 30 years from now with $2 million dollars. If you get a big inheritance now, how much money do you need to deposit now so that it grows to $2 million assuming an annual interest rate of 6% with interest compounded monthly? b) Suppose in question a) that instead of a one-time payment, you want to save monthly for your retirement. How much should your monthly savings be with interest compounded monthly?
Twenty years from now, you would like to purchase a cottage located on the shores of...
Twenty years from now, you would like to purchase a cottage located on the shores of your favourite lake. You expect that you will have $250,000 available at that time for this purchase. You could afford a home that is currently selling for ____ if the homes increase in value by 3% annually, but if the homes increase in value by 5% annually, you can only afford a home priced at _____ today.
you would like to retire 20 years from now and have an investment worth $3 million...
you would like to retire 20 years from now and have an investment worth $3 million at that time. Currently, you have $200,000 in your account and plan to add $10,000 to that account each year. What annual rate of return must you earn on average to achieve your goal? a) 10.42% b) 12.77% c) 12.86% d) 14.07% e) 12.25% An investment is expected to produce cash flows of $1,000 at the end of each of the next 6 years,...
You are 22 now and would like to retire at age of 67. After you retire,...
You are 22 now and would like to retire at age of 67. After you retire, you assume you will live for another 20 years until 87 years old. Suppose you want to withdraw $5,000 at the beginning of each month from your retirement plan after you retire, and the monthly return of your retirement plan is 0.5%. a. In order to support your monthly withdrawal after retirement, how much do you need to accumulate when you are 67? b....
You now realize you would like to retire in 30 years (age 60). You are currently...
You now realize you would like to retire in 30 years (age 60). You are currently making $90K a year. After your life expenditure and taxes, you are able to save 10% of your salary. You come from a family with really good genes so you expect to live another 25 years after retirement (to an age of 85 years old). You do not want to be a burden on your family and it’s not likely there will be any...
Imagine you are 30 years old in 2019, and would like to retire in 2049 (when...
Imagine you are 30 years old in 2019, and would like to retire in 2049 (when you are 60 years old). On December 31st 2019, you invest $10,000 in an investment brokerage account. With the $10,000, you buy 2 mutual funds. $5000 is invested in a stock mutual fund that is expected to return 7% per year, and $5000 in a Bond mutual fund that is expected to return 4% per year. Every year on December 31st, you continue to...
You are planning to save for retirement. You would like to retire 24 years from today...
You are planning to save for retirement. You would like to retire 24 years from today and you currently have $200,000 set aside. You anticipate saving $750 per month ($500 out of your pocket and $250 from a company match into your 401(k) plan. You anticipating earning an 8.8% rate of return over the next 10 years. After 10 years, you will change your monthly savings to $X per month (combined contribution from you and your employer into your 401(k)...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT