Home Products Research & Library Library Weidthed Rates Cont.

Part two of two

 

The Next Generation in Weighted Cap Rates

____________________________________

A Generalized Analysis

to

Determine Three Unknowns;

Value, Real Estate Taxes

and

Real Estate Tax Recoveries

(Continued)

 

 

Generalized Value and Tax Assessment Analysis

The problem with the basic value and tax assessment analysis is that it can not solve for three co-dependent variables; market value, taxes and tax recoveries. If taxes are not appropriately assessed, then any real estate tax recoveries based on these taxes will not be appropriate either. Such real estate tax recoveries should not be used in the calculation of gross or net income. However the property still has the value created by the potential for real estate tax recoveries. To capture this value, the capitalization rate must be adjusted for the potential real estate tax recoveries.

 

The capitalization rate can be adjusted for the potential real estate tax recoveries by adjusting the effective tax rate for the landlord’s tax contribution. The effective tax rate is adjusted by multiplying the effective tax rate by the landlord’s tax contribution and is thereby converted into the landlord’s effective tax rate. By adding the landlord’s effective tax rate, instead of the full tax rate, the adjusted capitalization rate truly reflects the landlord’s equity interest (the fee estate or leased fee estate) in the property.

 

Generalized Value and Tax Assessment Analysis

Actual Real Estate Tax Recoveries

All Other Rents, Income and Recoveries

Total Gross Income

Actual Real Estate Taxes

All Other Expenses

Total Expenses

Net Operating Income

 

Actual Effective Tax Rate

Real Estate Taxes Not Recovered

Landlord’s Tax Contribution

 

Capitalization Rate

Tax Adjusted Capitalization Rate

 

Indicated Market Value, Rounded

 

Actual Effective Tax Rate

Indicated Real Estate Taxes

Real Estate Tax Recovery Rate

Indicated Real Estate Tax Recoveries

NA

$1,000,000

$1,000,000

NA

300,000

$300,000

$700,000

 

3.0%

50.0%

1.5%

 

10.0%

11.5%

 

$6,090,000

 

3.0%

$182,700

50.0%

$91,350

 

Consistency Proof

Indicated Real Estate Tax Recoveries

All Other Rents, Income and Recoveries

Total Gross Income

Indicated Real Estate Taxes

All Other Expenses

Total Expenses

Net Operating Income

Capitalization Rate

Indicated Market Value, Rounded

 

Actual Effective Tax Rate

Indicated Real Estate Taxes

Real Estate Tax Recovery Rate

Indicated Real Estate Tax Recoveries

$91,350

$1,000,000

$1,091,350

$182,700

300,000

$482,700

$608,650

10.0%

$6,090,000

 

3.0%

$182,700

50.0%

$91,350

 

 

 

 

 

 

 

 

 

 

Q: Compare?

A: Consistent!

 

The proof indicates consistency for all three variables; market value, taxes and tax recoveries. The generalized formula works!

 

Estimating Landlord’s Tax Contribution

The analyst has two methods of estimating the landlord’s tax contribution, and its inverse, the percentage of real estate taxes recovered by the landlord: a trend-based projection method and a lease by lease analysis method.

 

Trend-Based Projection

A trend-based projection is an analysis of the property’s historical experience and/or an analysis of market-wide experiences. When estimating real estate tax recoveries, the analyst must be aware of the usual pitfalls encountered when estimating and forecasting income and expenses, such as above or below market experiences at the subject property, unusually variable income or expense item experiences at the subject property, the incomparability of market data.

 

Example of a Trend-Based Projection Analysis

 

1 Years Ago

2 Years Ago

Last Year

Projection

Subject Property

60%

55%

50%

50%

Market Comparables

60%

60%

50%

 

 

 

 

Lease by Lease Analysis

A lease by lease analysis is an analysis of every lease for its real estate tax recoveries potential. The percentage of taxes to be paid by the each tenant should be tallied to ascertain the landlord’s contribution for taxes for the entire property. Any percentage estimated using the actual leases must be adjusted for expectations of stabilized vacancy and credit loss, and for rollover to market lease terms, and local assessment procedures.

 

Example of Lease by Lease Analysis

 

Landlord’s Tax Contribution

 

Square

Feet

 

Sq. Ft Weighted

Contribution

 

Remaining

Lease Term

 

Market Lease Terms?

Lease #1

60%

20,000

12,000

3 yrs

Yes

Lease #2

60%

25,000

15,000

4 yrs

Yes

Lease #x

55%

30,000

16,500

3 yrs

Yes

Vacant Unit #1

55%

20,000

11,000

5 yrs

Yes

Vacant Unit #x

55%

30,000

16,500

5 yrs

Yes

Total

 

125,000

71,000

  

 

If property was 100% occupied, the tenants would pay 57% (71,000/125,000)of the taxes. The landlord’s building wide tax contribution, at 100% occupancy, is estimated at 43% (100%-57%). However market expectations call for a vacancy and credit loss rate of 7%. Therefore the landlord’s building wide tax contribution, at stabilized vacancy and credit loss, is estimated at 50% (43% + 7%).

 

Net Leased Properties and Average Vacancy & Credit Loss

Unless properties are net leased for very long terms, say more than 20 years to high credit rated tenants, the basic value and tax assessment analysis will not work and the generalized value and tax assessment analysis must be used. Over a typical holding period, most properties are expected to experience some vacancy and credit loss. If a property has some vacancy and credit loss over a holding period, then its average or stabilized vacancy and credit loss represent the percentage of real estate taxes not recovered by the landlord.

 

A generalized analysis can be constructed as follows. No tax recovery income and no taxes should be included in the net income estimate. The stabilized vacancy and credit loss should continue to be deducted from all other potential rents, income and recoveries. No vacancy and credit loss are taken against the potential tax recovery income. The taxes, the tax recovery income and its vacancy and credit loss should only be reflected in the adjustment to the capitalization rate.

 

Benefits to Property Owner & Consultant

The generalized tax assessment analysis for a net leased property shown on the next page yields additional savings over the basic tax assessment analysis of $4,200. It may take the consultant one hour to complete the analysis and one hour to explain the procedure. On a 25% contingency fee basis, the consultant would earn a healthy $1,050 fee.

 

Generalized Value and Tax Assessment Analysis for a Net Leased Property

 

Basic

Value

And Tax

Analysis

Generalized Value

and Tax

Analysis

Holding Period

10 Years

10 Years

   

Average/Stabilized Vacancy & Credit Loss:

  

On All Other Rents, Income and Recoveries

7%

7%

On Real Estate Tax Recoveries

NA

7%

   

Potential Real Estate Tax Recoveries

NA

NA

Vacancy & Credit Loss Real Estate Tax Recoveries

NA

NA

Effective Gross Real Estate Tax Recoveries

NA

NA

   

Potential All Other Rents, Income and Recoveries

$1,075,269

$1,075,269

Vacancy & Credit Loss All Other Income and Recoveries

7%

7%

Effective Gross All Other Income and Recoveries

$1,000,000

$1,000,000

   

Real Estate Tax Recoveries

All Other Rents, Income and Recoveries

Total Gross Income

 

Real Estate Taxes

All Other Expenses

Total Expenses

 

Net Operating Income

 

Actual Effective Tax Rate

Real Estate Taxes Not Recovered

Landlord’s Tax Contribution

Capitalization Rate

Tax Adjusted Capitalization Rate

 

Indicated Market Value, Rounded

 

Actual Effective Tax Rate

Indicated Real Estate Taxes

Real Estate Tax Recovery Rate

Indicated Real Estate Tax Recoveries

NA

$1,000,000

$1,000,000

 

NA

300,000

$300,000

 

$700,000

 

3.0%

0.0%

0.0%

10.0%

10.0%

 

$7,000,000

 

3.0%

$210,000

100.0%

$210,000

NA

$1,000,000

$1,000,000

 

NA

300,000

$300,000

 

$700,000

 

3.0%

7.0%

0.2%

10.0%

10.2%

 

$6,860,000

 

3.0%

$205,800

93.0%

$191,394

 

Discounted Cash Flow Analyses

The principle of not using tax recovery income that is based on inappropriately assessed taxes is equally applicable to discounted cash flows (DCF’s). However the generalized capitalization rate adjustment procedure described above can not be applied to the discount rate in a DCF. Analysts must use an iteration process. (The generalized cap rate adjustment procedure can e applied to the reversionary capitalization rate in a DCF.) Depending on the DCF software used, various iteration techniques can be used instead of the algebraic formula discussed above. In certain software packages, the analyst sets up the tax recoveries as dependent upon the data entered in the taxes cash flow. When the time comes for the analyst to calculate the property value, the analyst enters a guess estimate of the taxes and calculates the first value. This first value is analyzed to find the indicated taxes. If the indicated taxes do not match the guess estimate, then the analyst must make a second guess estimate, recalculate the property value, and reanalyze the second property value for its second indicated taxes. If the second indicated taxes do not match the second guess estimate, then the analyst must repeat the above steps until they match.

 

Conclusion

In conclusion, the basic tax assessment analysis is not valid for many important types of properties, including most office buildings, retail malls, and many industrial buildings. For such properties, the generalized analysis must be employed. The basic analysis remains valid for properties with only gross leases, such as residential apartment buildings, but the generalized analysis can be used for all properties. This easy to use analysis will save property owners tax dollars and earn fees for tax consultants.