Cash Flow Forecast - 12 Months
Month: Receipts Cash sales Collections from credit sales New equity inflow Loans received Other Total Receipts Payments Cash purchases Payments to creditors Salaries and wages Employee benefits Payroll taxes Rent Utiltities Repairs and maintenance Insurance Travel Telephone Postage Office supplies Advertising Marketing/promotion Professional fees Training and development Bank charges Miscellaneous Owner's drawings Loan repayments Tax payments Capital purchases Other Total Payments Cashflow Surplus/Deficit (-) Opening Cash Balance Closing Cash Balance
Pre-Start
1
2
3
4
5
6
7
8
9
10
11
12
Totals
0 0 0 0 0 0
0 0 0 16,700 0 16,700
10,020 0 0 0 0 10,020
10,855 251 0 0 0 11,106
12,525 418 0 8,350 0 21,293
14,195 501 0 0 0 14,696
15,865 501 0 0 0 16,366
18,370 585 0 8,350 0 27,305
21,710 752 0 0 0 22,462
24,215 752 0 0 0 24,967
26,406 1,002 0 8,350 0 35,758
28,808 1,002 0 0 0 29,810
33,066 1,166 0 0 0 34,232
216,035 6,930 0 41,750 0 264,715
0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0 0
401 1,203 6,304 3,152 1,051 5,253 1,021 584 1,021 1,240 1,043 438 949 6,938 5,439 1,751 26 0 0 0 0 25,050 0 0 62,864 (46,164) 0 (46,164)
326 978 5,120 2,560 853 4,267 830 474 830 1,007 847 358 770 5,635 4,418 1,422 21 0 0 0 0 0 0 0 30,716 (20,696) (46,164) (66,860)
166 499 2,620 1,310 437 2,183 425 243 425 515 434 182 394 2,883 2,261 728 11 0 0 0 0 4,175 0 0 19,891 (8,785) (66,860) (75,645)
131 392 2,058 1,029 343 1,715 333 191 333 405 341 143 310 2,265 1,776 572 9 0 0 0 0 0 10,000 0 22,346 (1,053) (75,645) (76,698)
237 713 3,728 1,864 621 3,107 604 345 604 734 617 259 561 4,103 3,217 1,036 16 0 0 0 0 0 0 0 22,366 (7,670) (76,698) (84,368)
166 499 2,620 1,310 437 2,183 425 243 425 515 434 182 394 2,883 2,261 728 11 0 0 0 0 0 0 0 15,716 650 (84,368) (83,718)
149 446 2,336 1,168 389 1,947 379 216 379 460 387 162 352 2,571 2,016 649 10 0 0 0 0 0 10,000 0 24,016 3,289 (83,718) (80,429)
149 446 2,336 1,168 389 1,947 379 216 379 460 387 162 352 2,571 2,016 649 10 0 0 0 0 0 0 0 14,016 8,446 (80,429) (71,983)
166 499 2,620 1,310 437 2,183 425 243 425 515 434 182 394 2,883 2,261 728 11 0 0 0 0 0 0 0 15,716 9,251 (71,983) (62,732)
113 339 1,780 890 297 1,483 288 165 288 350 295 124 268 1,959 1,536 494 7 0 0 0 0 0 21,325 0 32,001 3,757 (62,732) (58,975)
113 339 1,780 890 297 1,483 288 165 288 350 295 124 268 1,959 1,536 494 7 0 0 0 0 0 0 10,676 19,134 (58,975) (39,841)
167 503 2,631 1,315 438 2,192 426 244 426 518 435 183 396 2,895 2,270 731 11 0 0 0 0 0 0 15,781 18,451 (39,841) (21,390)
2,284 6,856 35,933 17,966 5,989 29,943 5,823 3,329 5,823 7,069 5,949 2,499 5,408 39,545 31,007 9,982 150 0 0 0 0 29,225 41,325 0 286,105 (21,390) (747,413) (768,803)
© Copyright, 2006, JaxWorks, All Rights Reserved.
Since 1996, JaxWorks has offered a suite of Free Excel workbooks and spreadsheets, and ass documents, that cover a number of financial, accounting and sales functions. These are invalua Also included Free are: - business plan tools, including spreadsheets and excellent instructions - Excel functions glossary and guide; - free training courses for most Microsoft Office applications. These guides are in PDF format and rival commercial books! - comprehensive list of acronyms, ratios and formulas in customer financial analysis, and financial terms; - suite of online calculators, including, breakeven analysis, productivity analysis, business evaluation; - Altman Z-Score (covering publicly and privately held firms, and small businesses); - and payroll analysis. If you are involved in financial analysis at any level, or want to learn more about MS Excel and suite this site is invaluable.
JaxWorks Small Business Spreadsheet Factory
spreadsheets, and associated MS Word, PDF and HTML ons. These are invaluable small business tools.
uides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory