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