Staryoo.com

Start your own business plan »

Investment Website 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
VPN Brokerage Access Fees 0% $0 $0 $0 $0 $0 $2,500 $7,500 $15,000 $25,000 $37,500 $52,500 $67,500
Pager Alerts 0% $0 $0 $0 $0 $0 $133 $400 $800 $1,333 $2,000 $2,800 $3,600
Advertisement Fees 0% $0 $0 $0 $0 $0 $667 $2,000 $4,000 $6,667 $10,000 $14,000 $18,000
E-Commerce 0% $0 $0 $0 $0 $0 $556 $1,667 $3,333 $5,556 $8,333 $11,667 $15,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $0 $0 $0 $0 $3,856 $11,567 $23,133 $38,556 $57,833 $80,967 $104,100
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
VPN Brokerage Access Fees 10% $0 $0 $0 $0 $0 $250 $750 $1,500 $2,500 $3,750 $5,250 $6,750
Pager Alerts 10% $0 $0 $0 $0 $0 $13 $40 $80 $133 $200 $280 $360
Advertisement Fees 10% $0 $0 $0 $0 $0 $67 $200 $400 $667 $1,000 $1,400 $1,800
E-Commerce 10% $0 $0 $0 $0 $0 $56 $167 $333 $556 $833 $1,167 $1,500
Other 10% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $386 $1,157 $2,313 $3,856 $5,783 $8,097 $10,410
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
CEO - USA 0% $6,250 $6,250 $6,250 $6,250 $6,250 $7,700 $8,000 $8,500 $9,000 $9,500 $10,000 $10,000
COO - USA 0% $0 $6,250 $6,250 $6,250 $6,250 $7,700 $8,000 $8,500 $9,000 $9,500 $10,000 $10,000
Vice-Manager Mktg & Adv. - China 0% $0 $0 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
CTO - China 0% $1,000 $1,000 $1,000 $1,000 $1,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
CFO - China 0% $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500 $3,500
Engineering Staff - USA 0% $0 $0 $0 $0 $0 $0 $0 $0 $11,000 $11,000 $11,000 $11,000
Engineering Staff - China 0% $2,500 $3,500 $4,500 $4,500 $6,000 $6,000 $7,500 $7,500 $7,500 $7,500 $9,000 $9,000
Sales & Advertising Staff - USA 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales & Advertising Staff - China 0% $0 $0 $0 $0 $1,600 $1,200 $1,600 $1,600 $1,600 $2,000 $2,000 $2,400
Customer Service Staff - USA 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Customer Service Staff - China 0% $0 $0 $0 $0 $0 $800 $800 $1,200 $1,200 $1,600 $1,600 $2,000
Accounting Staff 0% $0 $0 $0 $400 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200 $1,200
Miscellaneous Staff - USA 0% $0 $0 $0 $0 $0 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
Miscellaneous Staff - China 0% $0 $0 $0 $700 $1,400 $2,100 $2,100 $2,100 $2,100 $2,100 $2,100 $2,100
Total People 8 11 14 14 28 32 36 37 39 41 44 46
Total Payroll $13,250 $20,500 $25,000 $26,100 $30,700 $41,200 $43,700 $45,100 $57,100 $58,900 $61,400 $62,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 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00% 5.00%
Long-term Interest Rate 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00% 7.00%
Tax Rate 30.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.00% 35.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 $3,856 $11,567 $23,133 $38,556 $57,833 $80,967 $104,100
Direct Cost of Sales $0 $0 $0 $0 $0 $386 $1,157 $2,313 $3,856 $5,783 $8,097 $10,410
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $386 $1,157 $2,313 $3,856 $5,783 $8,097 $10,410
Gross Margin $0 $0 $0 $0 $0 $3,470 $10,410 $20,820 $34,700 $52,050 $72,870 $93,690
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00% 90.00%
Expenses
Payroll $13,250 $20,500 $25,000 $26,100 $30,700 $41,200 $43,700 $45,100 $57,100 $58,900 $61,400 $62,200
Sales and Marketing and Other Expenses $0 $0 $0 $10,000 $61,250 $161,250 $161,250 $161,250 $161,250 $161,250 $161,250 $161,250
Depreciation 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Line Charges 5000000% $0 $0 $0 $0 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Utilities 1600000% $0 $0 $0 $0 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Technology 20000000% $0 $0 $0 $0 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Rent 3500000% $0 $0 $0 $3,889 $3,889 $3,889 $3,889 $3,889 $3,889 $3,889 $3,889 $3,889
Payroll Taxes 10% $1,325 $2,050 $2,500 $2,610 $3,070 $4,120 $4,370 $4,510 $5,710 $5,890 $6,140 $6,220
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $14,575 $22,550 $27,500 $42,599 $132,159 $243,709 $246,459 $247,999 $261,199 $263,179 $265,929 $266,809
Profit Before Interest and Taxes ($14,575) ($22,550) ($27,500) ($42,599) ($132,159) ($240,238) ($236,049) ($227,179) ($226,498) ($211,129) ($193,059) ($173,119)
EBITDA ($14,575) ($22,550) ($27,500) ($42,599) ($132,159) ($240,238) ($236,049) ($227,179) ($226,498) ($211,129) ($193,059) ($173,119)
Interest Expense $0 $0 $0 $0 $208 $167 $125 $83 $42 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($14,575) ($22,550) ($27,500) ($42,599) ($132,367) ($240,405) ($236,174) ($227,263) ($226,540) ($211,129) ($193,059) ($173,119)
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% -6234.57% -2041.79% -982.42% -587.56% -365.07% -238.44% -166.30%
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 $3,856 $11,567 $23,133 $38,556 $57,833 $80,967 $104,100
Subtotal Cash from Operations $0 $0 $0 $0 $0 $3,856 $11,567 $23,133 $38,556 $57,833 $80,967 $104,100
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 $50,000 $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 $2,000,000 $0 $0 $2,000,000 $0 $0 $0
Subtotal Cash Received $0 $0 $0 $0 $50,000 $2,003,856 $11,567 $23,133 $2,038,556 $57,833 $80,967 $104,100
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,250 $20,500 $25,000 $26,100 $30,700 $41,200 $43,700 $45,100 $57,100 $58,900 $61,400 $62,200
Bill Payments $44 $1,349 $2,065 $2,967 $19,338 $105,047 $203,094 $204,082 $205,386 $208,065 $210,148 $212,705
Subtotal Spent on Operations $13,294 $21,849 $27,065 $29,067 $50,038 $146,247 $246,794 $249,182 $262,486 $266,965 $271,548 $274,905
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 $10,000 $10,000 $10,000 $10,000 $10,000 $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 $0 $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 $0 $0 $0 $0 $0 $800,000 $0 $0 $500,000 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $13,294 $21,849 $27,065 $29,067 $50,038 $956,247 $256,794 $259,182 $772,486 $276,965 $271,548 $274,905
Net Cash Flow ($13,294) ($21,849) ($27,065) ($29,067) ($38) $1,047,609 ($245,227) ($236,049) $1,266,070 ($219,132) ($190,581) ($170,805)
Cash Balance $86,706 $64,857 $37,792 $8,725 $8,687 $1,056,296 $811,069 $575,020 $1,841,090 $1,621,958 $1,431,378 $1,260,572
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 $100,000 $86,706 $64,857 $37,792 $8,725 $8,687 $1,056,296 $811,069 $575,020 $1,841,090 $1,621,958 $1,431,378 $1,260,572
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $100,000 $86,706 $64,857 $37,792 $8,725 $8,687 $1,056,296 $811,069 $575,020 $1,841,090 $1,621,958 $1,431,378 $1,260,572
Long-term Assets
Long-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $850,000 $850,000 $850,000 $1,350,000 $1,350,000 $1,350,000 $1,350,000
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $50,000 $50,000 $50,000 $50,000 $50,000 $50,000 $850,000 $850,000 $850,000 $1,350,000 $1,350,000 $1,350,000 $1,350,000
Total Assets $150,000 $136,706 $114,857 $87,792 $58,725 $58,687 $1,906,296 $1,661,069 $1,425,020 $3,191,090 $2,971,958 $2,781,378 $2,610,572
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 $1,281 $1,982 $2,417 $15,949 $98,278 $196,292 $197,239 $198,452 $201,063 $203,060 $205,538 $207,852
Current Borrowing $0 $0 $0 $0 $0 $50,000 $40,000 $30,000 $20,000 $10,000 $0 $0 $0
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $0 $1,281 $1,982 $2,417 $15,949 $148,278 $236,292 $227,239 $218,452 $211,063 $203,060 $205,538 $207,852
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,281 $1,982 $2,417 $15,949 $148,278 $236,292 $227,239 $218,452 $211,063 $203,060 $205,538 $207,852
Paid-in Capital $435,000 $435,000 $435,000 $435,000 $435,000 $435,000 $2,435,000 $2,435,000 $2,435,000 $4,435,000 $4,435,000 $4,435,000 $4,435,000
Retained Earnings ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000) ($285,000)
Earnings $0 ($14,575) ($37,125) ($64,625) ($107,224) ($239,591) ($479,996) ($716,170) ($943,432) ($1,169,973) ($1,381,102) ($1,574,160) ($1,747,279)
Total Capital $150,000 $135,425 $112,875 $85,375 $42,776 ($89,591) $1,670,004 $1,433,830 $1,206,568 $2,980,027 $2,768,898 $2,575,840 $2,402,721
Total Liabilities and Capital $150,000 $136,706 $114,857 $87,792 $58,725 $58,687 $1,906,296 $1,661,069 $1,425,020 $3,191,090 $2,971,958 $2,781,378 $2,610,572
Net Worth $150,000 $135,425 $112,875 $85,375 $42,776 ($89,591) $1,670,004 $1,433,830 $1,206,568 $2,980,027 $2,768,898 $2,575,840 $2,402,721