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 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

Solutions

Expert Solution

Compute the value of loan, using the equation as shown below:

Loan value = Building cost*LTV ratio

                   = $1,000,000*80%

                   = $800,000

Hence, the value of the loan is $800,000.

Compute the monthly rate of interest, using the equation as shown below:

Monthly rate = Annual rate/ 12 months

                      = 4%/ 12 months

                      = 0.33333333333%

Hence, the monthly rate of interest is 0.33333333333%.

Compute the present value annuity factor (PVIFA), using the equation as shown below:

PVIFA = {1 – (1 + Rate)^-Number of periods}/ Rate

                   = {1 – (1 + 0.00333333333)^-360}/ 0.33333333333%

             = 209.461240555

Hence, the present value annuity factor is 209.461240555.

Compute the monthly payment of the loan, using the equation as shown below:

Monthly payment = Loan amount/ PVIFA

                             = $800,000/ 209.461240555

                              = $3,819.32236188

Hence, the monthly payment of the loan is $3,819.32.


Related Solutions

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)?
3. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000...
3. Ann obtains a fully amortizing 30 year Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. How much does Ann need to pay monthly? 16. Ann obtains a 30 year Interest Only Fixed Rate Mortgage with monthly payments for $135,000 at 5.25%. What will Ann’s monthly payments be?
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be...
QUESTION 25 Ann wants to buy a building. The annual NOI for the building will be $100,000. She wants to get a 30 year, fully amortizing, fixed rate mortgage at an annual rate of 5% with monthly compounding and monthly payments to buy the building. The lender has a minimum Debt Service Coverage Ratio (DSCR) of 1.20. If Ann gets a 50% LTV loan for $500,000, what is her DSCR? A. 4.00 B. There is not enough information to compute...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT