Question

In: Finance

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) What will be their equity (disregard depreciation) after 10 years?

$

Solutions

Expert Solution

Part a:

P = Mortgage Amount = $130,000 - $10,000 = $120,000

r = monthly interest rate = 4.5%/12 = 0.375%

n = 30* 12 = 360 months

Monthly payment = [r*PV] / [1 - (1+r)^-n]

= [0.375% * $120,000] - [1 - (1+0.375%)^-360]

= $450 / 0.740104346

= $608.022374

Therefore, monthly payment required to make is $608.02

Part b:

Total interest paid over life of loan = [360 months * monthly payment] - Mortgage amount

= (360 * $608.02] - $120,000

= $218,887.2 - $120,000

= $98,887.2

Therefore, total interest paid over life of loan is $98,887.2

Part c:

P = Monthly payment = $608.02

r = monthly interest rate = 4.5%/12 = 0.375%

n = 30* 12 = 360 months

x = installments paid = 10*12 = 120 months

Balance of loan after 10 years = P * [1 - (1+r)^-(n-x)] / r

= $608.02 * [1 - (1+0.375%)^-(360-120)] / 0.375%

= $608.02 * 0.592745388 / 0.00375

= $96,106.9469

Equity after 10 years = Mortgament amount - balance after 10 years

= $120,000 - $96,106.9469

= $23,893.0531

Therefore, equity after 10 years is $23,893.05


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 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 $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 $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 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...
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...
Helen purchased a house for $450,000. She made a down payment of 30.00% of the value...
Helen purchased a house for $450,000. She made a down payment of 30.00% of the value of the house and received a mortgage for the rest of the amount at 3.92% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 3 year period. a. Calculate the monthly payment amount. Round to the nearest cent b. Calculate the principal balance at the end of the 3 year term. Round to the nearest cent c. Calculate the monthly...
Jenna purchased a house for $325,000. She made a down payment of 25.00% of the value...
Jenna purchased a house for $325,000. She made a down payment of 25.00% of the value of the house and received a mortgage for the rest of the amount at 5.72% compounded semi-annually amortized over 20 years. The interest rate was fixed for a 5 year period. a. Calculate the monthly payment amount. b. Calculate the principal balance at the end of the 5 year term. c. Calculate the monthly payment amount if the mortgage was renewed for another 5...
Amanda purchased a car for $28,000. She made an initial down payment of $4,000 and borrowed...
Amanda purchased a car for $28,000. She made an initial down payment of $4,000 and borrowed the rest of the money. She got an annual rate of 1.99% on her car loan, which was payable over a 5-year period. The loan required monthly payments (end of each month). 1. What is the outbalance for her car loan? 2. Using an excel spreadsheet to calculate Amanda’s monthly car payment. 3. Prepare an amortization table for this loan. 4. How much did...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT