Heavy Lifting, Inc.

Start your own business plan »

Aircraft Weighing Systems 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
Consulting 0% $0 $0 $2,000 $0 $0 $0 $0 $2,000 $0 $0 $2,000 $0
Weigh Bridge Deposit 0% $0 $0 $0 $0 $500,000 $0 $500,000 $0 $0 $0 $0 $0
Weigh Bridge Balance 0% $2,000,000 $0 $0 $0 $0 $0 $0 $0 $500,000 $0 $500,000 $0
Total Sales $2,000,000 $0 $2,000 $0 $500,000 $0 $500,000 $2,000 $500,000 $0 $502,000 $0
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
Materials/Construction 65% $1,300,000 $0 $0 $0 $0 $0 $0 $0 $650,000 $0 $652,600 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,300,000 $0 $0 $0 $0 $0 $0 $0 $650,000 $0 $652,600 $0
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
Chief Executive Officer 0% $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666 $16,666
Technical Director 0% $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500
Project Director 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $12,500 $12,500 $12,500
Office Manager/PA to CEO 0% $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250 $6,250
Legal Services Director 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
Software Engineer 0% $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333 $8,333
Corporate Services 0% $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500 $12,500
Total People 3 3 3 3 3 6 6 6 6 6 6 9
Total Payroll $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $78,749 $78,749 $78,749
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% 0.00%
Tax Rate 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00% 33.00%
Sales Tax 9 9 9 9 9 9 9 9 9 9 9 9
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 $2,000,000 $0 $2,000 $0 $500,000 $0 $500,000 $2,000 $500,000 $0 $502,000 $0
Direct Cost of Sales $1,300,000 $0 $0 $0 $0 $0 $0 $0 $650,000 $0 $652,600 $0
Manufacturing costs $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000
Total Cost of Sales $1,316,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $16,000 $666,000 $16,000 $668,600 $16,000
Gross Margin $684,000 ($16,000) ($14,000) ($16,000) $484,000 ($16,000) $484,000 ($14,000) ($166,000) ($16,000) ($166,600) ($16,000)
Gross Margin % 34.20% 0.00% -700.00% 0.00% 96.80% 0.00% 96.80% -700.00% -33.20% 0.00% -33.19% 0.00%
Expenses
Payroll $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $78,749 $78,749 $78,749
Sales and Marketing and Other Expenses $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700 $1,700
Depreciation $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Leased Equipment $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417 $417
Rent and Utilities $0 $0 $0 $0 $0 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500 $1,500
Payroll Taxes 25% $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 $81,366 $81,366 $81,366 $81,366 $81,366 $82,866 $82,866 $82,866 $82,866 $85,366 $85,366 $85,366
Profit Before Interest and Taxes $602,634 ($97,366) ($95,366) ($97,366) $402,634 ($98,866) $401,134 ($96,866) ($248,866) ($101,366) ($251,966) ($101,366)
EBITDA $605,634 ($94,366) ($92,366) ($94,366) $405,634 ($95,866) $404,134 ($93,866) ($245,866) ($98,366) ($248,966) ($98,366)
Interest Expense $8,186 $8,117 $8,048 $7,980 $7,911 $7,842 $7,773 $7,705 $7,636 $7,567 $7,498 $0
Taxes Incurred $196,168 ($34,809) ($34,127) ($34,764) $130,259 ($35,214) $129,809 ($34,508) ($84,646) ($35,948) ($85,623) ($33,451)
Net Profit $398,280 ($70,674) ($69,288) ($70,582) $264,465 ($71,494) $263,552 ($70,062) ($171,856) ($72,985) ($173,841) ($67,915)
Net Profit/Sales 19.91% 0.00% -3464.38% 0.00% 52.89% 0.00% 52.71% -3503.11% -34.37% 0.00% -34.63% 0.00%
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 $1,000,000 $0 $0 $0 $500,000 $0 $500,000 $0 $500,000 $0 $500,000 $0
Cash from Receivables $0 $33,333 $966,667 $0 $2,000 $0 $0 $0 $0 $2,000 $0 $0
Subtotal Cash from Operations $1,000,000 $33,333 $966,667 $0 $502,000 $0 $500,000 $0 $500,000 $2,000 $500,000 $0
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 $1,000,000 $33,333 $966,667 $0 $502,000 $0 $500,000 $0 $500,000 $2,000 $500,000 $0
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 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $76,249 $78,749 $78,749 $78,749
Bill Payments $75,749 $1,463,146 ($16,251) ($16,363) ($3,169) $143,322 ($2,256) $144,773 $12,806 $564,090 $11,331 $560,455
Subtotal Spent on Operations $151,998 $1,539,395 $59,998 $59,886 $73,080 $219,571 $73,993 $221,022 $89,055 $642,839 $90,080 $639,204
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 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250 $8,250
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 $160,248 $1,547,645 $68,248 $68,136 $81,330 $227,821 $82,243 $229,272 $97,305 $651,089 $98,330 $647,454
Net Cash Flow $839,752 ($1,514,312) $898,419 ($68,136) $420,670 ($227,821) $417,757 ($229,272) $402,695 ($649,089) $401,669 ($647,454)
Cash Balance $3,139,752 $1,625,440 $2,523,858 $2,455,723 $2,876,393 $2,648,572 $3,066,329 $2,837,057 $3,239,752 $2,590,663 $2,992,332 $2,344,878
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,300,000 $3,139,752 $1,625,440 $2,523,858 $2,455,723 $2,876,393 $2,648,572 $3,066,329 $2,837,057 $3,239,752 $2,590,663 $2,992,332 $2,344,878
Accounts Receivable $0 $1,000,000 $966,667 $2,000 $2,000 $0 $0 $0 $2,000 $2,000 $0 $2,000 $2,000
Other Current Assets $250,000 $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 Current Assets $2,550,000 $4,389,752 $2,842,107 $2,775,858 $2,707,723 $3,126,393 $2,898,572 $3,316,329 $3,089,057 $3,491,752 $2,840,663 $3,244,332 $2,596,878
Long-term Assets
Long-term Assets $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000 $400,000
Accumulated Depreciation $0 $3,000 $6,000 $9,000 $12,000 $15,000 $18,000 $21,000 $24,000 $27,000 $30,000 $33,000 $36,000
Total Long-term Assets $400,000 $397,000 $394,000 $391,000 $388,000 $385,000 $382,000 $379,000 $376,000 $373,000 $370,000 $367,000 $364,000
Total Assets $2,950,000 $4,786,752 $3,236,107 $3,166,858 $3,095,723 $3,511,393 $3,280,572 $3,695,329 $3,465,057 $3,864,752 $3,210,663 $3,611,332 $2,960,878
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 $25,000 $1,471,722 $0 $8,289 $15,986 $175,441 $24,364 $183,820 $31,860 $611,661 $38,807 $621,568 $47,279
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 $25,000 $1,471,722 $0 $8,289 $15,986 $175,441 $24,364 $183,820 $31,860 $611,661 $38,807 $621,568 $47,279
Long-term Liabilities $990,550 $982,300 $974,050 $965,800 $957,550 $949,300 $941,050 $932,800 $924,550 $916,300 $908,050 $899,800 $891,550
Total Liabilities $1,015,550 $2,454,022 $974,050 $974,089 $973,536 $1,124,741 $965,414 $1,116,620 $956,410 $1,527,961 $946,857 $1,521,368 $938,829
Paid-in Capital $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000 $2,000,000
Retained Earnings ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550) ($65,550)
Earnings $0 $398,280 $327,607 $258,319 $187,737 $452,202 $380,708 $644,259 $574,197 $402,341 $329,356 $155,514 $87,599
Total Capital $1,934,450 $2,332,730 $2,262,057 $2,192,769 $2,122,187 $2,386,652 $2,315,158 $2,578,709 $2,508,647 $2,336,791 $2,263,806 $2,089,964 $2,022,049
Total Liabilities and Capital $2,950,000 $4,786,752 $3,236,107 $3,166,858 $3,095,723 $3,511,393 $3,280,572 $3,695,329 $3,465,057 $3,864,752 $3,210,663 $3,611,332 $2,960,878
Net Worth $1,934,450 $2,332,730 $2,262,057 $2,192,769 $2,122,187 $2,386,652 $2,315,158 $2,578,709 $2,508,647 $2,336,791 $2,263,806 $2,089,964 $2,022,049