Question

Suppose you want to purchase a $305,000 home, and you have the required $63,000 down payment...

Suppose you want to purchase a $305,000 home, and you have the required $63,000 down payment in savings.

Complete the table below for a mortgage option presented by a mortgage broker.

Principal: $242,000

Interest Rate: 3.255%

Terms (years): 20

(Find) Payment:

(Find) Total of Payments over Life of Loan:

(Find) Total Interest Paid over Life of Loan:

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

The payment amount is calculated using the PMT as follows:

=PMT(rate,nper,pv)

=PMT(3.255%,20,-242000)

=16,652.10

Total of payments =16,652.10*20 = 333,042.06

Total interest=333,042.06-242000=91,042.06

Add a comment
Know the answer?
Add Answer to:
Suppose you want to purchase a $305,000 home, and you have the required $63,000 down payment...
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
  • Suppose you want to purchase a $287,000 home, and you have the required $64,000 down payment...

    Suppose you want to purchase a $287,000 home, and you have the required $64,000 down payment in savings. Complete the table presented by a mortgage broker. Principal $223,000 Interest Rate 3.625% Terms (years) 20 Payment Total of Payments over Life of Loan Total Interest Paid over Life of Loan Complete the table below. (years) | Payment Total of Payments over Life of Loan Principal Interest | Terms Rate $223,000 3.625% 20 (Round to the nearest cent as needed.) Total Interest...

  • A3-8 Suppose you want to borrow $200,000 to purchase a home. You have found terms that...

    A3-8 Suppose you want to borrow $200,000 to purchase a home. You have found terms that include a 30-year note with a nominal rate of 7.0% com - pounded monthly. The loan includes payment of 2.5 points, which will be paid out of the loan at closing. One point is equal to 1% of the loan value.) A) Calculate the monthly mortgage payment. B) How much interest is paid in the 2nd month's payment? C) How much principal is paid...

  • you want to purchase a home for $300,000. you have calculated that you can afford monthly...

    you want to purchase a home for $300,000. you have calculated that you can afford monthly payments of $1300 for principal and interest and that you can obtain a 30 year mortgage with monthly payments at an APR of 4.5% how much is maximum loan amount? based on the loan amount, how much must your down payment be in order to purchase the home? Please show work and BAII Plus

  • 1.         You have purchased a home for $150,000. Fortunately, you were able to make a down...

    1.         You have purchased a home for $150,000. Fortunately, you were able to make a down payment of $15,000, but took out a 30-year mortgage for the $135,000 balance. The note payments are $1,388.63 per month at 12% annual interest.                         A.        Prepare the amortization schedule for the first 12 months of payments. B.       Calculate the subtotal for the amounts of cash payments, interest payments, and principal payments for the first12 months of payments.                         C.        Calculate the total...

  • You plan to buy a $240000 home with a 10% down payment. The bank you want...

    You plan to buy a $240000 home with a 10% down payment. The bank you want to finance the purchase suggests two options (use semiannual compounding): Option 1: 20-year mortgage at 8.12% APR Option 2: 30-year mortgage at 10.45% APR. What is the equivalent monthly interest rate for each option? Equivalent monthly interest rate Option 1: Equivalent monthly interest rate Option 2: What is the monthly payment of each option? Monthly payment Option 1: $ Monthly payment Option 2: $

  • You plan to buy a $240000 home with a 10% down payment. The bank you want...

    You plan to buy a $240000 home with a 10% down payment. The bank you want to finance the purchase suggests two options (use semiannual compounding): Option 1: 20-year mortgage at 8.19% APR Option 2: 30-year mortgage at 11.23% APR. What is the equivalent monthly interest rate for each option? Equivalent monthly interest rate Option 1: Equivalent monthly interest rate Option 2: What is the monthly payment of each option? Monthly payment Option 1: $ Monthly payment Option 2: $

  • you want to purchase a house for $350,000 with a 10% down payment and thereby you...

    you want to purchase a house for $350,000 with a 10% down payment and thereby you need to finance $315,000 through a home mortgage loan which you signed today you start paying the loan in 6 months from today with 60 quarterly payments at an interest rate of 6% per quarter. Which of the following is true for the first payment? Where A is the loan payment. . This is an immediate payment loan, where A = $350,000(AP 6%, 60)...

  • You are buying a home and have saved $45,000 for a down payment. The house costs...

    You are buying a home and have saved $45,000 for a down payment. The house costs $360,000. You are given a choice by the mortgage banker. You can use your entire $45,000 for the down payment, and borrow $315,000 at a 4.2% annual rate with monthly payments of about $1540 per month for 30 years (360 monthly payments). Or you can buy down the interest rate by paying an upfront fee to the lender of $8,000. This will reduce the...

  • Suppose you purchase your first home by making a $10,000 down payment on a debt of...

    Suppose you purchase your first home by making a $10,000 down payment on a debt of $150,000. The bank charges an APR of 4.8% compounded monthly for a 30 year mortgage. Your monthly payment on the remaining $140,000 is $787.00. (Do not enter $ sign and round answers to the nearest cent: Examples: 650.35, 12000.00) a) You elect to payoff the entire loan after you pay 240 payments (120 payments remain). How much must you pay to payoff the loan...

  • Suppose you want to purchase a home for $375,000 with a 30-year mortgage at 5.94% interest....

    Suppose you want to purchase a home for $375,000 with a 30-year mortgage at 5.94% interest. Suppose also that you can put down 30%. What are the monthly payments? (Round your answer to the nearest cent.) $ 1563.71 What is the total amount paid for principal and interest? (Round your answer to the nearest cent.) $ 300435.05 x What is the amount saved if this home is financed for 15 years instead of for 30 years? (Round your answer to...

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