← Back to Dashboard

Detailed Monthly Cashflow Table

Complete month-by-month breakdown of all capital movements, cash balance, home inventory position, and funds outstanding. Toggle repayment scenario to see the impact on cash flows.

Repayment Structure
Seed capital ($2M) always repays monthly M13-M36 (~$83k/mo). Toggle controls main capital ($12M): 5% monthly amortization vs bullet at M36.
Month-by-Month Cashflow Analysis
All inflows and outflows, cumulative cash balance, home inventory position, and outstanding investor principal.
MonthCapital RaiseRevenueConstructionPrincipal RepayNet Cash FlowCash BalanceHomes ProgressHomes SoldFunds Out
M1$2,000,000—($900,000)—$1,100,000$1,100,00030$2,000,000
M2$1,000,000—($900,000)—$100,000$1,200,00060$3,000,000
M3$1,000,000—($900,000)—$100,000$1,300,00090$4,000,000
M4$1,000,000—($900,000)—$100,000$1,400,000120$5,000,000
M5$1,000,000—($900,000)—$100,000$1,500,000150$6,000,000
M6$1,000,000—($900,000)—$100,000$1,600,000180$7,000,000
M7$1,000,000$1,200,000($1,800,000)—$400,000$2,000,000213$8,000,000
M8$1,000,000$1,200,000($1,800,000)—$400,000$2,400,000246$9,000,000
M9$1,000,000$1,200,000($1,800,000)—$400,000$2,800,000279$10,000,000
M10$1,000,000$1,200,000($1,800,000)—$400,000$3,200,0003012$11,000,000
M11$1,000,000$1,200,000($1,800,000)—$400,000$3,600,0003315$12,000,000
M12$1,000,000$1,200,000($1,800,000)—$400,000$4,000,0003618$13,000,000
M13—$2,400,000($1,800,000)($83,333)$516,667$4,516,6673624$13,916,667
M14—$2,400,000($1,800,000)($83,333)$516,667$5,033,3333630$13,833,333
M15—$2,400,000($1,800,000)($83,333)$516,667$5,550,0003636$13,750,000
M16—$2,400,000($1,800,000)($83,333)$516,667$6,066,6673642$13,666,667
M17—$2,400,000($1,800,000)($83,333)$516,667$6,583,3333648$13,583,333
M18—$2,400,000($1,800,000)($83,333)$516,667$7,100,0003654$13,500,000
M19—$2,400,000($1,800,000)($83,333)$516,667$7,616,6673660$13,416,667
M20—$2,400,000($1,800,000)($83,333)$516,667$8,133,3333666$13,333,333
M21—$2,400,000($1,800,000)($83,333)$516,667$8,650,0003672$13,250,000
M22—$2,400,000($1,800,000)($83,333)$516,667$9,166,6673678$13,166,667
M23—$2,400,000($1,800,000)($83,333)$516,667$9,683,3333684$13,083,333
M24—$2,400,000($1,800,000)($83,333)$516,667$10,200,0003690$13,000,000
M25—$2,400,000($1,800,000)($83,333)$516,667$10,716,6673696$12,916,667
M26—$2,400,000($1,800,000)($83,333)$516,667$11,233,33336102$12,833,333
M27—$2,400,000($1,800,000)($83,333)$516,667$11,750,00036108$12,750,000
M28—$2,400,000($1,800,000)($83,333)$516,667$12,266,66736114$12,666,667
M29—$2,400,000($1,800,000)($83,333)$516,667$12,783,33336120$12,583,333
M30—$2,400,000($1,800,000)($83,333)$516,667$13,300,00036126$12,500,000
M31—$2,400,000($1,800,000)($83,333)$516,667$13,816,66736132$12,416,667
M32—$2,400,000($1,800,000)($83,333)$516,667$14,333,33336138$12,333,333
M33—$2,400,000($1,800,000)($83,333)$516,667$14,850,00036144$12,250,000
M34—$2,400,000($1,800,000)($83,333)$516,667$15,366,66736150$12,166,667
M35—$2,400,000($1,800,000)($83,333)$516,667$15,883,33336156$12,083,333
M36—$2,400,000($1,800,000)($12,083,333)$-11,483,333$4,400,00036162$0
Total Capital Raised

$13,000,000

Total Revenue

$64,800,000

Total Construction

($59,400,000)

Final Cash Balance

$4,400,000