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 would like to purchase a vacation home in 15 years. The current price of such...
You would like to purchase a vacation home in 15 years. The current price of such a home is $275,000 but the price of these types of homes is rising at a rate of 3% per year. How much would you have to invest in years 1 to 5, (the same amount in each year) in nominal terms to exactly pay for the vacation home if your investments earn 4% APR (compounded annually) in nominal terms?
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...
You hope to retire in 30 years, when you do, you would like to have the...
You hope to retire in 30 years, when you do, you would like to have the purchasing power of $100,000 today, during each year of retirement. Your cash is needed at the beginning of each year of retirement. Inflation is expected to be 3% per year from now until the end of your retirement. Your retirement will last 25 years, you expect your 401k to earn 5% per year during your retirement years. How much money do you need at...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT