Compute the realized average life of a 30 yr., 5/1 ARM with initial rate of 4%,...

Compute the realized average life of a 30 yr., 5/1 ARM with initial rate of 4%, and a margin of 2%. The underlying index is (date in yrs., index in %): (0,2), (1,3), (2,3), (3,2.5), (4,3), (5,5), (6,5), and (7-30,6). The loan is never prepaid, nor curtailed, nor defaults. There are no rate or payment caps. Annotate excel, or show all work.

Solutions

Expert Solution

The realised average life is like the duration of the mortgage loan. We will calculate the monthly mortgage payment and then take the principal repayments being made monthly, multiply the principal repayment by the month in which they are being repaid and divide the sum of the weighted principal repayments by the principal repaid - the resultant number is the average life.

Since this is a 5/1 ARM, the interest rate is fixed for first 5 years at 4%, 6 year will be 7% and after that 8%.

Mortgage payment formula = Loan * [ r * (1+r)^t ] / [(1+r)^t - 1]

Residual Loan balance after k months formula = Loan * [ (1+r)^t - (1+r)^k ] / [(1+r)^t - 1]

where r is the applicable monthly interest rate and t is the tenure in months. We will assume a Loan of $1000 and calculate the average life.

Monthly Payment (Year 1 to 5) = 1000 * [(4%/12) * (1+4%/12)³⁶⁰ ] / [(1+4%/12)³⁶⁰ - 1] = 4.77

Loan balance after 5 years (60 months) = 1000 * [(1+ 4%/12)³⁶⁰ - (1+4%/12)⁶⁰ ] / [(1+4%/12)³⁶⁰ - 1] = 904.48

Monthly Payment (Year 6) = 904.48 * [(7%/12) * (1+7%/12)³⁰⁰ ] / [(1+7%/12)³⁰⁰ - 1] = 6.39

Loan balance after 6 years = 904.48 * [(1+ 7%/12)³⁰⁰ - (1+7%/12)¹² ] / [(1+7%/12)³⁰⁰ - 1] = 890.64

Monthly Payment (Year 7 to 30) = 890.64 * [(8%/12) * (1+8%/12)²⁸⁸ ] / [(1+8%/12)²⁸⁸ - 1] = 6.97

Hence we can see that the average life is 235.92 months

jeff jeffy answered 1 year ago

Next > < Previous

Related Solutions

Compute the realized average life of a 30 yr., 5/1 ARM with initial rate of 4%,...

You have taken out a $150,000, 5/1 ARM. The initial rate is 2%. The interest rate...

You have taken out a $150,000, 5/1 ARM. The initial rate is 2%. The interest rate after the initial lock period is 4%. The term on this 5/1 ARM is 30 years. What is the total amount of interest paid during the initial lock period?

An ARM is made for $50,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $50,000 for 30 years with the following terms: Initial interest rate = 1 percent Index = 1-year Treasuries Payments reset each year Margin = 200 basis points Interest rate cap = none Payment cap = none Discount points = 1 point Negative amortization is not allowed Based on estimated forward rates, the 1-year Treasury yields to which the ARM is tied is forecasted as follows: Beginning of year (BOY) 2 = one percent (1%); (BOY)...

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $150,000 for 30 years with the following terms: Initial interest rate = 3% Index = 1-year Treasuries Payments reset each year Margin = 2 percent Fully amortizing Interest rate cap = 1 percent annually; 3 percent lifetime Estimated forward rates: BOY 2 4.00% BOY 3 5.25% BOY 4 6% BOY 5 6.50% Compute payments and balances for each of the years 1-5.

An ARM is made for $200,000 for 30 years with the following terms: Initial interest rate...

An ARM is made for $200,000 for 30 years with the following terms: Initial interest rate = 3% Index = 1-year Treasuries Payments reset each year Margin = 2 percent Fully amortizing Estimated forward rates: BOY 2 4.50% BOY 3 5.25% BOY 4 6% BOY 5 6.50% Compute payments and balances for each of the years 1-5.

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%....

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.2%. After the first year, the interest rate will adjust each year, using 1 yr LIBOR as the index, plus a margin of 175bp. The price of the property is $8,000,000 and the loan will have an initial LTV ratio of 75% At the first reset date, 1 year LIBOR is at 3%. What is the borrower’s payment during the 2nd year of the loan?

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%....

A borrower is offered a 30 year, fully amortizing ARM with an initial rate of 3.35%. After the first year, the interest rate will adjust each year, using 1 yr LIBOR as the index, plus a margin of 175bp. The price of the property is $8,000,000 and the loan will have an initial LTV ratio of 75% At the first reset date, 1 year LIBOR is at 3%. What is the borrower s payment during the 2nd year of the...

A borrower takes out a 5/1 Hybrid ARM for $200,000 with an initial contract interest rate...

A borrower takes out a 5/1 Hybrid ARM for $200,000 with an initial contract interest rate of 3.5%. The interest rate will adjust according to the 1 yr LIBOR rate, plus a margin of 2%. At the first reset date, 1 yr LIBOR is at 1%. What will the borrowers’ monthly payment be immediately after the first reset? (State the payment as a positive number. Unless otherwise stated, you can assume 5/1 ARMs have a term of 30 years. Round...

You have taken out a $300,000, 5/1 ARM. The initial rate of 5.4% (annual) is locked in for 5 years.

You have taken out a $300,000, 5/1 ARM. The initial rate of 5.4% (annual) is locked in for 5 years. Calculate the payment after recasting the loan (i.e., after the reset) assuming the interest rate after the initial lock period is 8.0%. (Note: the term on this 5/1 ARM is 30 years) A. $1,684.59 B. $1,784.79 C. $1,887.75 D. $2,138.02

You have taken out a $300,000, 5/1 ARM. The initial rate of 5.4% (annual) is locked...

You have taken out a $300,000, 5/1 ARM. The initial rate of 5.4% (annual) is locked in for five years. Calculate the payment after recasting the loan (i.e., after the reset) assuming the interest rate after the initial lock period is 8.0%. (Note: the term on this 5/1 ARM is 30 years.)

Subjects