JTB Integrated Technologies

Start your own business plan »

Database Software 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
Interactive media site revenues 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,100 $1,600 $2,800
Custom Applications Revenue 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Existing Applications Revenue 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $774 $1,100 $1,850
Support Services Revenue 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $570 $910 $1,400
Distributed Resale Products 0% $0 $0 $0 $0 $0 $600 $600 $1,200 $1,800 $2,000 $2,200 $2,500
Distributor Partner Revenues 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Affitiate Revenue 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $200
Total Sales $0 $0 $0 $0 $0 $600 $600 $1,200 $1,800 $4,444 $5,810 $8,750
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
Interactive media site 20% $0 $0 $0 $0 $0 $0 $0 $0 $0 $220 $320 $560
Custom Applications 10% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Existing Applications 10% $0 $0 $0 $0 $0 $0 $0 $0 $0 $77 $110 $185
Support Services 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Distributed Resale Products 64% $0 $0 $0 $0 $0 $384 $384 $768 $1,152 $1,280 $1,408 $1,600
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $384 $384 $768 $1,152 $1,577 $1,838 $2,345
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
Developers Personnel
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 Developer/QA Tester $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
Subtotal $7,000 $7,000 $7,000 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200
Sales and Marketing Personnel
Customer Support Associate/ 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
(shared)Sales and Marketing Associate $0 $0 $0 $0 $0 $0 $0 $0 $0 $250 $250 $1,200
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,050 $4,050 $5,000
General and Administrative Personnel
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
Other Personnel
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 3 3 3 3 3 3 3 3 3 6 6 6
Total Payroll $7,000 $7,000 $7,000 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $12,250 $12,250 $13,200
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 $0 $0 $0 $0 $0 $600 $600 $1,200 $1,800 $4,444 $5,810 $8,750
Direct Cost of Sales $0 $0 $0 $0 $0 $384 $384 $768 $1,152 $1,577 $1,838 $2,345
Developers Payroll $7,000 $7,000 $7,000 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200
Contracted Graphics Dvlpmnt for Software $0 $0 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Total Cost of Sales $7,000 $7,000 $7,450 $8,650 $8,650 $9,034 $9,034 $9,418 $9,802 $10,227 $10,488 $10,995
Gross Margin ($7,000) ($7,000) ($7,450) ($8,650) ($8,650) ($8,434) ($8,434) ($8,218) ($8,002) ($5,783) ($4,678) ($2,245)
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% -1405.67% -1405.67% -684.83% -444.56% -130.14% -80.52% -25.66%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $4,050 $4,050 $5,000
Advertising/Promotion $450 $450 $450 $500 $500 $500 $500 $500 $500 $500 $500 $500
Other Sales and Marketing Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $450 $450 $450 $500 $500 $500 $500 $500 $500 $4,550 $4,550 $5,500
Sales and Marketing % 0.00% 0.00% 0.00% 0.00% 0.00% 83.33% 83.33% 41.67% 27.78% 102.39% 78.31% 62.86%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $500 $500 $500 $500 $500 $500
Depreciation $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83
Rent $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750 $750
Utilities $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Insurance $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
CPA: Accounting and Payroll $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
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 $1,513 $1,513 $1,513 $1,513 $1,513 $3,513 $2,013 $2,013 $2,013 $2,013 $2,013 $2,013
General and Administrative % 0.00% 0.00% 0.00% 0.00% 0.00% 585.50% 335.50% 167.75% 111.83% 45.30% 34.65% 23.01%
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 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 $1,963 $1,963 $1,963 $2,013 $2,013 $4,013 $2,513 $2,513 $2,513 $6,563 $6,563 $7,513
Profit Before Interest and Taxes ($8,963) ($8,963) ($9,413) ($10,663) ($10,663) ($12,447) ($10,947) ($10,731) ($10,515) ($12,346) ($11,241) ($9,758)
EBITDA ($8,880) ($8,880) ($9,330) ($10,580) ($10,580) ($12,364) ($10,864) ($10,648) ($10,432) ($12,263) ($11,158) ($9,675)
Interest Expense $225 $223 $222 $220 $218 $217 $215 $214 $212 $211 $209 $207
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($9,188) ($9,186) ($9,635) ($10,883) ($10,881) ($12,664) ($11,162) ($10,945) ($10,727) ($12,557) ($11,450) ($9,965)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% -2110.64% -1860.38% -912.06% -595.95% -282.56% -197.07% -113.89%
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 $300 $300 $600 $900 $2,222 $2,905 $4,375
Cash from Receivables $0 $0 $0 $0 $0 $0 $160 $300 $460 $760 $1,605 $2,586
Subtotal Cash from Operations $0 $0 $0 $0 $0 $300 $460 $900 $1,360 $2,982 $4,510 $6,961
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 $0 $0 $0 $0 $0 $300 $460 $900 $1,360 $2,982 $4,510 $6,961
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 $7,000 $7,000 $7,000 $8,200 $8,200 $8,200 $8,200 $8,200 $8,200 $12,250 $12,250 $13,200
Bill Payments $0 $1,824 $2,103 $2,492 $2,594 $2,599 $4,330 $3,512 $4,041 $4,564 $5,031 $5,175
Subtotal Spent on Operations $7,000 $8,824 $9,103 $10,692 $10,794 $10,799 $12,530 $11,712 $12,241 $16,814 $17,281 $18,375
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 $189 $189 $189 $189 $189 $189 $189 $189 $189 $189 $189 $189
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 $7,189 $9,013 $9,292 $10,880 $10,982 $10,987 $12,719 $11,901 $12,429 $17,003 $17,470 $18,564
Net Cash Flow ($7,189) ($9,013) ($9,292) ($10,880) ($10,982) ($10,687) ($12,259) ($11,001) ($11,069) ($14,021) ($12,960) ($11,602)
Cash Balance $202,812 $193,799 $184,507 $173,627 $162,645 $151,958 $139,699 $128,698 $117,629 $103,609 $90,649 $79,047
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 $210,000 $202,812 $193,799 $184,507 $173,627 $162,645 $151,958 $139,699 $128,698 $117,629 $103,609 $90,649 $79,047
Accounts Receivable $0 $0 $0 $0 $0 $0 $300 $440 $740 $1,180 $2,642 $3,942 $5,731
Inventory $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $616 $482 $768 $1,152 $1,577 $1,838 $2,345
Other Current Assets $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500 $6,500
Total Current Assets $217,500 $210,312 $201,299 $192,007 $181,127 $170,145 $159,374 $147,121 $136,706 $126,461 $114,328 $102,929 $93,622
Long-term Assets
Long-term Assets $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Accumulated Depreciation $0 $83 $166 $249 $332 $415 $498 $581 $664 $747 $830 $913 $996
Total Long-term Assets $15,000 $14,917 $14,834 $14,751 $14,668 $14,585 $14,502 $14,419 $14,336 $14,253 $14,170 $14,087 $14,004
Total Assets $232,500 $225,229 $216,133 $206,758 $195,795 $184,730 $173,876 $161,540 $151,042 $140,714 $128,498 $117,016 $107,626
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 $2,105 $2,384 $2,832 $2,940 $2,945 $4,943 $3,958 $4,594 $5,181 $5,710 $5,867 $6,631
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 $2,105 $2,384 $2,832 $2,940 $2,945 $4,943 $3,958 $4,594 $5,181 $5,710 $5,867 $6,631
Long-term Liabilities $27,150 $26,962 $26,773 $26,585 $26,396 $26,208 $26,019 $25,831 $25,642 $25,454 $25,265 $25,077 $24,888
Total Liabilities $27,150 $29,066 $29,157 $29,416 $29,336 $29,153 $30,962 $29,789 $30,236 $30,635 $30,975 $30,943 $31,519
Paid-in Capital $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000 $225,000
Retained Earnings ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650) ($19,650)
Earnings $0 ($9,188) ($18,374) ($28,008) ($38,891) ($49,773) ($62,437) ($73,599) ($84,543) ($95,271) ($107,828) ($119,277) ($129,243)
Total Capital $205,350 $196,162 $186,976 $177,342 $166,459 $155,577 $142,913 $131,751 $120,807 $110,079 $97,522 $86,073 $76,107
Total Liabilities and Capital $232,500 $225,229 $216,133 $206,758 $195,795 $184,730 $173,876 $161,540 $151,042 $140,714 $128,498 $117,016 $107,626
Net Worth $205,350 $196,162 $186,976 $177,342 $166,459 $155,577 $142,913 $131,751 $120,807 $110,079 $97,522 $86,073 $76,107
Long-term
Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7 Year 8 Year 9 Year 10
Sales $23,204 $199,948 $268,330 $331,797 $443,411 $546,335 $570,335 $602,279 $650,462 $679,732
Cost of Sales $107,748 $115,095 $134,519 $145,351 $169,827 $209,246 $218,438 $230,673 $249,127 $260,337
Gross Margin ($84,544) $84,853 $133,811 $186,446 $273,584 $337,089 $351,897 $371,606 $401,335 $419,395
Gross Margin % -364.35% 42.44% 49.87% 56.19% 61.70% 61.70% 61.70% 61.70% 61.70% 61.70%
Operating Expenses $42,106 $85,200 $101,000 $104,000 $111,000 $139,320 $143,499 $147,087 $150,028 $154,529
Operating Income ($126,650) ($347) $32,811 $82,446 $162,584 $197,769 $208,398 $224,519 $251,307 $264,866
Net Income ($129,243) ($2,721) $21,467 $56,372 $112,630 $153,965 $160,286 $204,048 $233,290 $250,059
Current Assets $93,622 $91,069 $164,976 $202,426 $239,136 $263,049 $289,354 $318,290 $350,119 $385,131
Long-term Assets $14,004 $13,004 $12,004 $11,004 $10,004 $18,004 $15,004 $12,004 $9,004 $6,004
Current Liabilities $6,631 $8,099 $11,838 $14,216 $19,596 $31,120 $33,659 $23,859 $25,851 $27,537
Long-term Liabilities $24,888 $22,588 $20,288 $17,988 $15,688 $13,388 $11,088 $8,788 $6,488 $4,188
Equity $76,107 $73,387 $144,854 $181,226 $213,856 $236,545 $259,611 $297,647 $326,784 $359,410