JTB Technologies

Start your own business plan »

Holding Company 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
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