Sharable Seller Accountant Cash Flow Forecast
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
$
%
123
 
 
 
 
 
 
 
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Cash Flow Forecast Template
2
VIDEO
https://drive.google.com/file/d/1bbNu1dWBnR-LnKj8SwtRZLnsGmJav-t8/view
3
4
5
6
7
www.selleraccountant.comJanuaryFebruaryMarchAprilMayJuneJulyAugustSeptemberOctoberNovember
8
Operations
9
Expected Sales$100,000.00$115,000.00$105,450.00$92,000.00$100,000.00$105,000.00$100,000.00$100,000.00
10
Expected COGS$55,000.00$62,000.00$63,270.00$55,200.00$60,000.00$63,000.00$60,000.00$60,000.00
11
Gross Profit$45,000.00$53,000.00$42,180.00$36,800.00$40,000.00$42,000.00$40,000.00$40,000.00
12
Advertising Budget$10,000.00$11,500.00$10,545.00$9,200.00$10,000.00$10,500.00$10,000.00$10,000.00
13
Other Overhead/Expenses$15,000.00$16,250.00$15,817.50$15,450.00$15,432.00$16,500.00$16,500.00$16,500.00
14
Expected Impact from OPS (Operating Profit)$20,000.00$25,250.00$15,817.50$12,150.00$14,568.00$15,000.00$13,500.00$13,500.00
15
Financing
16
Pymt Loan 1-$3,500.00-$3,500.00-$3,500.00-$3,500.00-$3,500.00-$3,500.00-$3,500.00-$3,500.00
17
Pymt Loan 2-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00-$1,500.00
18
Credit Card 1-$2,800.00-$2,800.00-$2,800.00-$2,800.00-$2,800.00-$2,800.00-$2,800.00-$2,800.00
19
Credit Card 2-$6,700.00-$6,700.00-$6,700.00-$6,700.00-$6,700.00-$6,700.00-$6,700.00-$6,700.00
20
Expected New Loans (adding money to the business)$15,000.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
21
Total Impact of Debt$500.00-$14,500.00-$14,500.00-$14,500.00-$14,500.00-$14,500.00-$14,500.00-$14,500.00
22
Inventory Impact
23
Accounts Payable Last Month$50,000.00$30,000.00$36,400.00$31,000.00$30,000.00$40,000.00$35,000.00$33,000.00
24
Accounts Payable This Month$30,000.00$36,400.00$31,000.00$30,000.00$40,000.00$35,000.00$33,000.00$38,000.00
25
Change in Accounts Payable Due to Inventory Purchases-$20,000.00$6,400.00-$5,400.00-$1,000.00$10,000.00-$5,000.00-$2,000.00$5,000.00
26
Investing
27
Expected Owner investments$0.00$0.00$0.00$0.00$0.00$0.00$0.00$0.00
28
Expected profit distributions$0.00$0.00-$2,500.00-$24,427.00-$2,500.00$0.00-$16,687.20-$2,500.00
29
Expected total from Investing$0.00$0.00-$2,500.00-$24,427.00-$2,500.00$0.00-$16,687.20-$2,500.00
30
31
EXPECTED TOTAL CHANGE IN CASH FOR THE MONTH
$500.00$17,150.00-$6,582.50-$27,777.00$7,568.00-$4,500.00-$19,687.20$1,500.00
32
Beginning Available Cash$25,000.00$25,500.00$42,650.00$36,067.50$8,290.50$15,858.50$11,358.50-$8,328.70
33
Ending available Cash$25,500.00$42,650.00$36,067.50$8,290.50$15,858.50$11,358.50-$8,328.70-$6,828.70
34
35
Target Cash Available for rainy day$30,000.00$32,500.00$31,635.00$30,900.00$30,864.00$33,000.00$33,000.00$33,000.00
36
Surplus or (Deficit) In Cash Expected-$4,500.00$10,150.00$4,432.50-$22,609.50-$15,005.50-$21,641.50-$41,328.70-$39,828.70
37
38
39
40
41
42
43
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
Loading...