Tricky Widgets Manufacturing

Start your own business plan »

Heavy 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
Widget Basic 0% 22 22 23 23 24 24 25 25 26 26 27 27
Widget Deluxe 0% 25 26 26 27 27 28 28 29 29 30 30 31
Widget Premium 0% 27 28 28 29 29 30 30 31 32 32 33 34
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 74 75 77 79 80 82 83 85 87 88 90 92
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
Widget Basic $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00 $35,000.00
Widget Deluxe $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00 $50,000.00
Widget Premium $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00 $75,000.00
Other $0.00 $0.00 $0.00 $0.00 $0.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
Sales
Widget Basic $770,000 $785,400 $801,108 $817,130 $833,473 $850,142 $867,145 $884,488 $902,178 $920,221 $938,626 $957,398
Widget Deluxe $1,250,000 $1,275,000 $1,300,500 $1,326,510 $1,353,040 $1,380,101 $1,407,703 $1,435,857 $1,464,574 $1,493,866 $1,523,743 $1,554,218
Widget Premium $2,025,000 $2,065,500 $2,106,810 $2,148,946 $2,191,925 $2,235,764 $2,280,479 $2,326,088 $2,372,610 $2,420,062 $2,468,464 $2,517,833
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $4,045,000 $4,125,900 $4,208,418 $4,292,586 $4,378,438 $4,466,007 $4,555,327 $4,646,434 $4,739,362 $4,834,149 $4,930,832 $5,029,449
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
Widget Basic 0.00% $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00 $28,000.00
Widget Deluxe 0.00% $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00 $40,000.00
Widget Premium 0.00% $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00 $60,000.00
Other 0.00% $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00
Direct Cost of Sales
Widget Basic $616,000 $628,320 $640,886 $653,704 $666,778 $680,114 $693,716 $707,590 $721,742 $736,177 $750,901 $765,919
Widget Deluxe $1,000,000 $1,020,000 $1,040,400 $1,061,208 $1,082,432 $1,104,081 $1,126,162 $1,148,686 $1,171,659 $1,195,093 $1,218,994 $1,243,374
Widget Premium $1,620,000 $1,652,400 $1,685,448 $1,719,157 $1,753,540 $1,788,611 $1,824,383 $1,860,871 $1,898,088 $1,936,050 $1,974,771 $2,014,266
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $3,236,000 $3,300,720 $3,366,734 $3,434,069 $3,502,750 $3,572,805 $3,644,262 $3,717,147 $3,791,490 $3,867,320 $3,944,666 $4,023,559
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
Executives 0% $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000 $40,000
Managers 0% $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000 $80,000
Manufacturing Process Workers 0% $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000 $60,000
Engineering 0% $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000 $250,000
Total People 75 75 75 75 85 85 85 100 100 100 100 115
Total Payroll $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000
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 $4,045,000 $4,125,900 $4,208,418 $4,292,586 $4,378,438 $4,466,007 $4,555,327 $4,646,434 $4,739,362 $4,834,149 $4,930,832 $5,029,449
Direct Cost of Sales $3,236,000 $3,300,720 $3,366,734 $3,434,069 $3,502,750 $3,572,805 $3,644,262 $3,717,147 $3,791,490 $3,867,320 $3,944,666 $4,023,559
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $3,236,000 $3,300,720 $3,366,734 $3,434,069 $3,502,750 $3,572,805 $3,644,262 $3,717,147 $3,791,490 $3,867,320 $3,944,666 $4,023,559
Gross Margin $809,000 $825,180 $841,684 $858,517 $875,688 $893,201 $911,065 $929,287 $947,872 $966,830 $986,166 $1,005,890
Gross Margin % 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00% 20.00%
Expenses
Payroll $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000
Sales and Marketing and Other Expenses $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200 $20,200
Depreciation $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000 $25,000
Utilities $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Payroll Taxes 15% $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 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200 $476,200
Profit Before Interest and Taxes $332,800 $348,980 $365,484 $382,317 $399,488 $417,001 $434,865 $453,087 $471,672 $490,630 $509,966 $529,690
EBITDA $357,800 $373,980 $390,484 $407,317 $424,488 $442,001 $459,865 $478,087 $496,672 $515,630 $534,966 $554,690
Interest Expense $37,308 $58,783 $58,592 $58,400 $58,208 $58,017 $57,825 $57,633 $57,441 $57,250 $57,058 $56,866
Taxes Incurred $88,648 $87,059 $92,068 $97,175 $102,384 $107,695 $113,112 $118,636 $124,269 $130,014 $135,873 $141,847
Net Profit $206,844 $203,138 $214,824 $226,742 $238,896 $251,289 $263,928 $276,818 $289,962 $303,366 $317,036 $330,976
Net Profit/Sales 5.11% 4.92% 5.10% 5.28% 5.46% 5.63% 5.79% 5.96% 6.12% 6.28% 6.43% 6.58%
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,022,500 $2,062,950 $2,104,209 $2,146,293 $2,189,219 $2,233,003 $2,277,663 $2,323,217 $2,369,681 $2,417,075 $2,465,416 $2,514,725
Cash from Receivables $0 $67,417 $2,023,848 $2,064,325 $2,105,612 $2,147,724 $2,190,679 $2,234,492 $2,279,182 $2,324,766 $2,371,261 $2,418,686
Subtotal Cash from Operations $2,022,500 $2,130,367 $4,128,057 $4,210,618 $4,294,831 $4,380,727 $4,468,342 $4,557,709 $4,648,863 $4,741,840 $4,836,677 $4,933,411
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 $2,600,000 $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,022,500 $4,730,367 $4,128,057 $4,210,618 $4,294,831 $4,380,727 $4,468,342 $4,557,709 $4,648,863 $4,741,840 $4,836,677 $4,933,411
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 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000 $430,000
Bill Payments $238,092 $6,732,629 $3,541,363 $3,613,666 $3,687,418 $3,762,648 $3,839,385 $3,917,660 $3,997,503 $4,078,945 $4,162,019 $4,246,757
Subtotal Spent on Operations $668,092 $7,162,629 $3,971,363 $4,043,666 $4,117,418 $4,192,648 $4,269,385 $4,347,660 $4,427,503 $4,508,945 $4,592,019 $4,676,757
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 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003 $23,003
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 $691,095 $7,185,632 $3,994,366 $4,066,669 $4,140,421 $4,215,651 $4,292,388 $4,370,663 $4,450,506 $4,531,948 $4,615,022 $4,699,760
Net Cash Flow $1,331,405 ($2,455,265) $133,692 $143,949 $154,410 $165,076 $175,954 $187,046 $198,357 $209,892 $221,655 $233,651
Cash Balance $3,331,405 $876,140 $1,009,831 $1,153,781 $1,308,190 $1,473,266 $1,649,220 $1,836,266 $2,034,623 $2,244,515 $2,466,171 $2,699,822
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 $2,000,000 $3,331,405 $876,140 $1,009,831 $1,153,781 $1,308,190 $1,473,266 $1,649,220 $1,836,266 $2,034,623 $2,244,515 $2,466,171 $2,699,822
Accounts Receivable $0 $2,022,500 $4,018,033 $4,098,394 $4,180,362 $4,263,969 $4,349,248 $4,436,233 $4,524,958 $4,615,457 $4,707,766 $4,801,922 $4,897,960
Inventory $100,000 $3,559,600 $3,630,792 $3,703,408 $3,777,476 $3,853,026 $3,930,086 $4,008,688 $4,088,862 $4,170,639 $4,254,052 $4,339,133 $4,425,915
Other Current Assets $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000 $100,000
Total Current Assets $2,200,000 $9,013,505 $8,624,965 $8,911,633 $9,211,618 $9,525,185 $9,852,601 $10,194,141 $10,550,085 $10,920,719 $11,306,333 $11,707,225 $12,123,697
Long-term Assets
Long-term Assets $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000
Accumulated Depreciation $0 $25,000 $50,000 $75,000 $100,000 $125,000 $150,000 $175,000 $200,000 $225,000 $250,000 $275,000 $300,000
Total Long-term Assets $2,500,000 $2,475,000 $2,450,000 $2,425,000 $2,400,000 $2,375,000 $2,350,000 $2,325,000 $2,300,000 $2,275,000 $2,250,000 $2,225,000 $2,200,000
Total Assets $4,700,000 $11,488,505 $11,074,965 $11,336,633 $11,611,618 $11,900,185 $12,202,601 $12,519,141 $12,850,085 $13,195,719 $13,556,333 $13,932,225 $14,323,697
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 $10,000 $6,614,664 $3,420,989 $3,490,836 $3,562,082 $3,634,756 $3,708,885 $3,784,500 $3,861,630 $3,940,305 $4,020,556 $4,102,415 $4,185,913
Current Borrowing $0 $0 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000 $2,600,000
Other Current Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Current Liabilities $10,000 $6,614,664 $6,020,989 $6,090,836 $6,162,082 $6,234,756 $6,308,885 $6,384,500 $6,461,630 $6,540,305 $6,620,556 $6,702,415 $6,785,913
Long-term Liabilities $4,500,000 $4,476,997 $4,453,994 $4,430,991 $4,407,988 $4,384,985 $4,361,982 $4,338,979 $4,315,976 $4,292,973 $4,269,970 $4,246,967 $4,223,964
Total Liabilities $4,510,000 $11,091,661 $10,474,983 $10,521,827 $10,570,070 $10,619,741 $10,670,867 $10,723,479 $10,777,606 $10,833,278 $10,890,526 $10,949,382 $11,009,877
Paid-in Capital $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000 $508,000
Retained Earnings ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000) ($318,000)
Earnings $0 $206,844 $409,982 $624,806 $851,548 $1,090,444 $1,341,733 $1,605,662 $1,882,479 $2,172,441 $2,475,807 $2,792,843 $3,123,819
Total Capital $190,000 $396,844 $599,982 $814,806 $1,041,548 $1,280,444 $1,531,733 $1,795,662 $2,072,479 $2,362,441 $2,665,807 $2,982,843 $3,313,819
Total Liabilities and Capital $4,700,000 $11,488,505 $11,074,965 $11,336,633 $11,611,618 $11,900,185 $12,202,601 $12,519,141 $12,850,085 $13,195,719 $13,556,333 $13,932,225 $14,323,697
Net Worth $190,000 $396,844 $599,982 $814,806 $1,041,548 $1,280,444 $1,531,733 $1,795,662 $2,072,479 $2,362,441 $2,665,807 $2,982,843 $3,313,819