Question

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). Suppose you pay the bank $1,350 each month rather than making the required payment, calculate the number of months it will take to payoff the loan. (Round to the nearest whole number; zero decimals)

Homework Answers

Answer #1

Information provided:

Price of the house= $300,000

Down payment= $70,000

Mortgage= present value= $300,000 - $70,000= $230,000

Monthly interest rate= 3.5%/12= 0.2917%

Monthly payment= $1,350

The time to payoff the loan is calculated by entering the below in a financial calculator:

PV= -230,000

PMT= 1,350

I/Y= 0.2917

Press the CPT key and N to compute the time to payoff the loan.

The value obtained is 235.8839.

Therefore, it will take 236 months to payoff the loan.

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
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...
1. You have purchased a home computer with the latest technology for $3,290.00 (including tax). The...
1. You have purchased a home computer with the latest technology for $3,290.00 (including tax). The store is financing your purchase with a three year loan with monthly payments of $109.28. a. What is the total paid on this loan? b. How much interest will you have paid?   2. Samantha received a $1,500.00 bonus. She decided to deposit the money in a savings account earning 3% APR compounded annually. What is the value of her bonus (bonus plus all interest)...
Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take...
Suppose you plan to purchase a $250,000 home. You plan to put 5% down, and take a loan from the bank for the remaining amount. The bank has offered you a 30-year loan with a 4.5% APR (compounded monthly). Assuming you make every monthly payment on time, calculate the principal balance of the loan 10-years from today. (Round to 2 decimals)
You have found your dream home. The selling price is $300,000. You will put $60,000 as...
You have found your dream home. The selling price is $300,000. You will put $60,000 as down payment and obtain a 30-year fixed-rate mortgage loan at 4.5 percent annual interest rate for the rest. a) You are required to make an equal payment every monthfor 360 months to pay off the balance on the loan. Assume that the first payment begins in one month after you obtained the loan. What will each monthly payment be? b) If you want to...
When interest rates are low, some automobile dealers offer loans at 0% APR, as indicated in...
When interest rates are low, some automobile dealers offer loans at 0% APR, as indicated in a 2016 advertisement by a prominent car dealership, offering zero percent financing or cash back deals on some models. Zero percent financing means the obvious thing—that no interest is being charged on the loan. So if we borrow $1,200 at 0% interest and pay it off over 12 months, our monthly payment will be $1,200/12 = $100. Suppose you are buying a new truck...
When interest rates are low, some automobile dealers offer loans at 0% APR, as indicated in...
When interest rates are low, some automobile dealers offer loans at 0% APR, as indicated in a 2016 advertisement by a prominent car dealership, offering zero percent financing or cash back deals on some models. Zero percent financing means the obvious thing—that no interest is being charged on the loan. So if we borrow $1,200 at 0% interest and pay it off over 12 months, our monthly payment will be $1,200/12 = $100. Suppose you are buying a new truck...
TVM Assignment Please answer the question in an excel spreadsheet with the formulas showing. Part VI:...
TVM Assignment Please answer the question in an excel spreadsheet with the formulas showing. Part VI: Car Loan You are looking to buy a 2018 Ford Focus Titanium Hatchback with sunroof and leather seats at a price of $26,000. Being a college student, you have cash to pay taxes, title, license and fees but your parents offer to give you 10% of the price, $2,600, as a down payment and you need to finance the remainder of $23,400. You smartly...
You plan to buy a house that has the sale price of $180,000. A local bank...
You plan to buy a house that has the sale price of $180,000. A local bank can offer you a conventional 30-year mortgage with 20% down payment and 4% APR. The bank also charge you 2% fees off the loan amount, including origination fee, document fee and etc. How much would be your upfront payment and monthly mortgage payment (a) Upfront payment (b) Monthly mortgage payment
You Are interested in buying a new sierra 1500 pickup truck. after all negotiations the total...
You Are interested in buying a new sierra 1500 pickup truck. after all negotiations the total cost will be 48,250. As a down payment, you decide to pay $3250 today and finance the remainder with a 72 month loan at 3.24% APR compound monthly, with first payment due in 1 month. How much is your fixed monthly Loan Payment? Your friend spends $5 per day on lattes at his favorite coffee shop. If he were, instead, to deposit that amount...
The calculations have to be using Excel. 1)You are looking at five different banks offering the...
The calculations have to be using Excel. 1)You are looking at five different banks offering the following rates: (make sure you show at least 2 decimal places in your answers) Bank 1.         8% with semiannual compounding Bank 2.        7.91% with monthly compounding Bank 3.         7.89% with continuous compounding a. Which bank would you borrow from and why? b. Which bank would you invest in and why? 2)You owe $63,000 at 4.8%. You decided to pay off the loan...