Need this project completed
Sheet1
| Key Check Figures | ||||
| Schedules | ||||
| Schedule B | July | August | September | Sched E15 |
| Total collections | $2,274,993 | $2,572,479 | $2,858,704 | $929,200 |
| Schedule D | ||||
| COGS | $1,692,384 | $1,909,842 | $2,156,968 | |
| Schedule E | ||||
| Total Payments | $2,076,010 | $1,985,264 | $2,177,350 | |
| Projected Income statements | ||||
| Net Income before Taxes | $125,877 | $161,323 | $203,086 | |
| Projected Balance Seet | September | |||
| Accounts Receivable | $3,079,662 | |||
| Inventory | $1,587,432 | |||
| Fixed Assets, net of depreciation | $1,522,000 | |||
| Total Assets | $6,230,594 | |||
| Accounts Payable | $896,796 | |||
| Projected SCF | July | August | September | |
| Cash excess (deficit) | -$527,715 | -$166,635 | -$206,252 |