Cash Budget
For Jul-2006 through Jun-2007
Jul
Beginning cash balance Cash from operations Total Available Cash Less: Capital expenditures Interest Dividends Debt retirement Other Total Disbursements Cash Balance (Deficit) Add: Short-term loans Long-term loans Capital stock issues Total Additions Ending Cash Balance $935 125 $1,060 $113 20 2 50 0 $185 $875 6 $10 0 16 $891
Aug
$891 218 $1,109 $123 26 4 31 0 $184 $925 3 $0 0 3 $928
Sep
$928 141 $1,069 $113 24 3 40 0 $180 $889 6 $0 0 6 $895
Oct
$895 156 $1,051 $106 25 5 32 0 $168 $883 6 $0 0 6 $889
Nov
$889 211 $1,100 $102 21 0 48 0 $171 $929 10 $0 0 10 $939
Dec
$939 161 $1,100 $94 22 2 39 0 $157 $943 9 $0 0 9 $952
Jan
$952 155 $1,107 $114 27 1 46 0 $188 $919 8 $0 0 8 $927
Feb
$927 187 $1,114 $126 29 2 41 0 $198 $916 4 $0 0 4 $920
Mar
$920 167 $1,087 $133 20 3 34 0 $190 $897 7 $5 0 12 $909
Apr
$909 246 $1,155 $126 27 2 30 2 $187 $968 9 $0 0 9 $977
May
$977 132 $1,109 $119 23 4 40 0 $186 $923 4 $0 0 4 $927
Jun
$927 184 $1,111 $123 29 5 42 0 $199 $912 5 $0 0 5 $917
Total
$935 2,083 $3,018 $1,392 293 33 473 2 $2,193 $825 77 $15 92 $917
© 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.
ides are in
y analysis,
about MS Excel and other applications in the Office
sheet Factory