Edit This Plan
 

Get real P&L data for your plan!

We have complete profit and loss financial data from companies like Hard Hats Construction.

SIC 1542 Building Cnstrctn - General Contractors & Operative Builders - Nonresidential construction, nec

Get Finanicals

*Reports start as low as $89

 

Commercial Construction Business Plan

Hard Hats Construction

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

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
Commercial Buildings 0% 1 1 1 2 2 2 2 2 2 2 1 1
Government Contracts 0% 1 0 0 0 0 1 1 1 1 1 0 0
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 2 1 1 2 2 3 3 3 3 3 1 1
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
Commercial Buildings $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00
Government Contracts $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,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
Commercial Buildings $2,000,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,000,000 $4,000,000 $4,000,000 $4,000,000 $4,000,000 $2,000,000 $2,000,000
Government Contracts $500,000 $0 $0 $0 $0 $500,000 $500,000 $500,000 $500,000 $550,000 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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
Commercial Buildings 0.00% $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00
Government Contracts 0.00% $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,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
Commercial Buildings $900,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $900,000 $900,000
Government Contracts $250,000 $0 $0 $0 $0 $250,000 $250,000 $250,000 $250,000 $275,000 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
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
Owners 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
Office personnel 0% $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650
Foremen 0% $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Crew Workers 0% $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 60 60 60 60 70 70 70 80 80 80 80 100
Total Payroll $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
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 25.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 $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
Direct Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
Gross Margin $1,350,000 $1,265,000 $1,454,750 $1,672,963 $1,923,907 $2,450,000 $2,450,000 $2,450,000 $2,450,000 $2,475,000 $1,100,000 $1,100,000
Gross Margin % 54.00% 55.00% 55.00% 55.00% 55.00% 54.44% 54.44% 54.44% 54.44% 54.40% 55.00% 55.00%
Expenses
Payroll $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
Sales and Marketing and Other Expenses $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $69,950 $69,950 $69,950
Depreciation 15% $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 5% $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 15% $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $436,798 $436,798 $436,798
Profit Before Interest and Taxes $63,203 ($21,798) $167,953 $386,165 $637,109 $1,163,203 $1,163,203 $1,163,203 $1,163,203 $2,038,203 $663,203 $663,203
EBITDA $88,203 $3,203 $192,953 $411,165 $662,109 $1,188,203 $1,188,203 $1,188,203 $1,188,203 $2,063,203 $688,203 $688,203
Interest Expense $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277
Taxes Incurred $6,981 ($14,269) $33,169 $87,722 $150,458 $281,981 $281,981 $281,981 $281,981 $500,731 $156,981 $156,981
Net Profit $20,944 ($42,806) $99,507 $263,166 $451,375 $845,944 $845,944 $845,944 $845,944 $1,502,194 $470,944 $470,944
Net Profit/Sales 0.84% -1.86% 3.76% 8.65% 12.90% 18.80% 18.80% 18.80% 18.80% 33.02% 23.55% 23.55%
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,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
Subtotal Cash from Operations $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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 $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
Bill Payments $72,914 $2,152,864 $2,027,912 $2,231,613 $2,465,869 $2,745,235 $3,332,406 $3,332,406 $3,332,406 $3,312,197 $2,675,531 $1,207,406
Subtotal Spent on Operations $369,564 $2,449,514 $2,324,562 $2,528,263 $2,762,519 $3,041,885 $3,629,056 $3,629,056 $3,629,056 $3,608,847 $2,972,181 $1,504,056
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 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000
Dividends $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757
Subtotal Cash Spent $600,321 $2,680,271 $2,555,319 $2,759,020 $2,993,276 $3,272,642 $3,859,813 $3,859,813 $3,859,813 $3,839,604 $3,202,938 $1,734,813
Net Cash Flow $1,899,679 ($380,271) $89,681 $282,730 $504,737 $1,227,358 $640,187 $640,187 $640,187 $710,396 ($1,202,938) $265,187
Cash Balance $3,399,679 $3,019,409 $3,109,090 $3,391,820 $3,896,556 $5,123,914 $5,764,102 $6,404,289 $7,044,476 $7,754,872 $6,551,934 $6,817,122
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 $1,500,000 $3,399,679 $3,019,409 $3,109,090 $3,391,820 $3,896,556 $5,123,914 $5,764,102 $6,404,289 $7,044,476 $7,754,872 $6,551,934 $6,817,122
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 $1,600,000 $3,499,679 $3,119,409 $3,209,090 $3,491,820 $3,996,556 $5,223,914 $5,864,102 $6,504,289 $7,144,476 $7,854,872 $6,651,934 $6,917,122
Long-term Assets
Long-term Assets $2,500,000 $2,675,000 $2,850,000 $3,025,000 $3,200,000 $3,375,000 $3,550,000 $3,725,000 $3,900,000 $4,075,000 $4,250,000 $4,425,000 $4,600,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,650,000 $2,800,000 $2,950,000 $3,100,000 $3,250,000 $3,400,000 $3,550,000 $3,700,000 $3,850,000 $4,000,000 $4,150,000 $4,300,000
Total Assets $4,100,000 $6,149,679 $5,919,409 $6,159,090 $6,591,820 $7,246,556 $8,623,914 $9,414,102 $10,204,289 $10,994,476 $11,854,872 $10,801,934 $11,217,122
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 $1,000 $2,085,492 $1,953,784 $2,149,715 $2,375,036 $2,634,155 $3,221,325 $3,221,325 $3,221,325 $3,221,325 $2,635,284 $1,167,159 $1,167,159
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 $1,000 $2,085,492 $1,953,784 $2,149,715 $2,375,036 $2,634,155 $3,221,325 $3,221,325 $3,221,325 $3,221,325 $2,635,284 $1,167,159 $1,167,159
Long-term Liabilities $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200
Total Liabilities $4,234,200 $6,318,692 $6,186,984 $6,382,915 $6,608,236 $6,867,355 $7,454,525 $7,454,525 $7,454,525 $7,454,525 $6,868,484 $5,400,359 $5,400,359
Paid-in Capital $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000
Retained Earnings ($524,200) ($579,957) ($635,714) ($691,471) ($747,228) ($802,985) ($858,742) ($914,499) ($970,256) ($1,026,013) ($1,081,770) ($1,137,527) ($1,193,284)
Earnings $0 $20,944 ($21,861) $77,646 $340,812 $792,186 $1,638,131 $2,484,075 $3,330,020 $4,175,964 $5,678,158 $6,149,103 $6,620,047
Total Capital ($134,200) ($169,013) ($267,575) ($223,825) ($16,416) $379,201 $1,169,389 $1,959,576 $2,749,764 $3,539,951 $4,986,388 $5,401,576 $5,816,763
Total Liabilities and Capital $4,100,000 $6,149,679 $5,919,409 $6,159,090 $6,591,820 $7,246,556 $8,623,914 $9,414,102 $10,204,289 $10,994,476 $11,854,872 $10,801,934 $11,217,122
Net Worth ($134,200) ($169,013) ($267,575) ($223,825) ($16,416) $379,201 $1,169,389 $1,959,576 $2,749,764 $3,539,951 $4,986,388 $5,401,576 $5,816,763
previous
next
Edit This Plan
Share this page:
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
Commercial Buildings 0% 1 1 1 2 2 2 2 2 2 2 1 1
Government Contracts 0% 1 0 0 0 0 1 1 1 1 1 0 0
Other 0% 0 0 0 0 0 0 0 0 0 0 0 0
Total Unit Sales 2 1 1 2 2 3 3 3 3 3 1 1
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
Commercial Buildings $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00 $2,000,000.00
Government Contracts $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,000.00 $500,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
Commercial Buildings $2,000,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,000,000 $4,000,000 $4,000,000 $4,000,000 $4,000,000 $2,000,000 $2,000,000
Government Contracts $500,000 $0 $0 $0 $0 $500,000 $500,000 $500,000 $500,000 $550,000 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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
Commercial Buildings 0.00% $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00 $900,000.00
Government Contracts 0.00% $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,000.00 $250,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
Commercial Buildings $900,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $1,800,000 $900,000 $900,000
Government Contracts $250,000 $0 $0 $0 $0 $250,000 $250,000 $250,000 $250,000 $275,000 $0 $0
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
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
Owners 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
Office personnel 0% $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650 $116,650
Foremen 0% $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Crew Workers 0% $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000 $150,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 60 60 60 60 70 70 70 80 80 80 80 100
Total Payroll $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
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 25.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 $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
Direct Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $1,150,000 $1,035,000 $1,190,250 $1,368,788 $1,574,106 $2,050,000 $2,050,000 $2,050,000 $2,050,000 $2,075,000 $900,000 $900,000
Gross Margin $1,350,000 $1,265,000 $1,454,750 $1,672,963 $1,923,907 $2,450,000 $2,450,000 $2,450,000 $2,450,000 $2,475,000 $1,100,000 $1,100,000
Gross Margin % 54.00% 55.00% 55.00% 55.00% 55.00% 54.44% 54.44% 54.44% 54.44% 54.40% 55.00% 55.00%
Expenses
Payroll $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
Sales and Marketing and Other Expenses $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $919,950 $69,950 $69,950 $69,950
Depreciation 15% $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 5% $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700 $700
Payroll Taxes 15% $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498 $44,498
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $1,286,798 $436,798 $436,798 $436,798
Profit Before Interest and Taxes $63,203 ($21,798) $167,953 $386,165 $637,109 $1,163,203 $1,163,203 $1,163,203 $1,163,203 $2,038,203 $663,203 $663,203
EBITDA $88,203 $3,203 $192,953 $411,165 $662,109 $1,188,203 $1,188,203 $1,188,203 $1,188,203 $2,063,203 $688,203 $688,203
Interest Expense $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277 $35,277
Taxes Incurred $6,981 ($14,269) $33,169 $87,722 $150,458 $281,981 $281,981 $281,981 $281,981 $500,731 $156,981 $156,981
Net Profit $20,944 ($42,806) $99,507 $263,166 $451,375 $845,944 $845,944 $845,944 $845,944 $1,502,194 $470,944 $470,944
Net Profit/Sales 0.84% -1.86% 3.76% 8.65% 12.90% 18.80% 18.80% 18.80% 18.80% 33.02% 23.55% 23.55%
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,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
Subtotal Cash from Operations $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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 $2,500,000 $2,300,000 $2,645,000 $3,041,750 $3,498,013 $4,500,000 $4,500,000 $4,500,000 $4,500,000 $4,550,000 $2,000,000 $2,000,000
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 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650 $296,650
Bill Payments $72,914 $2,152,864 $2,027,912 $2,231,613 $2,465,869 $2,745,235 $3,332,406 $3,332,406 $3,332,406 $3,312,197 $2,675,531 $1,207,406
Subtotal Spent on Operations $369,564 $2,449,514 $2,324,562 $2,528,263 $2,762,519 $3,041,885 $3,629,056 $3,629,056 $3,629,056 $3,608,847 $2,972,181 $1,504,056
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 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000 $175,000
Dividends $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757 $55,757
Subtotal Cash Spent $600,321 $2,680,271 $2,555,319 $2,759,020 $2,993,276 $3,272,642 $3,859,813 $3,859,813 $3,859,813 $3,839,604 $3,202,938 $1,734,813
Net Cash Flow $1,899,679 ($380,271) $89,681 $282,730 $504,737 $1,227,358 $640,187 $640,187 $640,187 $710,396 ($1,202,938) $265,187
Cash Balance $3,399,679 $3,019,409 $3,109,090 $3,391,820 $3,896,556 $5,123,914 $5,764,102 $6,404,289 $7,044,476 $7,754,872 $6,551,934 $6,817,122
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 $1,500,000 $3,399,679 $3,019,409 $3,109,090 $3,391,820 $3,896,556 $5,123,914 $5,764,102 $6,404,289 $7,044,476 $7,754,872 $6,551,934 $6,817,122
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 $1,600,000 $3,499,679 $3,119,409 $3,209,090 $3,491,820 $3,996,556 $5,223,914 $5,864,102 $6,504,289 $7,144,476 $7,854,872 $6,651,934 $6,917,122
Long-term Assets
Long-term Assets $2,500,000 $2,675,000 $2,850,000 $3,025,000 $3,200,000 $3,375,000 $3,550,000 $3,725,000 $3,900,000 $4,075,000 $4,250,000 $4,425,000 $4,600,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,650,000 $2,800,000 $2,950,000 $3,100,000 $3,250,000 $3,400,000 $3,550,000 $3,700,000 $3,850,000 $4,000,000 $4,150,000 $4,300,000
Total Assets $4,100,000 $6,149,679 $5,919,409 $6,159,090 $6,591,820 $7,246,556 $8,623,914 $9,414,102 $10,204,289 $10,994,476 $11,854,872 $10,801,934 $11,217,122
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 $1,000 $2,085,492 $1,953,784 $2,149,715 $2,375,036 $2,634,155 $3,221,325 $3,221,325 $3,221,325 $3,221,325 $2,635,284 $1,167,159 $1,167,159
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 $1,000 $2,085,492 $1,953,784 $2,149,715 $2,375,036 $2,634,155 $3,221,325 $3,221,325 $3,221,325 $3,221,325 $2,635,284 $1,167,159 $1,167,159
Long-term Liabilities $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200 $4,233,200
Total Liabilities $4,234,200 $6,318,692 $6,186,984 $6,382,915 $6,608,236 $6,867,355 $7,454,525 $7,454,525 $7,454,525 $7,454,525 $6,868,484 $5,400,359 $5,400,359
Paid-in Capital $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000 $390,000
Retained Earnings ($524,200) ($579,957) ($635,714) ($691,471) ($747,228) ($802,985) ($858,742) ($914,499) ($970,256) ($1,026,013) ($1,081,770) ($1,137,527) ($1,193,284)
Earnings $0 $20,944 ($21,861) $77,646 $340,812 $792,186 $1,638,131 $2,484,075 $3,330,020 $4,175,964 $5,678,158 $6,149,103 $6,620,047
Total Capital ($134,200) ($169,013) ($267,575) ($223,825) ($16,416) $379,201 $1,169,389 $1,959,576 $2,749,764 $3,539,951 $4,986,388 $5,401,576 $5,816,763
Total Liabilities and Capital $4,100,000 $6,149,679 $5,919,409 $6,159,090 $6,591,820 $7,246,556 $8,623,914 $9,414,102 $10,204,289 $10,994,476 $11,854,872 $10,801,934 $11,217,122
Net Worth ($134,200) ($169,013) ($267,575) ($223,825) ($16,416) $379,201 $1,169,389 $1,959,576 $2,749,764 $3,539,951 $4,986,388 $5,401,576 $5,816,763