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 then 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:

7 Year Property5 Year Property

1.14.29%1.20%

2.24.49% 2.32%

3.17.49%3.19.2%

4.12.49%4.11.52%

5.8.93%5.11.5%

6.8.92%6.5.76%

7.8.93

8.4.46XYZ 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 then 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:

7 Year Property5 Year Property

1.14.29%1.20%

2.24.49% 2.32%

3.17.49%3.19.2%

4.12.49%4.11.52%

5.8.93%5.11.5%

6.8.92%6.5.76%

7.8.93

8.4.46