Discover Productions

Start your own business plan »

ASP B2B Technology Business Plan

Appendix

Personnel Plan
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
All departments 0% $36,231 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 12 12 12 12 12 12 12 12 12 12 12 12
Total Payroll $36,231 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232
Sales Forecast
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales
Hosting Services 0% $13,953 $13,953 $16,279 $19,767 $23,255 $23,255 $23,255 $23,255 $23,255 $23,255 $23,255 $23,255
Internet Sales 0% $18,140 $18,140 $21,163 $25,698 $30,233 $30,233 $30,233 $30,233 $30,233 $30,233 $30,233 $30,233
Computing Solutions 0% $27,907 $27,907 $32,558 $39,535 $46,512 $46,512 $46,512 $46,512 $46,512 $46,512 $46,512 $46,512
Total Sales $60,000 $60,000 $70,000 $85,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Hosting Services $1,298 $1,298 $1,514 $1,839 $2,163 $2,163 $2,163 $2,163 $2,163 $2,163 $2,163 $2,163
Internet Sales $1,687 $1,687 $1,969 $2,390 $2,813 $2,813 $2,813 $2,813 $2,813 $2,813 $2,813 $2,812
Computing Solutions $2,595 $2,595 $3,028 $3,677 $4,327 $4,327 $4,327 $4,327 $4,327 $4,327 $4,327 $4,327
Subtotal Direct Cost of Sales $5,580 $5,580 $6,511 $7,906 $9,303 $9,303 $9,303 $9,303 $9,303 $9,303 $9,303 $9,302
General Assumptions
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
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% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00% 25.00%
Other 0 0 0 0 0 0 0 0 0 0 0 0
Pro Forma Cash Flow
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Cash Received
Cash from Operations
Cash Sales $15,000 $15,000 $17,500 $21,250 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Cash from Receivables $20,000 $21,500 $45,000 $45,250 $52,875 $64,125 $75,000 $75,000 $75,000 $75,000 $75,000 $75,000
Subtotal Cash from Operations $35,000 $36,500 $62,500 $66,500 $77,875 $89,125 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
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 $914,900 $0 $0 $0 $0 $0 $0 $0 $3,000,000 $0 $0 $0
Subtotal Cash Received $949,900 $36,500 $62,500 $66,500 $77,875 $89,125 $100,000 $100,000 $3,100,000 $100,000 $100,000 $100,000
Expenditures Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Expenditures from Operations
Cash Spending $36,231 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232
Bill Payments $32,126 $63,773 $63,771 $63,750 $65,140 $66,491 $66,491 $66,491 $66,491 $66,491 $66,491 $66,491
Subtotal Spent on Operations $68,357 $100,005 $100,003 $99,982 $101,372 $102,723 $102,723 $102,723 $102,723 $102,723 $102,723 $102,723
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 $646 $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 $22,000 $30,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $90,357 $130,005 $200,003 $200,628 $201,372 $202,723 $202,723 $202,723 $202,723 $202,723 $202,723 $202,723
Net Cash Flow $859,543 ($93,505) ($137,503) ($134,128) ($123,497) ($113,598) ($102,723) ($102,723) $2,897,277 ($102,723) ($102,723) ($102,723)
Cash Balance $889,543 $796,038 $658,535 $524,407 $400,910 $287,312 $184,589 $81,866 $2,979,144 $2,876,421 $2,773,698 $2,670,975
Pro Forma Profit and Loss
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Sales $60,000 $60,000 $70,000 $85,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Direct Cost of Sales $5,580 $5,580 $6,511 $7,906 $9,303 $9,303 $9,303 $9,303 $9,303 $9,303 $9,303 $9,302
Other $4,000 $4,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Total Cost of Sales $9,580 $9,580 $9,511 $10,906 $12,303 $12,303 $12,303 $12,303 $12,303 $12,303 $12,303 $12,302
Gross Margin $50,420 $50,420 $60,489 $74,094 $87,697 $87,697 $87,697 $87,697 $87,697 $87,697 $87,697 $87,698
Gross Margin % 84.03% 84.03% 86.41% 87.17% 87.70% 87.70% 87.70% 87.70% 87.70% 87.70% 87.70% 87.70%
Expenses
Payroll $36,231 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232 $36,232
Sales and Marketing and Other Expenses $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300 $40,300
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
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Rent $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Utilities $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Continuing Education $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Payroll Taxes 15% $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435 $5,435
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $92,966 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967 $92,967
Profit Before Interest and Taxes ($42,546) ($42,547) ($32,478) ($18,873) ($5,270) ($5,270) ($5,270) ($5,270) ($5,270) ($5,270) ($5,270) ($5,269)
EBITDA ($39,546) ($39,547) ($29,478) ($15,873) ($2,270) ($2,270) ($2,270) ($2,270) ($2,270) ($2,270) ($2,270) ($2,269)
Interest Expense $458 $458 $458 $453 $453 $453 $453 $453 $453 $453 $453 $453
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($43,004) ($43,005) ($32,936) ($19,326) ($5,723) ($5,723) ($5,723) ($5,723) ($5,723) ($5,723) ($5,723) ($5,722)
Net Profit/Sales -71.67% -71.68% -47.05% -22.74% -5.72% -5.72% -5.72% -5.72% -5.72% -5.72% -5.72% -5.72%
Pro Forma Balance Sheet
Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Assets Starting Balances
Current Assets
Cash $30,000 $889,543 $796,038 $658,535 $524,407 $400,910 $287,312 $184,589 $81,866 $2,979,144 $2,876,421 $2,773,698 $2,670,975
Accounts Receivable $40,000 $65,000 $88,500 $96,000 $114,500 $136,625 $147,500 $147,500 $147,500 $147,500 $147,500 $147,500 $147,500
Other Current Assets $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Total Current Assets $75,000 $959,543 $889,538 $759,535 $643,907 $542,535 $439,812 $337,089 $234,366 $3,131,644 $3,028,921 $2,926,198 $2,823,475
Long-term Assets
Long-term Assets $100,000 $122,000 $152,000 $252,000 $352,000 $452,000 $552,000 $652,000 $752,000 $852,000 $952,000 $1,052,000 $1,152,000
Accumulated Depreciation $20,000 $23,000 $26,000 $29,000 $32,000 $35,000 $38,000 $41,000 $44,000 $47,000 $50,000 $53,000 $56,000
Total Long-term Assets $80,000 $99,000 $126,000 $223,000 $320,000 $417,000 $514,000 $611,000 $708,000 $805,000 $902,000 $999,000 $1,096,000
Total Assets $155,000 $1,058,543 $1,015,538 $982,535 $963,907 $959,535 $953,812 $948,089 $942,366 $3,936,644 $3,930,921 $3,925,198 $3,919,475
Liabilities and Capital Apr May Jun Jul Aug Sep Oct Nov Dec Jan Feb Mar
Current Liabilities
Accounts Payable $30,000 $61,647 $61,647 $61,581 $62,924 $64,274 $64,274 $64,274 $64,274 $64,274 $64,274 $64,274 $64,273
Current Borrowing $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $35,000 $66,647 $66,647 $66,581 $67,924 $69,274 $69,274 $69,274 $69,274 $69,274 $69,274 $69,274 $69,273
Long-term Liabilities $50,000 $50,000 $50,000 $50,000 $49,354 $49,354 $49,354 $49,354 $49,354 $49,354 $49,354 $49,354 $49,354
Total Liabilities $85,000 $116,647 $116,647 $116,581 $117,278 $118,628 $118,628 $118,628 $118,628 $118,628 $118,628 $118,628 $118,627
Paid-in Capital $25,000 $939,900 $939,900 $939,900 $939,900 $939,900 $939,900 $939,900 $939,900 $3,939,900 $3,939,900 $3,939,900 $3,939,900
Retained Earnings $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000 $45,000
Earnings $0 ($43,004) ($86,009) ($118,945) ($138,271) ($143,994) ($149,717) ($155,439) ($161,162) ($166,885) ($172,608) ($178,330) ($184,052)
Total Capital $70,000 $941,896 $898,891 $865,955 $846,629 $840,906 $835,184 $829,461 $823,738 $3,818,015 $3,812,293 $3,806,570 $3,800,848
Total Liabilities and Capital $155,000 $1,058,543 $1,015,538 $982,535 $963,907 $959,535 $953,812 $948,089 $942,366 $3,936,644 $3,930,921 $3,925,198 $3,919,475
Net Worth $70,000 $941,896 $898,891 $865,955 $846,629 $840,906 $835,183 $829,461 $823,738 $3,818,015 $3,812,293 $3,806,570 $3,800,848