1. Coretta Bradley got a $75,000 mortgage loan for 15 years at 4.85%. The property taxes...

1. Coretta Bradley got a $75,000 mortgage loan for 15 years at 4.85%. The property taxes on the property are $2,060 annually and the insurance premium is $945. What is the amount of the monthly payment, including the amount put in escrow?

2. Jason Bradley’s brother is getting qualified for a VA mortgage loan. His monthly salary is $5,214. Annual property taxes on the property are $2,491 and insurance is $763. He has a car payment of $437.50 and a student loan of $325 to pay each month. The VA has a qualifying ratio of 41%. What is the maximum monthly mortgage payment allowed?

Solutions

Expert Solution

1. Monthly mortagage of the loan =PMT(rate,nper,pv) in excel =PMT(0.0485/12,15*12,75000) = $587.25

Monthly property tax = 2060/12 = 171.67

Monthly insurance premium = 945/12 = 78.75

Total monthly payment = 587.25 +78.75 +171.67 = 837.67

2. Monthly salary = $5214

Monthly property tax = 2491/12 = $207.583

Monthly insurance = 763/12 = 63.583

Monthly Car payment = 437.50

Monthly Student loan = 325

Total payments per month = 1033.666

His maximum monthly payment possible as per ratio = 0.41*5214 = 2137.74

His monthly mortatage payment allowed = 2137.74 -1033.666 =$1,104.07

His monthly mortatage payment allowed=$1,104.07

jeff jeffy answered 2 years ago

Next > < Previous

Related Solutions

You have a mortgage of $93,000 at 5% for 20 years. The property taxes are $3,700...

You have a mortgage of $93,000 at 5% for 20 years. The property taxes are $3,700 per year, and the hazard insurance premium is $686 per year. Find the monthly PITI payment.

Consider a loan of 75,000 repayable by equal quarterly instalments over 15 years calculated at an...

Consider a loan of 75,000 repayable by equal quarterly instalments over 15 years calculated at an interest rate of 8.80% per annum convertible quarterly. From the lenders perspective, set a cash flow model in tabular form which covers all the scheduled repayments in the 15 years, allowing for tax at 30% on the interest component of the loan. Calculate the amount of each quarterly payment and calculate the after tax internal rate of return achieved by the lender on its...

On November 1, Year 1, Bradley Corporation incurs a 15-year $200,000 mortgage liability in conjunction with...

On November 1, Year 1, Bradley Corporation incurs a 15-year $200,000 mortgage liability in conjunction with the acquisition of an office building. This mortgage is payable in monthly installments of $2,400, which include interest computed at the rate of 12% per year. The second monthly payment is made on December 31, Year 1. How much of the second payment made on December 31, Year 1, represents interest expense? A. $400. B. $1,996. C. $2,000. D. $4,000.

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years?

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly...

For a mortgage loan of $300,000, at 2.0 percent interest for 15 years and 12 monthly payments per year, find the balance at the end of 4 years and 10 years.

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is...

A fully amortizing mortgage loan is made for $90,000 for 15 years. The interest rate is 6 percent per year compounding monthly. Payments are to be made monthly. What is the principal payment in the first monthly payment?

You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with

You bought a house 8 years ago with a $250,000 mortgage. It was a 15 year loan with monthly payments which will pay off the loan when you make the last payment. The interest rate was 6%. What are your monthly payment and your current loan balance? How much interest will you pay in the upcoming year?

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years...

Assume a mortgage loan amount of $ 400,000, with annual interest rate 4% and 15 years term 1. Calculate annual payment amount 2. Calculate monthly payment amount 3. Do you pay more annually or monthly? Why? 4. Prepare a 180 month loan amortization schedule. How much is your total interest payment?

John plans to borrow $400,000 15-years mortgage loan from his bank, which agrees that John...

John plans to borrow $400,000 15-years mortgage loan from his bank, which agrees that John should repay the loan in 180 equal end-of-month payments. The annual interest rate is 4%, compounded monthly. (1) What is the amount of each monthly payment? Show your calculation. (2) How much total interest dollar amount will John pay over the 180 months life of the loan? Show your calculation (3) Complete the following loan amortization schedule for the first 6...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate,...

Suppose that a 15-year mortgage loan for $200,000 is obtained. The mortgage is a level-payment, fixed-rate, fully amortized mortgage and the mortgage rate is 7.0% (APR, monthly). a. Find the monthly mortgage payment. b. Compute an amortization schedule for the first six months. c. What will the mortgage balance be at the end of the 15th year? d. If an investor purchased this mortgage, what will the timing of the cash flow be assuming that the borrower does not default?

Subjects