Question

In: Finance

1. Ann gets a 30 year 1/1 Fully Amortizing ARM for $1,000,000, with monthly payments and...

1. Ann gets a 30 year 1/1 Fully Amortizing ARM for $1,000,000, with monthly payments and monthly compounding. The initial rate is 3%. In the future, the rate will reset to 250 basis points above the LIBOR. There are no rate caps or floors. Suppose at the first reset, the LIBOR was 6%. What is the monthly mortgage payment for the second year?

A.

$4,216.04

B.

$3,958.47

C.

$7,585.95

D.

$7,747.70

2. Sam bought a house that costs $1,000,000. Sam got a 97% LTV loan. The lender demanded that Sam buy private mortgage insurance to insure the portion of the loan over 80% LTV. Suppose 5 years later, Sam’s mortgage balance is $900,000. However Sam defaults and his house sells for $750,000 in a foreclosure auction. How much will the mortgage insurance company pay Sam’s lender?

A.

$220,000.00

B.

$170,000.00

C.

$150,000.00

D.

$250,000.00

3. A bank makes a 30 year Fully Amortizing, Fixed Rate Mortgage (FRM) for $2,000,000 at an annual interest rate of 4.125% compounded monthly, with monthly payments. What is the market value of this loan after 7 years of payments if the annual interest rate for this loan is 10% compounded monthly?

A.

$1,045,425.62

B.

$1,726,113.67

C.

$ 680,688.05

D.

$1,101,017.63

4. A bank originates a 30 year Fully Amortizing FRM at an annual interest rate of 5% with monthly compounding and monthly payments. If 10 years later, the bank borrows at 6%, what is this bank’s Net Interest Margin (NIM) on this FRM?

A.

-11.00%

B.

-1.00%

C.

5.00%

D.

6.00%

5. Ann gets a 30 year 3/1 Fully Amortizing ARM for $1,000,000, with monthly payments and monthly compounding. Ann pays $10,000 in closing costs. The initial rate is 2.50%. In the future, the rate will reset to 250 basis points above the LIBOR. There are no rate caps or floors. Suppose at origination and at the rate reset the LIBOR was 1%.

Part 1: What is the loan balance when the rate resets (round to nearest whole number and enter without commas, e.g. 123,456 enter as 123456)?

Part 2: What is the annualized true APR for the loan (round two decimal places and enter without % sign, e.g. 4.95% enter as 4.95)?

6. A bank makes a 30 year Fully Amortizing FRM for $2,000,000 at an annual interest rate of 4.125% compounded monthly, with monthly payments.Suppose inflation is 2% per year, compounded monthly. What is the real value of the 20th payment?

A.

$9,050.06

B.

$9,375.48

C.

$9,692.99

D.

$6,523.11

7. Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 6% compounded monthly, with monthly payments. After 5 years of payments, Ann can refinance the balance into a 25 year Fully Amortizing FRM at an annual interest rate of 4% compounded monthly, with monthly payments. Refinancing will cost Ann 1 point and $1,500 in closing costs.

If Ann refinances into this loan and makes payments for 25 years, what will be her annualized IRR from refinancing?

A.

120.36%

B.

113.09%

C.

130.05%

D.

10.03%

8. Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 4.25% compounded monthly, with monthly payments. After 5 years of payments, Ann can refinance the balance into a 25 year Fully Amortizing FRM at an annual interest rate of 3.75% compounded monthly, with monthly payments. Refinancing will cost Ann 2 points and $1,500 in closing costs.

If Ann refinances into this loan after 5 years, what will be her total cost of refinancing?

A.

$19,661.54

B.

$21,500.00

C.

$18,161.54

D.

$20,000.00

9. Which of the following is a reason a borrower may want to refinance?

A.

The borrower's credit score rises

B.

The borrower's house value declines

C.

Lender's demand lower LTVs

D.

Lender's demand lower DTIs

10. Lucy bought a house for $100,000. Lucy’s annual cost of ownership net of tax savings is exactly equal to the annual rent she would have paid to live in the same house. The house price grows 4.5% annually (compounded annually).

Suppose buying costs are 5% (of the purchase price of the house) and selling costs are 8% (of the selling price of the house). Lucy will sell the house in one year. What is Lucy’s annualized IRR? (hint: it will be negative)

Solutions

Expert Solution

1]

First, we calculate the principal paid off after 1 year (12 months) using CUMPRINC function in Excel :

rate = 3%/12 (converting annual rate into monthly rate)

nper = 30*12 (30 year loan with 12 monthly payments each year)

pv = 1000000 (original loan amount)

start period = 1 (We are calculating principal paid off between 1st and 12th month)

end period = 12 (We are calculating principal paid off between 1st and 12th month)

type = 0 (each payment is made at the end of month)

CUMPRINC is calculated to be $20,878

The balance loan principal outstanding after 1 year =  $1,000,000 - $20,878 = $979,122

For the 2nd year, the interest rate = LIBOR + margin = 3% + 2.5% = 5.5%

Monthly loan payment is calculated using PMT function in Excel :

rate = 5.5% / 12   (converting annual rate into monthly rate)

nper = 29*12 (29 years remaining on loan with 12 monthly payments each year)

pv = 979122 (balance loan principal outstanding after 1 year)

PMT is calculated to be $7,585.95

The answer is C


Related Solutions

Ann gets a fully amortizing 30-year fixed rate mortgage with quarterly payments for $1,000,000. The interest...
Ann gets a fully amortizing 30-year fixed rate mortgage with quarterly payments for $1,000,000. The interest rate is 4%, compounded quarterly. She prepays the mortgage in 1 quarter (i.e. she makes the 1st payment and immediately prepays the remaining balance). What is Ann’s APR? Notes: a quarter equals 3 months, one year consists of 4 quarters, APR is annual. Modify question above: At the moment when Ann signs the mortgage, she must pay an origination fee that equals 2 points....
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the the bank the balance, which mortgage has the lowest cost of borrowing (lowest annualized IRR)
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, which mortgage has the lowest cost of borrowing (ie lowest annualized IRR)? Type 1 for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage A? #2 IRR from mortgage B? I would like to know how to calculate the IRR of this in a BA II
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Assuming Ann makes payments for 30 years, what is Ann’s IRR from mortgage A? Note: IRR is always annualized. If you’ve found a monthly rate, multiply by 12. In this case, two digits for a monthly rate is not enough to avoid rounding errors in the annual rate...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. (A) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage A? (B) Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage B? (C)...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage B?
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 30 years, what is Ann’s annualized IRR from mortgage B?
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage A?
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for...
Ann is looking for a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $3,200,000. Mortgage A has a 4.38% interest rate and requires Ann to pay 1.5 points upfront. Mortgage B has a 6% interest rate and requires Ann to pay zero fees upfront. Assuming Ann makes payments for 2 years before she sells the house and pays the bank the balance, what is Ann’s annualized IRR from mortgage A
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT