Question

In: Accounting

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


Related Solutions

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
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
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...
A property has first year NOI of $1.5 million. NOI grows at 7% during the next...
A property has first year NOI of $1.5 million. NOI grows at 7% during the next two years. In year four, NOI goes drops 50% due to a lost tenant. You are very lucky and replace the tenant. Year five NOI is 4X year four. (continues below…) What is year 5 NOI? continue…You have a $10 million mortgage on this property, at 5% interest, amortization of twenty years. There are two partners who have invested $3 million total in the...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT