Our biggest savings of the year
JTB Technologies
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 | |||||||||||||
Industrial Sales Division | 0% | $2,100 | $3,740 | $5,600 | $10,255 | $12,895 | $15,375 | $19,375 | $22,725 | $24,975 | $27,545 | $29,865 | $32,075 |
Products and Services Div | 0% | $1,000 | $1,915 | $6,220 | $12,270 | $18,500 | $26,920 | $34,300 | $39,320 | $45,400 | $51,520 | $55,520 | $61,820 |
Integrated Technologies Div | 0% | $0 | $0 | $0 | $0 | $0 | $600 | $600 | $1,200 | $1,800 | $4,444 | $5,810 | $8,750 |
Total Sales | $3,100 | $5,655 | $11,820 | $22,525 | $31,395 | $42,895 | $54,275 | $63,245 | $72,175 | $83,509 | $91,195 | $102,645 | |
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 | |
Industrial Sales Division | $1,295 | $2,314 | $3,500 | $6,389 | $8,023 | $9,546 | $12,046 | $14,121 | $15,501 | $17,098 | $18,525 | $19,901 | |
Products and Services Div | $490 | $1,050 | $3,340 | $6,066 | $9,587 | $14,537 | $18,654 | $21,262 | $24,573 | $29,723 | $32,721 | $37,048 | |
Integrated Technologies Div | $0 | $0 | $0 | $0 | $0 | $384 | $384 | $768 | $1,152 | $1,577 | $1,838 | $2,345 | |
Subtotal Direct Cost of Sales | $1,785 | $3,364 | $6,840 | $12,455 | $17,610 | $24,467 | $31,084 | $36,151 | $41,226 | $48,398 | $53,084 | $59,294 |
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 | |||||||||||||
Shipping and Receiving | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
Application Developer | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | $4,000 | |
Part-time App Dev/QA | $0 | $0 | $0 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | $1,200 | |
Web Developer | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | $3,000 | |
Service Team Manager | $0 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | $3,200 | |
Service Team Member | $0 | $0 | $0 | $0 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | $1,100 | |
Subtotal | $7,800 | $11,000 | $11,000 | $12,200 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | |
Sales and Marketing Personnel | |||||||||||||
Sales Team Leader | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | |
Sales Associate | $0 | $0 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | $900 | |
Customer Support Manager | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $2,600 | $2,600 | $2,600 | |
Customer Support Associate | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $1,200 | $1,200 | $1,200 | |
Sales and Marketing Assoc (shared) | $0 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $250 | $500 | $500 | $1,450 | |
Subtotal | $2,500 | $2,750 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $7,700 | $7,700 | $8,650 | |
General and Administrative Personnel | |||||||||||||
Vice President, Production Manager and Secretary | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | $3,600 | |
President/Sales Manager | $0 | $1,200 | $1,200 | $1,200 | $1,400 | $1,400 | $1,400 | $1,600 | $1,600 | $1,600 | $1,600 | $1,600 | |
Subtotal | $3,600 | $4,800 | $4,800 | $4,800 | $5,000 | $5,000 | $5,000 | $5,200 | $5,200 | $5,200 | $5,200 | $5,200 | |
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 | |
Subtotal | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total People | 6 | 8 | 9 | 10 | 11 | 11 | 11 | 11 | 11 | 13 | 13 | 13 | |
Total Payroll | $13,900 | $18,550 | $19,450 | $20,650 | $21,950 | $21,950 | $21,950 | $22,150 | $22,150 | $26,200 | $26,200 | $27,150 |
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 | Tax Rate | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $3,100 | $5,655 | $11,820 | $22,525 | $31,395 | $42,895 | $54,275 | $63,245 | $72,175 | $83,509 | $91,195 | $102,645 | |
Direct Cost of Sales | $1,785 | $3,364 | $6,840 | $12,455 | $17,610 | $24,467 | $31,084 | $36,151 | $41,226 | $48,398 | $53,084 | $59,294 | |
Production Payroll | $7,800 | $11,000 | $11,000 | $12,200 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | $13,300 | |
Contracted Graphics Development | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | $375 | |
Total Cost of Sales | $9,960 | $14,739 | $18,215 | $25,030 | $31,285 | $38,142 | $44,759 | $49,826 | $54,901 | $62,073 | $66,759 | $72,969 | |
Gross Margin | ($6,860) | ($9,084) | ($6,395) | ($2,505) | $110 | $4,753 | $9,516 | $13,419 | $17,274 | $21,436 | $24,436 | $29,676 | |
Gross Margin % | -221.29% | -160.64% | -54.10% | -11.12% | 0.35% | 11.08% | 17.53% | 21.22% | 23.93% | 25.67% | 26.80% | 28.91% | |
Operating Expenses | |||||||||||||
Sales and Marketing Expenses | |||||||||||||
Sales and Marketing Payroll | $2,500 | $2,750 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $3,650 | $7,700 | $7,700 | $8,650 | |
Advertising/Promotion | $450 | $1,100 | $1,100 | $1,150 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | |
Other Sales and Marketing Expenses | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
. | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total Sales and Marketing Expenses | $2,950 | $3,850 | $4,750 | $4,800 | $4,900 | $4,900 | $4,900 | $4,900 | $4,900 | $8,950 | $8,950 | $9,900 | |
Sales and Marketing % | 95.16% | 68.08% | 40.19% | 21.31% | 15.61% | 11.42% | 9.03% | 7.75% | 6.79% | 10.72% | 9.81% | 9.64% | |
General and Administrative Expenses | |||||||||||||
General and Administrative Payroll | $3,600 | $4,800 | $4,800 | $4,800 | $5,000 | $5,000 | $5,000 | $5,200 | $5,200 | $5,200 | $5,200 | $5,200 | |
Sales and Marketing and Other Expenses | $450 | $450 | $450 | $450 | $450 | $450 | $950 | $950 | $950 | $950 | $950 | $950 | |
Depreciation | $891 | $891 | $891 | $891 | $891 | $891 | $891 | $891 | $891 | $891 | $891 | $891 | |
Rent (consolidated) | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | $2,200 | |
Utilities (consolidated) | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,150 | $1,250 | $1,250 | $1,250 | $1,250 | $1,250 | |
Equipment lease Ind Prod Div | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | $2,999 | |
Prototype and Printing Equipment | $0 | $0 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | $1,071 | |
Insurance (consolidated) | $950 | $950 | $950 | $950 | $950 | $950 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | $1,050 | |
Payroll Taxes (consolidated) | 15% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
CPA – Accounting and Payroll | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | $350 | |
Off-site secure backup storage | 15% | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 | $30 |
Computer maintenance and software upgrades | $0 | $0 | $0 | $0 | $0 | $2,000 | $0 | $0 | $0 | $0 | $0 | $0 | |
Total General and Administrative Expenses | $12,620 | $13,820 | $14,891 | $14,891 | $15,091 | $17,091 | $15,691 | $15,991 | $15,991 | $15,991 | $15,991 | $15,991 | |
General and Administrative % | 407.11% | 244.39% | 125.98% | 66.11% | 48.07% | 39.84% | 28.91% | 25.28% | 22.16% | 19.15% | 17.54% | 15.58% | |
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 | |
Other Other Expenses | $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 | $15,570 | $17,670 | $19,641 | $19,691 | $19,991 | $21,991 | $20,591 | $20,891 | $20,891 | $24,941 | $24,941 | $25,891 | |
Profit Before Interest and Taxes | ($22,430) | ($26,754) | ($26,036) | ($22,196) | ($19,881) | ($17,238) | ($11,075) | ($7,472) | ($3,617) | ($3,505) | ($505) | $3,785 | |
EBITDA | ($21,539) | ($25,863) | ($25,145) | ($21,305) | ($18,990) | ($16,347) | ($10,184) | ($6,581) | ($2,726) | ($2,614) | $386 | $4,676 | |
Interest Expense | $2,098 | $2,087 | $2,075 | $2,064 | $2,053 | $2,041 | $2,030 | $2,018 | $2,007 | $1,996 | $1,984 | $1,973 | |
Taxes Incurred | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
Net Profit | ($24,529) | ($28,841) | ($28,112) | ($24,260) | ($21,934) | ($19,279) | ($13,105) | ($9,491) | ($5,624) | ($5,501) | ($2,489) | $1,812 | |
Net Profit/Sales | -791.24% | -510.01% | -237.83% | -107.70% | -69.86% | -44.95% | -24.15% | -15.01% | -7.79% | -6.59% | -2.73% | 1.77% |
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 | $775 | $1,414 | $2,955 | $5,631 | $7,849 | $10,724 | $13,569 | $15,811 | $18,044 | $20,877 | $22,799 | $25,661 | |
Cash from Receivables | $0 | $1,240 | $3,347 | $6,707 | $13,147 | $20,442 | $28,146 | $36,723 | $44,294 | $51,006 | $58,665 | $65,706 | |
Subtotal Cash from Operations | $775 | $2,654 | $6,302 | $12,339 | $20,996 | $31,166 | $41,715 | $52,535 | $62,338 | $71,883 | $81,464 | $91,367 | |
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 | $775 | $2,654 | $6,302 | $12,339 | $20,996 | $31,166 | $41,715 | $52,535 | $62,338 | $71,883 | $81,464 | $91,367 | |
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 | $13,900 | $18,550 | $19,450 | $20,650 | $21,950 | $21,950 | $21,950 | $22,150 | $22,150 | $26,200 | $26,200 | $27,150 | |
Bill Payments | $2,143 | $9,885 | $11,657 | $12,609 | $26,776 | $35,195 | $45,447 | $51,159 | $54,808 | $59,664 | $68,545 | $71,489 | |
Subtotal Spent on Operations | $16,043 | $28,435 | $31,107 | $33,259 | $48,726 | $57,145 | $67,397 | $73,309 | $76,958 | $85,864 | $94,745 | $98,639 | |
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 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | $1,369 | |
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 | $17,412 | $29,804 | $32,476 | $34,628 | $50,095 | $58,514 | $68,766 | $74,678 | $78,327 | $87,233 | $96,114 | $100,008 | |
Net Cash Flow | ($16,637) | ($27,150) | ($26,174) | ($22,290) | ($29,099) | ($27,348) | ($27,051) | ($22,143) | ($15,989) | ($15,350) | ($14,651) | ($8,641) | |
Cash Balance | $479,613 | $452,463 | $426,290 | $404,000 | $374,901 | $347,553 | $320,502 | $298,359 | $282,370 | $267,020 | $252,369 | $243,728 |
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 | $496,250 | $479,613 | $452,463 | $426,290 | $404,000 | $374,901 | $347,553 | $320,502 | $298,359 | $282,370 | $267,020 | $252,369 | $243,728 |
Accounts Receivable | $0 | $2,325 | $5,326 | $10,844 | $21,031 | $31,430 | $43,160 | $55,720 | $66,430 | $76,267 | $87,893 | $97,624 | $108,902 |
Inventory | $22,000 | $20,215 | $16,851 | $10,011 | $13,701 | $19,371 | $26,914 | $34,192 | $39,766 | $45,349 | $53,238 | $58,392 | $65,223 |
Other Current Assets | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 | $17,000 |
Total Current Assets | $535,250 | $519,153 | $491,640 | $464,145 | $455,731 | $442,702 | $434,626 | $427,414 | $421,555 | $420,986 | $425,151 | $425,386 | $434,854 |
Long-term Assets | |||||||||||||
Long-term Assets | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 | $79,500 |
Accumulated Depreciation | $0 | $891 | $1,783 | $2,674 | $3,565 | $4,457 | $5,348 | $6,239 | $7,131 | $8,022 | $8,913 | $9,805 | $10,696 |
Total Long-term Assets | $79,500 | $78,609 | $77,717 | $76,826 | $75,935 | $75,043 | $74,152 | $73,261 | $72,369 | $71,478 | $70,587 | $69,695 | $68,804 |
Total Assets | $614,750 | $597,762 | $569,358 | $540,971 | $531,666 | $517,745 | $508,778 | $500,675 | $493,924 | $492,464 | $495,737 | $495,081 | $503,658 |
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 | $2,500 | $11,409 | $13,215 | $14,309 | $30,633 | $40,016 | $51,697 | $58,068 | $62,177 | $67,709 | $77,853 | $81,055 | $89,189 |
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 | $2,500 | $11,409 | $13,215 | $14,309 | $30,633 | $40,016 | $51,697 | $58,068 | $62,177 | $67,709 | $77,853 | $81,055 | $89,189 |
Long-term Liabilities | $253,150 | $251,781 | $250,412 | $249,043 | $247,674 | $246,305 | $244,936 | $243,567 | $242,198 | $240,829 | $239,460 | $238,091 | $236,722 |
Total Liabilities | $255,650 | $263,190 | $263,627 | $263,352 | $278,307 | $286,321 | $296,633 | $301,635 | $304,375 | $308,538 | $317,313 | $319,146 | $325,911 |
Paid-in Capital | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 | $455,000 |
Retained Earnings | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) | ($95,900) |
Earnings | $0 | ($24,529) | ($53,370) | ($81,481) | ($105,742) | ($127,675) | ($146,955) | ($160,060) | ($169,551) | ($175,175) | ($180,676) | ($183,165) | ($181,353) |
Total Capital | $359,100 | $334,571 | $305,730 | $277,619 | $253,358 | $231,425 | $212,145 | $199,040 | $189,549 | $183,925 | $178,424 | $175,935 | $177,747 |
Total Liabilities and Capital | $614,750 | $597,762 | $569,358 | $540,971 | $531,666 | $517,745 | $508,778 | $500,675 | $493,924 | $492,464 | $495,737 | $495,081 | $503,658 |
Net Worth | $359,100 | $334,571 | $305,730 | $277,619 | $253,358 | $231,425 | $212,145 | $199,040 | $189,549 | $183,925 | $178,424 | $175,935 | $177,747 |
Long-term | ||||||||||
Year 1 | Year 2 | Year 3 | Year 4 | Year 5 | Year 6 | Year 7 | Year 8 | Year 9 | Year 10 | |
Sales | $584,434 | $1,008,798 | $1,303,319 | $1,604,704 | $2,020,771 | $2,166,942 | $2,318,189 | $2,411,867 | $2,550,497 | $2,662,957 |
Cost of Sales | $488,658 | $611,854 | $743,119 | $876,910 | $1,078,910 | $1,146,672 | $1,232,935 | $1,283,395 | $1,364,157 | $1,431,032 |
Gross Margin | $95,776 | $396,944 | $560,200 | $727,794 | $941,861 | $1,020,270 | $1,085,254 | $1,128,472 | $1,186,340 | $1,231,925 |
Gross Margin % | 16.39% | 39.35% | 42.98% | 45.35% | 46.61% | 47.08% | 46.81% | 46.79% | 46.51% | 46.26% |
Operating Expenses | $252,704 | $325,940 | $367,040 | $386,440 | $407,640 | $476,693 | $478,899 | $490,721 | $507,339 | $517,599 |
Operating Income | ($156,928) | $71,004 | $193,160 | $341,354 | $534,221 | $543,577 | $606,355 | $637,751 | $679,001 | $714,326 |
Net Income | ($181,353) | $33,709 | $171,958 | $225,259 | $516,312 | $365,827 | $408,077 | $429,206 | $456,968 | $480,741 |
Current Assets | $434,854 | $440,933 | $648,560 | $820,123 | $1,181,701 | $1,348,152 | $1,543,406 | $1,734,009 | $1,949,112 | $2,144,024 |
Long-term Assets | $68,804 | $58,104 | $47,404 | $36,704 | $26,004 | $15,304 | $4,604 | $0 | $0 | $0 |
Current Liabilities | $89,189 | $67,326 | $78,761 | $100,831 | $111,863 | $205,573 | $223,916 | $229,108 | $250,160 | $275,017 |
Long-term Liabilities | $236,722 | $220,256 | $203,790 | $187,324 | $170,858 | $145,230 | $119,602 | $106,460 | $93,744 | $81,028 |
Equity | $177,747 | $211,455 | $413,413 | $568,672 | $924,984 | $1,012,653 | $1,204,492 | $1,398,441 | $1,605,208 | $1,787,979 |