{[ promptMessage ]}

Bookmark it

{[ promptMessage ]}

cfsensit - CASH FLOW BUDGET WORKSHEET SENSITIVITY...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full Document Right Arrow Icon
This is the end of the preview. Sign up to access the rest of the document.

Unformatted text preview: CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS (ASSUMES 5% CHANGE IN RECEIPTS AND DISBURSEMENTS) Pessimistic Cash Flow Expected Cash Flow Optimistic Cash Flow $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 D IRECTIONS: Insert your cash flow information in the middle column entitled "EXPECTED CASH FLOW" Beginning Cash Balance $0 $0 C ash Inflows (Income): Accts. Rec. Collections $19 $20 Loan Proceeds $19 $20 Sales & Receipts $19 $20 Other: $0 $0 T otal Cash Inflows $57 $60 Available Cash Balance $57 $60 C ash Outflows (Expenses): Advertising $0 Bank Service Charges $0 C ontingencies $0 C redit Card Fees $0 D elivery Charges $0 D eposits $0 D ues & Subscriptions $0 H ealth Insurance $0 I nsurance $0 I nterest $0 I nventory Purchases $0 Lease Payments $0 Licenses & Permits $0 M iscellaneous $0 Office $0 Payroll $0 Payroll Taxes $0 Professional Fees $0 R ent or Lease $0 R epairs & Maintenance $0 Sales tax $0 Services $0 Signs $0 Supplies $0 T axes & Licenses $0 U tilities & Telephone $21 $20 Other: $0 $0 $0 Subtotal $21 $20 CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS (ASSUMES 5% CHANGE IN RECEIPTS AND DISBURSEMENTS) Pessimistic Cash Flow Other Cash Out Flows: Capital Purchases Building Construction D ecorating F ixtures & Equipment I nstall Fixtures & Equip. R emodeling Lease Payments Loan Principal Owner's Draw Other: Subtotal T otal Cash Outflows Ending Cash Balance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $21 $36 Expected Cash Flow Optimistic Cash Flow $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $19 $44 $0 $20 $40 ...
View Full Document

{[ snackBarMessage ]}

Page1 / 2

cfsensit - CASH FLOW BUDGET WORKSHEET SENSITIVITY...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon bookmark
Ask a homework question - tutors are online