Question

Sue & Mike are in the process of buying a home. The house costs $300,000 they...

Sue & Mike are in the process of buying a home. The house costs $300,000 they have decided on a $200,000 mortgage loan for a 30 year period with a 3.75% rate and 4.917% APR. How much money are their monthly payments?
What is the total amount of the loan?
What is the total amount of interest?

Homework Answers

Answer #1
Principal A 200000
Installment B monthly
Rate of interest C 4.92
Period D 30 years
Monthly rate E=C/12/100 0.0040975
1 Calculation of EMI (monthly payments)
= PMT(0.0040975,360,200000)
= -$1,063.52
2 Total payments= No of installment X installment
= 30X12X1063.52
382867.2
3 Interest payment
= Total payment- Principal payment
= 382867.2-200000
= 182867.2
Know the answer?
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
Similar Questions
Joe and Sue are building a new home and are looking at a 30 year construction...
Joe and Sue are building a new home and are looking at a 30 year construction loan of $380,000 with the first year being interest only. From years 2 to 30, the loan is a normal amortized loan. The first year is interest only as the house is being built. The interest rate is 4.375% APR. What is the monthly payment for the first year. What is the monthly payment for years 2-30? At the end of 10 years, they...
Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires...
Steve is buying home that costs $500,000. You have been offered a 30-year mortgage that requires a 20% down payment for the house. The loan is to be repaid in equal monthly installments. The APR of the mortgage is 4%. Compute the EAR and the amount of your monthly payment on the mortgage. Show all calculations. you need to find the amount of the monthly payment in two different ways: 1) using the built-in Excel function 2) using the annuity...
If you buy a house for $300,000 at 3.75% interest, what are your monthly payments for...
If you buy a house for $300,000 at 3.75% interest, what are your monthly payments for a 30 year conventional loan? If you pay an extra $300 each month, by how much can you reduce the term of your loan?
You buy a house for $300,000. The mortgage company offers a 30 year loan with an...
You buy a house for $300,000. The mortgage company offers a 30 year loan with an annual interest rate of 10% (but the loan requires monthly payments and the interest will compound monthly). Your monthly house payment is? Show equation please
You are looking at buying a home with an asking price of $300,000. Since the market...
You are looking at buying a home with an asking price of $300,000. Since the market is hot, you plan to put in an offer for full asking price. You also plan to put a $70,000 down payment and finance the remainder. Your bank is offering you a 30-year loan at 3.5% APR (compounded monthly). Assume your first payment is made one month from today and all payments are made on time, calculate the total amount paid to the bank...
Nancy Brock is buying her first home. It costs $85,000, and she will make a down...
Nancy Brock is buying her first home. It costs $85,000, and she will make a down payment of $15,000. She is planning on a 30-year loan at 8% interest. a. What is the exact monthly payment she will pay to the mortgage company? b. If Nancy is transferred to a new job in another city after owning the home for six years, what is the balance due the loan company when she sells the house?
Frodo is going to buy a new house for $304,000. The bank will offer a loan...
Frodo is going to buy a new house for $304,000. The bank will offer a loan for the total value of the house at 7.6% APR for 20 years. What will be the monthly payment for this mortgage? To answer this question which calculator will you use? Systematic Savings - Find total saved with a monthly deposit Systematic Savings - Find monthly deposit to achieve a savings goal Loan - Find monthly payment for a loan Loan - Find loan...
6. You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A....
6. You are buying a new house on a 30-year, 5.2% mortgage loan of $230,000. A. How much will your monthly payments be? B. How much will go toward principal in the 75th month? How much will go toward interest in the 75th month? What will be the balance after 75 months? C. How much interest will you pay in total over the 30 years? D. If you do a 15-year loan instead of a 30-year one, how much will...
You are planning to purchase a house that costs $550,000, and you will use a 30-year...
You are planning to purchase a house that costs $550,000, and you will use a 30-year mortgage. You want to determine whether or not you should save some of your money and put only 10% down on your house. Because you are only putting 10% down, lenders require that you purchase private mortgage insurance (PMI). You want to pay the PMI with a monthly payment (for the same 30-year). Assume that PMI is 1% of the mortgage amount and has...
Choose the scenario that saves the homeowner the most money while buying a home. Assume the...
Choose the scenario that saves the homeowner the most money while buying a home. Assume the home costs $200,000 and the interest rate is 5.75% compounded monthly.    The homeowner makes quarterly payments for 30 years (interest is quarterly too).     The homeowner makes a deal for no interest rate but has to pay $900 per month for 30 years.     The homeowner pays 20% as a down payment and finances the rest for 30 years.     The homeowner negotiates...