Pyramid Engineering

Start your own business plan »

Architectural Engineering Business Plan

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