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?
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.
Assume that you plan to retire in 35 years and that you estimate you will need...
Assume that you plan to retire in 35 years and that you estimate you will need an income of $100,000 at the beginning of each year for 30 years, following your retirement. You also plan to donate $1,000,000 to the Georgia Southern University College of Business to endow a scholarship in the name of your favorite finance professor. You will make this endowment exactly 5 years after you retire. Assume that you will earn 11.00 percent during your working years...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT