Reference no: EM13909278
Unlevered BTIRR problem
The property is a specialty retail property (which is interesting, but not relevant to the solution). Mr. Beyer is planning to acquire the property, hold it for five years and then sell it at the end of the fifth year.
* The first year net operating income (NOI) is projected to be $8,460,750. Mr. Beyer is projecting that, based on increasing base rents and increasing percentage rents, his NOI will increase at a compounded annual rate of 4%.
* His closing costs (legal, recording, appraisal, environmental, engineering, title, etc.) will come to $600,000. These closing costs will be expended simultaneous to taking title.
* In the fifth year of the holding period, in order to prepare the property for disposition, Mr. Beyer intends to spend $3,500,000 in property upgrade, and he builds in that assumption to his numbers. This capital expenditure is, of course, an increase in his equity investment.
* Mr. Beyer projects his sale to the next purchaser at the end of the fifth year. The sales price will be determined by utilizing a residual or terminal capitalization rate of 9.15% of the projected sixth year NOI (rounded to the nearest $100,000). After all, the next buyer is buying future income, not past income. But Mr. Beyer also projects a cost of sale (legal, marketing, brokerage) of an amount equal to 2% of the gross sales price. This cost of sale will be deducted from his gross sale price to arrive at net sales proceeds.
If all of Mr. Beyer’s projections are accurate, and if he pays $92,000,000 for this property, what will be his before tax IRR (BTIRR)?
Calculate all in EXCEL and show formulas!
|
What rate of return is sally receiving on the loan
: Sally Johnson loaned a friend $10,000 at 15% interest, compounded annually. The loan will be paid in five equal end-of-year payments. Sally expects the inflation rate to be 12%. After taking inflation into account, what rate of return is Sally receiv..
|
|
Calculate expected rates of return for market and stock
: The market and stock J have the following probability distributions: Calculate the expected rates of return for the market and stock J.
|
|
What is the liability-loan charges compound interest
: What is the liability after 10years if the loan charges simple interest? What is the liability after 10 years if the loan charges compound interest?
|
|
Combed through the pages of the chapter
: Combed through the pages of the chapter and cannot locate an answer for the following question: In a joint production process, the allocation of joint (common) costs to the joint products is needed: A. To determine whether the firm in question shou..
|
|
The property is a specialty retail property
: The property is a specialty retail property (which is interesting, but not relevant to the solution). Mr. Beyer is planning to acquire the property, hold it for five years and then sell it at the end of the fifth year. The first year net operating in..
|
|
Save an electronic
: Directions: Be sure to save an electronic copy of your answer before submitting it to Ashworth College for grading. Unless otherwise stated, answer in complete sentences, and be sure to use correct English, spelling, and grammar. Sources must be cite..
|
|
What will the annual savings be
: Community Hospital has annual net patient revenues of $150 million. At the present time, payments received by the hospital are not deposited for six days on average. The hospital is exploring a lock-box arrangement will promises to cut the six days t..
|
|
Compute the sales level required in both dollars
: Astro Co. sold 20,000 units of its only product and incurred a $50,000 loss (ignoring taxes) for the current year as shown here.
|
|
What is the future worth of your investment in actual dollar
: General price inflation is estimated to be 3% for the next 5 years, 5% the 5 years after that, and 8% the following 5 years. If you invest $10,000 at 10% for those 15 years, what is the future worth of your investment in actual dollars at that time a..
|