Integrated Three-Statement Model

Income statement · balance sheet · cash flow · quarterly FY2027–FY2029 · driver-based · synthetic company
$42M$64M$86M2027Q12027Q32028Q12028Q32029Q12029Q3 ● base ● upside ● downside

Income statement

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Revenue10.911.812.813.714.615.616.517.518.419.320.221.1
Cost of revenue-2.5-2.7-2.9-3.1-3.4-3.6-3.8-4.0-4.2-4.4-4.7-4.9
Gross profit8.49.19.810.511.312.012.713.414.214.915.616.3
Sales & marketing-5.0-5.4-5.8-6.1-6.5-6.8-7.2-7.5-7.8-8.1-8.4-8.7
Research & development-3.3-3.6-3.8-4.1-4.4-4.7-5.0-5.2-5.5-5.8-6.1-6.3
General & administrative-1.5-1.6-1.7-1.8-2.0-2.1-2.2-2.4-2.5-2.6-2.7-2.9
Depreciation-0.4-0.4-0.5-0.5-0.5-0.5-0.6-0.6-0.7-0.7-0.7-0.8
EBIT-1.8-1.9-1.9-2.0-2.1-2.1-2.2-2.3-2.3-2.3-2.4-2.4
Tax-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0
Net income-1.8-1.9-1.9-2.0-2.1-2.1-2.2-2.3-2.3-2.3-2.4-2.4
memo: SBC within opex1.41.51.61.71.81.92.02.12.22.32.42.5
memo: billings11.012.313.614.715.916.918.019.019.920.921.822.7

Balance sheet

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Cash57.557.057.057.457.958.759.660.761.963.264.566.0
Accounts receivable7.07.88.69.410.110.811.412.112.713.313.914.4
PP&E, net6.56.56.56.46.46.46.46.46.46.46.46.3
Total assets70.971.372.173.274.575.977.579.281.082.884.886.8
Accounts payable4.14.44.75.05.45.76.06.36.66.97.27.5
Deferred revenue26.026.527.328.429.631.032.534.035.537.138.740.3
Total liabilities30.130.932.033.435.036.738.540.342.244.146.047.8
Paid-in capital90.692.093.695.397.199.0101.0103.1105.3107.7110.1112.6
Retained earnings (deficit)-49.8-51.6-53.6-55.6-57.7-59.8-62.0-64.2-66.5-68.9-71.3-73.7
Total equity40.840.440.139.739.539.239.038.938.838.838.838.9
Total liabilities + equity70.971.372.173.274.575.977.579.281.082.884.886.8
check: A − (L + E)0.00.00.00.00.00.00.00.00.00.0-0.0-0.0

Cash flow statement (indirect)

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Net income-1.8-1.9-1.9-2.0-2.1-2.1-2.2-2.3-2.3-2.3-2.4-2.4
+ Depreciation0.40.40.50.50.50.50.60.60.70.70.70.8
+ Stock-based compensation1.41.51.61.71.81.92.02.12.22.32.42.5
− Increase in receivables2.8-0.9-0.8-0.7-0.7-0.7-0.7-0.6-0.6-0.6-0.6-0.6
+ Increase in payables-0.00.30.30.30.30.30.30.30.30.30.30.3
+ Increase in deferred revenue0.00.50.81.11.21.41.51.51.61.61.61.6
Cash from operations2.8-0.00.40.81.11.31.51.71.82.02.12.2
Capital expenditure-0.4-0.4-0.4-0.5-0.5-0.5-0.6-0.6-0.6-0.7-0.7-0.7
Cash from investing-0.4-0.4-0.4-0.5-0.5-0.5-0.6-0.6-0.6-0.7-0.7-0.7
Cash from financing0.00.00.00.00.00.00.00.00.00.00.00.0
Net change in cash2.5-0.4-0.00.30.60.80.91.11.21.31.41.5
Beginning cash55.057.557.057.057.457.958.759.660.761.963.264.5
Ending cash57.557.057.057.457.958.759.660.761.963.264.566.0
check: = balance-sheet cash0.00.00.00.00.00.00.00.00.00.00.00.0

Income statement

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Revenue11.112.213.414.716.017.418.820.421.923.625.227.0
Cost of revenue-2.3-2.6-2.8-3.1-3.4-3.7-4.0-4.3-4.6-4.9-5.3-5.7
Gross profit8.79.610.611.612.613.714.916.117.318.619.921.3
Sales & marketing-5.1-5.5-6.0-6.4-6.9-7.4-7.9-8.4-8.9-9.5-10.0-10.5
Research & development-3.3-3.7-4.0-4.4-4.8-5.2-5.7-6.1-6.6-7.1-7.6-8.1
General & administrative-1.5-1.6-1.8-2.0-2.2-2.3-2.5-2.7-3.0-3.2-3.4-3.6
Depreciation-0.4-0.4-0.5-0.5-0.5-0.6-0.6-0.6-0.7-0.7-0.8-0.8
EBIT-1.6-1.6-1.7-1.7-1.8-1.8-1.8-1.8-1.8-1.8-1.8-1.8
Tax-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0
Net income-1.6-1.6-1.7-1.7-1.8-1.8-1.8-1.8-1.8-1.8-1.8-1.8
memo: SBC within opex1.41.51.71.81.92.12.32.42.62.82.93.1
memo: billings11.513.114.816.418.019.721.323.024.826.528.330.2

Balance sheet

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Cash57.757.958.659.861.463.365.668.271.074.277.781.5
Accounts receivable7.38.49.410.411.512.513.614.615.716.918.019.2
PP&E, net6.56.56.56.56.66.66.76.86.96.97.17.2
Total assets71.572.774.576.779.482.485.889.593.698.0102.8107.9
Accounts payable4.04.44.85.35.76.26.67.17.68.28.79.2
Deferred revenue26.427.428.830.532.634.837.340.042.845.748.852.0
Total liabilities30.531.833.635.838.241.043.947.150.453.957.561.2
Paid-in capital90.692.193.895.597.599.6101.8104.3106.9109.6112.5115.7
Retained earnings (deficit)-49.6-51.2-52.9-54.6-56.4-58.2-60.0-61.8-63.6-65.5-67.3-69.0
Total equity41.040.940.940.941.141.441.942.543.244.145.346.6
Total liabilities + equity71.572.774.576.779.482.485.889.593.698.0102.8107.9
check: A − (L + E)0.0-0.00.0-0.00.00.00.00.00.00.00.00.0

Cash flow statement (indirect)

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Net income-1.6-1.6-1.7-1.7-1.8-1.8-1.8-1.8-1.8-1.8-1.8-1.8
+ Depreciation0.40.40.50.50.50.60.60.60.70.70.80.8
+ Stock-based compensation1.41.51.71.81.92.12.32.42.62.82.93.1
− Increase in receivables2.5-1.1-1.0-1.0-1.0-1.0-1.1-1.1-1.1-1.1-1.1-1.2
+ Increase in payables-0.10.40.40.40.40.50.50.50.50.50.50.5
+ Increase in deferred revenue0.41.01.41.72.02.32.52.72.83.03.13.2
Cash from operations3.10.61.21.72.12.52.93.33.74.04.44.7
Capital expenditure-0.4-0.4-0.5-0.5-0.6-0.6-0.7-0.7-0.8-0.8-0.9-0.9
Cash from investing-0.4-0.4-0.5-0.5-0.6-0.6-0.7-0.7-0.8-0.8-0.9-0.9
Cash from financing0.00.00.00.00.00.00.00.00.00.00.00.0
Net change in cash2.70.20.71.21.61.92.32.62.93.23.53.8
Beginning cash55.057.757.958.659.861.463.365.668.271.074.277.7
Ending cash57.757.958.659.861.463.365.668.271.074.277.781.5
check: = balance-sheet cash0.00.00.00.00.00.00.00.00.00.00.00.0

Income statement

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Revenue10.811.411.912.412.913.313.714.114.414.815.115.3
Cost of revenue-2.7-2.8-3.0-3.1-3.2-3.3-3.4-3.5-3.6-3.7-3.8-3.8
Gross profit8.18.58.99.39.610.010.310.610.811.111.311.5
Sales & marketing-5.4-5.6-5.8-6.0-6.2-6.3-6.5-6.6-6.7-6.7-6.8-6.9
Research & development-3.2-3.4-3.6-3.7-3.9-4.0-4.1-4.2-4.3-4.4-4.5-4.6
General & administrative-1.5-1.5-1.6-1.7-1.7-1.8-1.9-1.9-1.9-2.0-2.0-2.1
Depreciation-0.4-0.4-0.5-0.5-0.5-0.5-0.6-0.6-0.6-0.7-0.7-0.7
EBIT-2.4-2.5-2.5-2.6-2.6-2.7-2.7-2.7-2.7-2.8-2.8-2.8
Tax-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0
Net income-2.4-2.5-2.5-2.6-2.6-2.7-2.7-2.7-2.7-2.8-2.8-2.8
memo: SBC within opex1.41.51.51.61.61.71.71.81.81.81.91.9
memo: billings10.211.211.912.613.213.714.214.614.915.215.515.8

Balance sheet

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Cash55.553.852.551.450.549.849.148.648.147.647.246.8
Accounts receivable8.08.79.39.810.310.711.011.311.611.812.112.3
PP&E, net6.56.46.46.46.36.26.16.05.95.85.65.4
Total assets69.968.968.267.667.166.766.365.965.665.264.964.5
Accounts payable4.24.44.64.85.05.15.35.45.55.65.75.8
Deferred revenue25.525.325.325.525.926.326.727.227.728.128.629.0
Total liabilities29.729.729.930.330.831.432.032.633.233.734.234.7
Paid-in capital90.692.193.695.296.998.6100.3102.1103.9105.7107.6109.5
Retained earnings (deficit)-50.4-52.9-55.4-58.0-60.6-63.3-66.0-68.7-71.5-74.2-77.0-79.7
Total equity40.239.238.237.236.235.334.333.432.431.530.629.8
Total liabilities + equity69.968.968.267.667.166.766.365.965.665.264.964.5
check: A − (L + E)0.00.00.00.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0-0.0

Cash flow statement (indirect)

$M2027Q12027Q22027Q32027Q42028Q12028Q22028Q32028Q42029Q12029Q22029Q32029Q4
Net income-2.4-2.5-2.5-2.6-2.6-2.7-2.7-2.7-2.7-2.8-2.8-2.8
+ Depreciation0.40.40.50.50.50.50.60.60.60.70.70.7
+ Stock-based compensation1.41.51.51.61.61.71.71.81.81.81.91.9
− Increase in receivables1.8-0.7-0.6-0.5-0.5-0.4-0.4-0.3-0.3-0.2-0.2-0.2
+ Increase in payables0.10.20.20.20.20.10.10.10.10.10.10.1
+ Increase in deferred revenue-0.5-0.20.10.20.30.40.40.50.50.50.40.4
Cash from operations0.8-1.3-0.9-0.6-0.4-0.3-0.2-0.10.00.10.10.2
Capital expenditure-0.4-0.4-0.4-0.4-0.5-0.5-0.5-0.5-0.5-0.5-0.5-0.5
Cash from investing-0.4-0.4-0.4-0.4-0.5-0.5-0.5-0.5-0.5-0.5-0.5-0.5
Cash from financing0.00.00.00.00.00.00.00.00.00.00.00.0
Net change in cash0.5-1.7-1.3-1.1-0.9-0.7-0.6-0.6-0.5-0.5-0.4-0.4
Beginning cash55.055.553.852.551.450.549.849.148.648.147.647.2
Ending cash55.553.852.551.450.549.849.148.648.147.647.246.8
check: = balance-sheet cash0.00.00.00.00.00.00.00.00.00.00.00.0