ABCDEFGHIJKLMNOPQRSTUVWXYZAAABACADAEAFAGAHAIAJ
1
Monthly Cash Flow Projection - Enter YOUR labels or numbers in greenish cells
2
Jan-23Feb-23Mar-23Apr-23May-23Jun-23Jul-23Aug-23Sep-23Oct-23Nov-23Dec-23TOTAL
3
Beginning Cash
0 0 0 0 0 0 0 0 0 0 0 Assumptions
4
CASH RECEIPTS (Operating Income)
5
Cash Sale Receipts 0
6
Accts Receivable paid 0
7
0
8
CASH RECEIPTS (Capital Inflows)
9
New Loan Amounts
10
Owner Investments 0
11
Total Cash Receipts
0 0 0 0 0 0 0 0 0 0 0 0 0
12
Total Cash Available
0 0 0 0 0 0 0 0 0 0 0 0 0
13
CASH PAID OUT (Operating Expenses)
14
Inventory purchases 0
15
Insurance 0
16
Wages 0
17
Payroll Taxes+Benefits 0
18
Accounting, Legal, Other 0
19
Software 0
20
Travel+Food+Lodging 0
21
Office Supplies 0
22
Repairs+Maintenance 0
23
Phone, Internet 0
24
Electricity+Gas+Oil 0
25
Rent 0
26
Training+License Fees 0
27
Excise+Property Taxes 0
28
Miscellaneous 0
29
Loan Interest (from below) 0 0 0 0 0 0 0 0 0 0 0 0 0
30
CASH PAID OUT (Capital Items, etc.)
31
Loan Principal (from below) 0 0 0 0 0 0 0 0 0 0 0 0 0
32
Equipment Purchases 0
33
Major Building Repairs 0
34
Estimated Tax Withdrawals 0
35
Owner Withdrawals 0
36
Total Cash Paid Out
0 0 0 0 0 0 0 0 0 0 0 0 0
37
Ending Cash
0 0 0 0 0 0 0 0 0 0 0 0 0
38
39
Total Debt 0 0 0 0 0 0 0 0 0 0 0 0
40
Loan #1 PrincipalRate:6.0%Term (Yrs): 10
Monthly Pmt:
0
41
Interest Payment 0 0 0 0 0 0 0 0 0 0 0 0
42
Principal Payment 0 0 0 0 0 0 0 0 0 0 0 0
43
Principal Balance 0 0 0 0 0 0 0 0 0 0 0 0
44
Loan #2 PrincipalRate:6.0%Term (Yrs): 10
Monthly Pmt:
0
45
Interest Payment 0 0 0 0 0 0 0 0 0 0 0 0
46
Principal Payment 0 0 0 0 0 0 0 0 0 0 0 0
47
Principal Balance 0 0 0 0 0 0 0 0 0 0 0 0
48
Loan #3 PrincipalRate:6.0%Term (Yrs): 10
Monthly Pmt:
0
49
Interest Payment 0 0 0 0 0 0 0 0 0 0 0 0
50
Principal Payment 0 0 0 0 0 0 0 0 0 0 0 0
51
Principal Balance 0 0 0 0 0 0 0 0 0 0 0 0
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