cfsensit - CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS...

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 DocumentRight 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

This note was uploaded on 06/28/2010 for the course MKTG 00HP01 taught by Professor Himanshu during the Spring '10 term at Indiana Institute of Technology.

Page1 / 2

cfsensit - CASH FLOW BUDGET WORKSHEET SENSITIVITY ANALYSIS...

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

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