Our biggest savings of the year
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 |