Question

In: Finance

Suppose John takes a 15 year mortgage loan of $150,000 at 4.8% (12). a. What is...

Suppose John takes a 15 year mortgage loan of $150,000 at 4.8% (12).

a. What is the monthly payment?

b. If he wants to pay off the loan after 10 years, (i.e., on the 120th payment), what is the payoff amount?

Solutions

Expert Solution

a

Monthly payment = [P * R * (1+R)^N ] / [(1+R)^N -1]
Using the formula:
Loan amount P                                                        150,000.00
Rate of interest per period:
Annual rate of interest 4.800%
Frequency of payment = Once in 1 month period
Numer of payments in a year = 12/1 = 12
Rate of interest per period R 0.048 /12 = 0.4000%
Total number of payments:
Frequency of payment = Once in 1 month period
Number of years of loan repayment =                                                                        15
Total number of payments N 15*12 = 180
Period payment using the formula = [ 150000*0.004*(1+0.004)^180] / [(1+0.004 ^180 -1]
Monthly payment = 1,170.62

b

Loan balance = PV * (1+r)^n - P[(1+r)^n-1]/r
Loan amount PV = 150,000.00
Rate of interest r= 0.4000%
nth payment n= 120
Payment P= 1,170.62
Loan balance = 150000*(1+0.004)^120 - 1170.62*[(1+0.004)^120-1]/0.004
Loan balance =                                                                            62,334.28

Payoff amount is 62,334.28


Related Solutions

a borrower takes out a 15 year mortgage loan for 100,000 with an interest rate of...
a borrower takes out a 15 year mortgage loan for 100,000 with an interest rate of 5% plus 3 points. what is the effective annual interest rate on the loan if the loan is carried 15 years.
A borrower takes out a 15-year mortgage loan for $490,000 with an interest rate of 4.5%....
A borrower takes out a 15-year mortgage loan for $490,000 with an interest rate of 4.5%. If she wants to pay off the loan after 6 years, what would be the outstanding balance on the loan?
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?
A borrower takes out a 15-year adjustable rate mortgage loan for $560,000 with monthly payments. The...
A borrower takes out a 15-year adjustable rate mortgage loan for $560,000 with monthly payments. The first 4 years of the loan have a “teaser” rate of 5%, after that, the rate can reset with a 5% annual payment cap. On the reset date, the composite rate is 9%. What would the Year 5 (after 4 years; 11 years left) monthly payment be?
A borrower takes out a 15-year adjustable rate mortgage loan for $550,000 with monthly payments. The...
A borrower takes out a 15-year adjustable rate mortgage loan for $550,000 with monthly payments. The first 5 years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 5% annual payment cap. On the reset date, the composite rate is 7%. What would the Year 6 (after 5 years; 10 years left) monthly payment be?
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...
John and Peggy recently bought a house. They financed the house with a $150,000, 30-year mortgage...
John and Peggy recently bought a house. They financed the house with a $150,000, 30-year mortgage with a nominal interest rate of 6.68%. Mortgage payments are made at the end of each month. What total dollar amount of their mortgage payments during the first 4 years will go towards repayment of principal?
John takes out a college loan today of 5000 at 4% per year. John is expected...
John takes out a college loan today of 5000 at 4% per year. John is expected to make 20 annual payments of X at the end of each year to repay the loan, starting a year from today. Starting with the sixth payment, John can only pay one quarter of X at the end of each year. This goes on for 10 payments. The bank agrees to accumulate the unpaid balance at 4%. After making the ten reduced payments, the...
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.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT