Austin Kinetic

Start your own business plan »

Outsourced Computer Support 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
Project related 0% $2,400 $4,800 $9,600 $19,200 $24,000 $26,400 $31,200 $33,600 $36,000 $38,400 $40,800 $43,200
Service contract 0% $0 $0 $0 $0 $0 $3,000 $3,000 $4,000 $4,000 $5,000 $5,000 $6,000
Total Sales $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
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
Technician Salary $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 Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
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
Profit Sharing - 5% net profits 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Adam Authortisement (CEO) 0% $100 $200 $400 $800 $1,000 $1,250 $1,450 $1,600 $1,700 $1,850 $1,950 $2,100
Edgar Extension (COO) 0% $100 $200 $400 $800 $1,000 $1,250 $1,450 $1,600 $1,700 $1,850 $1,950 $2,100
Cary Curry (CIO) 0% $100 $200 $400 $800 $1,000 $1,250 $1,450 $1,600 $1,700 $1,850 $1,950 $2,100
Dean Dri (CFO) 0% $100 $200 $400 $800 $1,000 $1,250 $1,450 $1,600 $1,700 $1,850 $1,950 $2,100
Bob Borgware (CTO) 0% $100 $200 $400 $800 $1,000 $1,250 $1,450 $1,600 $1,700 $1,850 $1,950 $2,100
Secretary 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales/Marketing 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-1 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-2 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-3 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-4 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-5 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-6 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-7 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-8 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Technician-9 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 5 5 5 5 5 5 5 5 5 5 5 5
Total Payroll $500 $1,000 $2,000 $4,000 $5,000 $6,250 $7,250 $8,000 $8,500 $9,250 $9,750 $10,500
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 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 $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Gross Margin $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
Gross Margin % 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00% 100.00%
Expenses
Payroll $500 $1,000 $2,000 $4,000 $5,000 $6,250 $7,250 $8,000 $8,500 $9,250 $9,750 $10,500
Marketing/Promotion 5% $200 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Moving Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,000
Utilities $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225 $225
Insurance $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250 $250
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Expensed Computer Equipment 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,000 $0 $0
Charity (5% of previous year net profit) 5% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $1,175 $1,475 $2,475 $4,475 $5,475 $6,725 $7,725 $8,475 $8,975 $14,725 $10,225 $15,975
Profit Before Interest and Taxes $1,225 $3,325 $7,125 $14,725 $18,525 $22,675 $26,475 $29,125 $31,025 $28,675 $35,575 $33,225
EBITDA $1,225 $3,325 $7,125 $14,725 $18,525 $22,675 $26,475 $29,125 $31,025 $28,675 $35,575 $33,225
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $368 $998 $2,138 $4,418 $5,558 $6,803 $7,943 $8,738 $9,308 $8,603 $10,673 $9,968
Net Profit $858 $2,328 $4,988 $10,308 $12,968 $15,873 $18,533 $20,388 $21,718 $20,073 $24,903 $23,258
Net Profit/Sales 35.73% 48.49% 51.95% 53.68% 54.03% 53.99% 54.19% 54.22% 54.29% 46.25% 54.37% 47.27%
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 $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
Subtotal Cash from Operations $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
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 $2,400 $4,800 $9,600 $19,200 $24,000 $29,400 $34,200 $37,600 $40,000 $43,400 $45,800 $49,200
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 $500 $1,000 $2,000 $4,000 $5,000 $6,250 $7,250 $8,000 $8,500 $9,250 $9,750 $10,500
Bill Payments $35 $1,057 $1,511 $2,689 $4,931 $6,074 $7,316 $8,444 $9,232 $9,926 $13,980 $11,291
Subtotal Spent on Operations $535 $2,057 $3,511 $6,689 $9,931 $12,324 $14,566 $16,444 $17,732 $19,176 $23,730 $21,791
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 $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 $0 $0 $0 $0 $0 $0 $0
Dividends $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Spent $535 $2,057 $3,511 $6,689 $9,931 $12,324 $14,566 $16,444 $17,732 $19,176 $23,730 $21,791
Net Cash Flow $1,865 $2,743 $6,090 $12,512 $14,070 $17,076 $19,635 $21,156 $22,269 $24,224 $22,070 $27,409
Cash Balance $6,415 $9,158 $15,248 $27,759 $41,829 $58,905 $78,539 $99,695 $121,964 $146,188 $168,258 $195,668
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 $4,550 $6,415 $9,158 $15,248 $27,759 $41,829 $58,905 $78,539 $99,695 $121,964 $146,188 $168,258 $195,668
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $4,550 $6,415 $9,158 $15,248 $27,759 $41,829 $58,905 $78,539 $99,695 $121,964 $146,188 $168,258 $195,668
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $4,550 $6,415 $9,158 $15,248 $27,759 $41,829 $58,905 $78,539 $99,695 $121,964 $146,188 $168,258 $195,668
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,008 $1,423 $2,525 $4,729 $5,831 $7,035 $8,137 $8,905 $9,456 $13,608 $10,776 $14,928
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 $1,008 $1,423 $2,525 $4,729 $5,831 $7,035 $8,137 $8,905 $9,456 $13,608 $10,776 $14,928
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $1,008 $1,423 $2,525 $4,729 $5,831 $7,035 $8,137 $8,905 $9,456 $13,608 $10,776 $14,928
Paid-in Capital $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100 $12,100
Retained Earnings ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550) ($7,550)
Earnings $0 $858 $3,185 $8,173 $18,480 $31,448 $47,320 $65,853 $86,240 $107,958 $128,030 $152,933 $176,190
Total Capital $4,550 $5,408 $7,735 $12,723 $23,030 $35,998 $51,870 $70,403 $90,790 $112,508 $132,580 $157,483 $180,740
Total Liabilities and Capital $4,550 $6,415 $9,158 $15,248 $27,759 $41,829 $58,905 $78,539 $99,695 $121,964 $146,188 $168,258 $195,668
Net Worth $4,550 $5,408 $7,735 $12,723 $23,030 $35,998 $51,870 $70,403 $90,790 $112,508 $132,580 $157,483 $180,740