Unlevered BTIRR problem the property is a specialty retail property (which is 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 expects that he will have 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 will be at a sales price 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 Mr. Beyer pays $92,000,000 for this property, what is his before tax IRR (BTIRR)? Please explain how to compute in financial calculator or excel.