Apolis

Deal: St. Louis Park West End, 200 unitsPage: Cash flows

Cash flows

Sample

Ten-year cash flow from closing to sale.Model v1, worked example, no edits

Sample deal. Stated figures from the worked example.

Equity in
$18,267,000
Peak Jan 2029, month 24
Cash back
$56,447,349
3.09x equity multiple
Levered IRR · pre-promote
16.85%
Unlevered 10.27%
Stabilized NOI · year 4
$3,787,177
1.60x coverage, covenant 1.20x met

Cash to equity by year · levered, annual

ConstructionLease-upStabilizedSaleRefi($20.0M)0$20.0M$40.0MClosing: ($3.9M) net, ($3.9M) cumulativeCloseYear 1: ($14.3M) net, ($18.3M) cumulativeY1Year 2: ($221) net, ($18.3M) cumulativeY2Year 3: $0 net, ($18.3M) cumulativeY3Year 4: $1.3M net, ($17.0M) cumulativeY4Year 5: $1.4M net, ($15.5M) cumulativeY5Year 6: $14.7M net, ($806K) cumulativeY6Year 7: $815K net, $9K cumulativeY7Year 8: $914K net, $923K cumulativeY8Year 9: $1.0M net, $1.9M cumulativeY9Year 10: $36.2M net, $38.2M cumulativeY10Paid back, Y7$38.2M net
  • Equity in
  • Cash back
  • Cumulative

Cash flow by year

Cash flow, annual, US dollars
Line, US dollarsConstructionLeaseStabilizedSaleTotalClose to Y10
CloseJan 2027Y1Months 1 to 12Y2Months 13 to 24Y3Months 25 to 36Y4Months 37 to 48Y5Months 49 to 60Y6Months 61 to 72Y7Months 73 to 84Y8Months 85 to 96Y9Months 97 to 108Y10Months 109 to 120
5,560,1775,726,9825,867,7946,014,0426,164,2686,318,4746,476,6606,637,83048,766,228
(3,196,956)(286,349)(293,390)(300,702)(308,213)(315,924)(323,833)(331,892)(5,357,258)
(27,801)(28,635)(29,339)(30,070)(30,821)(31,592)(32,383)(33,189)(243,831)
(9,453)(21,763)(22,298)(22,853)(23,424)(24,010)(24,611)(25,224)(173,636)
158,033366,227375,232384,584394,191404,052414,168424,4742,920,960
2,484,0005,756,4635,898,0006,045,0006,196,0006,351,0006,510,0006,672,00045,912,463
(969,000)(1,561,286)(1,598,143)(1,637,097)(1,677,625)(1,719,665)(1,763,157)(1,806,036)(12,732,009)
(381,000)(408,000)(418,000)(429,000)(440,000)(451,000)(462,000)(474,000)(3,463,000)
(1,350,000)(1,969,286)(2,016,143)(2,066,097)(2,117,625)(2,170,665)(2,225,157)(2,280,036)(16,195,009)
1,134,0003,787,1773,881,8573,978,9034,078,3754,180,3354,284,8434,391,96429,717,454
(50,000)(100,000)(102,500)(105,060)(107,687)(110,379)(113,138)(115,966)(804,730)
(2,000,000)(2,000,000)
(19,517,259)(21,971,251)(41,488,510)
(1,165,850)(2,176,231)(769,824)(4,111,905)
(510,000)(1,020,000)(510,000)(2,040,000)
(254,415)(254,415)
(43,945)(2,250,225)(2,294,170)
(3,930,265)(22,757,435)(25,501,300)(52,189,000)
79,982,59879,982,598
(1,599,652)(1,599,652)
78,382,94678,382,946
(3,930,265)(22,757,435)(25,501,300)1,084,0003,687,1773,779,3573,873,8433,970,6884,069,9564,171,70582,658,94555,106,671
8,420,92125,501,07933,922,000
(2,374,000)(2,374,000)(2,374,000)(7,122,000)
(3,155,981)(3,155,981)(3,155,981)(3,155,981)(3,155,981)(15,779,905)
47,032,00047,032,000
(32,982,304)(32,982,304)
(25,000)(25,000)
(43,261,112)(43,261,112)
1,290,0001,290,000
8,420,92125,501,079(1,084,000)(2,374,000)(2,374,000)10,868,715(3,155,981)(3,155,981)(3,155,981)(46,417,093)(16,926,322)
(3,930,265)(14,336,514)(221)1,313,1771,405,35714,742,558814,707913,9751,015,72436,241,85138,180,349
1,313,1771,405,35714,742,558814,707913,9751,015,72436,241,85156,447,349
Conventions
  • Close is closing day, month 0. Y1 is months 1 to 12; the deal page folds Close into its year one.
  • Cash going out is in parentheses. Every subtotal is the sum of the lines above it, and months add to years.
  • Distributions and ratios are run by year, so the monthly view shows them on year columns only.