Question

In: Finance

Consider a 30-year adjustable rate mortgage (ARM), which requires the borrower to make monthly payments at...

Consider a 30-year adjustable rate mortgage (ARM), which requires the borrower to make monthly payments at the end of each month. The mortgage amount is $432,000 and the APR on the mortgage is 3.65% for the first 10 years and then 3.87% for the next 20 years. Prepare a loan amortization schedule for this mortgage. Assume that the mortgage closing date is October 1, 2018. Among other things, the following columns should be included. (50) (i) Date (ii) Beginning Balance (iii) Payment (iv) Principal (v) Interest (vi) Cumulative Principal (vii) Cumulative Interest (viii) Ending Balance

I keep ending up with the final two payments resulting in a negative ending balance. Shouldn't the ending balance result in 0 exactly after the last payment?

Solutions

Expert Solution


Related Solutions

A borrower takes out a 30-year adjustable rate mortgage loan for $325,000 with monthly payments.
A borrower takes out a 30-year adjustable rate mortgage loan for $325,000 with monthly payments. The first two 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 6%. Assume that the loan allows for negative amortization. What would be the outstanding balance on the loan at the end of Year 3?
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two years of the loan have a "teaser" rate of 2%, after that, the rate can reset with a 7% annual payment cap. On the reset date, the composite rate is 6%. Assume that the loan allows for negative amortization. What would be the outstanding balance on the loan at the end of Year 3?
A borrower takes out a 30-year adjustable rate mortgage loan for $400,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $400,000 with monthly payments. The first two years of the loan have a “teaser” rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be?
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two 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 6%. What would the Year 3 monthly payment be? with the way please.
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The...
A borrower takes out a 30-year adjustable rate mortgage loan for $200,000 with monthly payments. The first two 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 6%. What would the Year 3 monthly payment be? $955 $1,003 $1,067 $1,186 Because of the payment cap, the payment would not change.
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?
A borrower takes out a 25-year adjustable rate mortgage loan for $446,242 with monthly payments. The...
A borrower takes out a 25-year adjustable rate mortgage loan for $446,242 with monthly payments. The first two years of the loan have a "teaser" rate of 4%, after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be?
A borrower takes out a 28-year adjustable rate mortgage loan for $451,185 with monthly payments. The...
A borrower takes out a 28-year adjustable rate mortgage loan for $451,185 with monthly payments. The first two years of the loan have a "teaser" rate of 4%; after that, the rate can reset with a 2% annual rate cap. On the reset date, the composite rate is 5%. What would the Year 3 monthly payment be?
Consider a $300,000, 4.50% fixed-rate mortgage, which requires the borrower to make annual payments. If the...
Consider a $300,000, 4.50% fixed-rate mortgage, which requires the borrower to make annual payments. If the security currently has 23 years remaining until maturity, and is selling to offer a yield-to-maturity of 6%, what is this mortgage’s modified duration
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT