Question

In: Finance

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 (IRR) compounded annually.

Question #1: What property value are you projecting at the end of year 5?

Question #2: What should you pay to earn your desired IRR?

(If you can please show how to set-up & solve in excel, that would be extremely helpful. Thank you.)

Solutions

Expert Solution


Related Solutions

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 acquisition of a small office building. The purchase price is $775,000. Seventy-five...
You are considering the acquisition of a small office building. The purchase price is $775,000. Seventy-five percent of the purchase price can be borrowed with a 30-year, 7.50% mortgage. Up-front financing costs will total 3.00% of the loan amount. The expected cash flows assuming a 5-year holding period are as follows: Year NOI 1 $48,492 2 $53,768 3 $59,282 4 $65,043 5 $71,058 The cash flow from the sale of the property is expected to be $1,000,000. What is the...
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
You are considering the purchase of a parking deck close to your office building. The parking...
You are considering the purchase of a parking deck close to your office building. The parking deck is a​ 15-year old structure with an estimated remaining service life of 25 years. The tenants have recently signed​ long-term leases, which leads you to believe that the current rental income of ​$250,000 per year will remain constant for the first five years. Then the rental income will increase by 10​% for every​ five-year interval over the remaining asset life.​ Thus, the annual...
You are considering the purchase of a parking deck close to your office building. The parking...
You are considering the purchase of a parking deck close to your office building. The parking deck is a​ 15-year old structure with an estimated remaining service life of 25 years. The tenants have recently signed​ long-term leases, which leads you to believe that the current rental income of​$250,000 per year will remain constant for the first five years. Then the rental income will increase by 10​% for every​ five-year interval over the remaining asset life.​ Thus, the annual rental...
You are considering the purchase of an office building. You have gathered information, surveyed the market,...
You are considering the purchase of an office building. You have gathered information, surveyed the market, and made predictions. Assume you plan to purchase the property on January 1, 2020 and sell the property on December 31, 2024. Other assumptions: Total acquisition price: $931,000. Property consists of 10 office suites, 5 on the first floor and 5 on the second. Contract rents: 5 suites at $1,831 per month and 5 at $1,431 per month. Annual market rent increases: 2.31 %...
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
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1...
You are considering the purchase of an apartment complex. Purchase price: $775,000 BTCF: Year NOI 1 $103,085 2 $108,361 3 $113,875 4 $119,636 5 $125,651 Holding period is four years Cap rate is expected to be 7% in year 4 Selling expenses will be 5% of the sale price The 4-year Treasury bill rate is 3% and your risk premium for this project is 8% a) Calculate the NPV of this project assuming that you do not take any mortgages...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT