Advanced Technology Pallets
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 | ||
Sales | |||||||||||||
RST-PAL pallets | $18.50/$22.50 (5th yr) | $646,464 | $1,292,928 | $1,864,800 | $1,939,392 | $1,864,800 | $1,864,800 | $1,939,392 | $1,939,392 | $1,939,392 | $1,939,392 | $1,864,800 | $1,939,392 |
Subsidies | $30/ton | $26,208 | $52,416 | $75,600 | $78,624 | $75,600 | $75,600 | $78,624 | $78,624 | $78,624 | $78,624 | $78,624 | $75,600 |
Total Sales | $672,672 | $1,345,344 | $1,940,400 | $2,018,016 | $1,940,400 | $1,940,400 | $2,018,016 | $2,018,016 | $2,018,016 | $2,018,016 | $1,943,424 | $2,014,992 | |
Direct Cost of Sales | Month 1 | Month 2 | Month 3 | Month 4 | Month 5 | Month 6 | Month 7 | Month 8 | Month 9 | Month 10 | Month 11 | Month 12 | |
Recycled Rubber | 125% | $43,680 | $87,360 | $126,025 | $131,040 | $126,000 | $126,000 | $131,040 | $131,040 | $131,040 | $131,040 | $126,000 | $131,040 |
Recycled Plastic | 90% | $31,450 | $62,899 | $90,738 | $94,349 | $90,720 | $90,720 | $94,349 | $94,349 | $94,349 | $94,349 | $90,720 | $94,349 |
Binders System | 650% | $227,136 | $454,272 | $655,330 | $681,408 | $655,200 | $655,200 | $681,408 | $681,408 | $681,408 | $681,408 | $655,200 | $681,408 |
Subtotal Direct Cost of Sales | $302,266 | $604,531 | $872,093 | $906,797 | $871,920 | $871,920 | $906,797 | $906,797 | $906,797 | $906,797 | $871,920 | $906,797 |
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 | |||||||||||||
Texas plant manager | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Texas office worker | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Receptionist (x2) | $6.50/hr | $1,040 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 | $2,080 |
Data entry (x1) | $6.50/hr | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 | $1,040 |
Foreman (x3) | $2,200/mo | $2,200 | $4,400 | $6,600 | $6,600 | $6,600 | $6,600 | $6,800 | $7,000 | $7,200 | $7,200 | $7,200 | $7,200 |
Line operator (x6) | $8.25/hr | $3,432 | $6,864 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 | $10,296 |
Loader (x6) | $7.25/hr | $3,016 | $6,032 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 |
Batcher (x6) | $7.50/hr | $3,120 | $6,240 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 | $9,360 |
Conveyer worker (x12) | $6.50/hr | $5,408 | $10,816 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 | $16,224 |
Assembly lead (x4) | $7.25/hr | $3,016 | $3,016 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 | $6,032 |
Assembly helper (x4) | $6.50/hr | $2,704 | $2,704 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 | $5,408 |
Cutter (x12) | $7.25/hr | $12,064 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 | $18,096 |
Forklift operator (x6) | $7.25/hr | $6,032 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 | $9,048 |
Maint. Supervisor | $7.50/hr | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 | $1,560 |
Maint. helper (x3) | $6.50/hr | $1,352 | $2,704 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 | $4,056 |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $51,184 | $79,800 | $104,048 | $104,048 | $104,048 | $104,048 | $104,248 | $104,448 | $104,648 | $104,648 | $104,648 | $104,648 | |
Sales and Marketing Personnel | |||||||||||||
Marketing Director | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | $4,500 | |
Marketing Secretary | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | |
Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,700 | $6,700 | $6,700 | $6,700 | $6,700 | $6,700 | |
General and Administrative Personnel | |||||||||||||
President – Dan Radke | $6,000 | $6,000 | $6,500 | $6,500 | $7,500 | $7,500 | $8,000 | $8,000 | $8,500 | $8,500 | $8,500 | $8,500 | |
Vice Pres. – Elie Banenson | $6,000 | $6,000 | $6,000 | $6,000 | $7,000 | $7,000 | $7,500 | $7,500 | $8,000 | $8,000 | $8,000 | $8,000 | |
Office Manager | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | $3,300 | |
Receptionist (x2) | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $1,500 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Office workers (x2) | $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 | $16,500 | $16,500 | $17,000 | $17,000 | $19,000 | $19,000 | $21,800 | $21,800 | $22,800 | $22,800 | $22,800 | $22,800 | |
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 | |
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 | 33 | 56 | 74 | 74 | 74 | 74 | 75 | 75 | 75 | 75 | 75 | 75 | |
Total Payroll | $73,684 | $102,300 | $127,048 | $127,048 | $129,048 | $129,048 | $132,748 | $132,948 | $134,148 | $134,148 | $134,148 | $134,148 |
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 | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Long-term Interest Rate | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | 0.00% | |
Tax Rate | 30.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.00% | 34.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 | $672,672 | $1,345,344 | $1,940,400 | $2,018,016 | $1,940,400 | $1,940,400 | $2,018,016 | $2,018,016 | $2,018,016 | $2,018,016 | $1,943,424 | $2,014,992 | |
Direct Cost of Sales | $302,266 | $604,531 | $872,093 | $906,797 | $871,920 | $871,920 | $906,797 | $906,797 | $906,797 | $906,797 | $871,920 | $906,797 | |
Production Payroll | $51,184 | $79,800 | $104,048 | $104,048 | $104,048 | $104,048 | $104,248 | $104,448 | $104,648 | $104,648 | $104,648 | $104,648 | |
Other Costs of Goods | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Cost of Sales | $353,450 | $684,331 | $976,141 | $1,010,845 | $975,968 | $975,968 | $1,011,045 | $1,011,245 | $1,011,445 | $1,011,445 | $976,568 | $1,011,445 | |
Gross Margin | $319,222 | $661,013 | $964,259 | $1,007,171 | $964,432 | $964,432 | $1,006,971 | $1,006,771 | $1,006,571 | $1,006,571 | $966,856 | $1,003,547 | |
Gross Margin % | 47.46% | 49.13% | 49.69% | 49.91% | 49.70% | 49.70% | 49.90% | 49.89% | 49.88% | 49.88% | 49.75% | 49.80% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,000 | $6,700 | $6,700 | $6,700 | $6,700 | $6,700 | $6,700 | |
Advertising/Promotion | $3,500 | $3,500 | $4,500 | $4,500 | $5,000 | $5,000 | $6,000 | $6,000 | $7,500 | $7,500 | $10,000 | $10,000 | |
Royalties | $0 | $0 | $0 | $0 | $0 | $0 | $96,970 | $96,970 | $96,970 | $96,970 | $93,240 | $96,970 | |
Other Sales and Marketing Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $9,500 | $9,500 | $10,500 | $10,500 | $11,000 | $11,000 | $109,670 | $109,670 | $111,170 | $111,170 | $109,940 | $113,670 | |
Sales and Marketing % | 1.41% | 0.71% | 0.54% | 0.52% | 0.57% | 0.57% | 5.43% | 5.43% | 5.51% | 5.51% | 5.66% | 5.64% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $16,500 | $16,500 | $17,000 | $17,000 | $19,000 | $19,000 | $21,800 | $21,800 | $22,800 | $22,800 | $22,800 | $22,800 | |
Sales and Marketing and Other Expenses | $6,000 | $6,000 | $7,000 | $7,000 | $7,500 | $7,500 | $105,470 | $105,470 | $106,970 | $106,970 | $105,740 | $109,470 | |
Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Rent | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | $5,000 | |
Office Expenses | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Accounting | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Legal | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Travel | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Insurance (property & casualty) | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | $1,000 | |
Payroll Taxes & Benefits Payroll Burden | 23% | $27,675 | $27,675 | $28,290 | $28,290 | $30,750 | $30,750 | $35,055 | $35,055 | $36,285 | $36,285 | $36,285 | $36,285 |
Other General and Administrative Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $64,675 | $64,675 | $66,790 | $66,790 | $71,750 | $71,750 | $176,825 | $176,825 | $180,555 | $180,555 | $179,325 | $183,055 | |
General and Administrative % | 9.61% | 4.81% | 3.44% | 3.31% | 3.70% | 3.70% | 8.76% | 8.76% | 8.95% | 8.95% | 9.23% | 9.08% | |
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 | |
Machine Maintenance | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Miscellaneous Expenses | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | $10,000 | |
Total Other Expenses | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | $12,500 | |
Other % | 1.86% | 0.93% | 0.64% | 0.62% | 0.64% | 0.64% | 0.62% | 0.62% | 0.62% | 0.62% | 0.64% | 0.62% | |
Total Operating Expenses | $86,675 | $86,675 | $89,790 | $89,790 | $95,250 | $95,250 | $298,995 | $298,995 | $304,225 | $304,225 | $301,765 | $309,225 | |
Profit Before Interest and Taxes | $232,547 | $574,338 | $874,469 | $917,381 | $869,182 | $869,182 | $707,976 | $707,776 | $702,346 | $702,346 | $665,091 | $694,322 | |
EBITDA | $232,547 | $574,338 | $874,469 | $917,381 | $869,182 | $869,182 | $707,976 | $707,776 | $702,346 | $702,346 | $665,091 | $694,322 | |
Interest Expense | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Taxes Incurred | $69,764 | $195,275 | $297,319 | $311,910 | $295,522 | $295,522 | $240,712 | $240,644 | $238,798 | $238,798 | $226,131 | $236,069 | |
Net Profit | $162,783 | $379,063 | $577,150 | $605,471 | $573,660 | $573,660 | $467,264 | $467,132 | $463,548 | $463,548 | $438,960 | $458,253 | |
Net Profit/Sales | 24.20% | 28.18% | 29.74% | 30.00% | 29.56% | 29.56% | 23.15% | 23.15% | 22.97% | 22.97% | 22.59% | 22.74% |
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 | $672,672 | $1,345,344 | $1,940,400 | $2,018,016 | $1,940,400 | $1,940,400 | $2,018,016 | $2,018,016 | $2,018,016 | $2,018,016 | $1,943,424 | $2,014,992 | |
Cash from Receivables | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Subtotal Cash from Operations | $672,672 | $1,345,344 | $1,940,400 | $2,018,016 | $1,940,400 | $1,940,400 | $2,018,016 | $2,018,016 | $2,018,016 | $2,018,016 | $1,943,424 | $2,014,992 | |
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 | $0 | $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 | $0 | $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 | $672,672 | $1,345,344 | $1,940,400 | $2,018,016 | $1,940,400 | $1,940,400 | $2,018,016 | $2,018,016 | $2,018,016 | $2,018,016 | $1,943,424 | $2,014,992 | |
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 | $73,684 | $102,300 | $127,048 | $127,048 | $129,048 | $129,048 | $132,748 | $132,948 | $134,148 | $134,148 | $134,148 | $134,148 | |
Bill Payments | $25,623 | $782,957 | $1,207,607 | $1,523,626 | $1,319,526 | $1,200,606 | $1,244,981 | $1,455,087 | $1,418,015 | $1,420,320 | $1,417,374 | $1,336,251 | |
Subtotal Spent on Operations | $99,307 | $885,257 | $1,334,655 | $1,650,674 | $1,448,574 | $1,329,654 | $1,377,729 | $1,588,035 | $1,552,163 | $1,554,468 | $1,551,522 | $1,470,399 | |
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 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Other Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Long-term Liabilities Principal Repayment | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Purchase Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $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 | $99,307 | $885,257 | $1,334,655 | $1,650,674 | $1,448,574 | $1,329,654 | $1,377,729 | $1,588,035 | $1,552,163 | $1,554,468 | $1,551,522 | $1,470,399 | |
Net Cash Flow | $573,365 | $460,087 | $605,745 | $367,342 | $491,826 | $610,746 | $640,287 | $429,981 | $465,853 | $463,548 | $391,902 | $544,593 | |
Cash Balance | $1,327,265 | $1,787,352 | $2,393,097 | $2,760,439 | $3,252,265 | $3,863,011 | $4,503,298 | $4,933,278 | $5,399,131 | $5,862,679 | $6,254,581 | $6,799,174 |
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 | $753,900 | $1,327,265 | $1,787,352 | $2,393,097 | $2,760,439 | $3,252,265 | $3,863,011 | $4,503,298 | $4,933,278 | $5,399,131 | $5,862,679 | $6,254,581 | $6,799,174 |
Accounts Receivable | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Inventory | $0 | $332,493 | $664,984 | $959,302 | $997,477 | $959,112 | $959,112 | $997,477 | $997,477 | $997,477 | $997,477 | $959,112 | $997,477 |
Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Current Assets | $753,900 | $1,659,757 | $2,452,336 | $3,352,399 | $3,757,916 | $4,211,377 | $4,822,123 | $5,500,774 | $5,930,755 | $6,396,608 | $6,860,156 | $7,213,693 | $7,796,650 |
Long-term Assets | |||||||||||||
Long-term Assets | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 |
Accumulated Depreciation | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Long-term Assets | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 | $4,033,200 |
Total Assets | $4,787,100 | $5,692,957 | $6,485,536 | $7,385,599 | $7,791,116 | $8,244,577 | $8,855,323 | $9,533,974 | $9,963,955 | $10,429,808 | $10,893,356 | $11,246,893 | $11,829,850 |
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 | $0 | $743,074 | $1,156,590 | $1,479,503 | $1,279,549 | $1,159,350 | $1,196,435 | $1,407,823 | $1,370,671 | $1,372,976 | $1,372,976 | $1,287,553 | $1,412,258 |
Current Borrowing | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Subtotal Current Liabilities | $0 | $743,074 | $1,156,590 | $1,479,503 | $1,279,549 | $1,159,350 | $1,196,435 | $1,407,823 | $1,370,671 | $1,372,976 | $1,372,976 | $1,287,553 | $1,412,258 |
Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
Total Liabilities | $0 | $743,074 | $1,156,590 | $1,479,503 | $1,279,549 | $1,159,350 | $1,196,435 | $1,407,823 | $1,370,671 | $1,372,976 | $1,372,976 | $1,287,553 | $1,412,258 |
Paid-in Capital | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 | $6,000,000 |
Retained Earnings | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) | ($1,212,900) |
Earnings | $0 | $162,783 | $541,846 | $1,118,996 | $1,724,467 | $2,298,127 | $2,871,787 | $3,339,051 | $3,806,184 | $4,269,732 | $4,733,280 | $5,172,240 | $5,630,493 |
Total Capital | $4,787,100 | $4,949,883 | $5,328,946 | $5,906,096 | $6,511,567 | $7,085,227 | $7,658,887 | $8,126,151 | $8,593,284 | $9,056,832 | $9,520,380 | $9,959,340 | $10,417,593 |
Total Liabilities and Capital | $4,787,100 | $5,692,957 | $6,485,536 | $7,385,599 | $7,791,116 | $8,244,577 | $8,855,323 | $9,533,974 | $9,963,955 | $10,429,808 | $10,893,356 | $11,246,893 | $11,829,850 |
Net Worth | $4,787,100 | $4,949,883 | $5,328,946 | $5,906,096 | $6,511,567 | $7,085,227 | $7,658,887 | $8,126,151 | $8,593,284 | $9,056,832 | $9,520,380 | $9,959,340 | $10,417,593 |