Question

In: Finance

An office building has the following investment characteristics: Year 1 NOI $2,100,000 Year 2 NOI $2,200,000...

An office building has the following investment characteristics: Year 1 NOI $2,100,000 Year 2 NOI $2,200,000 Year 3 NOI $2,300,000 Year 4 NOI $2,400,000 Initial (going in) cap rate 7% Loan Principal $18,000,000 Interest rate 5% Amortization 30 years Exit cap rate 8% Holding period 3 years Solve for each of the following:

Purchase price

Loan to value ratio

Annual debt service

Debt service coverage ratio for year 1

Loan balance at the end of year 3

Equity (Levered) IRR

Solutions

Expert Solution

Purchase price of the property is $30,000,000

Loan to Value Ratio is 60%

Annual Debt Service is $1,170,925.83

Debt Service Coverage Ratio for Year 1 is 1.79

Loan Balance at the end of Year 3 is $17,145,906.32

Levered IRR Calculation

The Levered IRR is 7.52%

Workings


Related Solutions

2. An office building has the following investment characteristics:             Year 1 NOI                   
2. An office building has the following investment characteristics:             Year 1 NOI                             $2,100,000             Year 2 NOI                             $2,200,000             Year 3 NOI                             $2,300,000             Year 4 NOI                             $2,400,000             Initial (going in) cap rate        7%             Loan Principal                        $18,000,000             Interest rate                             5%             Amortization                           30 years             Exit cap rate                            8%             Holding period                        3 years Solve for each of the following:             Purchase price                                                                                                 Loan...
An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000...
An apartment building has the following investment characteristics: Year 1 NOI $2,500,000 Year 2 NOI $2,600,000 Year 3 NOI $2,704,000 Year 4 NOI $2,812,000 You plan to purchase the asset at a 5% initial cap rate and to sell it 3 years later, also at a 5% cap rate. You plan to use a loan at 60% LTV to purchase the asset. The loan will be interest-only (no amortization) at a 4% annual interest rate. Answer the following: What is...
An apartment building has the following investment characteristics:             Year 1 NOI                 $2,500,000
An apartment building has the following investment characteristics:             Year 1 NOI                 $2,500,000             Year 2 NOI                 $2,600,000             Year 3 NOI                 $2,704,000             Year 4 NOI                 $2,812,000 You plan to purchase the asset at a 5% initial cap rate and to sell it 3 years later, also at a 5% cap rate. You plan to use a loan at 60% LTV to purchase the asset. The loan will be interest only (no amortization) at a 4% annual interest rate....
An office building is purchased with the following projected cash flows: NOI is expected to be...
An office building is purchased with the following projected cash flows: NOI is expected to be $180,000 in year 1 with 2 percent annual increa The purchase price of the property is $910,000. 100% equity financing is used to purchase the property The property is sold at the end of year 4 for $970,000 with selling cost 8 % Calculate the unlevered internal rate of return (IRR). A. 19.9% B. 20.7% C. 21.5% D. 22.3% E. 23.1%
An office building is purchased with the following projected cash flows: NOI is expected to be...
An office building is purchased with the following projected cash flows: NOI is expected to be $180,000 in year 1 with 2 percent annual increa The purchase price of the property is $910,000. 100% equity financing is used to purchase the property The property is sold at the end of year 4 for $970,000 with selling cost 8 % Calculate the unlevered internal rate of return (IRR). A. 19.9% B. 20.7% C. 21.5% D. 22.3% E. 23.1%
You are considering the purchase of a small office building. The NOI is expected to be...
You are considering the purchase of a small office building. The NOI is expected to be the following: Year 1 = $200,000 Year 2 = $210,000 Year 3 = $220,000 Year 4 = $230,000 Year 5 = $240,000 -The property will be sold at the end of year 5. -You believe that the property will have a terminal cap rate of 7%. -You plan to pay all cash for the property. -You want to earn a 10% return on investment...
You are seeking financing for a $500,000 investment in an apartment building. The NOI in the...
You are seeking financing for a $500,000 investment in an apartment building. The NOI in the first year is projected to be $35,000. The bank is willing to underwrite a fully-amortizing, 30 year fixed rate mortgage with constant monthly payments at an interest rate of 6%, compounded monthly. Please note the following ratio: Debt Coverage Ratio= Net Operating Income/ Annual Debt Service Compute the Debt Coverage Ratio if the bank underwrites a mortgage at a Loan-to-Value Ratio of 75%.
You have an opportunity to buy an office building for $125,000 that produces an annual NOI...
You have an opportunity to buy an office building for $125,000 that produces an annual NOI of $10,000. You can obtain an 80% loan from a bank with a 7% interest rate and amortized for 30 years. Your required investor cash on cash return is 12%. You will have to put 20% of the purchase down. What is the value of the office building? A. $140,999 B. $118,242 C. $113,895 D. $125,000
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 2,200,000...
Merrill Corp. has the following information available about a potential capital investment: Initial investment $ 2,200,000 Annual net income $ 190,000 Expected life 8 years Salvage value $ 200,000 Merrill’s cost of capital 8 % Assume straight line depreciation method is used. Required: 1. Calculate the project’s net present value. 2. Without making any calculations, determine whether the internal rate of return (IRR) is more or less than 8 percent. 3. Calculate the net present value using a 12 percent...
A company has two investment possibilities, with the following cash inflows: Investment Year 1 Year 2...
A company has two investment possibilities, with the following cash inflows: Investment Year 1 Year 2 Year 3 A $1,600 1,800 2,000 B $1,200 1,200 1,200 If the firm can earn 7 percent in other investments, what is the present value of investments A and B? Use Appendix B and Appendix D to answer the question. Round your answers to the nearest dollar. PV(Investment A): $ PV(Investment B): $ If each investment costs $4,000, is the present value of each...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT