Question

In: Finance

You've saved up to buy a house and will put $60,000 down on a $350,000 home....

You've saved up to buy a house and will put $60,000 down on a $350,000 home. You're stated interest rate is 4.3%, and you'll make monthly payments for 30 years. What will be your mortgage payment?

Solutions

Expert Solution

Monthly mortgage payment is calculated using the PMT function as follows:-

=PMT(rate,nper,pv)

=PMT(4.3%/12,30*12,350000-60000)

=1435.13


Related Solutions

You wish to buy a house today for $350,000. You plan to put 10% down and...
You wish to buy a house today for $350,000. You plan to put 10% down and finance the rest at 5.20% p.a. for thirty years. You will make equal monthly payments of $_______.
You wish to buy a house today for $350,000. You plan to put 10% down and...
You wish to buy a house today for $350,000. You plan to put 10% down and finance the rest at 5.20% p.a. for thirty years. You will make equal monthly payments of $_______.
You want to buy a house that worth $250,000. You put done $60,000 down payment and...
You want to buy a house that worth $250,000. You put done $60,000 down payment and borrow the rest from a bank with interest rate 4.5% per year compounded monthly for 15 years. What is you monthly payment to the bank? How much interest you will pay to the bank in 15 years? How much interest you pay in the FIRST year?
A young professional couple buy a house for $600,000. They make a down payment of $60,000...
A young professional couple buy a house for $600,000. They make a down payment of $60,000 and agree to amortise the rest of the debt with quarterly payments made at the end of each quarter over the next 20 years. The interest on the debt is 12% per annum compounded quarterly. 5(a). (i) What type of annuity is this? (ii) How many payments are made in total? (iii) What is the interest rate per period? (iv) Write down an explicit...
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. a. Calculate the monthly payments. b- Calculate the 1st month interest payment. c-Calculate the 1st month principal payments
You are planning to buy a house in New Jersey. You put a 20% down payment,...
You are planning to buy a house in New Jersey. You put a 20% down payment, and 15-year mortgage rates are at 4.2% -Price of the house is $400,000. A. Calculate the 1st month interest payments B.Calculate the 1st month principal payments C.  Calculate the monthly payments. Place answer in the box below and use 2 decimals and no $ sign
You looking to buy your first house. The cost of the house is $350,000. The bank...
You looking to buy your first house. The cost of the house is $350,000. The bank has agreed to make a loan to you for 30 years at 3.25% if you can make a down payment of 10%, and the loan payments equal 40% of your gross monthly income. Based upon this information: A. What will be the amount of your monthly payments? B. How much is your gross monthly income? C. What must your annual salary be in order...
You want to buy a new house. Your options are a tradition house for $350,000 and...
You want to buy a new house. Your options are a tradition house for $350,000 and a 3D printed concrete house for $100,000. These houses are built over a plot that increases 5% every year. You want to keep this house for 20 years and make a bit of money at the end. Which house would be the better option if both homes lose 2% of its value, but also increase due to an inflation of 3.22% every year?
You are planning to buy a house today. The house costs $350,000. You have $50,000 in...
You are planning to buy a house today. The house costs $350,000. You have $50,000 in cash that you can use as a down payment on the​ house, but you need to borrow the rest of the purchase price. The bank is offering a 30​-year mortgage that requires annual payments and has an EAR of 5% per year. What will be your annual mortgage​ payment?
E231- John Smith wants to buy a house that worth $250,000. He put done $40,000 down...
E231- John Smith wants to buy a house that worth $250,000. He put done $40,000 down payment and borrow the rest from a bank with interest rate 3.5% per year compounded monthly for 15 years. What is the monthly payment to the bank? How much interest John will pay to the bank in 15 years? How much interest John will pay in the FIRST year?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT