Question

You are interested in buying a house that costs $300,000. You plan to make a 20% down payment and borrow 80% of the purchase price. You will issue a mortgage loan (yes, the borrower is the issuer of the mortgage loan) to the bank who is lending you the money. The term of the mortgage loan is 15 years. The interest rate is fixed at 5% per year. Lets assume yearly rather than monthly payments for this problem set. Keep in mind that your mortgage loan will be fully amortized (paid off) after the end of fifteen years. What are your total pretax monthly mortgage payments: Here are the Excel terms that you will need to calculate your pre-tax mortgage payments: rate: 5% nper:15 pv: $240,000 fv: 0 type: 0 $17,890.10 $23,122.15 $5,868.05 $22,345.16 $17254.10

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

We need to use the funtion PMT

Rate 5%
NPER 15
PV -240000
fv 0
type 0

Excel Funtion =PMT(5%,15,-240000,0,0)

Pretax Mortage Payment=$23122.15

Add a comment
Know the answer?
Add Answer to:
You are interested in buying a house that costs $300,000. You plan to make a 20%...
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 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...

  • You are buying a house priced at $354,125. You plan to pay 20% of the price...

    You are buying a house priced at $354,125. You plan to pay 20% of the price for down payment and finance the rest. The mortgage loan you need to borrow lasts 30 years and requires 4.25% interest rate per annum. What is your payment EACH MONTH for the mortgage loan? please show all work

  • aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is...

    aSuppose you bought a house and took out a mortgage for $100,000. The interest rate is 3%, and you must amortize the loan over 10 years with equal end-of-year payments. A. Calculate the mortgage payment using the Excel function Rate Nper PV FV Payment B. Set up an amortization schedule that shows the annual payments and the amount of each payment that repays the principal and the amount that constitutes interest expense to the borrower and interest income to the...

  • 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...

  • Problem 3: How many years will it take for an intial investment of $2000, earning 5.4%...

    Problem 3: How many years will it take for an intial investment of $2000, earning 5.4% annually, to reach $10,000? NPER ? VY (Rate) PV PMT FV Compounding Periods CPT (Compute)? Problem 4: You have future plans to buy a house 5 years from now. You estimate that a down payment of $20,000 will be required at that time. To accumulate that amount, you want to start making monthly payments into an account paying 3.9% interest. What will your monthly...

  • Cri computer Problem 5: You are buying a car. The one you have choosen to purchase...

    Cri computer Problem 5: You are buying a car. The one you have choosen to purchase is going to cost you $32,985. Your car salesman has told you that you can purchase this vehicle for $525 per month for 72 months. What interest rate will you be paying? Note: For a loan the price is listed Because the bank gives you the money in FV is 0, because the loan will be paid off NPER 1/Y (Rate) PV PMT FV...

  • 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...

  • 1) You wish to borrow $150,000 from a lending institution for the purchase of a house....

    1) You wish to borrow $150,000 from a lending institution for the purchase of a house. The bank will lend this amount at an Annual Percentage Rate of 4.5% to be paid-off with equal monthly mortgage payments over a 30-year period. This is a 4.5% APR, 30-year fixed-rate mortgage loan. You wish to know how this loan will affect your federal income tax burden, as only the interest paid on a home mortgage, not the principal, is tax deductible. Construct...

  • Suppose you are buying a house that cost $300,000. You make a 10% down payment and...

    Suppose you are buying a house that cost $300,000. You make a 10% down payment and are also going to make semiannual payments for next 10 years on the balance of the loan which you are financing at 5% APR. Also, the IRS allows the tax exemption for the mortgage interest payment at the end of each year and your tax rate is 30% (i.e. Tax saving = annual interest * tax rate). Using the given information, construct the amortization...

  • Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of...

    Problem #2 (30%) To buy a house you ask a bank for a mortgage loan of $ 400,000, repayable a mortgage loan of $ 400,000, repayable in 30 years of monthly payments at a yearly interest rate of 3%. After 20 years (240 m yearly interest rate of 3%. After 20 years (240 monthly payments) you decide to pay of the remainder of the loan. A) What is your monthly payment? B) What sum you must pay to the bank...

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