MBA570 - Team Assignment - Cash Flow Sensitivity Analysis - 07-29-06

MBA570 - Team Assignment - Cash Flow Sensitivity Analysis - 07-29-06

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

View Full Document Right Arrow Icon
Exercising More than Just Your Body Cash Flow Sensitivity Analysis For the year ended 12/31/2006 % change in receipts and disbursements 3.5% Expected Pessimistic Optimistic Beginning Cash Balance $200,000 $200,000 $200,000 Cash Inflows (Income): Accounts Receivable Collections Loan Proceeds 300,000 289,500 310,500 Other: Total Cash Inflows $300,000 $289,500 $310,500 Available Cash Balance $500,000 $489,500 $510,500 Cash Outflows (Expenses): Advertising $6,000 $5,790 $6,210 Bank Service Charges 240 232 248 Contingencies Credit Card Fees 2,500 2,413 2,588 Delivery Charges 120 116 124 Deposits 200 193 207 Health Insurance 12,000 11,580 12,420 Insurance 3,000 2,895 3,105 Interest Inventory Purchases 8,400 8,106 8,694 Lease Payments 1,200 1,158 1,242 750 724 776 Miscellaneous Office 1,500 1,448 1,553 Payroll 144,000 138,960 149,040 Payroll Taxes 11,520 11,117 11,923 Professional Fees 5,000 4,825 5,175 Rent or Lease
Background image of page 1

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

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 2

MBA570 - Team Assignment - Cash Flow Sensitivity Analysis - 07-29-06

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