Everywhere Assistant

Start your own business plan »

Administrative Service Business Plan

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
Companies 0% $200 $325 $450 $500 $625 $745 $780 $850 $925 $1,154 $1,345 $1,515
Not for profit organizations 0% $122 $198 $275 $305 $381 $454 $476 $519 $564 $704 $820 $924
Individuals 0% $108 $176 $243 $270 $338 $402 $421 $459 $500 $623 $726 $818
Total Sales $430 $699 $968 $1,075 $1,344 $1,602 $1,677 $1,828 $1,989 $2,481 $2,892 $3,257
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
Companies $10 $16 $23 $25 $31 $37 $39 $43 $46 $58 $67 $76
Not for profit organizations $6 $10 $14 $15 $19 $23 $24 $26 $28 $35 $41 $46
Individuals $5 $9 $12 $14 $17 $20 $21 $23 $25 $31 $36 $41
Subtotal Direct Cost of Sales $22 $35 $48 $54 $67 $80 $84 $91 $99 $124 $145 $163
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
Sadie 0% $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
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 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
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 $430 $699 $968 $1,075 $1,344 $1,602 $1,677 $1,828 $1,989 $2,481 $2,892 $3,257
Direct Cost of Sales $22 $35 $48 $54 $67 $80 $84 $91 $99 $124 $145 $163
Other Costs of Sales $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $22 $35 $48 $54 $67 $80 $84 $91 $99 $124 $145 $163
Gross Margin $409 $664 $919 $1,021 $1,277 $1,522 $1,593 $1,736 $1,889 $2,357 $2,747 $3,094
Gross Margin % 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00% 95.00%
Expenses
Payroll $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Sales and Marketing and Other Expenses $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Depreciation $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117 $117
Rent $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Utilities $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Insurance $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50 $50
Payroll Taxes 15% $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300 $300
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767 $2,767
Profit Before Interest and Taxes ($2,359) ($2,103) ($1,848) ($1,746) ($1,490) ($1,245) ($1,174) ($1,031) ($878) ($410) ($20) $327
EBITDA ($2,242) ($1,986) ($1,731) ($1,629) ($1,373) ($1,128) ($1,057) ($914) ($761) ($293) $97 $444
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Net Profit ($2,359) ($2,103) ($1,848) ($1,746) ($1,490) ($1,245) ($1,174) ($1,031) ($878) ($410) ($20) $327
Net Profit/Sales -548.49% -300.99% -190.99% -162.40% -110.92% -77.75% -70.00% -56.41% -44.13% -16.52% -0.69% 10.05%
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 $108 $175 $242 $269 $336 $400 $419 $457 $497 $620 $723 $814
Cash from Receivables $0 $11 $329 $531 $728 $813 $1,014 $1,203 $1,262 $1,375 $1,504 $1,871
Subtotal Cash from Operations $108 $185 $571 $800 $1,064 $1,213 $1,434 $1,660 $1,759 $1,995 $2,227 $2,685
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 $108 $185 $571 $800 $1,064 $1,213 $1,434 $1,660 $1,759 $1,995 $2,227 $2,685
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 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Bill Payments $22 $672 $685 $699 $704 $718 $730 $734 $742 $750 $775 $795
Subtotal Spent on Operations $2,022 $2,672 $2,685 $2,699 $2,704 $2,718 $2,730 $2,734 $2,742 $2,750 $2,775 $2,795
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 $2,022 $2,672 $2,685 $2,699 $2,704 $2,718 $2,730 $2,734 $2,742 $2,750 $2,775 $2,795
Net Cash Flow ($1,915) ($2,487) ($2,114) ($1,899) ($1,640) ($1,504) ($1,297) ($1,074) ($983) ($755) ($548) ($110)
Cash Balance $14,885 $12,399 $10,284 $8,385 $6,745 $5,241 $3,944 $2,870 $1,887 $1,132 $584 $474
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 $16,800 $14,885 $12,399 $10,284 $8,385 $6,745 $5,241 $3,944 $2,870 $1,887 $1,132 $584 $474
Accounts Receivable $0 $323 $836 $1,232 $1,508 $1,787 $2,176 $2,419 $2,586 $2,817 $3,303 $3,968 $4,539
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $16,800 $15,208 $13,234 $11,517 $9,893 $8,533 $7,417 $6,363 $5,457 $4,704 $4,435 $4,552 $5,014
Long-term Assets
Long-term Assets $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000 $7,000
Accumulated Depreciation $0 $117 $234 $351 $468 $585 $702 $819 $936 $1,053 $1,170 $1,287 $1,404
Total Long-term Assets $7,000 $6,883 $6,766 $6,649 $6,532 $6,415 $6,298 $6,181 $6,064 $5,947 $5,830 $5,713 $5,596
Total Assets $23,800 $22,091 $20,000 $18,166 $16,425 $14,948 $13,715 $12,544 $11,521 $10,651 $10,265 $10,265 $10,610
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 $649 $662 $675 $680 $693 $706 $709 $717 $724 $748 $768 $786
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 $649 $662 $675 $680 $693 $706 $709 $717 $724 $748 $768 $786
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $649 $662 $675 $680 $693 $706 $709 $717 $724 $748 $768 $786
Paid-in Capital $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000 $30,000
Retained Earnings ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200) ($6,200)
Earnings $0 ($2,359) ($4,462) ($6,310) ($8,055) ($9,546) ($10,791) ($11,965) ($12,996) ($13,874) ($14,283) ($14,303) ($13,976)
Total Capital $23,800 $21,442 $19,338 $17,490 $15,745 $14,254 $13,009 $11,835 $10,804 $9,927 $9,517 $9,497 $9,824
Total Liabilities and Capital $23,800 $22,091 $20,000 $18,166 $16,425 $14,948 $13,715 $12,544 $11,521 $10,651 $10,265 $10,265 $10,610
Net Worth $23,800 $21,442 $19,338 $17,490 $15,745 $14,254 $13,009 $11,835 $10,804 $9,926 $9,517 $9,497 $9,824