Stretch 'r Wings

Start your own business plan »

Aircraft Equipment Maker 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
Unit Sales
Medical Units 0% 0 0 0 0 0 0 0 0 0 0 0 1
STC 0% 0 0 0 0 0 0 0 0 0 0 0 1
Parts 0% 0 0 0 0 0 0 0 0 0 0 0 1
Loading Ramps and Additions 0% 0 0 0 0 0 0 0 0 0 0 0 1
Total Unit Sales 0 0 0 0 0 0 0 0 0 0 0 4
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Medical Units $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $26,495.00
STC $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,195.00
Parts $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,000.00
Loading Ramps and Additions $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $1,000.00
Sales
Medical Units $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $26,495
STC $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,195
Parts $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000
Loading Ramps and Additions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $1,000
Total Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,690
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Medical Units 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $5,300.00
STC 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $225.00
Parts 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $750.00
Loading Ramps and Additions 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $200.00
Direct Cost of Sales
Medical Units $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $5,300
STC $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $225
Parts $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $750
Loading Ramps and Additions $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $200
Subtotal Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,475
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
Owner/Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $3,750 $3,750 $3,750 $3,750
Office Personnel 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Production Personnel 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales Manager 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $2,500 $2,500
Total People 0 0 0 0 0 0 0 0 1 1 2 2
Total Payroll $0 $0 $0 $0 $0 $0 $0 $0 $3,750 $3,750 $6,250 $6,250
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 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,690
Direct Cost of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $6,475
Other $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 $6,475
Gross Margin $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $23,215
Gross Margin % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 78.19%
Expenses
Payroll $0 $0 $0 $0 $0 $0 $0 $0 $3,750 $3,750 $6,250 $6,250
Sales and Marketing and Other Expenses $0 $0 $0 $0 $500 $650 $650 $650 $300 $7,200 $5,200 $150
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 $0 $0 $0 $0 $0 $0 $0 $50 $50 $75 $75 $100
Phone $0 $0 $0 $0 $0 $0 $0 $100 $150 $200 $250 $250
Rent $0 $0 $0 $0 $0 $0 $0 $525 $525 $525 $525 $525
Payroll Taxes 15% $0 $0 $0 $0 $0 $0 $0 $0 $563 $563 $938 $938
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $0 $0 $0 $0 $500 $650 $650 $1,325 $5,338 $12,313 $13,238 $8,213
Profit Before Interest and Taxes $0 $0 $0 $0 ($500) ($650) ($650) ($1,325) ($5,338) ($12,313) ($13,238) $15,003
EBITDA $0 $0 $0 $0 ($500) ($650) ($650) ($1,325) ($5,338) ($12,313) ($13,238) $15,003
Interest Expense $164 $161 $158 $156 $153 $150 $147 $144 $142 $139 $136 $133
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($164) ($161) ($158) ($156) ($653) ($800) ($797) ($1,469) ($5,479) ($12,451) ($13,374) $14,869
Net Profit/Sales 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 50.08%
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 $0 $0 $0 $0 $0 $0 $29,690
Subtotal Cash from Operations $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $29,690
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 $0 $0 $0 $0 $0 $0 $29,690
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 $0 $0 $0 $0 $0 $0 $0 $0 $3,750 $3,750 $6,250 $6,250
Bill Payments $5 $164 $161 $158 $172 $658 $800 $820 $1,478 $1,962 $8,649 $7,409
Subtotal Spent on Operations $5 $164 $161 $158 $172 $658 $800 $820 $5,228 $5,712 $14,899 $13,659
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 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333 $333
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 $338 $497 $494 $491 $505 $991 $1,133 $1,153 $5,561 $6,045 $15,232 $13,992
Net Cash Flow ($338) ($497) ($494) ($491) ($505) ($991) ($1,133) ($1,153) ($5,561) ($6,045) ($15,232) $15,698
Cash Balance $59,662 $59,165 $58,671 $58,179 $57,674 $56,684 $55,551 $54,398 $48,837 $42,792 $27,561 $43,258
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 $60,000 $59,662 $59,165 $58,671 $58,179 $57,674 $56,684 $55,551 $54,398 $48,837 $42,792 $27,561 $43,258
Inventory $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $7,123
Other Current Assets $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Total Current Assets $70,000 $69,662 $69,165 $68,671 $68,179 $67,674 $66,684 $65,551 $64,398 $58,837 $52,792 $37,561 $60,381
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 $70,000 $69,662 $69,165 $68,671 $68,179 $67,674 $66,684 $65,551 $64,398 $58,837 $52,792 $37,561 $60,381
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 $158 $156 $153 $150 $631 $773 $771 $1,420 $1,672 $8,411 $6,886 $15,170
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 $158 $156 $153 $150 $631 $773 $771 $1,420 $1,672 $8,411 $6,886 $15,170
Long-term Liabilities $20,000 $19,667 $19,334 $19,001 $18,668 $18,335 $18,002 $17,669 $17,336 $17,003 $16,670 $16,337 $16,004
Total Liabilities $20,000 $19,825 $19,490 $19,154 $18,818 $18,966 $18,775 $18,440 $18,756 $18,675 $25,081 $23,223 $31,174
Paid-in Capital $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000 $62,000
Retained Earnings ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000) ($12,000)
Earnings $0 ($164) ($325) ($483) ($639) ($1,292) ($2,092) ($2,889) ($4,358) ($9,838) ($22,289) ($35,663) ($20,794)
Total Capital $50,000 $49,836 $49,675 $49,517 $49,361 $48,708 $47,908 $47,111 $45,642 $40,162 $27,711 $14,337 $29,206
Total Liabilities and Capital $70,000 $69,662 $69,165 $68,671 $68,179 $67,674 $66,684 $65,551 $64,398 $58,837 $52,792 $37,561 $60,381
Net Worth $50,000 $49,836 $49,675 $49,517 $49,361 $48,708 $47,908 $47,111 $45,642 $40,162 $27,711 $14,337 $29,206