|
|
| | Module 5, Assignment 1 |
| | | Part 1: Collections and Payments |
| | | | JAN | FEB | MARCH | APRIL | MAY | JUNE | JULY | AUG | SEPT |
| | | SALES | 162,000 | 168,000 | 324,000 | 485,000 | 648,000 | 325,000 | 325,000 | 80,000 | 162,000 |
| | | Collections |
| | | Month of Sale | $ 19,440.00 |
| | | Month after Sale | 0 | 97200 |
| | | 2nd Month after Sale | 0 | 0 | 45360 | 47040 | 90720 | 135800 | 181440 | 91000 | 91000 |
| | | Totals | $ 19,440.00 | $ 97,200.00 | $ 45,360.00 | $ 47,040.00 | $ 90,720.00 | $ 135,800.00 | $ 181,440.00 | $ 91,000.00 | $ 91,000.00 |
| | | Purchase of Labor and Materials | $80,000.00 | $80,000.00 | $114,000.00 | $794,000.00 | $275,000.00 | $210,500.00 | $146,000.00 | $80,000.00 | $81,000.00 |
| | | Payments | | $80,000.00 |
| | | Part 2: Net Cash Flow for the Month | | | MARCH | APRIL | MAY | JUNE | JULY | AUG | SEPT |
| | | Total Receipts | | | $ 185,040.00 |
| | | Payments: |
| | | Labor and Materials | | | 80000 | | | 275000 | | | 80000 |
| | | Administrative Salaries | | | | 25000 | | | 25000 |
| | | Lease Payments | | | | | | 8500 |
| | | Income taxes | | | 0 | 0 | | 0 | 0 |
| | | Miscellaneous Expenses | | | | | 3000 |
| | | Boat Dock | | | 0 | 0 | 0 | 0 | 175000 | 0 |
| | | Total Payments | | | $ 80,000.00 | $ 25,000.00 | $ 3,000.00 | $ 283,500.00 | $ 200,000.00 | $ - 0 |
| | | Net Gain (loss) | | | $ 105,040.00 | $ (25,000.00) | $ (3,000.00) | $ (283,500.00) | $ (200,000.00) | $ - 0 |
| | | Part 3: Surplus or Loan Requirements |
| | | Cash at beginning of the month |
| | | Cumulative Cash |
| | | Less: Mimimum Cash Balance | | | 85000 | 85000 | 85000 | 85000 | 85000 | 85000 |
| | | Surplus/Loan Requirements |
cabo1789
module_5_homework_template.xls
