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

jeff jeffy answered 1 year ago

Next > < Previous

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 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?

You are planning to buy a house appraised for $350,000 and finance it through a mortgage...

You are planning to buy a house appraised for $350,000 and finance it through a mortgage of $300,000. What is the loan-to-value ratio and is it be above or below the normal cutoff set by your lender of 80 percent for a prime mortgage? Being securely employed, your take-home pay is $2,300 per month and you have no substantial other debts. Your lender has offered you a 2.5 percent, 30 year, fixed-rate mortgage. What is the amount that you will...

Subjects