Indonesia EEC
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 |
By 
