Edit This Plan
 

Get real P&L data for your plan!

We have complete profit and loss financial data from companies like Ibrio Incorporated.

SIC 7375 Business Services - Information retrieval services

Get Finanicals

*Reports start as low as $89

 

Web Design Business Plan

Ibrio Incorporated

This sample business plan can be edited directly in Business Plan Pro software.

previous
next

Appendix

Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Website Development 0% $0 $0 $4,800 $5,400 $7,200 $8,400 $8,400 $11,200 $14,000 $19,200 $19,200 $19,200
Result-based Marketing 0% $0 $0 $0 $0 $0 $0 $1,750 $2,100 $2,800 $3,500 $4,200 $4,900
Maintenance 0% $0 $0 $110 $280 $510 $750 $1,010 $1,350 $1,790 $2,290 $2,810 $3,330
Hosting 0% $0 $0 $200 $300 $540 $780 $1,020 $1,340 $1,740 $2,200 $2,700 $3,220
Total Sales $0 $0 $5,110 $5,980 $8,250 $9,930 $12,180 $15,990 $20,330 $27,190 $28,910 $30,650
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Website Development $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Result-based Marketing $0 $0 $0 $0 $0 $0 $900 $1,080 $1,440 $1,800 $2,160 $2,520
Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Hosting $0 $0 $350 $350 $350 $350 $350 $1,100 $700 $700 $700 $700
Subtotal Direct Cost of Sales $0 $0 $350 $350 $350 $350 $1,250 $2,180 $2,140 $2,500 $2,860 $3,220
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Production Personnel
Brandon/Web Developer $0 $200 $200 $200 $300 $300 $300 $300 $400 $400 $400 $400
Keith/Hired in Oct $0 $0 $1,836 $1,152 $1,584 $1,440 $1,584 $1,512 $1,840 $1,680 $1,760 $1,840
Developer #2/Hired in Feb $0 $0 $0 $0 $0 $1,440 $1,584 $1,512 $1,656 $1,512 $1,584 $1,656
Developer #3/Hired in Apr $0 $0 $0 $0 $0 $0 $0 $1,512 $1,656 $1,512 $1,584 $1,656
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $200 $2,036 $1,352 $1,884 $3,180 $3,468 $4,836 $5,552 $5,104 $5,328 $5,552
Sales and Marketing Personnel
Dave/Marketing $0 $200 $200 $200 $300 $300 $300 $300 $400 $400 $400 $400
Sales Position #1/Hired in Oct $0 $0 $1,904 $1,080 $1,440 $1,680 $1,680 $1,680 $1,760 $1,760 $1,760 $1,760
Sales Position #2/Hired in Feb $0 $0 $0 $0 $0 $1,120 $1,232 $1,176 $1,288 $1,760 $1,760 $1,760
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $200 $2,104 $1,280 $1,740 $3,100 $3,212 $3,156 $3,448 $3,920 $3,920 $3,920
General and Administrative Personnel
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Personnel
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 2 4 4 4 6 6 7 7 7 7 7
Total Payroll $0 $400 $4,140 $2,632 $3,624 $6,280 $6,680 $7,992 $9,000 $9,024 $9,248 $9,472
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current 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%
Long-term Interest Rate 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00%
Tax Rate 30.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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $5,110 $5,980 $8,250 $9,930 $12,180 $15,990 $20,330 $27,190 $28,910 $30,650
Direct Cost of Sales $0 $0 $350 $350 $350 $350 $1,250 $2,180 $2,140 $2,500 $2,860 $3,220
Production Payroll $0 $200 $2,036 $1,352 $1,884 $3,180 $3,468 $4,836 $5,552 $5,104 $5,328 $5,552
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $200 $2,386 $1,702 $2,234 $3,530 $4,718 $7,016 $7,692 $7,604 $8,188 $8,772
Gross Margin $0 ($200) $2,724 $4,278 $6,016 $6,400 $7,462 $8,974 $12,638 $19,586 $20,722 $21,878
Gross Margin % 0.00% 0.00% 53.31% 71.54% 72.92% 64.45% 61.26% 56.12% 62.16% 72.03% 71.68% 71.38%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $200 $2,104 $1,280 $1,740 $3,100 $3,212 $3,156 $3,448 $3,920 $3,920 $3,920
Advertising/Promotion $0 $0 $230 $230 $230 $300 $300 $300 $300 $300 $300 $300
Travel $0 $0 $60 $60 $60 $120 $120 $120 $120 $120 $120 $120
Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $0 $200 $2,394 $1,570 $2,030 $3,520 $3,632 $3,576 $3,868 $4,340 $4,340 $4,340
Sales and Marketing % 0.00% 0.00% 46.85% 26.25% 24.61% 35.45% 29.82% 22.36% 19.03% 15.96% 15.01% 14.16%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $300 $300 $300 $300 $330 $330 $330 $330 $330 $330
Rent $0 $0 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $55 $70 $70 $80 $80 $90 $90 $90 $90 $90
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 12% $0 $48 $497 $316 $435 $754 $802 $959 $1,080 $1,083 $1,110 $1,137
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $0 $48 $1,302 $1,136 $1,255 $1,584 $1,662 $1,829 $1,950 $1,953 $1,980 $2,007
General and Administrative % 0.00% 0.00% 25.48% 18.99% 15.21% 15.95% 13.64% 11.44% 9.59% 7.18% 6.85% 6.55%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $0 $248 $3,696 $2,706 $3,285 $5,104 $5,294 $5,405 $5,818 $6,293 $6,320 $6,347
Profit Before Interest and Taxes $0 ($448) ($972) $1,572 $2,731 $1,296 $2,168 $3,569 $6,820 $13,293 $14,402 $15,531
EBITDA $0 ($448) ($672) $1,872 $3,031 $1,596 $2,498 $3,899 $7,150 $13,623 $14,732 $15,861
Interest Expense $217 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217
Taxes Incurred ($65) ($166) ($297) $339 $629 $270 $488 $838 $1,651 $3,269 $3,546 $3,829
Net Profit ($152) ($499) ($891) $1,017 $1,886 $810 $1,464 $2,514 $4,953 $9,807 $10,639 $11,486
Net Profit/Sales 0.00% 0.00% -17.44% 17.00% 22.86% 8.16% 12.02% 15.72% 24.36% 36.07% 36.80% 37.47%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $1,686 $1,973 $2,723 $3,277 $4,019 $5,277 $6,709 $8,973 $9,540 $10,115
Cash from Receivables $0 $0 $0 $114 $3,443 $4,057 $5,565 $6,703 $8,246 $10,810 $13,774 $18,256
Subtotal Cash from Operations $0 $0 $1,686 $2,088 $6,166 $7,334 $9,584 $11,980 $14,955 $19,783 $23,315 $28,370
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 $10,700 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $1,686 $2,088 $6,166 $7,334 $20,284 $11,980 $14,955 $19,783 $23,315 $28,370
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $0 $400 $4,140 $2,632 $3,624 $6,280 $6,680 $7,992 $9,000 $9,024 $9,248 $9,472
Bill Payments $5 $150 $147 $1,577 $2,045 $2,443 $2,579 $3,754 $5,184 $6,114 $8,051 $8,715
Subtotal Spent on Operations $5 $550 $4,287 $4,209 $5,669 $8,723 $9,259 $11,746 $14,184 $15,138 $17,299 $18,187
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 $5 $550 $4,287 $4,209 $5,669 $8,723 $9,259 $11,746 $14,184 $15,138 $17,299 $18,187
Net Cash Flow ($5) ($550) ($2,601) ($2,121) $497 ($1,389) $11,025 $234 $771 $4,645 $6,016 $10,183
Cash Balance $16,995 $16,445 $13,844 $11,723 $12,219 $10,830 $21,855 $22,089 $22,860 $27,505 $33,521 $43,704
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $17,000 $16,995 $16,445 $13,844 $11,723 $12,219 $10,830 $21,855 $22,089 $22,860 $27,505 $33,521 $43,704
Accounts Receivable $0 $0 $0 $3,424 $7,316 $9,401 $11,996 $14,592 $18,602 $23,977 $31,384 $36,980 $39,260
Other Current Assets $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650
Total Current Assets $24,650 $24,645 $24,095 $24,918 $26,689 $29,270 $30,476 $44,097 $48,341 $54,487 $66,540 $78,151 $90,614
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $300 $600 $900 $1,200 $1,530 $1,860 $2,190 $2,520 $2,850 $3,180
Total Long-term Assets $0 $0 $0 ($300) ($600) ($900) ($1,200) ($1,530) ($1,860) ($2,190) ($2,520) ($2,850) ($3,180)
Total Assets $24,650 $24,645 $24,095 $24,618 $26,089 $28,370 $29,276 $42,567 $46,481 $52,297 $64,020 $75,301 $87,434
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $147 $95 $1,509 $1,964 $2,359 $2,456 $3,583 $4,982 $5,846 $7,761 $8,403 $9,050
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 $0 $147 $95 $1,509 $1,964 $2,359 $2,456 $3,583 $4,982 $5,846 $7,761 $8,403 $9,050
Long-term Liabilities $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Total Liabilities $20,000 $20,147 $20,095 $21,509 $21,964 $22,359 $22,456 $23,583 $24,982 $25,846 $27,761 $28,403 $29,050
Paid-in Capital $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Retained Earnings ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650)
Earnings $0 ($152) ($650) ($1,542) ($525) $1,361 $2,171 $3,635 $6,149 $11,101 $20,909 $31,548 $43,034
Total Capital $4,650 $4,498 $4,000 $3,108 $4,125 $6,011 $6,821 $18,985 $21,499 $26,451 $36,259 $46,898 $58,384
Total Liabilities and Capital $24,650 $24,645 $24,095 $24,618 $26,089 $28,370 $29,276 $42,567 $46,481 $52,297 $64,020 $75,301 $87,434
Net Worth $4,650 $4,498 $4,000 $3,108 $4,125 $6,011 $6,821 $18,985 $21,499 $26,451 $36,259 $46,898 $58,384
previous
next
Edit This Plan
Share this page:
Sales Forecast
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales
Website Development 0% $0 $0 $4,800 $5,400 $7,200 $8,400 $8,400 $11,200 $14,000 $19,200 $19,200 $19,200
Result-based Marketing 0% $0 $0 $0 $0 $0 $0 $1,750 $2,100 $2,800 $3,500 $4,200 $4,900
Maintenance 0% $0 $0 $110 $280 $510 $750 $1,010 $1,350 $1,790 $2,290 $2,810 $3,330
Hosting 0% $0 $0 $200 $300 $540 $780 $1,020 $1,340 $1,740 $2,200 $2,700 $3,220
Total Sales $0 $0 $5,110 $5,980 $8,250 $9,930 $12,180 $15,990 $20,330 $27,190 $28,910 $30,650
Direct Cost of Sales Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Website Development $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Result-based Marketing $0 $0 $0 $0 $0 $0 $900 $1,080 $1,440 $1,800 $2,160 $2,520
Maintenance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Hosting $0 $0 $350 $350 $350 $350 $350 $1,100 $700 $700 $700 $700
Subtotal Direct Cost of Sales $0 $0 $350 $350 $350 $350 $1,250 $2,180 $2,140 $2,500 $2,860 $3,220
Personnel Plan
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Production Personnel
Brandon/Web Developer $0 $200 $200 $200 $300 $300 $300 $300 $400 $400 $400 $400
Keith/Hired in Oct $0 $0 $1,836 $1,152 $1,584 $1,440 $1,584 $1,512 $1,840 $1,680 $1,760 $1,840
Developer #2/Hired in Feb $0 $0 $0 $0 $0 $1,440 $1,584 $1,512 $1,656 $1,512 $1,584 $1,656
Developer #3/Hired in Apr $0 $0 $0 $0 $0 $0 $0 $1,512 $1,656 $1,512 $1,584 $1,656
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $200 $2,036 $1,352 $1,884 $3,180 $3,468 $4,836 $5,552 $5,104 $5,328 $5,552
Sales and Marketing Personnel
Dave/Marketing $0 $200 $200 $200 $300 $300 $300 $300 $400 $400 $400 $400
Sales Position #1/Hired in Oct $0 $0 $1,904 $1,080 $1,440 $1,680 $1,680 $1,680 $1,760 $1,760 $1,760 $1,760
Sales Position #2/Hired in Feb $0 $0 $0 $0 $0 $1,120 $1,232 $1,176 $1,288 $1,760 $1,760 $1,760
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $200 $2,104 $1,280 $1,740 $3,100 $3,212 $3,156 $3,448 $3,920 $3,920 $3,920
General and Administrative Personnel
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other Personnel
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
N/A $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 2 4 4 4 6 6 7 7 7 7 7
Total Payroll $0 $400 $4,140 $2,632 $3,624 $6,280 $6,680 $7,992 $9,000 $9,024 $9,248 $9,472
General Assumptions
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Plan Month 1 2 3 4 5 6 7 8 9 10 11 12
Current 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%
Long-term Interest Rate 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00% 13.00%
Tax Rate 30.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
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Sales $0 $0 $5,110 $5,980 $8,250 $9,930 $12,180 $15,990 $20,330 $27,190 $28,910 $30,650
Direct Cost of Sales $0 $0 $350 $350 $350 $350 $1,250 $2,180 $2,140 $2,500 $2,860 $3,220
Production Payroll $0 $200 $2,036 $1,352 $1,884 $3,180 $3,468 $4,836 $5,552 $5,104 $5,328 $5,552
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $200 $2,386 $1,702 $2,234 $3,530 $4,718 $7,016 $7,692 $7,604 $8,188 $8,772
Gross Margin $0 ($200) $2,724 $4,278 $6,016 $6,400 $7,462 $8,974 $12,638 $19,586 $20,722 $21,878
Gross Margin % 0.00% 0.00% 53.31% 71.54% 72.92% 64.45% 61.26% 56.12% 62.16% 72.03% 71.68% 71.38%
Operating Expenses
Sales and Marketing Expenses
Sales and Marketing Payroll $0 $200 $2,104 $1,280 $1,740 $3,100 $3,212 $3,156 $3,448 $3,920 $3,920 $3,920
Advertising/Promotion $0 $0 $230 $230 $230 $300 $300 $300 $300 $300 $300 $300
Travel $0 $0 $60 $60 $60 $120 $120 $120 $120 $120 $120 $120
Miscellaneous $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales and Marketing Expenses $0 $200 $2,394 $1,570 $2,030 $3,520 $3,632 $3,576 $3,868 $4,340 $4,340 $4,340
Sales and Marketing % 0.00% 0.00% 46.85% 26.25% 24.61% 35.45% 29.82% 22.36% 19.03% 15.96% 15.01% 14.16%
General and Administrative Expenses
General and Administrative Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Sales and Marketing and Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Depreciation $0 $0 $300 $300 $300 $300 $330 $330 $330 $330 $330 $330
Rent $0 $0 $450 $450 $450 $450 $450 $450 $450 $450 $450 $450
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Leased Equipment $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Utilities $0 $0 $55 $70 $70 $80 $80 $90 $90 $90 $90 $90
Insurance $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Payroll Taxes 12% $0 $48 $497 $316 $435 $754 $802 $959 $1,080 $1,083 $1,110 $1,137
Other General and Administrative Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total General and Administrative Expenses $0 $48 $1,302 $1,136 $1,255 $1,584 $1,662 $1,829 $1,950 $1,953 $1,980 $2,007
General and Administrative % 0.00% 0.00% 25.48% 18.99% 15.21% 15.95% 13.64% 11.44% 9.59% 7.18% 6.85% 6.55%
Other Expenses:
Other Payroll $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Contract/Consultants $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Other Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Other % 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00% 0.00%
Total Operating Expenses $0 $248 $3,696 $2,706 $3,285 $5,104 $5,294 $5,405 $5,818 $6,293 $6,320 $6,347
Profit Before Interest and Taxes $0 ($448) ($972) $1,572 $2,731 $1,296 $2,168 $3,569 $6,820 $13,293 $14,402 $15,531
EBITDA $0 ($448) ($672) $1,872 $3,031 $1,596 $2,498 $3,899 $7,150 $13,623 $14,732 $15,861
Interest Expense $217 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217 $217
Taxes Incurred ($65) ($166) ($297) $339 $629 $270 $488 $838 $1,651 $3,269 $3,546 $3,829
Net Profit ($152) ($499) ($891) $1,017 $1,886 $810 $1,464 $2,514 $4,953 $9,807 $10,639 $11,486
Net Profit/Sales 0.00% 0.00% -17.44% 17.00% 22.86% 8.16% 12.02% 15.72% 24.36% 36.07% 36.80% 37.47%
Pro Forma Cash Flow
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Cash Received
Cash from Operations
Cash Sales $0 $0 $1,686 $1,973 $2,723 $3,277 $4,019 $5,277 $6,709 $8,973 $9,540 $10,115
Cash from Receivables $0 $0 $0 $114 $3,443 $4,057 $5,565 $6,703 $8,246 $10,810 $13,774 $18,256
Subtotal Cash from Operations $0 $0 $1,686 $2,088 $6,166 $7,334 $9,584 $11,980 $14,955 $19,783 $23,315 $28,370
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 $10,700 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $0 $1,686 $2,088 $6,166 $7,334 $20,284 $11,980 $14,955 $19,783 $23,315 $28,370
Expenditures Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Expenditures from Operations
Cash Spending $0 $400 $4,140 $2,632 $3,624 $6,280 $6,680 $7,992 $9,000 $9,024 $9,248 $9,472
Bill Payments $5 $150 $147 $1,577 $2,045 $2,443 $2,579 $3,754 $5,184 $6,114 $8,051 $8,715
Subtotal Spent on Operations $5 $550 $4,287 $4,209 $5,669 $8,723 $9,259 $11,746 $14,184 $15,138 $17,299 $18,187
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 $5 $550 $4,287 $4,209 $5,669 $8,723 $9,259 $11,746 $14,184 $15,138 $17,299 $18,187
Net Cash Flow ($5) ($550) ($2,601) ($2,121) $497 ($1,389) $11,025 $234 $771 $4,645 $6,016 $10,183
Cash Balance $16,995 $16,445 $13,844 $11,723 $12,219 $10,830 $21,855 $22,089 $22,860 $27,505 $33,521 $43,704
Pro Forma Balance Sheet
Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Assets Starting Balances
Current Assets
Cash $17,000 $16,995 $16,445 $13,844 $11,723 $12,219 $10,830 $21,855 $22,089 $22,860 $27,505 $33,521 $43,704
Accounts Receivable $0 $0 $0 $3,424 $7,316 $9,401 $11,996 $14,592 $18,602 $23,977 $31,384 $36,980 $39,260
Other Current Assets $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650 $7,650
Total Current Assets $24,650 $24,645 $24,095 $24,918 $26,689 $29,270 $30,476 $44,097 $48,341 $54,487 $66,540 $78,151 $90,614
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $300 $600 $900 $1,200 $1,530 $1,860 $2,190 $2,520 $2,850 $3,180
Total Long-term Assets $0 $0 $0 ($300) ($600) ($900) ($1,200) ($1,530) ($1,860) ($2,190) ($2,520) ($2,850) ($3,180)
Total Assets $24,650 $24,645 $24,095 $24,618 $26,089 $28,370 $29,276 $42,567 $46,481 $52,297 $64,020 $75,301 $87,434
Liabilities and Capital Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Current Liabilities
Accounts Payable $0 $147 $95 $1,509 $1,964 $2,359 $2,456 $3,583 $4,982 $5,846 $7,761 $8,403 $9,050
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 $0 $147 $95 $1,509 $1,964 $2,359 $2,456 $3,583 $4,982 $5,846 $7,761 $8,403 $9,050
Long-term Liabilities $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000 $20,000
Total Liabilities $20,000 $20,147 $20,095 $21,509 $21,964 $22,359 $22,456 $23,583 $24,982 $25,846 $27,761 $28,403 $29,050
Paid-in Capital $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $7,300 $18,000 $18,000 $18,000 $18,000 $18,000 $18,000
Retained Earnings ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650) ($2,650)
Earnings $0 ($152) ($650) ($1,542) ($525) $1,361 $2,171 $3,635 $6,149 $11,101 $20,909 $31,548 $43,034
Total Capital $4,650 $4,498 $4,000 $3,108 $4,125 $6,011 $6,821 $18,985 $21,499 $26,451 $36,259 $46,898 $58,384
Total Liabilities and Capital $24,650 $24,645 $24,095 $24,618 $26,089 $28,370 $29,276 $42,567 $46,481 $52,297 $64,020 $75,301 $87,434
Net Worth $4,650 $4,498 $4,000 $3,108 $4,125 $6,011 $6,821 $18,985 $21,499 $26,451 $36,259 $46,898 $58,384