Question

In: Finance

You are 20 years old and plan to purchase a house when you are 35 .a....

You are 20 years old and plan to purchase a house when you are 35

.a. The current price of the house you want to purchase is $275,000 and the price is expected to increase by 3% per year. How much will the house cost when you are 35?

b. When you are 35, the bank will require a cash down-payment of 10% of the house price to obtain a mortgage. How much will you need to save each year between age 20 and 35 to have enough for the down-payment, if you can earn 5% on your deposits? Assume end-of-year deposits.

c. Given the same data in part b., how much will you need to deposit each year to have enough for the down-payment if you make beginning-of-year deposits?

d. Suppose your parents promise to pay the down-payment when you turn 35. How much will they need to deposit today in an account that will earn 8% for the next 15 years (when you will need to the down-payment)?

Solutions

Expert Solution

Solution a
Price of house $                 275,000
Annual inflation 3%
Price of house after 15 years= 275000*(1+3%)^15
Price of house after 15 years= $           428,441.04
Solution b
Down payment 10%
Down payment $             42,844.10 428441.04*10%
FV of annuity
P = PMT x ((((1 + r) ^ n) - 1) / r)
Where:
P = the future value of an annuity stream $             42,844.10
PMT = the dollar amount of each annuity payment PMT
r = the effective interest rate (also known as the discount rate) 5%
n = the number of periods in which payments will be made 15
FV of annuity= PMT x ((((1 + r) ^ n) - 1) / r)
42844.10= PMT x ((((1 + 5%) ^15) - 1) / 5%)
Annual year end paymen to accumulate the down payment= 42844.10/ ((((1 + 5%) ^15) - 1) / 5%)
Annual year end paymen to accumulate the down payment= $               1,985.49
Solution c
Down payment 10%
Down payment $             42,844.10 428441.04*10%
FV of annuity due
P = PMT x ((((1 + r) ^ n) - 1) / r)*(1+r)
Where:
P = the future value of an annuity stream $             42,844.10
PMT = the dollar amount of each annuity payment PMT
r = the effective interest rate (also known as the discount rate) 5%
n = the number of periods in which payments will be made 15
FV of annuity= PMT x ((((1 + r) ^ n) - 1) / r)*(1+r)
42844.10= PMT x ((((1 + 5%) ^ 15) - 1) / 5%)*(1+5%)
Annual year begin payment to accumulate the down payment= 42844.10/ (((((1 + 5%) ^ 15) - 1) / 5%)*(1+5%))
Annual year begin payment to accumulate the down payment= $               1,890.95
Solution d
Amount to be deposted today for down payment= Down payment/(1+Interest)^period
Amount to be deposted today for down payment= 42844.10/(1+5%)^15
Amount to be deposted today for down payment= $             20,608.74

Related Solutions

You are planning to purchase a house that costs $480,000. You plan to put 20% down...
You are planning to purchase a house that costs $480,000. You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of $1700...
Assume you are 32 years old and plan to retire in 35 years at age 67....
Assume you are 32 years old and plan to retire in 35 years at age 67. You are currently earning $75,000/year and expect average annual salary increases of 4.0%/year over the next 35 years. You have $0 saved for retirement. You are trying to determine how much money to save (invest) each year in your 401(k) Plan to fund your retirement in order to pay yourself 70% of your final salary each year (that increases with inflation). [Remember this is...
Mortgage Analysis You are planning to purchase a house that costs $480,000.  You plan to put 20%...
Mortgage Analysis You are planning to purchase a house that costs $480,000.  You plan to put 20% down and borrow the remainder. Based on your credit score, you believe that you will pay 3.99% on a 30-year mortgage. Use function “PMT” to calculate your mortgage payment. Use function “PV” to calculate the loan amount given a payment of $1700 per month. What is the most that you can borrow? Use function “RATE” to calculate the interest rate given a payment of...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
You are 25 years old and plan to retire 35 year from today. You expect that...
You are 25 years old and plan to retire 35 year from today. You expect that you will live 30 years after retiring. You want to have enough money upon reaching retirement age to withdraw $150,000 from the account at the beginning of each year you expect to live, and yet still have $1,000,000 left in the account at the time of your expected death (65 years from now). You plan to accumulate the retirement fund by making equal annual...
Assume you are now 25 years old. You plan to retire when you are 65 years...
Assume you are now 25 years old. You plan to retire when you are 65 years old. You think you will live until you are 80 years. a.) If the rate of return during your working years (a.k.a. the "savings period") is 8% and you plan to save $2,000 per year, how much will you have saved up by retirement age? b.) If the rate of return during your retirement is 6% on the amount of savings you have accumulated,...
You plan to retire in 15 years and buy a house in​ Oviedo, Florida. The house...
You plan to retire in 15 years and buy a house in​ Oviedo, Florida. The house you are looking at currently costs $150,000 and is expected to increase in value each year at a rate of 6 percent. Assuming you can earn 9 percent annually on your​ investments, how much must you invest at the end of each of the next 15 years to be able to buy your dream home when you​ retire? a.  If the house you are...
You have decided to purchase a house that has a price of $150,000. You plan on...
You have decided to purchase a house that has a price of $150,000. You plan on putting 10% down and then financing the rest. Assuming you are able to get a 3% annual interest rate compounded monthly, what is your monthly payment?
John, James and Joe are all 35 years old and plan to retire at age 65....
John, James and Joe are all 35 years old and plan to retire at age 65. They expect to live to 90 years old. Upon retirement they would all like to take immediate annual pension payments from their savings at the start of each year. John and James can access a quoted rate of 9% per year with quarterly compounding whilst Joe can access a quoted rate of 11% per annum with semi-annual compounding. a) John has a monthly income...
You decide that, starting when you are 20 years old, you will save $5 a day...
You decide that, starting when you are 20 years old, you will save $5 a day for retirement. At the end of the year, you invest the accumulated savings ($1,825) in a brokerage account with an expected annual return of 8%. If you continue the practice every year until you are 65, how much money will you have? Please use two decimals rounded up.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT