Stretch 'r Wings
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 |