|
Available for Free on ULI Website
|
|
Chapter 3 - land development
|
|
Figure 3-9a
|
|
DCF Results
|
|
Figure 3-9b
|
|
Assumptions - sales, prices, development costs, land note
|
|
Figure 3-9c through line 197 (Profit before interest)
|
|
Cash Flow Summary for unleveraged development (without financing)
|
|
Chapter 4 - Income Property Analysis
|
|
Figure 4-3a Rent Summary
|
|
Figure 4-3b Pro Forma NOI
|
|
Figure 4-3c Maximum Debt Calculation
|
|
Figure 4-3d Development Costs
|
|
Figure 4-3e Stage 1 Analysis
|
|
Figure 4-4 Stage 2 Analysis, Before-tax and After-tax
DCF model with IRRs
|
|
Available for modest charge ($49.95)
|
|
Chapter 3 - land development
|
|
Full integrated spreadsheet incorporating Figures 3-17a
through 3-17e
|
|
Figures 3-9a and 3-9b
|
Figure 3-9c (complete figure including interest, land
note and development loan
computations and cash flows after financing)
|
|
Figure 3-9d Cash and loan calculations and IRRs
|
|
Figure 3-9e Investor Return Analysis
|
|
Chapter 4 - income property
|
Full integrated spreadsheet for Income Property Analysis
including Figures 4-3 through 4-9
|
|
Figures 4-3a thru 4-3e Stage 1 Analysis
|
|
Figure 4-4 Stage 2 Analysis
|
Figure 4-6 Stage 3 Analysis (Part 1) Cash Flows During
Development Period,
Including Initial Lease-Up Activities
|
|
Figure 4-7 Development Cost Summary
|
Figure 4-8 Stage 3 Analysis (Part 2) Combined Annual
Before and After-Tax Cash Flows
during Development and Operating Period
|
|
Figure 4-9 Stage 5 DCF Analysis, Return to Investors
|
|
Chapter 6 - industrial property
|
Deal Structure IllustratedTables A and B, p. 284-285
Lookback Return with Sliding Profit Split
|