Indonesia EEC construction engineering business plan appendix. Indonesia Energy Engineering and Construction is an ongoing firm dedicated to solving the electric energy problems of Southeast Asia and Indonesia.

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
Indonesia EEC construction engineering business plan appendix. Indonesia Energy Engineering and Construction is an ongoing firm dedicated to solving the electric energy problems of Southeast Asia and Indonesia.