Concrete Carbon Parts

Start your own business plan »

Bicycle Manufacturer Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Individuals 0% $2,500 $2,900 $2,876 $3,565 $3,938 $4,223 $4,432 $4,654 $4,998 $5,112 $5,332 $5,454
Distributors 0% $0 $0 $0 $0 $6,565 $7,121 $8,098 $8,767 $9,878 $9,987 $9,656 $9,765
Total Sales $2,500 $2,900 $2,876 $3,565 $10,503 $11,344 $12,530 $13,421 $14,876 $15,099 $14,988 $15,219
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Individuals $1,125 $1,305 $1,294 $1,604 $1,772 $1,900 $1,994 $2,094 $2,249 $2,300 $2,399 $2,454
Distributors $0 $0 $0 $0 $4,530 $4,913 $5,588 $6,049 $6,816 $6,891 $6,663 $6,738
Subtotal Direct Cost of Sales $1,125 $1,305 $1,294 $1,604 $6,302 $6,814 $7,582 $8,144 $9,065 $9,191 $9,062 $9,192
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Josh 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Employee #1 0% $0 $0 $0 $1,500 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Total People 0 1 1 2 2 2 2 2 2 2 2 2
Total Payroll $2,000 $2,000 $2,000 $3,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
General Assumptions
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $2,500 $2,900 $2,876 $3,565 $10,503 $11,344 $12,530 $13,421 $14,876 $15,099 $14,988 $15,219
Direct Cost of Sales $1,125 $1,305 $1,294 $1,604 $6,302 $6,814 $7,582 $8,144 $9,065 $9,191 $9,062 $9,192
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,125 $1,305 $1,294 $1,604 $6,302 $6,814 $7,582 $8,144 $9,065 $9,191 $9,062 $9,192
Gross Margin $1,375 $1,595 $1,582 $1,961 $4,201 $4,530 $4,948 $5,277 $5,811 $5,908 $5,926 $6,027
Gross Margin % 55.00% 55.00% 55.00% 55.00% 40.00% 39.93% 39.49% 39.32% 39.06% 39.13% 39.54% 39.60%
Expenses
Payroll $2,000 $2,000 $2,000 $3,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Sales and Marketing and Other Expenses $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400 $400
Depreciation $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83 $83
Rent $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350 $350
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 15% $300 $300 $300 $525 $600 $600 $600 $600 $600 $600 $600 $600
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $3,483 $3,483 $3,483 $5,208 $5,783 $5,783 $5,783 $5,783 $5,783 $5,783 $5,783 $5,783
Profit Before Interest and Taxes ($2,108) ($1,888) ($1,901) ($3,247) ($1,582) ($1,253) ($835) ($506) $28 $125 $143 $244
EBITDA ($2,025) ($1,805) ($1,818) ($3,164) ($1,499) ($1,170) ($752) ($423) $111 $208 $226 $327
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 ($2,108) ($1,888) ($1,901) ($3,247) ($1,582) ($1,253) ($835) ($506) $28 $125 $143 $244
Net Profit/Sales -84.32% -65.10% -66.11% -91.09% -15.06% -11.04% -6.66% -3.77% 0.19% 0.83% 0.95% 1.60%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $625 $725 $719 $891 $2,626 $2,836 $3,133 $3,355 $3,719 $3,775 $3,747 $3,805
Cash from Receivables $0 $63 $1,885 $2,174 $2,174 $2,847 $7,898 $8,538 $9,420 $10,102 $11,163 $11,321
Subtotal Cash from Operations $625 $788 $2,604 $3,066 $4,800 $5,683 $11,031 $11,893 $13,139 $13,877 $14,910 $15,126
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 $70,000 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $70,625 $788 $2,604 $3,066 $4,800 $5,683 $11,031 $11,893 $13,139 $13,877 $14,910 $15,126
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $2,000 $2,000 $2,000 $3,500 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Bill Payments $1,099 $3,347 $2,896 $2,712 $3,890 $13,033 $9,112 $10,138 $10,505 $11,754 $11,017 $10,634
Subtotal Spent on Operations $3,099 $5,347 $4,896 $6,212 $7,890 $17,033 $13,112 $14,138 $14,505 $15,754 $15,017 $14,634
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 $5,000 $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 $8,099 $5,347 $4,896 $6,212 $7,890 $17,033 $13,112 $14,138 $14,505 $15,754 $15,017 $14,634
Net Cash Flow $62,526 ($4,560) ($2,292) ($3,146) ($3,090) ($11,350) ($2,081) ($2,245) ($1,366) ($1,877) ($107) $493
Cash Balance $67,981 $63,421 $61,130 $57,983 $54,893 $43,543 $41,462 $39,217 $37,850 $35,974 $35,867 $36,359
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $5,455 $67,981 $63,421 $61,130 $57,983 $54,893 $43,543 $41,462 $39,217 $37,850 $35,974 $35,867 $36,359
Accounts Receivable $0 $1,875 $3,988 $4,260 $4,759 $10,462 $16,123 $17,622 $19,150 $20,887 $22,109 $22,188 $22,281
Inventory $400 $1,238 $1,436 $1,424 $1,765 $6,932 $7,495 $8,340 $8,958 $9,971 $10,111 $9,968 $10,111
Other Current Assets $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800 $800
Total Current Assets $6,655 $71,893 $69,644 $67,613 $65,307 $73,087 $67,961 $68,224 $68,125 $69,509 $68,994 $68,823 $69,551
Long-term Assets
Long-term Assets $1,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Accumulated Depreciation $0 $83 $166 $249 $332 $415 $498 $581 $664 $747 $830 $913 $996
Total Long-term Assets $1,000 $5,917 $5,834 $5,751 $5,668 $5,585 $5,502 $5,419 $5,336 $5,253 $5,170 $5,087 $5,004
Total Assets $7,655 $77,810 $75,478 $73,364 $70,975 $78,672 $73,463 $73,643 $73,461 $74,762 $74,164 $73,910 $74,555
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $987 $3,250 $2,806 $2,593 $3,451 $12,730 $8,774 $9,789 $10,112 $11,386 $10,663 $10,266 $10,667
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 $987 $3,250 $2,806 $2,593 $3,451 $12,730 $8,774 $9,789 $10,112 $11,386 $10,663 $10,266 $10,667
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $987 $3,250 $2,806 $2,593 $3,451 $12,730 $8,774 $9,789 $10,112 $11,386 $10,663 $10,266 $10,667
Paid-in Capital $0 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000 $70,000
Retained Earnings $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668 $6,668
Earnings $0 ($2,108) ($3,996) ($5,897) ($9,144) ($10,726) ($11,979) ($12,814) ($13,320) ($13,292) ($13,167) ($13,024) ($12,780)
Total Capital $6,668 $74,560 $72,672 $70,771 $67,524 $65,942 $64,689 $63,854 $63,348 $63,376 $63,501 $63,644 $63,888
Total Liabilities and Capital $7,655 $77,810 $75,478 $73,364 $70,975 $78,672 $73,463 $73,643 $73,461 $74,762 $74,164 $73,910 $74,555
Net Worth $6,668 $74,560 $72,672 $70,771 $67,524 $65,942 $64,689 $63,854 $63,348 $63,376 $63,501 $63,644 $63,888