Question

In: Finance

"Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...

"Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage with 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. The mortgage has a 2% prepayment penalty if the borrower prepays in the first 5 years. Suppose Ann makes the required monthly payment for 3 years and prepays after her final monthly payment at the end of 3 years. What is the annualized IRR on Ann s mortgage? "  

Solutions

Expert Solution

Cost of office building: $1,000,000

LTV= 80%

Therefore, loan amount= Cost*LTV= $1,000,000*80%= $800,000

Monthly payments on this mortgage is $3,819.32 calculated as follows:

Balance outstanding after payment of 36 installments is $755,989.30 as shown in the relevant portion of amortization schedule below:

Prepayment penalty @2% will be levied on this amount.

Hence amount of prepayment penalty= $755,989.80*2% = $15,119.80

Cash flows on this mortgage are as follows:

Month 0: $800,000

Months 1 to 35: -$3,819.32 each

Month 36: Monthly payment + Balance after monthly payment + Prepayment penalty = $3819.32.+$755,989.90+$15,119.80 = $774,928.92

Monthly IRR on this mortgage is calculated using IRR function of Excel at 0.38367784%

Hence annualized IRR = ).38367784*12 = 4.60413409%. Details as follows:


Related Solutions

Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage at 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. How much is Ann’s monthly payment? A. $3,819.32 B. $2,666.67 C. $3,333.33 D. $4,774.15
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully...
Ann wants to buy an office building which costs $1,000,000. She obtains a 30 year fully amortizing fixed rate mortgage with 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. The mortgage has a 2% prepayment penalty if the borrower prepays in the first 5 years. Suppose Ann makes the required monthly payment for 3 years and prepays after her final monthly payment at the end of 3 years. What is the annualized IRR on...
Ann wants to buy an office building which costs $2,000,000. She obtains a 30 year fully...
Ann wants to buy an office building which costs $2,000,000. She obtains a 30 year fully amortizing fixed rate mortgage with 80% LTV, an annual interest rate of 4%, with monthly compounding and monthly payments. The mortgage has a 2% prepayment penalty if the borrower prepays in the first 5 years. Suppose Ann makes the required monthly payment for 3 years and prepays after her final monthly payment at the end of 3 years. What is the annual IRR on...
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30...
Ann wants to buy a building. The annual NOI will be $100,000 She wants a 30 year fully amortizing fixed rate mortgage at an annual rate of 5% with compounding monthly payments. The lender has a minimum DSCR of 1.2. If Ann gets a 50% LTV loan for $500,000 what is her DCSR?
Ann is looking to buy an office building in 2014. She plans to rent it out...
Ann is looking to buy an office building in 2014. She plans to rent it out for 5 years (2015-2019) and sell it at the end of 2019. Inputs Annual Interest Rate 5.75% Minimum DSCR 1.20 Maximum LTV 90% Cash Available to Close $1,500,000.00 Asking Price / Value $21,257,764.62 NOI 2015 $1,381,754.70 Income Test Maximum Annual Mortgage Payment ? Maximum Loan Amount ? Collateral Test Maximum Loan Amount LTV Test ? Both tests Maximum Loan Amount ? Debt Service Payment...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20th payment goes to interest? If Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $4,500,000 at 4.38%. What percent of Ann’s 20th payment goes to principal?v
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at...
Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What will be Ann’s mortgage balance after 20 years of payments (i.e. after 240 months)? Ann obtains a fully amortizing 30-year Fixed Rate Mortgage with monthly payments for $1,250,000 at 4.38%. What fraction of Ann’s 40th payment goes to interest? Solutions with financial calculation and excel please.
Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of...
Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 7% 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 6% compounded monthly, with monthly payments. Refinancing will cost Ann 1 point and $1,500 in closing costs. If Ann refinances into this loan after 5 years, what will be her total cost of refinancing? Answer...
Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of...
Ann got a 30 year Fully Amortizing FRM for $1,000,000 at an annual interest rate of 5.5% 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.75% 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...
4. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with annual payments for $135,000...
4. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with annual payments for $135,000 at 5.25%. How much does Ann need to pay annually? 7. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will be Ann’s mortgage balance after 20 years of payments (ie after 240 months)?
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT