H2O Industries

Start your own business plan »

Water Purification Business Plan

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