Question

In: Finance

Find the monthly PITI payment for a mortgage of $93,500 at a rate of 9.25% for...

Find the monthly PITI payment for a mortgage of $93,500 at a rate of 9.25% for 25 years with annual property taxes and hazard insurance premium of $3,750 and $687 respectively.

Solutions

Expert Solution

Mortgage or loan = $93500 , Rate of interest = 9.25% , Period of loan = 25 years

As mortgage payments are made monthly, therefore

Monthly rate = Rate of interest / 12 = 9.25% / 12

No of months of loan = 12 x no of year of loan = 12 x 25 = 300 months

First we need to find the monthly mortgage payment(Principal and Interest)of loan

We can find the monthly mortgage payment of loan by using PMT function in excel

Formula to be used in excel: =PMT(rate,nper,-pv)

Using RATE function in excel, we get monthly mortgage payment = $800.72

Monthly property taxes and hazard insurance = Annual property taxes and hazard insurance / 12 = (3750 + 687) / 12 = 4437/12 = 369.75

Monthly PITI payment = Monthly mortgage payment + Monthly property taxes and hazard insurance = 800.72 + 369.75 = 1170.46

Hence Monthly Payment of Mortgage = $1170.47


Related Solutions

Find the monthly payment needed to amortize principal and interest for each fixed-rate mortgage for a...
Find the monthly payment needed to amortize principal and interest for each fixed-rate mortgage for a $220,000 at 4.5% interest for 30 years.
What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an...
What is the monthly mortgage payment on a $300,000 30 year fixed rate mortgage with an interest rate of 5.125 percent. A friend who knows you have studied amortization asks your help to find the interest portion of their house payments for tax purposes (assuming they itemize). The monthly payments are $2,107.02 on a 30 year loan with a 5 percent interest rate. a) What was the total amount of interest paid during year 2? b) At what point in...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (1) Calculate the principal. (2) How much of the principal is paid the first, 5th, 20th and last year? (3) How much interest is paid the first, 5th, 20th and last year year? (4) What is the total amount of money paid during the 30 years? (5) What is the total amount of interest paid during the 30 years? (6) What is...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment...
Consider a 30-year mortgage with an interest rate of 10% compounded monthly and a monthly payment of $850. (5) What is the total amount of interest paid during the 30 years? (6) What is the unpaid balance after 25 years? (7) How much has to be deposited into a savings account with an interest rate of 4% compounded quarterly in order to pay the unpaid balance of the mortgage after 25 years? (8) How much has to be deposited each...
Question 1 (a)] Find the monthly payment on a $300,000 mortgage quoted at 14 percent and...
Question 1 (a)] Find the monthly payment on a $300,000 mortgage quoted at 14 percent and amortized over 25 years. (b) Someone promises to pay you $1,000,000 every year (at the end of the year) for the next 15 years. The first payment will be one year from today. The relevant effective annual interest rate is 7.0%. What does the time line look like for this problem? What would you pay, today, for this promise? (c)   Show that the answer...
find the monthly piti for Sarah based on a mortgage of $96,00 at a rate of...
find the monthly piti for Sarah based on a mortgage of $96,00 at a rate of 7.5% for 20 years with an annual property tax and hazard insurance premium of $1,750 and $858 respectively.
Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of...
Calculate the monthly payment on a $220,000 mortgage if payment is made at the beginning of each month, and the annual interest rate is 3.75 percent for 20 years. Group of answer choices $1,304.35 $1,300.29 $1,319.25 $1,355.65
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the...
Monthly Mortgage Payments The average monthly mortgage payment including principal and interest is 982 in the United States. If the standard deviation is approximately 180 and the mortgage payments are approximately normally distributed, find the probabilities. Use a TI-83 Plus/TI-84 Plus calculator and round the answers to at least four decimal places. (a) (a)The selected monthly payment is more than $1400 (a)The selected monthly payment is more than 1400 P(Z>1400)= 2) Prison Sentences The average prison sentence for a person...
A $45,000 direct reduction loan is financed at 9.25% per annum. The monthly payment is $385....
A $45,000 direct reduction loan is financed at 9.25% per annum. The monthly payment is $385. What is the total number of monthly payments to pay off the loan? What are the amounts paid toward interest and principal in the 14th period? What is the remaining principal balance after the 14th payment has been made?
Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?
Ann obtains a 30 year Fixed Rate, Constant Payment Mortgage with monthly payments for $4,500,000 at 4.38%. Her monthly payment is $20,000. What is the balloon payment for this mortgage after 360 payments are made?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT