CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS
(ASSUMES 5% CHANGE IN RECEIPTS AND DISBURSEMENTS)
Pessimistic Cash Flow
Expected Cash Flow
Optimistic Cash Flow
DIRECTIONS: Insert your cash flow information in the middle column entitled "EXPECTED CASH FLOW" Beginning Cash Balance $0 Cash Inflows (Income): Accts. Rec. Collections Loan Proceeds Sales & Receipts Other: $19 $19 $19 $0 $0 $57 $57 $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 $21 $0 $0 $0 $21 $0 $20 $20 $20 $0 $21 $21 $21 $0 $0 $63 $63 $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 $19 $0 $0 $0 $19
Total Cash Inflows Available Cash Balance Cash Outflows (Expenses): Advertising Bank Service Charges Contingencies Credit Card Fees Delivery Charges Deposits Dues & Subscriptions Health Insurance Insurance Interest Inventory Purchases Lease Payments Licenses & Permits Miscellaneous Office Payroll Payroll Taxes Professional Fees Rent or Lease Repairs & Maintenance Sales tax Services Signs Supplies Taxes & Licenses Utilities & Telephone Other:
$60 $60
$20
Subtotal Other Cash Out Flows: Capital Purchases Building Construction Decorating Fixtures & Equipment Install Fixtures & Equip. Remodeling Lease Payments Loan Principal Owner's Draw Other: Subtotal Total Cash Outflows Ending Cash Balance
$20
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21 $36
$0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $19 $44
$0 $20 $40
Page 1