Docstoc

Cash budgeting paper

Document Sample
Cash budgeting paper Powered By Docstoc
					Cash Budgeting Worksheet Month 1 Estimated Total Sales Estimated Credit Sales Bad-Debt Loss Percentage Credit Policy Cash Discount (%) Percent Taking Discount Discount Period (Days) Credit Period (Days) Estimated Cash Receipts: Cash Sales Collection On Credit Sales: Current Month (Discount Takers) Current Month (No Discount Taken) One Month Prior Two Months Prior Three Months Prior Total Receivable Collections(Must = 100%) Estimated Credit Materials Purchases (%) Purchases Based On Next Month's Sales Or One After Next Month's Sales (1) Month After Next Month's Sales (2) Payments On Credit Purchases % Of Previous Month's Purchases $0 $0

Cash Bu Month 2 $0 $0 Month 3 $0 $0 Month 4 $0 $0 Month 5 $0 $0

0.00% 0.00%

0.00% 0.00% 0 0

$0 Percentage 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 1 $0 $0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 0.00%

$0

% Of Purchases Two Month's Prior Cash Budget

0.00% Month 1 Month 2 $0 Month 3 $0 Month 4 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 5 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

C

Sales Beginning Of Month Projected Cash Balance Receipts Cash Sales Receivables Collections Non-Operating Cash Receipts Cash From Sale Of Assets Cash From Financing Operations Total Cash Available Disbursements Payment On Credit Purchases Cash Purchases Labor General And Administrative Salaries Rent And Utilities Other Expenses Taxes Purchase Of Assets Interest Dividends Paid Repayment Of "Other" Loans Sinking Fund Payments Total Disbursements Excess Available Cash Over Disbursements Desired Cash Balance $0 Loan (Payment) Required To Maintain Cash Balance

$0

End Of Month Projected Cash Balance

$0

$0

Cash Budgeting Worksheet Month 6 Month 7 Month 8 $0 $0 $0 $0 $0 $0

Month 9 $0 $0

Month 10 $0 $0

Month 11 $0 $0

Month 12 $0 $0

Cash Budgeting Worksheet Month 13 $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 $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 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0

$0

$0

$0

$0

$0

$0

$0

Month 6 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Cash Budget Month 7 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Cash Budget Month 8 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 9 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 10 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 11 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 12 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 Month 13 $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

$0

$0

$0

Cash Budgeting Worksheet Month 14 Month 15 $0 $0 $0 $0

Month 16 $0 $0

Month 17 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0 $0 $0 $0 $0 $0 $0 $0

$0

$0

$0

$0

Cash Budget Month 14 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Month 15 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0

Month 16 $0

Month 17 $0

$0

$0


				
DOCUMENT INFO
Shared By:
Stats:
views:204
posted:4/25/2008
language:English
pages:9
lara castillo lara castillo
About