1. AICPA National Real Estate ConferenceDue DiligenceStephen A. Stoner
November 17, 2000
2. What is Due Diligence Risk management tool
Varies by client
Varies by practitioner
Consistency beginning to develop in secondary mortgage markets
Industry standards accepted by rating agencies, investors, and intermediaries
Dependent on good data
2
3. History of Due Diligence Prior to 1980’s
Minimal
Late 80’s, early 1990’s
Required and critical
Mid 1990’s - current
Changing real estate markets
Much done internally
Larger buyers
Different risk mitigation procedures
Future
to be determined3
4. Reason for Due DiligenceFile stuffer
Decision tool
Sales tool
Asset management
Deal structuring
4
5. The Due Diligence ProcessSalesContract
ExecutedFinancialOperationalReviewTenantReviewMarketAnalysisPhysical Asset and EnvironmentalReviewPro FormaAnalysisRecommendationto Buyer5
6. The Due Diligence ProcessSalesContract
ExecutedTenantReviewMarketAnalysisPro FormaAnalysisRecommendationto BuyerFinancialOperationalReviewPhysical Asset and EnvironmentalReview6
7. Financial Operational ReviewRevenue Streams
Current Rent
Signed and current leases (including amendments)
Legal clauses
Right of first refusal
Go dark provisions
Right to cancel
Noncompete clauses
Other
Tenant tour
Accounts receivable aging
Other forms of cash flow
Storage
Internet and telecommunication access
Phone revenue (hotels and motels)
Other
7
8. Financial Operational ReviewOperating Costs: high level
Costs per square feet
BOMA and other benchmarks (building size, location and age)
Analytic review
Review of tax returns
Adjustments for unusual items
Results used to focus detailed review
8
9. Financial Operational ReviewOperating Costs: detailed
Service contracts
Economic review
Review executed contracts
Compare financial terms to operating statements
Legal review
Duration
Ability to cancel or rebid
Implications of sale
Repairs and maintenance
Review of vouchers
Capitalization versus expenses
Property taxes
Review recent tax bills
Other
Review of vouchers
9
10. Financial Operational ReviewCapital items
Deferred maintenance
Walkthrough
Engineering report
Capital improvements
Engineering report
Strategic plan for property(ies)
Identifiable versus annual
Lease commissions
Linked to revenue stream
Market commissions - adjusted for business plan
Tenant improvements
Linked to revenue stream
Primarily driven by physical condition of building and market requirements
Engineering report
10
11. Financial Operational ReviewConclusions
Normalized NOI
Identification and quantification of trends
Unusual items11
12. The Due Diligence ProcessSalesContract
ExecutedTenantReviewMarketAnalysisPro FormaAnalysisRecommendationto BuyerFinancialOperationalReviewPhysical Asset and EnvironmentalReview12
13. Evaluation of Tenant CreditFinancial stability (credit rating)
Industry concentrations
Other concentrations13
14. The Due Diligence ProcessSalesContract
ExecutedTenantReviewMarketAnalysisPro FormaAnalysisRecommendationto BuyerFinancialOperationalReviewPhysical Asset and EnvironmentalReview14
15. Market AnalysisThree primary components
Site analysis
Supply
DemandSupplyDemandSquare
FeetTime15
16. Market AnalysisSite Analysis
Visibility
Access
Ingress/Egress
Amenities
Sources of demand
Competition
Quality
Surrounding land uses, current and projected
16
17. Market AnalysisSupply
Historical inventory
Existing and future competitive
Disaggregated by size, quality, and age
Projected future development
Planning departments
Media research
Local market interviews
17
18. Market AnalysisDemand
Historical absorption
Market research of key indicators
New business startups
Population growth
Other economic trends
Other demographic trends
Projected growth in demand
Demand
(sq ft)Time18
20. Market AnalysisSpace may be vacant prior to re-leasing
New rent is set
New tenant improvements, commissions
Base years, sales, other levels are setRenewal assumptions - What happens at the end of a lease?20
21. The Due Diligence ProcessSalesContact
ExecutedTenantReviewMarketAnalysisPro FormaAnalysisRecommendationto BuyerFinancialOperationalReviewPhysical Asset and EnvironmentalReview21
22. Physical Asset and Environmental ReviewEngineering report
Deferred maintenance
Required capital improvements
Architects or space planners
Efficiency of existing space: opportunities or constraints for value enhancement
Environmental
Phase 1, 2 and 3
Title search
22
23. The Due Diligence ProcessSalesContract
ExecutedFinancialOperationalReviewTenantReviewMarketAnalysisRecommendationto BuyerPhysical Asset and EnvironmentalReviewPro FormaAnalysisConverting analysis to cash flow23
24. PROFORMA ANALYSISAnalysis of projection assumptions based upon historical performance and market research
Compilation of projected revenues, expenses and net operating income
Analysis of capitalization and discount rates, debt service and post-financing cash flow, if required24
25. Things to look for:
If a portion of the property was non-operating during the year, the effect on future operating results needs to be considered
The seller’s or buyer’s budget, if used in the analysis, may contain optimistic assumptions
The fees and corporate overhead expenses charged by the seller will be modified after acquisition
All appropriate taxing jurisdictions and respective taxes are adequately reflected
Effects of non-recurring items projected to occur
PROFORMA ANALYSIS25
26. Tenant by Tenant
Appropriately Timed
Industry Accepted
Ready for “What if” Analyses
Easy to Review and ProofPROFORMA ANALYSISAdvantages to Prefab Systems 26