Below is the full cash flow model that results from the rules that are set in the foregoing sections. It will change dynamically as the user adjusts the various parameters above.
Oct '18
Nov '18
Dec '18
Jan '19
Feb '19
Mar '19
Apr '19
May '19
Jun '19
Jul '19
Aug '19
Sep '19
Oct '19
Nov '19
Dec '19
Jan '20
Feb '20
Mar '20
Oct '18
Nov '18
Dec '18
Jan '19
Feb '19
Mar '19
Apr '19
May '19
Jun '19
Jul '19
Aug '19
Sep '19
Oct '19
Nov '19
Dec '19
Jan '20
Feb '20
Mar '20
Revenues
1 Widget sales
$0
$0
$0
$0
$0
$0
$0
$0
$95,000
$99,560
$104,339
$109,347
$114,596
$120,096
$125,861
$131,902
$138,234
$144,869
Expenses
1 Overhead
-$10,000
-$10,250
-$10,506
-$10,769
-$11,038
-$11,314
-$11,597
-$11,887
-$12,184
-$12,489
-$12,801
-$13,121
-$13,449
-$13,785
-$14,130
-$14,483
-$14,845
-$15,216
2 Bus. planning
-$5,667
-$5,808
-$5,954
-$6,102
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
$0
3 Design
$0
$0
-$6,667
-$6,833
-$7,004
-$7,179
-$7,359
-$7,543
-$7,731
$0
$0
$0
$0
$0
$0
$0
$0
$0
4 Development
$0
$0
-$13,333
-$13,667
-$14,008
-$14,359
-$14,718
-$15,085
-$15,463
$0
$0
$0
$0
$0
$0
$0
$0
$0
5 Pre-marketing
$0
$0
$0
$0
$0
-$60,000
-$61,500
-$63,037
-$64,613
$0
$0
$0
$0
$0
$0
$0
$0
$0
6 Manufacturing
$0
$0
$0
$0
$0
$0
$0
$0
-$25,000
-$25,625
-$26,266
-$26,922
-$27,595
-$28,285
-$28,992
-$29,717
-$30,460
-$31,222
7 Marketing
$0
$0
$0
$0
$0
$0
$0
$0
-$8,000
-$8,200
-$8,405
-$8,615
-$8,831
-$9,051
-$9,278
-$9,509
-$9,747
-$9,991
Want to print your doc? This is not the way.
Try clicking the ··· in the right corner or using a keyboard shortcut (