Question

In: Finance

You have decided to invest in a small commercial office building that has one tenant for...

You have decided to invest in a small commercial office building that has one tenant for a price of $200,000. The tenant has a lease that calls for annual rent

payments of $15,000 per year for the next three years. Hint # 1 However, after that leases expires you expect to be able to increase the

rent by 4% per year for the next 7 years. Hint # 2 You plan to sell the building for $325, 000 ten years from now. Hint # 3

  1. Complete table 1 showing the projected cash flows for this investment, assuming the next lease payment will be made at the end of year one

B. Assuming that you need to earn 11% on this investment, what is the maximum price you would be willing to pay for the building?

  1. If the current price was $250,000 what rate of return would you earn.

Solutions

Expert Solution

Please see the table below. Please be guided by the second column titled “Linkage” to understand the mathematics. The last row highlighted in yellow is your answer. Figures in parenthesis, if any, mean negative values. All financials are in $. Adjacent cells in blue contain the formula in excel I have used to get the final output. All the three parts have been solved consequentially in the table itself.


Related Solutions

You have purchased a multi-tenant office building for $15,000,000. Your acquisition costs associated with this purchase...
You have purchased a multi-tenant office building for $15,000,000. Your acquisition costs associated with this purchase are $25,000. The estimated land value is $3,000,000, of which you estimate the depreciable land portion at $1,000,000. You estimate the 7-year property at a value of $2,000,000. You have arranged a 70% LTV, 7-year mortgage at a 5.25% interest rate with 2 points and a 25 year amortization period. Your projected NOI in the next two years is $1,200,000 and 1,250,000 which includes...
You have decided to purchase a small tract of land for building a new home on...
You have decided to purchase a small tract of land for building a new home on the outskirts of town. You have some money available but need a loan of $18,000 to make the purchase. The land will be owner-financed over 4 years with end-of-year payments. The interest rate is 9%. For each of the payback methods given, determine the present worth of the loan payments made by the borrower, using TVOM rates of 5%, 9%, and 13% Method 1:...
The global automaker you work for has decided to invest in building a greenfield automobile assembly...
The global automaker you work for has decided to invest in building a greenfield automobile assembly facility in Costa Rica with a local partner. Which FDI theory presented in this chapter might explain your company's decision? In what areas might your company want to exercise control, and in what areas might it code control to the partner? Be specific.
The global automaker you work for has decided to invest in building a greenfield automobile assembly...
The global automaker you work for has decided to invest in building a greenfield automobile assembly facility in Costa Rica with a local partner. 1. Which FDI theory presented in this chapter might explain your company's decision? 2. In what areas might your company want to exercise control, and in what areas might it cede control to the partner? Be specific. 1. Theory of Monopolistic Advantage 2. Oligopoly Theory of Advantage 3. Product Life Cycle Model 4. Eclectic theory
4.You have two office-block proposals. You initially intended to invest $300,000 in the building and then...
4.You have two office-block proposals. You initially intended to invest $300,000 in the building and then sell it at the end of the year for $400,000. Under the revised proposal, you planned to rent out the offices for 3 years at a fixed annual rent of $15,000 and then sell the building for $500,000. a). Calculate the IRR for the initial proposal; b). Calculate the IRR for the revised proposal; c). Which proposal should be chosen based on the IRRs...
You operate your own small building company and have decided to bid on a government contract...
You operate your own small building company and have decided to bid on a government contract to build a pedestrian walkway in a national park during the coming winter. The walkway is to be of standard government design and should involve no unexpected costs. Your present capacity utilization rate is moderate and allows sufficient scope to understand this contract, if you win it. You calculate your incremental costs to be $268,000 and your fully allocated costs to be $440,000. Your...
You operate your own small building company and have decided to bid on a government contract...
You operate your own small building company and have decided to bid on a government contract to build a pedestrian walkway in a national park during the coming winter. The walkway is to be of standard government design and should involve no unexpected costs. Your present capacity utilization rate is moderate and allows sufficient scope to understand this contract, if you win it. You calculate your incremental costs to be $268,000 and your fully allocated costs to be $440,000. Your...
Problem 2: You operate your own small building company and have decided to bid on a...
Problem 2: You operate your own small building company and have decided to bid on a government contract to build a pedestrian walkway in a national park during the coming winter. The walkway is to be of standard government design and should involve no unexpected costs. Your present capacity utilization rate is moderate and allows sufficient scope to understand this contract, if you win it. You calculate your incremental costs to be $268,000 and your fully allocated costs to be...
You operate your own small building company and have decided to bid on a government contract...
You operate your own small building company and have decided to bid on a government contract to build a pedestrian walkway in a national park during the coming winter. The walkway is to be of standard government design and should involve no unexpected costs. Your present capacity utilization rate is moderate and allows sufficient scope to understand this contract, if you win it. You calculate your incremental costs to be $268,000 and your fully allocated costs to be $440,000. Your...
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...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT