Apolis

Deal: St. Louis Park West End, 200 unitsPage: Methodology

Where the sample deal page's numbers come from

Sample

Each headline figure with its formula and inputs, then every key assumption and what moves the return.

Figures are the sponsor's projections, computed by the monthly model. Apolis formats them; the sponsor owns every projection.

Headline figures traced
14
each to a formula and inputs
Reproduce from inputs
8
8 of 14 within rounding
From the monthly model
6
Computed on monthly cash flows
Key assumptions
20
4 with a sensitivity on the deal page

Where each headline number comes from

  • Investor IRR
    15.16%
    From the monthly model
  • Investor multiple
    2.73x
    Reproduces
  • Levered project IRR
    16.85%
    From the monthly model
  • Untrended yield on cost
    6.51%
    Reproduces
  • Trended yield on cost
    7.26%
    Reproduces
  • Stabilized NOI
    $3,787,177
    Reproduces
  • Total project cost
    $52,189,000
    Reproduces
  • Cost per unit
    $260,945
    Reproduces
  • Equity
    $18,266,779
    From the monthly model
  • Construction loan
    $33,922,000
    From the monthly model
  • Loan to cost
    65.0%
    Reproduces
  • Refinance proceeds
    $14,024,696
    From the monthly model
  • Sale price and exit cap
    $79,982,598
    Reproduces
  • Sponsor promote
    $7,454,108
    From the monthly model
What each source means
Sponsor input:
a figure the sponsor states and defends
Model output:
computed from other inputs
Monthly model:
read from the model's dated monthly cash flow

Where the inputs do not reproduce the figure exactly, the row shows the sheet's figure and says so, rather than a second number that disagrees with it.