Question

David Abbot is buying a new​ house, and he is taking out a 30​-year mortgage. David will borrow ​$192,000 from a​ bank,...

David Abbot is buying a new​ house, and he is taking out a

30​-year

mortgage. David will borrow

​$192,000

from a​ bank, and to repay the loan he will make

360 monthly payments​ (principal and​ interest) of

​$1214.08

per month over the next

30 years. David can deduct interest payments on his mortgage from his taxable​ income, and based on his​ income, David is in the

30​%

tax bracket.

a. What is the​ before-tax interest rate​ (per year) on​ David's loan?

b. What is the​ after-tax interest rate that David is​ paying?

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

a) Before-tax interest rate per year is calculated using the RATE function:-

=RATE(nper,pmt,pv)

=RATE(360,-1214.08,192000)*12

=6.50%

b) After-tax:

=6.50%*(1-0.3)

=4.55%

Add a comment
Know the answer?
Add Answer to:
David Abbot is buying a new​ house, and he is taking out a 30​-year mortgage. David will borrow ​$192,000 from a​ bank,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Similar Homework Help Questions
  • This Question: 1 pt This Test: 50 pts possible Betore-tax cost of debt and after-tax cost...

    This Question: 1 pt This Test: 50 pts possible Betore-tax cost of debt and after-tax cost of debt David Abbot i bank, and to repay the koan he will make 360 monthly payments (principal and interest) of $1,161.11 per month over the next 30 years. David can s buying a new house, and he is taking out a 30-year mortgage. David will borrow $209,000 from a payments on his mortgage from his taxable income, and a. What is the before-tax...

  • Score: 0 of 1 pt 3 of 10 (3 complete) HW Score: 296, 0.2 of 10...

    Score: 0 of 1 pt 3 of 10 (3 complete) HW Score: 296, 0.2 of 10 pts 3 P9-3 (similar to Question Help | * Before-tax cost of debt and after-tax cost of debt David Abbot is buying a new house, and he is taking out a 30-year mortgage David will borrow $200,000 from a bank, and payments on his a. What is the before-tax interest rate (per year) on David's loan? b. What is the after-tax interest rate that...

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

  • Ben Thenking wants to borrow $300,000 to buy a house. He plans to live there for...

    Ben Thenking wants to borrow $300,000 to buy a house. He plans to live there for exactly 5 years before selling the house, repaying the lender the balance and moving. Ben is considering a 30 year fully amortizing fixed rate mortgage with monthly payments. The banker shows Ben three loan options: (1) A loan with a 5% annual interest rate which requires Ben to pay 2 points up front, (2) the same terms as (1), but the loan principal is...

  • 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 got a well-paying job in Finance and took out a mortgage for your house. It...

    You got a well-paying job in Finance and took out a mortgage for your house. It is paid monthly. The amount you borrowed is $790,000, at a monthly rate of 0.5% for the next 30 years (360 months). Use 0.5% as both the interest rate you are paying and the discount rate r. a. What types of loans are there, and what kind of loan is this most likely? b. Show an amortization schedule if this loan had constant monthly...

  • You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with...

    You borrow $500,000 to purchase a house. The mortgage is a 30-year fixed rate mortgage, with monthly payments. A. Assume that you have good credit, and can borrow money at a 3.75% annual interest rate. What will your monthly payment be? B. Now, assume that you have lousy credit, and must pay a 6.5% annual interest rate to obtain a mortgage. What will your monthly payment be? C. Having lousy credit can be costly. How much additional interest will you...

  • 2-13 interest Idle P J. R. Smith plans to borrow $200,000 through a 30-year mortgage from his bank to buy a home....

    2-13 interest Idle P J. R. Smith plans to borrow $200,000 through a 30-year mortgage from his bank to buy a home. If the bank charges him an interest rate of 7 percent, find the (a) Monthly mortgage payment (b) Amortization schedule for the first 3 months: balance after each payment: principal and interest portions of each payment. (c) For the first 221 payments, what is the total interest paid and the total principal. (d) How much would J. R....

  • Derek borrows $325,259.00 to buy a house. He has a 30-year mortgage with a rate of...

    Derek borrows $325,259.00 to buy a house. He has a 30-year mortgage with a rate of 4.08%. After making 147.00 payments, how much does he owe on the mortgage? Derek plans to buy a $25,844.00 car. The dealership offers zero percent financing for 57.00 months with the first payment due at signing (today). Derek would be willing to pay for the car in full today if the dealership offers him $____ cash back. He can borrow money from his bank...

  • 2. (12 points) Consider a homebuyer/investor who plans to buy a new house, the price of...

    2. (12 points) Consider a homebuyer/investor who plans to buy a new house, the price of which is $ 500,000. Suppose the buyer does not have any initial savings for the down payment. To buy the house, he needs to borrow $ 500,000 from a bank in the form of a mortgage loan. The mortgage is a 30-year-fixed-rate mortgage. After buying the house, the buyer budget is $ 30,011 per year. That is, if the mortgage asks him to repay...

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