Indonesia EEC

Start your own business plan »

Construction Engineering Business Plan

Appendix

Sales Forecast
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales
Engineering & Architect (E&A) 0% $6,250,000 $3,750,000 $2,500,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $1,250,000 $2,500,000
Engineering & Procurement 0% $10,000,000 $6,000,000 $4,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 $4,000,000
Engineering & Construction 0% $3,750,000 $2,250,000 $1,500,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $750,000 $1,500,000
Project management (PM) 0% $5,000,000 $3,000,000 $2,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $1,000,000 $2,000,000
Total Sales $25,000,000 $15,000,000 $10,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $10,000,000
Direct Cost of Sales Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Engineering & Architect (E&A) $3,375,000 $2,025,000 $1,350,000 $675,000 $675,000 $675,000 $675,000 $675,000 $675,000 $675,000 $675,000 $1,350,000
Engineering & Procurement $5,400,000 $3,240,000 $2,160,000 $1,080,000 $1,080,000 $1,080,000 $1,080,000 $1,080,000 $1,080,000 $1,080,000 $1,080,000 $2,160,000
Engineering & Construction $2,025,000 $1,215,000 $810,000 $405,000 $405,000 $405,000 $405,000 $405,000 $405,000 $405,000 $405,000 $810,000
Project management (PM) $2,700,000 $1,620,000 $1,080,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $540,000 $1,080,000
Subtotal Direct Cost of Sales $13,500,000 $8,100,000 $5,400,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $5,400,000
Personnel Plan
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
President Director/Chief Representative 0% $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500 $4,500
Executive Secretary 0% $540 $540 $540 $540 $540 $540 $540 $540 $540 $540 $540 $540
VP Sales & Marketing 0% $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166
Sales Manager 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Marketing & Business Dev. Manager 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Secretary 0% $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325
VP Internal Business Management (IBM) 0% $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166 $2,166
Finance Manager/Senior Accountant 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Accountant 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Human Resources Manager 0% $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300 $1,300
Administrative Officer 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Legal Officer 0% $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Bookkeeper 0% $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325 $325
Clerical 0% $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108
Clerical 0% $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108
Clerical 0% $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108
Clerical 0% $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108 $108
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654
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 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50% 8.50%
Long-term Interest Rate 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.00% 9.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
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Sales $25,000,000 $15,000,000 $10,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $10,000,000
Direct Cost of Sales $13,500,000 $8,100,000 $5,400,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $2,700,000 $5,400,000
Power System Studies $5,000 $5,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $0 $0
Total Cost of Sales $13,505,000 $8,105,000 $5,406,000 $2,706,000 $2,706,000 $2,706,000 $2,706,000 $2,706,000 $2,706,000 $2,706,000 $2,700,000 $5,400,000
Gross Margin $11,495,000 $6,895,000 $4,594,000 $2,294,000 $2,294,000 $2,294,000 $2,294,000 $2,294,000 $2,294,000 $2,294,000 $2,300,000 $4,600,000
Gross Margin % 45.98% 45.97% 45.94% 45.88% 45.88% 45.88% 45.88% 45.88% 45.88% 45.88% 46.00% 46.00%
Expenses
Payroll $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654
Sales and Marketing and Other Expenses $388,500 $382,000 $382,000 $388,500 $382,000 $382,000 $388,500 $382,000 $382,000 $388,500 $382,000 $382,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Utilities $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Insurance $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500 $500
Rent $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Payroll Taxes 15% $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798 $2,798
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $420,952 $414,452 $414,452 $420,952 $414,452 $414,452 $420,952 $414,452 $414,452 $420,952 $414,452 $414,452
Profit Before Interest and Taxes $11,074,048 $6,480,548 $4,179,548 $1,873,048 $1,879,548 $1,879,548 $1,873,048 $1,879,548 $1,879,548 $1,873,048 $1,885,548 $4,185,548
EBITDA $11,074,048 $6,480,548 $4,179,548 $1,873,048 $1,879,548 $1,879,548 $1,873,048 $1,879,548 $1,879,548 $1,873,048 $1,885,548 $4,185,548
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $2,768,512 $1,620,137 $1,044,887 $468,262 $469,887 $469,887 $468,262 $469,887 $469,887 $468,262 $471,387 $1,046,387
Net Profit $8,305,536 $4,860,411 $3,134,661 $1,404,786 $1,409,661 $1,409,661 $1,404,786 $1,409,661 $1,409,661 $1,404,786 $1,414,161 $3,139,161
Net Profit/Sales 33.22% 32.40% 31.35% 28.10% 28.19% 28.19% 28.10% 28.19% 28.19% 28.10% 28.28% 31.39%
Pro Forma Cash Flow
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Cash Received
Cash from Operations
Cash Sales $12,500,000 $7,500,000 $5,000,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 $5,000,000
Cash from Receivables $5,348,858 $5,765,525 $12,333,333 $7,416,667 $4,916,667 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000 $2,500,000
Subtotal Cash from Operations $17,848,858 $13,265,525 $17,333,333 $9,916,667 $7,416,667 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $7,500,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 $17,848,858 $13,265,525 $17,333,333 $9,916,667 $7,416,667 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $5,000,000 $7,500,000
Expenditures Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Expenditures from Operations
Cash Spending $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654 $18,654
Bill Payments $4,892,688 $16,457,314 $10,011,793 $6,737,681 $3,576,398 $3,571,685 $3,571,848 $3,576,398 $3,571,685 $3,571,848 $3,576,248 $3,676,352
Subtotal Spent on Operations $4,911,342 $16,475,968 $10,030,447 $6,756,335 $3,595,052 $3,590,339 $3,590,502 $3,595,052 $3,590,339 $3,590,502 $3,594,902 $3,695,006
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 $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 $4,911,342 $16,475,968 $10,030,447 $6,756,335 $3,595,052 $3,590,339 $3,590,502 $3,595,052 $3,590,339 $3,590,502 $3,594,902 $3,695,006
Net Cash Flow $12,937,516 ($3,210,444) $7,302,886 $3,160,332 $3,821,615 $1,409,661 $1,409,498 $1,404,948 $1,409,661 $1,409,498 $1,405,098 $3,804,994
Cash Balance $39,187,516 $35,977,072 $43,279,958 $46,440,290 $50,261,905 $51,671,566 $53,081,064 $54,486,013 $55,895,674 $57,305,172 $58,710,270 $62,515,265
Pro Forma Balance Sheet
Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Assets Starting Balances
Current Assets
Cash $26,250,000 $39,187,516 $35,977,072 $43,279,958 $46,440,290 $50,261,905 $51,671,566 $53,081,064 $54,486,013 $55,895,674 $57,305,172 $58,710,270 $62,515,265
Accounts Receivable $10,697,716 $17,848,858 $19,583,333 $12,250,000 $7,333,333 $4,916,667 $4,916,667 $4,916,667 $4,916,667 $4,916,667 $4,916,667 $4,916,667 $7,416,667
Other Current Assets $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380 $920,380
Total Current Assets $37,868,096 $57,956,754 $56,480,785 $56,450,338 $54,694,003 $56,098,952 $57,508,612 $58,918,111 $60,323,059 $61,732,720 $63,142,219 $64,547,317 $70,852,311
Long-term Assets
Long-term Assets $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965 $1,243,965
Total Assets $39,112,061 $59,200,719 $57,724,750 $57,694,303 $55,937,968 $57,342,917 $58,752,577 $60,162,076 $61,567,024 $62,976,685 $64,386,184 $65,791,282 $72,096,276
Liabilities and Capital Jan Feb Mar Apr May Jun Jul Aug Sep Oct Nov Dec
Current Liabilities
Accounts Payable $4,336,828 $16,119,950 $9,783,571 $6,618,462 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,448,279 $6,614,112
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 $4,336,828 $16,119,950 $9,783,571 $6,618,462 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,448,279 $6,614,112
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $4,336,828 $16,119,950 $9,783,571 $6,618,462 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,452,629 $3,452,629 $3,457,341 $3,448,279 $6,614,112
Paid-in Capital $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900 $4,743,900
Retained Earnings $1,781,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333 $30,031,333
Earnings $28,250,000 $8,305,536 $13,165,947 $16,300,608 $17,705,394 $19,115,055 $20,524,716 $21,929,501 $23,339,162 $24,748,823 $26,153,609 $27,567,770 $30,706,931
Total Capital $34,775,233 $43,080,769 $47,941,180 $51,075,841 $52,480,627 $53,890,288 $55,299,949 $56,704,734 $58,114,395 $59,524,056 $60,928,842 $62,343,003 $65,482,164
Total Liabilities and Capital $39,112,061 $59,200,719 $57,724,750 $57,694,303 $55,937,968 $57,342,917 $58,752,577 $60,162,076 $61,567,024 $62,976,685 $64,386,184 $65,791,282 $72,096,276
Net Worth $34,775,233 $43,080,769 $47,941,180 $51,075,841 $52,480,627 $53,890,288 $55,299,949 $56,704,734 $58,114,395 $59,524,056 $60,928,842 $62,343,003 $65,482,164