Aero Technologies

Start your own business plan »

Integrated Communications 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
All Services 0% $40,000 $40,000 $40,000 $55,000 $55,000 $70,000 $70,000 $80,000 $85,000 $95,000 $95,000 $95,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $40,000 $40,000 $40,000 $55,000 $55,000 $70,000 $70,000 $80,000 $85,000 $95,000 $95,000 $95,000
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
All Services $20,000 $20,000 $20,000 $27,500 $27,500 $35,000 $35,000 $40,000 $42,500 $47,500 $47,500 $47,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $20,000 $20,000 $20,000 $27,500 $27,500 $35,000 $35,000 $40,000 $42,500 $47,500 $47,500 $47,500
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
Directors 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Multimedia 0% $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Data Communications 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Call Center 0% $2,700 $2,700 $2,700 $2,700 $2,700 $2,700 $5,400 $5,400 $5,400 $5,400 $5,400 $5,400
Conference secr. 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 23 23 23 23 23 23 23 23 23 23 23 23
Total Payroll $29,700 $29,700 $29,700 $29,700 $29,700 $29,700 $49,400 $49,400 $49,400 $49,400 $49,400 $49,400
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% 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 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 $40,000 $40,000 $40,000 $55,000 $55,000 $70,000 $70,000 $80,000 $85,000 $95,000 $95,000 $95,000
Direct Cost of Sales $20,000 $20,000 $20,000 $27,500 $27,500 $35,000 $35,000 $40,000 $42,500 $47,500 $47,500 $47,500
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $20,000 $20,000 $20,000 $27,500 $27,500 $35,000 $35,000 $40,000 $42,500 $47,500 $47,500 $47,500
Gross Margin $20,000 $20,000 $20,000 $27,500 $27,500 $35,000 $35,000 $40,000 $42,500 $47,500 $47,500 $47,500
Gross Margin % 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00% 50.00%
Expenses
Payroll $29,700 $29,700 $29,700 $29,700 $29,700 $29,700 $49,400 $49,400 $49,400 $49,400 $49,400 $49,400
Sales and Marketing and Other Expenses $11,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550 $2,550
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Insurance $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Payroll Taxes 0% $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
Total Operating Expenses $45,050 $36,050 $36,050 $36,050 $36,050 $36,050 $55,750 $55,750 $55,750 $55,750 $55,750 $55,750
Profit Before Interest and Taxes ($25,050) ($16,050) ($16,050) ($8,550) ($8,550) ($1,050) ($20,750) ($15,750) ($13,250) ($8,250) ($8,250) ($8,250)
EBITDA ($25,050) ($16,050) ($16,050) ($8,550) ($8,550) ($1,050) ($20,750) ($15,750) ($13,250) ($8,250) ($8,250) ($8,250)
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($25,050) ($16,050) ($16,050) ($8,550) ($8,550) ($1,050) ($20,750) ($15,750) ($13,250) ($8,250) ($8,250) ($8,250)
Net Profit/Sales -62.63% -40.13% -40.13% -15.55% -15.55% -1.50% -29.64% -19.69% -15.59% -8.68% -8.68% -8.68%
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 $10,000 $10,000 $10,000 $13,750 $13,750 $17,500 $17,500 $20,000 $21,250 $23,750 $23,750 $23,750
Cash from Receivables $0 $1,000 $30,000 $30,000 $30,375 $41,250 $41,625 $52,500 $52,750 $60,125 $64,000 $71,250
Subtotal Cash from Operations $10,000 $11,000 $40,000 $43,750 $44,125 $58,750 $59,125 $72,500 $74,000 $83,875 $87,750 $95,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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $10,000 $11,000 $40,000 $43,750 $44,125 $58,750 $59,125 $72,500 $74,000 $83,875 $87,750 $95,000
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 $29,700 $29,700 $29,700 $29,700 $29,700 $29,700 $49,400 $49,400 $49,400 $49,400 $49,400 $49,400
Bill Payments $1,912 $56,317 $26,350 $26,875 $41,825 $34,375 $49,325 $41,700 $51,842 $51,858 $59,167 $53,850
Subtotal Spent on Operations $31,612 $86,017 $56,050 $56,575 $71,525 $64,075 $98,725 $91,100 $101,242 $101,258 $108,567 $103,250
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 $31,612 $86,017 $56,050 $56,575 $71,525 $64,075 $98,725 $91,100 $101,242 $101,258 $108,567 $103,250
Net Cash Flow ($21,612) ($75,017) ($16,050) ($12,825) ($27,400) ($5,325) ($39,600) ($18,600) ($27,242) ($17,383) ($20,817) ($8,250)
Cash Balance $328,388 $253,372 $237,322 $224,497 $197,097 $191,772 $152,172 $133,572 $106,330 $88,947 $68,130 $59,880
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 $350,000 $328,388 $253,372 $237,322 $224,497 $197,097 $191,772 $152,172 $133,572 $106,330 $88,947 $68,130 $59,880
Accounts Receivable $0 $30,000 $59,000 $59,000 $70,250 $81,125 $92,375 $103,250 $110,750 $121,750 $132,875 $140,125 $140,125
Inventory $0 $22,000 $22,000 $22,000 $30,250 $30,250 $38,500 $38,500 $44,000 $46,750 $52,250 $52,250 $52,250
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $350,000 $380,388 $334,372 $318,322 $324,997 $308,472 $322,647 $293,922 $288,322 $274,830 $274,072 $260,505 $252,255
Long-term Assets
Long-term Assets $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400 $1,012,400
Total Assets $1,362,400 $1,392,788 $1,346,772 $1,330,722 $1,337,397 $1,320,872 $1,335,047 $1,306,322 $1,300,722 $1,287,230 $1,286,472 $1,272,905 $1,264,655
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 $55,438 $25,472 $25,472 $40,697 $32,722 $47,947 $39,972 $50,122 $49,880 $57,372 $52,055 $52,055
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 $55,438 $25,472 $25,472 $40,697 $32,722 $47,947 $39,972 $50,122 $49,880 $57,372 $52,055 $52,055
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $55,438 $25,472 $25,472 $40,697 $32,722 $47,947 $39,972 $50,122 $49,880 $57,372 $52,055 $52,055
Paid-in Capital $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400 $2,554,400
Retained Earnings ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000) ($1,192,000)
Earnings $0 ($25,050) ($41,100) ($57,150) ($65,700) ($74,250) ($75,300) ($96,050) ($111,800) ($125,050) ($133,300) ($141,550) ($149,800)
Total Capital $1,362,400 $1,337,350 $1,321,300 $1,305,250 $1,296,700 $1,288,150 $1,287,100 $1,266,350 $1,250,600 $1,237,350 $1,229,100 $1,220,850 $1,212,600
Total Liabilities and Capital $1,362,400 $1,392,788 $1,346,772 $1,330,722 $1,337,397 $1,320,872 $1,335,047 $1,306,322 $1,300,722 $1,287,230 $1,286,472 $1,272,905 $1,264,655
Net Worth $1,362,400 $1,337,350 $1,321,300 $1,305,250 $1,296,700 $1,288,150 $1,287,100 $1,266,350 $1,250,600 $1,237,350 $1,229,100 $1,220,850 $1,212,600