Question

In: Finance

The Taylors have purchased a $310,000 house. They made an initial down payment of $30,000 and...

The Taylors have purchased a $310,000 house. They made an initial down payment of $30,000 and secured a mortgage with interest charged at the rate of 7%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.)
$

What is their equity (disregarding appreciation) after 5 years? After 10 years? After 20 years? (Round your answers to the nearest cent.)

5 years     $
10 years     $
20 years     $

Solutions

Expert Solution

House price = $ 310,000

Down payment = $ 30,000

Loan amount (present value) = House price – down payment

= $ 310,000 - $ 30,000 = $280,000

Term in year = 30 years

Number of month in 30 years = 30*12 = 360

Annual interest rate = 7%

Monthly interest rate = 7/12 = 0.005833

Present value of Annuity = Annuity * [ 1 - 1/(1+Periodic interest rate)number of periods / Periodic interest rate]

$ 280000 = Annuity * [ 1 - 1/(1+0.005833)360 / 0.005833 ]

$ 280000 = Annuity * 150.3059

Annuity = $280000 / 150.3059 = $ 1862.87

Therefore, the monthly payment on the loan is $1862.87

a)

Equity value after 5 years:

Monthly payment (Annuity) =$1862.87

Time left in years = 25 years (30 –5)

Number of period in 25 years = 25 * 12 = 300

Present value of Annuity = Annuity * [ 1 - 1/(1+Periodic interest rate)number of periods / Periodic interest rate]

= 1862.87 * [ 1 - 1/(1+0.005833)300 / 0.005833 ]

= 1862.87 * 141.4847

= 263581.22

So, the equity after 5 years is $310000 - 263581.22 = 46418.78

b)

Equity value after 10 years:

Monthly payment (Annuity) =$1862.87

Time left in years = 20 years (30 –10)

Number of period in 20 years = 20 * 12 = 240

Present value of Annuity = Annuity * [ 1 - 1/(1+Periodic interest rate)number of periods / Periodic interest rate]

= 1862.87 * [ 1 - 1/(1+0.005833)240 / 0.005833 ]

= 1862.87 * 128.9865

= 240285.08

So, the equity after 10 years is $310000 - 240285.08 = 69714.92

c)

Equity value after 20 years:

Monthly payment (Annuity) =$1862.87

Time left in years = 10 years (30 –20)

Number of period in 10 years = 10 * 12 = 120

Present value of Annuity = Annuity * [ 1 - 1/(1+Periodic interest rate)number of periods / Periodic interest rate]

= 1862.87 * [ 1 - 1/(1+0.005833)120 / 0.005833 ]

= 1862.87 * 86.12788

= 160445.05

So, the equity after 20 years is $310000 - 160445.05 = 149554.95

5 years     $ 46,418.78
10 years     $ 69,714.92
20 years     $149,554.95

Related Solutions

The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and...
The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 8%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.) $ 1761.03 What is their equity (disregarding appreciation) after 5 years? After...
The Taylors have purchased a $350,000 house. They made an initial down payment of $10,000 and...
The Taylors have purchased a $350,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 6%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.) _____________ What is their equity (disregarding appreciation) after 5 years? After 10...
The Turners have purchased a house for $160,000. They made an initial down payment of $30,000...
The Turners have purchased a house for $160,000. They made an initial down payment of $30,000 and secured a mortgage with interest charged at the rate of 7%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? $   (b) How much total interest will they pay on the loan? $   (c) What will be their equity...
The Taylors have purchased a $250,000 house. They made aninitial down payment of $10,000 and...
The Taylors have purchased a $250,000 house. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 8%/year on the unpaid balance. Interest computations are made at the end of each month. If the loan is to be amortized over 30 years, what monthly payment will the Taylors be required to make? (Round your answer to the nearest cent.)$ ________What is their equity (disregarding appreciation) after 5 years? After 10 years?...
The Turners have purchased a house for $130,000. They made an initial down payment of $10,000...
The Turners have purchased a house for $130,000. They made an initial down payment of $10,000 and secured a mortgage with interest charged at the rate of 4.5%/year on the unpaid balance. (Interest computations are made at the end of each month.) Assume that the loan is amortized over 30 years. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? $ (b) What will be their total interest payment? $ (c)...
The Turners have purchased a house for $200,000. They made an initial down payment of $20,000...
The Turners have purchased a house for $200,000. They made an initial down payment of $20,000 and secured a mortgage with interest charged at a rate of 6.2%/year, compounded monthly, on the unpaid balance. Assume the loan is amortized over 25 years. (a) What monthly payment will the Turners be required to make? (b) What will be their total interest paid over the 25 years? (c) What will be their equity disregarding depreciation after 5 years?
The Turners have purchased a house for $170,000. They made an initial down payment of $40,000...
The Turners have purchased a house for $170,000. They made an initial down payment of $40,000 and secured a mortgage with interest charged at the rate of 7%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? (b) How much total interest will they pay on the loan? (c) What will be their equity after 10...
The Turners have purchased a house for $140,000. They made an initial down payment of $40,000...
The Turners have purchased a house for $140,000. They made an initial down payment of $40,000 and secured a mortgage with interest charged at the rate of 8%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (Round your answers to the nearest cent.) (a) What monthly payment will the Turners be required to make? $   (b) How much total interest will they pay on the loan? $   (c) What will be their equity...
The Turners have purchased a house for $160,000. They made an initial down payment of $40,000...
The Turners have purchased a house for $160,000. They made an initial down payment of $40,000 and secured a mortgage with interest charged at the rate of 7%/year compounded monthly on the unpaid balance. The loan is to be amortized over 30 yr. (a) What monthly payment will the Turners be required to make? (b) How much total interest will they pay on the loan? (c) What will be their equity after 10 years? (d) What will be their equity...
John purchased a house in Atlanta. He made no down payment so the principal of the...
John purchased a house in Atlanta. He made no down payment so the principal of the mortgage equals to the price of the house: $234,000. The APR of his mortgage is 5%. The interest is compounded monthly. He made an agreement with the bank that he would pay off the mortgage in 30 years. Six years later, the businessman did very well at his job. He saved enough money to make a $80,000 payment to the lender to get rid...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT