Business Finance - Accounting I have a Finance assignment that I need completed tomorrow 24 July 2025.
Scorpio87
Sum2025Assignt2Checkfigures.xlsxSheet1
| Check Figures | ||||||
| Schedules | ||||||
| Schedule B | July | August | September | Cell E15 | Cell E16 | |
| Total collections | $2,306,092 | $2,598,660 | $2,889,982 | $929,200 | $483,000 | |
| Schedule D | ||||||
| COGS | $1,693,812 | $1,912,236 | $2,160,524 | |||
| Total purchases | $1,822,548 | $2,058,420 | $2,233,400 | |||
| Schedule E | ||||||
| Total Payments | $1,790,611 | $1,928,690 | $2,137,161 | |||
| Projected Income statements | ||||||
| Net Income before Taxes | $126,606 | $161,652 | $202,747 | |||
| Projected Balance Seet | September | |||||
| Cash & Equivalents | $30,000 | |||||
| Accounts Receivable | $2,778,354 | |||||
| Inventory | $1,360,656 | |||||
| Fixed Assets, net of depreciation | $1,522,000 | |||||
| Total Assets | $5,697,510 | |||||
| Accounts Payable | $1,228,370 | |||||
| Projected SCF | July | August | September | |||
| Cash excess (deficit) | -$204,217 | -$81,723 | -$132,062 |
