Darren has been approved for a 30-year mortgage with a 5.5% interest rate. He found a...

Question

Question

business finance

Answer 1

Answer #1

Calculation is shown below

C DEF 1 Using the PMT function in excel we can calculate the monthly mortgage payment 2 Loan amount (PV) $105,000 3 Monthly i

Following shows working

1 Using the PMT function in excel we can calculate the monthly mortgage payment 2 Loan amount (PV) 3 Monthly interest rate (R

Answer 2

Similar Homework Help Questions

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...
Bubba bought his house 20 years ago, he borrowed $200,000 with a 30-year mortgage with a...

Bubba bought his house 20 years ago, he borrowed $200,000 with a 30-year mortgage with a 5.0% APR. His mortgage broker has offered him a 10-year mortgage with a 4% APR with 3 points closing costs. What is Charlie's old monthly payment? What is the balance on Bubba's mortgage? What is Bubba's new monthly payment? How many months does Bubba need to live in the house to justify the refinancing costs?
Jonah has been looking for a house. He found one he liked for $300,000. Jonah can...

Jonah has been looking for a house. He found one he liked for $300,000. Jonah can afford a loan payment of $1,200 a month. He would like a 30-year loan. The bank is offering mortgage loans at a nominal annual interest rate of 6%, compounded monthly. How much of a down payment will Jonah need to make if he wants to buy this house?

Ramon is approved for a 8 year loan of 45,000 at nominal rate of interest convertible...

Ramon is approved for a 8 year loan of 45,000 at nominal rate of interest convertible semiannually of 8.2432 percent. He will be making monthly payments at the end of each month. a. What is his monthly payment?
Derek borrows $280,427.00 to buy a house. He has a 30-year mortgage with a rate of...

Derek borrows $280,427.00 to buy a house. He has a 30-year mortgage with a rate of 5.63%. The monthly mortgage payment is $________.
Jayce is borrowing $148,000 to buy a house. He is taking out a 30 year mortgage with a 5.35% fixed interest rate. Property taxes are $4,975 and homeowners insurance is $1125 per year. PMI is $75 per m...

Jayce is borrowing $148,000 to buy a house. He is taking out a 30 year mortgage with a 5.35% fixed interest rate. Property taxes are $4,975 and homeowners insurance is $1125 per year. PMI is $75 per month. Find his total monthly (PITI) payment. Show your work.

A man buys a house for $255,000. He pays $40,000 down and takes out a mortgage...

A man buys a house for $255,000. He pays $40,000 down and takes out a mortgage at 6.9% on the balance. Find his monthly payment and the total amount of interest he will pay if the length of the mortgage is (a) 15 years; (b) 20 years; (c) 25 years. (d) When will half the 20-year loan be paid off? (a) For the 15-year mortgage, the man will make monthly payments of $| (Do not round until the final answer....
Mackenzie Roth has a 30 year, 4.25% mortgage on his home. The current monthly payments for...

Mackenzie Roth has a 30 year, 4.25% mortgage on his home. The current monthly payments for the mortgage, which has a current balance of $170,000, are $1,019.24 per month. He can now afford a $1,500 monthly payment. How long would it take him to pay off his mortgage by making a $1,500 monthly payment? 150.7 months 95.5 months 145.1 months 144.5 months
Will has a 25-year mortgage on a $140,000 loan for his house in Florida. The interest...

Will has a 25-year mortgage on a $140,000 loan for his house in Florida. The interest rate on the loan is 4.8% per year (nominal interest), payable monthly at 0.4% per month. a. What is Will's monthly payment? b. If Will doubles his payment from Part (a), when will the loan be completely repaid?

You just entered into a $150,000 30-year home mortgage at an annual interest rate of 4.25%...

You just entered into a $150,000 30-year home mortgage at an annual interest rate of 4.25% making monthly payments of $737.91. Suppose you add an additional payment of $295.97 each month to the $737.91 house payment making your total monthly payments equal to $1,033.88. This extra amount is applied against the principal of the original loan. How long will it take you to pay off your loan of $150,000? Use a calculator to determine your answer. a. It will take...