This walkthrough, our third in the series, takes you through the entire process of modeling a simple development investment. I’ve created hypothetical assumptions for this exercise written out in PDF format (download link below) and then use those assumptions to assess the viability of the investment. I model a hypothetical retail development investment using the All-in-One model.

In an effort to provide greater instruction on how to use our All-in-One Underwriting Tool for Real Estate Development and Acquisition, we’re developing a series of walkthrough videos and posts on the methodology behind the various components of the model. Our hope is that if you are empowered with the how, you’ll be more willing/able to provide feedback to improve the model.

If you haven’t already, you can download the model here. This walkthrough uses beta version 0.3.12 of the All-in-One Model.

Video Walkthrough – Modeling a Simple Retail Development


Assumptions – Simple Retail Development

You can download these assumptions in PDF format here.

Investment Summary

  • Investment name: Saddle Farms
  • Parking: 250 spaces
  • Year built: 2019
  • Analysis Start: Jan 1, 2018
  • Construction length: 18 months
  • Analysis Period: 10 years
  • Building size: 50,000 SF (35,000 SF anchor plus 15,000 SF inline)

Valuation

  • Market NOI cap rate for comparable retail centers: 5.50%
  • Forecast growth in cap rate: 5 bps per year
  • Exit cap rate: 6.00%

Development Assumptions

Construction Budget

  • Land cost with entitlement: 750,000
  • Hard costs: 6,250,000 (125 PSF)
  • Hard cost contingency: 5% of hard costs
  • Soft costs: 1,250,000 (25 PSF)
  • Soft cost contingency: 5% of soft costs
  • Leasing costs included on rent roll

Construction Financing

  • 5% interest rate
  • 70% LTC loan
  • 2% loan origination fee

Operating Assumptions

Rent Roll

  • John’s Market – 35,000 SF (pre-leased); lease start at construction completion; 16 year lease; 12 months free rent upfront;
    • Rent: 12.50 PSF rent for years 1-6; 15.00 PSF for years 7-11; and 17.50 PSF for years 12-16
    • Leasing costs: Tenant improvements of $30 PSF; no leasing commission
    • Expense Reimbursement: 5.00 PSF CAM
    • Future leasing assumptions: N/A
  • Inline space – 15,000 SF (not pre-leased)
    • 5 suites at ~3,000 SF per suite
    • Absorption: 1 suite every 3 months with first suite leasing at construction completion
    • Leasing costs: Tenant improvements of $40 PSF and 6% leasing commission for 1st generation leases
    • Rent: 16.50 as of lease start with 2% annual bumps
    • Lease term: 63 months with 3 months free rent upfront
    • Expense Reimbursement: NNN (100% of pro rata share)
    • Future leasing:
      • Market rent: 16.50 PSF;
      • TIs: New: 20 PSF, Renewal: 7.50 PSF
      • LCs: New: 6%, Renewal: 4%
      • Free rent: none
      • Market rent growth: 3%, 3%, 2%, 2%, 2%
      • Contract rent growth: 2%
      • Expense Reimbursement: NNN (100% of pro rata share)
      • Renewal probability: 60%
      • Lease length: 60 months
      • Downtime: 6 months

Other Income

  • Misc. Income: 15,000 grown at 2% annually

General Vacancy

  • 10%, excluding anchor space

Operating Expenses

  • CAM: 4.00 PSF
  • Mgmt Fee: 3%
  • Insurance: 0.25 PSF
  • RE Tax: 1.25 PSF

Capital Expenditures

  • Capital reserve: 0.15 PSF

Permanent Debt Assumptions

Senior Debt

  • Amount: 65% of stabilized value
  • Loan Fees: 0.5% of loan amount
  • Interest rate: 4.25%
  • Amortization: 30 years
  • Interest-only: None

Junior Debt

  • None

Partnership Assumptions

  • Equity split: 90/10 LP/GP
  • Preferred return: 8.0% paid pro rata
  • Promote: 80/20 to a 12% IRR, 70/30 to a 15% IRR, 60/40 thereafter

About the Author: Born and raised in the Northwest United States, Spencer Burton has over 15 years of real estate investment and development experience. In his current position, Spencer assesses new acquisition, development, and debt opportunities for a $45bn real estate fund. He resides in Dallas, TX.