XYZ LLC is planning to purchase land and a commercial building for $200,000,000. An appraisal of the property has identified that 15% of the purchase price relates to land with the remaining relating to the building. A Cost Segregation Study (Cost Seg) was performed which showed that 90% of the building cost related to real property and that 8% and 2% related to 7 and 5 year personal property respectively. XYZ LLC plans to hold the property for 7 years and then sell it for $210,000,000. Calculate the after tax IRR assuming no cash flow other than tax savings from depreciation under two alternatives: 1) assuming no Cost Seg data is used to calculated depreciation and 2) Cost Seg data is used. Also, assume that when the personal property is sold that it will have no value.

Depreciation rates are as follows:

• Real Property 39 year straight line
• 7 and 5 Year Personal Property double declining with switch to straight line or:

	5 Year Property	7 Year Property
1	20%	14.29%
2	32%	24.49%
3	19.2%	17.49%
4	11.52%	12.49%
5	11.5%	8.93%
6	5.76%	8.92%
7		8.93%
8		4.46%

Further Assumptions

• Ordinary tax rate 28%
• Capital gains rate 20%
• IRR Formula

But use the XIRR function in Excel.