ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
📊 CASH FLOW FORECAST CALCULATOR - INSTRUCTIONS
2
3
HOW TO USE THIS CALCULATOR
4
5
1. CREATE YOUR COPY
6
 • Click on File > Make a copy
7
 • Name the copy and save it on your drive
8
9
2. GO TO THE "INPUTS" SHEET
10
 • Enter your values in the BLUE cells
11
 • Monthly Revenue: Your average monthly income
12
 • Monthly Expenses: Your average monthly costs
13
 • Capital Expenditure: One-time investments or equipment purchases
14
 • Annual Growth Rate: Expected yearly growth percentage
15
 • Select Period Type: Weekly, Monthly, or Quarterly
16
 • Select Scenario: Baseline, Optimistic (+20%), or Pessimistic (-20%)
17
18
3. VIEW YOUR RESULTS
19
 • Dashboard: Quick overview of key metrics
20
 • Cash Flow Projection: 12-period detailed forecast with charts
21
 • Waterfall Analysis: See where cash comes from and goes
22
 • Scenario Comparison: Compare all three scenarios side-by-side
23
24
4. UNDERSTAND THE COLOR CODING
25
 • BLUE text = Input values (you can change these)
26
 • BLACK text = Calculated formulas
27
 • GREEN text = Positive cash flows
28
 • RED text = Negative cash flows
29
 • YELLOW background = Important values needing attention
30
31
5. KEY METRICS EXPLAINED
32
 • Current Cash Balance: How much cash you have now
33
 • Projected Balance: Expected cash in 3 months
34
 • Burn Rate: How much you spend per month
35
 • Runway: How many months until you run out of cash
36
37
6. TIPS FOR ACCURATE FORECASTING
38
 • Use conservative (realistic) estimates
39
 • Review and update monthly
40
 • Compare scenarios to understand risks
41
 • Focus on extending your runway
42
43
💡 PRO TIP: Save different versions for different business scenarios!
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100