Pyramid Engineering
Appendix
| Sales Forecast | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Sales | |||||||||||||
| Educational | 0% | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 | $16,666 |
| Health Care / Senior Facilities | 0% | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 | $6,250 |
| Commercial | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Government | 0% | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 | $2,500 |
| Program Management | 0% | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 |
| Contractor / design Build | 0% | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 | $415 |
| Consulting Income | 0% | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 | $400 |
| Total Sales | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | |
| Direct Cost of Sales | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| See Personnel Table | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Subtotal Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Personnel Plan | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| John J. Solarczyk | 0% | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 |
| Thomas C. Heasley | 0% | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 | $6,558 |
| Eric C. Haugh | 0% | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 | $6,121 |
| John M. Lavoie | 0% | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 | $1,894 |
| Other | 0% | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total People | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | 4 | |
| Total Payroll | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.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 | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.00% | 30.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 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | |
| Direct Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Hidden Row | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Cost of Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Gross Margin | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | |
| Gross Margin % | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | 100.00% | |
| Expenses | |||||||||||||
| Payroll | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | |
| Sales and Marketing and Other Expenses | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | |
| Depreciation | 0% | $51 | $51 | $51 | $51 | $51 | $51 | $51 | $51 | $51 | $51 | $51 | $51 |
| Rent | 0% | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 | $600 |
| Utilities | 0% | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 | $1,130 |
| Insurance | 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 |
| Payroll Taxes | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | |
| 125 – Flexible Spending Account | 0% | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
| Automobile Expense | 0% | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 | $450 |
| Bank Service Charges | 0% | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 |
| Charity / Contributions | 0% | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 |
| Interest Expense | 0% | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
| Licenses and Permits | 0% | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 | $150 |
| Office Supplies | 0% | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 | $500 |
| Payroll taxes & Expenses | 0% | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 | $800 |
| Postage and Delivery | 0% | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 | $70 |
| Printing and Reproduction | 0% | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 | $200 |
| Professional Fees | 0% | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
| Professional Improvement (CEUs) | 0% | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 | $50 |
| Travel & Ent | 0% | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 | $100 |
| Other | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Total Operating Expenses | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | $28,345 | |
| Profit Before Interest and Taxes | $801 | $801 | $801 | $801 | $801 | $801 | $801 | $801 | $801 | $801 | $801 | $801 | |
| EBITDA | $852 | $852 | $852 | $852 | $852 | $852 | $852 | $852 | $852 | $852 | $852 | $852 | |
| Interest Expense | $162 | $167 | $171 | $176 | $180 | $185 | $189 | $194 | $198 | $203 | $207 | $211 | |
| Taxes Incurred | $192 | $190 | $189 | $188 | $186 | $185 | $184 | $182 | $181 | $180 | $178 | $177 | |
| Net Profit | $447 | $444 | $441 | $438 | $435 | $431 | $428 | $425 | $422 | $419 | $416 | $413 | |
| Net Profit/Sales | 1.53% | 1.52% | 1.51% | 1.50% | 1.49% | 1.48% | 1.47% | 1.46% | 1.45% | 1.44% | 1.43% | 1.42% | |
| Pro Forma Cash Flow | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | |
| Cash from Receivables | $33,565 | $34,537 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | |
| Subtotal Cash from Operations | $33,565 | $34,537 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | $29,146 | |
| 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 | $4,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | $2,000 | |
| 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 | $37,565 | $36,537 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | $31,146 | |
| Expenditures | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | $20,694 | |
| Bill Payments | $7,931 | $7,954 | $7,957 | $7,960 | $7,963 | $7,967 | $7,970 | $7,973 | $7,976 | $7,979 | $7,982 | $7,985 | |
| Subtotal Spent on Operations | $28,625 | $28,648 | $28,651 | $28,654 | $28,657 | $28,661 | $28,664 | $28,667 | $28,670 | $28,673 | $28,676 | $28,679 | |
| 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 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | $1,111 | |
| 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 | $29,736 | $29,759 | $29,762 | $29,765 | $29,768 | $29,771 | $29,774 | $29,777 | $29,780 | $29,784 | $29,787 | $29,790 | |
| Net Cash Flow | $7,829 | $6,778 | $1,384 | $1,381 | $1,378 | $1,375 | $1,372 | $1,369 | $1,366 | $1,362 | $1,359 | $1,356 | |
| Cash Balance | $10,428 | $17,206 | $18,590 | $19,972 | $21,350 | $22,725 | $24,096 | $25,465 | $26,831 | $28,193 | $29,552 | $30,909 | |
| Pro Forma Balance Sheet | |||||||||||||
| Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | $2,599 | $10,428 | $17,206 | $18,590 | $19,972 | $21,350 | $22,725 | $24,096 | $25,465 | $26,831 | $28,193 | $29,552 | $30,909 |
| Accounts Receivable | $67,130 | $62,711 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 | $57,320 |
| Other Current Assets | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Current Assets | $69,729 | $73,139 | $74,527 | $75,911 | $77,292 | $78,670 | $80,045 | $81,417 | $82,785 | $84,151 | $85,513 | $86,873 | $88,229 |
| Long-term Assets | |||||||||||||
| Long-term Assets | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 | $9,628 |
| Accumulated Depreciation | $5,345 | $5,396 | $5,447 | $5,498 | $5,549 | $5,600 | $5,651 | $5,702 | $5,753 | $5,804 | $5,855 | $5,906 | $5,957 |
| Total Long-term Assets | $4,283 | $4,232 | $4,181 | $4,130 | $4,079 | $4,028 | $3,977 | $3,926 | $3,875 | $3,824 | $3,773 | $3,722 | $3,671 |
| Total Assets | $74,012 | $77,371 | $78,708 | $80,041 | $81,371 | $82,698 | $84,022 | $85,343 | $86,660 | $87,975 | $89,286 | $90,595 | $91,900 |
| Liabilities and Capital | Jan | Feb | Mar | Apr | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | |
| Current Liabilities | |||||||||||||
| Accounts Payable | $7,666 | $7,689 | $7,692 | $7,695 | $7,698 | $7,701 | $7,704 | $7,707 | $7,710 | $7,713 | $7,716 | $7,719 | $7,722 |
| Current Borrowing | $29,609 | $32,499 | $33,388 | $34,278 | $35,167 | $36,057 | $36,946 | $37,836 | $38,725 | $39,615 | $40,504 | $41,394 | $42,283 |
| Other Current Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Subtotal Current Liabilities | $37,275 | $40,187 | $41,080 | $41,972 | $42,865 | $43,757 | $44,650 | $45,542 | $46,435 | $47,327 | $48,220 | $49,113 | $50,005 |
| Long-term Liabilities | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Total Liabilities | $37,275 | $40,187 | $41,080 | $41,972 | $42,865 | $43,757 | $44,650 | $45,542 | $46,435 | $47,327 | $48,220 | $49,113 | $50,005 |
| Paid-in Capital | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 | $0 |
| Retained Earnings | $55,858 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 | $36,737 |
| Earnings | ($19,121) | $447 | $891 | $1,332 | $1,769 | $2,204 | $2,635 | $3,063 | $3,488 | $3,911 | $4,329 | $4,745 | $5,158 |
| Total Capital | $36,737 | $37,184 | $37,628 | $38,069 | $38,506 | $38,941 | $39,372 | $39,800 | $40,225 | $40,648 | $41,066 | $41,482 | $41,895 |
| Total Liabilities and Capital | $74,012 | $77,371 | $78,708 | $80,041 | $81,371 | $82,698 | $84,022 | $85,343 | $86,660 | $87,975 | $89,286 | $90,595 | $91,900 |
| Net Worth | $36,737 | $37,184 | $37,628 | $38,069 | $38,506 | $38,941 | $39,372 | $39,800 | $40,225 | $40,648 | $41,066 | $41,482 | $41,895 |
By 
