H2O Industries
Appendix
Sales Forecast | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Unit Sales | |||||||||||||
Segregated Anion Service 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Segregated Cation Service 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Segregated Mixed Bed 10 cu ft | 0% | 14 | 19 | 23 | 27 | 31 | 35 | 40 | 44 | 48 | 52 | 56 | 57 |
Bulk Regen 10 cu ft (MB) | 0% | 5 | 11 | 16 | 22 | 26 | 33 | 38 | 43 | 43 | 43 | 43 | 43 |
Bulk Regen 10 cu ft (Cat) | 0% | 3 | 5 | 8 | 11 | 13 | 16 | 19 | 22 | 22 | 22 | 22 | 22 |
Bulk Regen 10 cu ft (An) | 0% | 3 | 5 | 8 | 11 | 13 | 16 | 19 | 22 | 22 | 22 | 22 | 22 |
Tank Rentals (each 3.6 cu ft): | 0% | 37 | 54 | 70 | 86 | 101 | 118 | 135 | 151 | 160 | 168 | 178 | 178 |
Tank Sales: | 0% | 2 | 2 | 3 | 4 | 5 | 5 | 7 | 7 | 8 | 8 | 8 | 8 |
Other | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Total Unit Sales | 92 | 133 | 174 | 214 | 251 | 294 | 336 | 376 | 398 | 419 | 442 | 443 | |
Unit Prices | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Segregated Anion Service 10 cu ft | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | |
Segregated Cation Service 10 cu ft | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | $476.00 | |
Segregated Mixed Bed 10 cu ft | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | $526.00 | |
Bulk Regen 10 cu ft (MB) | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | $359.00 | |
Bulk Regen 10 cu ft (Cat) | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | |
Bulk Regen 10 cu ft (An) | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | $267.50 | |
Tank Rentals (each 3.6 cu ft): | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | $40.00 | |
Tank Sales: | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | $1,200.00 | |
Other | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | |
Sales | |||||||||||||
Segregated Anion Service 10 cu ft | $6,807 | $8,806 | $10,805 | $12,804 | $14,804 | $16,803 | $18,802 | $20,801 | $22,800 | $24,800 | $26,799 | $26,989 | |
Segregated Cation Service 10 cu ft | $6,807 | $8,806 | $10,805 | $12,804 | $14,804 | $16,803 | $18,802 | $20,801 | $22,800 | $24,800 | $26,799 | $26,989 | |
Segregated Mixed Bed 10 cu ft | $7,364 | $9,731 | $11,940 | $14,149 | $16,359 | $18,568 | $20,777 | $22,986 | $25,195 | $27,405 | $29,614 | $29,982 | |
Bulk Regen 10 cu ft (MB) | $1,939 | $3,877 | $5,834 | $7,772 | $9,334 | $11,668 | $13,606 | $15,545 | $15,545 | $15,545 | $15,545 | $15,545 | |
Bulk Regen 10 cu ft (Cat) | $722 | $1,445 | $2,173 | $2,889 | $3,478 | $4,347 | $5,069 | $5,791 | $5,791 | $5,791 | $5,791 | $5,791 | |
Bulk Regen 10 cu ft (An) | $722 | $1,445 | $2,173 | $2,889 | $3,478 | $4,347 | $5,069 | $5,791 | $5,791 | $5,791 | $5,791 | $5,791 | |
Tank Rentals (each 3.6 cu ft): | $1,480 | $2,160 | $2,800 | $3,440 | $4,040 | $4,720 | $5,400 | $6,040 | $6,400 | $6,720 | $7,120 | $7,120 | |
Tank Sales: | $2,400 | $2,400 | $3,600 | $4,800 | $6,000 | $6,000 | $8,400 | $8,400 | $9,600 | $9,600 | $9,600 | $9,600 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales | $28,241 | $38,669 | $50,131 | $61,549 | $72,295 | $83,255 | $95,925 | $106,156 | $113,924 | $120,451 | $127,059 | $127,808 | |
Direct Unit Costs | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Segregated Anion Service 10 cu ft | 0.00% | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 | $107.40 |
Segregated Cation Service 10 cu ft | 0.00% | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 | $87.80 |
Segregated Mixed Bed 10 cu ft | 0.00% | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 | $102.80 |
Bulk Regen 10 cu ft (MB) | 0.00% | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 | $61.40 |
Bulk Regen 10 cu ft (Cat) | 0.00% | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 | $69.50 |
Bulk Regen 10 cu ft (An) | 0.00% | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 | $72.50 |
Tank Rentals (each 3.6 cu ft): | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Tank Sales: | 0.00% | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 | $450.00 |
Other | 0.00% | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 | $0.00 |
Direct Cost of Sales | |||||||||||||
Segregated Anion Service 10 cu ft | $1,536 | $1,987 | $2,438 | $2,889 | $3,340 | $3,791 | $4,242 | $4,693 | $5,144 | $5,596 | $6,047 | $6,090 | |
Segregated Cation Service 10 cu ft | $1,256 | $1,624 | $1,993 | $2,362 | $2,731 | $3,099 | $3,468 | $3,837 | $4,206 | $4,574 | $4,943 | $4,978 | |
Segregated Mixed Bed 10 cu ft | $1,439 | $1,902 | $2,334 | $2,765 | $3,197 | $3,629 | $4,061 | $4,492 | $4,924 | $5,356 | $5,788 | $5,860 | |
Bulk Regen 10 cu ft (MB) | $332 | $663 | $998 | $1,329 | $1,596 | $1,996 | $2,327 | $2,659 | $2,659 | $2,659 | $2,659 | $2,659 | |
Bulk Regen 10 cu ft (Cat) | $188 | $375 | $565 | $751 | $904 | $1,129 | $1,317 | $1,505 | $1,505 | $1,505 | $1,505 | $1,505 | |
Bulk Regen 10 cu ft (An) | $196 | $392 | $589 | $783 | $943 | $1,178 | $1,374 | $1,570 | $1,570 | $1,570 | $1,570 | $1,570 | |
Tank Rentals (each 3.6 cu ft): | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Tank Sales: | $900 | $900 | $1,350 | $1,800 | $2,250 | $2,250 | $3,150 | $3,150 | $3,600 | $3,600 | $3,600 | $3,600 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Direct Cost of Sales | $5,846 | $7,843 | $10,266 | $12,679 | $14,960 | $17,072 | $19,939 | $21,906 | $23,607 | $24,859 | $26,110 | $26,260 |
Personnel Plan | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Production Personnel | |||||||||||||
Production Manager | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | $3,467 | |
Assistant | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | |
Assistant | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | $1,733 | |
Engineer/fitter | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | $2,600 | |
Drivers | $3,467 | $3,466 | $3,467 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | $4,867 | $4,866 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $13,000 | $12,999 | $13,000 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | |
Sales and Marketing Personnel | |||||||||||||
Sales Manager (base) | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Sales Manager (commissions) | $960 | $1,500 | $2,000 | $2,500 | $3,000 | $3,700 | $3,850 | $3,950 | $4,100 | $4,250 | $4,350 | $4,500 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $2,960 | $3,500 | $4,000 | $4,500 | $5,000 | $5,700 | $5,850 | $5,950 | $6,100 | $6,250 | $6,350 | $6,500 | |
General and Administrative Personnel | |||||||||||||
Office Manager | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | |
Bookkeeper (part-time) | $0 | $0 | $0 | $0 | $0 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | $1,300 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | |
Other Personnel | |||||||||||||
Name or Title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Name or title | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total People | 7 | 7 | 7 | 7 | 8 | 9 | 9 | 9 | 9 | 9 | 9 | 9 | |
Total Payroll | $19,293 | $19,832 | $20,333 | $22,232 | $22,733 | $24,732 | $24,883 | $24,982 | $25,133 | $25,282 | $25,383 | $25,532 |
General Assumptions | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
Current Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Long-term Interest Rate | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | 10.00% | |
Tax Rate | 30.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 |
Pro Forma Profit and Loss | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Sales | $28,241 | $38,669 | $50,131 | $61,549 | $72,295 | $83,255 | $95,925 | $106,156 | $113,924 | $120,451 | $127,059 | $127,808 | |
Direct Cost of Sales | $5,846 | $7,843 | $10,266 | $12,679 | $14,960 | $17,072 | $19,939 | $21,906 | $23,607 | $24,859 | $26,110 | $26,260 | |
Production Payroll | $13,000 | $12,999 | $13,000 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | $14,400 | $14,399 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $18,846 | $20,842 | $23,266 | $27,078 | $29,360 | $31,471 | $34,339 | $36,305 | $38,007 | $39,258 | $40,510 | $40,659 | |
Gross Margin | $9,395 | $17,827 | $26,865 | $34,470 | $42,935 | $51,783 | $61,586 | $69,852 | $75,917 | $81,194 | $86,549 | $87,148 | |
Gross Margin % | 33.27% | 46.10% | 53.59% | 56.01% | 59.39% | 62.20% | 64.20% | 65.80% | 66.64% | 67.41% | 68.12% | 68.19% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $2,960 | $3,500 | $4,000 | $4,500 | $5,000 | $5,700 | $5,850 | $5,950 | $6,100 | $6,250 | $6,350 | $6,500 | |
Advertising/Promotion | $1,900 | $1,900 | $1,900 | $1,900 | $1,900 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Travel | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Fuel/oil for Vehicles: | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | $960 | |
Vehicle Repair: | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | $1,667 | |
Uniforms | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | |
Miscellaneous | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Total Sales and Marketing Expenses | $8,787 | $9,327 | $9,827 | $10,327 | $10,827 | $10,627 | $10,777 | $10,877 | $11,027 | $11,177 | $11,277 | $11,427 | |
Sales and Marketing % | 31.11% | 24.12% | 19.60% | 16.78% | 14.98% | 12.76% | 11.23% | 10.25% | 9.68% | 9.28% | 8.88% | 8.94% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $3,333 | $3,333 | $3,333 | $3,333 | $3,333 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | $4,633 | |
Sales and Marketing and Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Depreciation | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Leased Equipment | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | $1,271 | |
Utilities | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $100 | $100 | $100 | $100 | $100 | |
Insurance | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | $983 | |
Business Liab. Insurance: | $0 | $0 | $0 | $0 | $0 | $6,000 | $0 | $0 | $0 | $0 | $0 | $6,000 | |
Printing and Postage: | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | $300 | |
Telephone Expenses: | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | $667 | |
Auditing: | $0 | $0 | $0 | $2,400 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
Payroll Taxes | 13% | $2,441 | $2,509 | $2,572 | $2,812 | $2,876 | $3,129 | $3,148 | $3,160 | $3,179 | $3,198 | $3,211 | $3,230 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $14,245 | $14,313 | $14,376 | $17,016 | $14,680 | $22,233 | $16,252 | $16,114 | $16,133 | $16,152 | $16,165 | $22,184 | |
General and Administrative % | 50.44% | 37.01% | 28.68% | 27.65% | 20.31% | 26.70% | 16.94% | 15.18% | 14.16% | 13.41% | 12.72% | 17.36% | |
Other Expenses: | |||||||||||||
Other Payroll | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Contract/Consultants | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Other Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other % | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Total Operating Expenses | $23,032 | $23,640 | $24,203 | $27,343 | $25,507 | $32,860 | $27,029 | $26,991 | $27,160 | $27,329 | $27,442 | $33,611 | |
Profit Before Interest and Taxes | ($13,636) | ($5,812) | $2,662 | $7,127 | $17,428 | $18,924 | $34,558 | $42,860 | $48,756 | $53,864 | $59,107 | $53,538 | |
EBITDA | ($10,636) | ($2,812) | $5,662 | $10,127 | $20,428 | $21,924 | $37,558 | $45,860 | $51,756 | $56,864 | $62,107 | $56,538 | |
Interest Expense | $1,840 | $1,773 | $1,769 | $1,765 | $1,698 | $1,694 | $1,689 | $1,622 | $1,618 | $1,614 | $1,547 | $1,126 | |
Taxes Incurred | ($4,643) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($10,834) | ($7,586) | $893 | $5,362 | $15,730 | $17,230 | $32,868 | $41,238 | $47,138 | $52,251 | $57,560 | $52,412 | |
Net Profit/Sales | -38.36% | -19.62% | 1.78% | 8.71% | 21.76% | 20.70% | 34.26% | 38.85% | 41.38% | 43.38% | 45.30% | 41.01% |
Pro Forma Cash Flow | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Cash Received | |||||||||||||
Cash from Operations | |||||||||||||
Cash Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Cash from Receivables | $0 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Subtotal Cash from Operations | $0 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Additional Cash Received | |||||||||||||
Sales Tax, VAT, HST/GST Received | 0.00% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
New Current Borrowing | $50,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Other Liabilities (interest-free) | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Other Current Assets | $50,000 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Sales of Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
New Investment Received | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Received | $100,000 | $941 | $28,588 | $39,051 | $50,512 | $61,907 | $72,660 | $83,677 | $96,266 | $106,415 | $114,141 | $120,672 | |
Expenditures | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Expenditures from Operations | |||||||||||||
Cash Spending | $19,293 | $19,832 | $20,333 | $22,232 | $22,733 | $24,732 | $24,883 | $24,982 | $25,133 | $25,282 | $25,383 | $25,532 | |
Bill Payments | $61,849 | $13,625 | $25,719 | $28,739 | $33,600 | $33,584 | $40,540 | $38,353 | $39,147 | $40,550 | $41,335 | $42,644 | |
Subtotal Spent on Operations | $81,142 | $33,457 | $46,052 | $50,971 | $56,333 | $58,316 | $65,423 | $63,335 | $64,280 | $65,832 | $66,718 | $68,176 | |
Additional Cash Spent | |||||||||||||
Sales Tax, VAT, HST/GST Paid Out | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Principal Repayment of Current Borrowing | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $521 | $50,521 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $16,810 | |
Long-term Liabilities Principal Repayment | $30,000 | $7,500 | $0 | $0 | $7,500 | $0 | $0 | $7,500 | $0 | $0 | $7,500 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $5,400 | $8,550 | $9,900 | $9,900 | $9,450 | $5,400 | $4,500 | $10,350 | $0 | |
Purchase Long-term Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Dividends | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash Spent | $111,663 | $41,478 | $46,573 | $56,892 | $72,904 | $68,737 | $75,844 | $80,806 | $70,201 | $70,853 | $85,089 | $135,507 | |
Net Cash Flow | ($11,663) | ($40,537) | ($17,984) | ($17,840) | ($22,392) | ($6,830) | ($3,184) | $2,871 | $26,066 | $35,562 | $29,052 | ($14,836) | |
Cash Balance | $112,560 | $72,023 | $54,039 | $36,198 | $13,806 | $6,977 | $3,793 | $6,664 | $32,730 | $68,292 | $97,344 | $82,508 |
Pro Forma Balance Sheet | |||||||||||||
Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | ||
Assets | Starting Balances | ||||||||||||
Current Assets | |||||||||||||
Cash | $124,223 | $112,560 | $72,023 | $54,039 | $36,198 | $13,806 | $6,977 | $3,793 | $6,664 | $32,730 | $68,292 | $97,344 | $82,508 |
Accounts Receivable | $0 | $28,241 | $65,969 | $87,511 | $110,009 | $131,792 | $153,140 | $176,405 | $198,884 | $216,541 | $230,577 | $243,495 | $250,631 |
Inventory | $10,000 | $6,430 | $8,627 | $11,293 | $13,947 | $16,456 | $18,780 | $21,933 | $24,096 | $25,968 | $27,345 | $28,721 | $28,886 |
Other Current Assets | $90,000 | $40,000 | $40,000 | $40,000 | $45,400 | $53,950 | $63,850 | $73,750 | $83,200 | $88,600 | $93,100 | $103,450 | $103,450 |
Total Current Assets | $224,223 | $187,230 | $186,619 | $192,843 | $205,554 | $216,004 | $242,746 | $275,881 | $312,844 | $363,839 | $419,314 | $473,010 | $465,476 |
Long-term Assets | |||||||||||||
Long-term Assets | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 | $220,000 |
Accumulated Depreciation | $0 | $3,000 | $6,000 | $9,000 | $12,000 | $15,000 | $18,000 | $21,000 | $24,000 | $27,000 | $30,000 | $33,000 | $36,000 |
Total Long-term Assets | $220,000 | $217,000 | $214,000 | $211,000 | $208,000 | $205,000 | $202,000 | $199,000 | $196,000 | $193,000 | $190,000 | $187,000 | $184,000 |
Total Assets | $444,223 | $404,230 | $400,619 | $403,843 | $413,554 | $421,004 | $444,746 | $474,881 | $508,844 | $556,839 | $609,314 | $660,010 | $649,476 |
Liabilities and Capital | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Current Liabilities | |||||||||||||
Accounts Payable | $61,409 | $12,771 | $24,766 | $27,618 | $32,488 | $32,230 | $39,262 | $37,050 | $37,796 | $39,173 | $39,919 | $41,076 | $45,461 |
Current Borrowing | $21,354 | $70,833 | $70,312 | $69,791 | $69,270 | $68,749 | $68,228 | $67,707 | $67,186 | $66,665 | $66,144 | $65,623 | $15,102 |
Other Current Liabilities | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $16,810 | $0 |
Subtotal Current Liabilities | $99,573 | $100,414 | $111,888 | $114,219 | $118,568 | $117,789 | $124,300 | $121,567 | $121,792 | $122,648 | $122,873 | $123,509 | $60,563 |
Long-term Liabilities | $180,000 | $150,000 | $142,500 | $142,500 | $142,500 | $135,000 | $135,000 | $135,000 | $127,500 | $127,500 | $127,500 | $120,000 | $120,000 |
Total Liabilities | $279,573 | $250,414 | $254,388 | $256,719 | $261,068 | $252,789 | $259,300 | $256,567 | $249,292 | $250,148 | $250,373 | $243,509 | $180,563 |
Paid-in Capital | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 | $187,000 |
Retained Earnings | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) | ($22,350) |
Earnings | $0 | ($10,834) | ($18,420) | ($17,527) | ($12,164) | $3,566 | $20,796 | $53,664 | $94,902 | $142,040 | $194,291 | $251,851 | $304,263 |
Total Capital | $164,650 | $153,816 | $146,230 | $147,123 | $152,486 | $168,216 | $185,446 | $218,314 | $259,552 | $306,690 | $358,941 | $416,501 | $468,913 |
Total Liabilities and Capital | $444,223 | $404,230 | $400,619 | $403,843 | $413,554 | $421,004 | $444,746 | $474,881 | $508,844 | $556,839 | $609,314 | $660,010 | $649,476 |
Net Worth | $164,650 | $153,816 | $146,230 | $147,123 | $152,486 | $168,216 | $185,446 | $218,314 | $259,552 | $306,690 | $358,941 | $416,501 | $468,913 |