Question

This extended problem covers many of the features of a mortgage. You purchase a town house...

This extended problem covers many of the features of a mortgage. You purchase a town house for $300,000. Since you are able to make a down payment of 20 percent ($60,000), you are able to obtain a $240,000 mortgage loan for 20 years at a 4 percent annual rate of interest.

a. What are the annual payments that cover the interest and principal repayment?

b. How much of the first payment goes to cover the interest?

c. How much of the loan is paid off during the first year?

d. What is the interest payment during the second year?

e. What is the remaining balance after the second year?

0 0
Add a comment Improve this question Transcribed image text
Answer #1

Ans

Ans a) 17659.62
Ans b) $9,600.00
Ans c) $8,059.62
Ans d) $9,277.62
Ans e) $223,558.38
P = Regular Payments
PV = Loan Amount
r = rate of interest
n = no of periods
P = r (PV)
1 - (1 + r )-n
P = (4.00%)*240000
1 - (1 / (1 + 4.00%)^20))
P = 9600
0.543613054
P = 17659.62
Beginning Balance Interest Principal Ending Balance
1 $240,000.00 $9,600.00 $8,059.62 $231,940.38
2 $231,940.38 $9,277.62 $8,382.00 $223,558.38
Add a comment
Know the answer?
Add Answer to:
This extended problem covers many of the features of a mortgage. You purchase a town house...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage...

    You plan to purchase a $300,000 house using a mortgage obtained from your bank. The Mortgage rate offered to you is 4.50 percent for a 15 year Mortgage. You will make a down payment of 20 percent of the purchase price. Either using formula or Excel, calculate: A. Calculate your monthly payments on this mortgage? B. What is your loan balance at the end of 4 years (48 payment)? C. What is your loan balance at the end of 10...

  • Suppose you just purchase a new house for $550,000, with a 20% down payment. The mortgage...

    Suppose you just purchase a new house for $550,000, with a 20% down payment. The mortgage has a 6.1 percent stated annual interest rate, compounded monthly, and calls for equal monthly payments over the next 30 years. Your first payment will be due in 1 month. However, the mortgage has an eight-year balloon payment, meaning that the balance of the loan must be paid off at the end of Year 8. Suppose there are no other transaction costs or finance...

  • You plan to purchase a $1,000,000 house using a 30-year mortgage obtained from your local bank

    3. You plan to purchase a $1,000,000 house using a 30-year mortgage obtained from your local bank. The mortgage rate offered to you is 8.25%, and you will make a down payment of 20%. This is a fully amortizing mortgage loan. a. Calculate your required monthly payments. b. Calculate the interest payment, principal repayment, and ending balance for the first two months. c. Use a spreadsheet to calculate the total amount of interest payment. Is it greater or smaller than the amount of...

  • Problem 4 and 5-8 House Appreciation and Mortgage Payments Say that you purchase a house for $216,000 by getting a m...

    Problem 4 and 5-8 House Appreciation and Mortgage Payments Say that you purchase a house for $216,000 by getting a mortgage for $190,000 and paying a down payment of $26,000. If you get a 20-year mortgage with an interest rate of 8 percent, what are the monthly payments? (Round your final answer to 2 decimal places.) Payment What would the loan balance be in five years? (Use a payment value rounded to 2 decimal places. Round your final answer to...

  • Mortgage Analysis Part I You are planning to purchase a house that costs $480,000. You plan...

    Mortgage Analysis Part I 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 the function “PMT” to calculate your mortgage payment. Calculate the total cost of the home purchase. (Down payment plus principal (loan amount) plus interest.) Calculate how much interest you will pay in total? Assume that you plan to pay...

  • Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for...

    Problem 4 and 5-7 House Appreciation and Mortgage Payments Say that you purchase a house for $320,000 by getting a mortgage for $280,000 and paying a $40.000 down payment you get a 30 year mortgage with an interest rate of 8 percent, what are the monthly payments (Do not round Intermediate calculations and round your final answer to 2 decimal places.) sont What would the loan balance be in ten years? (Round the payment amount to the nearest cent but...

  • Say that you purchase a house for $192,000 by getting a mortgage for $170,000 and paying...

    Say that you purchase a house for $192,000 by getting a mortgage for $170,000 and paying a down payment of $22,000. If you get a 20-year mortgage with an interest rate of 6 percent, what are the monthly payments? (Round your final answer to 2 decimal places.) Payment: ? What would the loan balance be in five years? (Use a payment value rounded to 2 decimal places. Round your final answer to 2 decimal places.) Loan Balance: ? If the...

  • This morning, you borrowed $150,000 to buy a house. The mortgage rate is 7 percent. The...

    This morning, you borrowed $150,000 to buy a house. The mortgage rate is 7 percent. The amortized loan requires you to pay $10,000 in principal plus interest each year over 15 years. The first payment is due one year from today. How much is the second payment?

  • You are buying a house that costs $440000 and plan on taking out a 30-year fixed...

    You are buying a house that costs $440000 and plan on taking out a 30-year fixed rate mortgage at an annual interest rate of 2.4%. 1)You make a 15% down payment of 66000, and take out a loan for the remaining $374000. How much would your mortgage payments be? (Ignore taxes, fees, and other charges, and round to the nearest penny.)  . 2)You make this mortgage payment at the end of the first month. Your mortgage payment at the end of...

  • You borrow $100,000 at 6 percent for 25 years to fund part of the purchase of...

    You borrow $100,000 at 6 percent for 25 years to fund part of the purchase of a house. You repay the mortgage loan with equal monthly installments over 25 years. - What is your monthly loan repayment? How much interest payment and how much loan repayment are in your first mon th ly installment? - How much interest will you be paying over the entire life of the mortgage loan?

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT