| TFC's Cash Budget, July - December, 2013 (Dollars in Thousands) |
| | | | | | | TFC |
| Payment Terms For Body Builders: | | | | | | Current Terms |
| Percentage of Body Builders who pay in 1st month | | | | | | 50% |
| Percentage of Body Builders who pay in 2nd month | | | | | | 45% |
| Percentage of Body Builders who don't pay in 1st or 2nd month. | | | | | | 5% |
| Bad debt Percentage (not collected) - reduces 3rd month payments received | | | | | | 1% |
| TFC's Cash Budget, July - December, 2013 (Dollars in Thousands) |
| Projected Cash Transactions: | | | | | May | June | July | August | Sept | Oct | Nov | Dec |
| Sales Forecast: | | | | | $55,000 | $55,000 | $55,000 | $55,000 | $50,000 | $50,000 | $60,000 | $60,000 |
| Cash Collections on sales: |
| During Current month: | 0.5 | (Sales) | | | | | $27,500.0 | $27,500.0 | $25,000.0 | $25,000.0 | $30,000.0 | $30,000.0 |
| During 2nd month: | 0.45 | (prior month's sales) | | | | | $24,750.0 | $24,750.0 | $24,750.0 | $22,500.0 | $22,500.0 | $27,000.0 |
| Due in 3rd month: | 0.1 | (sales 2 months ago) | | | | | $2,750.0 | $2,750.0 | $2,750.0 | $2,750.0 | $2,500.0 | $2,500.0 |
| Less bad debts (BD% × Sales 2 months ago) | | | | | | | −$550.0 | −$550.0 | −$550.0 | −$550.0 | −$500.0 | −$500.0 |
| Total Cash Collections: | | | | | | | $54,450.0 | $54,450.0 | $51,950.0 | $49,700.0 | $54,500.0 | $59,000.0 |
| Cash Payments: |
| Operating Expenses | | | | | | | $45,000.0 | $45,000.0 | $45,000.0 | $45,000.0 | $45,000.0 | $45,000.0 |
| Other payments (interest on LT bonds, dividends, etc.) | | | | | | | $0.0 | $0.0 | $0.0 | $0.0 | $0.0 | $25,000.0 |
| Taxes | | | | | | | | | $6,900.0 | | | $6,900.0 |
| Payment for expansion project and loans | | | | | | | | | | $8,000.0 | $8,000.0 | $8,000.0 |
| Total Cash Payments: | | | | | | | $45,000.0 | $45,000.0 | $51,900.0 | $53,000.0 | $53,000.0 | $84,900.0 |
| Net cash flows: |
| Assuming zero cash to begin forecasted period | | | | | | | $0.0 |
| Net cash flow: Total Cash Collections – Total Cash Payments | | | | | | | $9,450.0 | $9,450.0 | $50.0 | −$3,300.0 | $1,500.0 | −$25,900.0 |
| Cumulative Cash Balance | | | | | | | $9,450.0 | $18,900.0 | $18,950.0 | $15,650.0 | $17,150.0 | −$8,750.0 |
| Cash surplus/shortage: |
| Target cash balance per month | | | | | | | $10,000.0 | $10,000.0 | $10,000.0 | $10,000.0 | $10,000.0 | $10,000.0 |
| Cash Surplus or Shortage per month: | | | | | | | −$550.0 | $8,900.0 | $8,950.0 | $5,650.0 | $7,150.0 | −$18,750.0 |
lapiercz3
trevose_fitness__center_cash_budget.xlsx
