Shaw's Records Management and Data Storage

Start your own business plan »

Document Storage 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
Storage 0% $0 $15,000 $20,000 $27,000 $36,000 $43,000 $50,000 $50,000 $60,000 $65,000 $70,000 $70,000
Storage Materials 0% $0 $2,000 $3,000 $5,000 $8,000 $10,000 $13,000 $15,000 $18,000 $20,000 $23,000 $21,000
Other 0% $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Sales $0 $17,000 $23,000 $32,000 $44,000 $53,000 $63,000 $65,000 $78,000 $85,000 $93,000 $91,000
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
Storage $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Storage Materials $0 $1,000 $1,500 $2,500 $4,000 $5,000 $6,500 $7,500 $9,000 $10,000 $11,500 $1,050
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Subtotal Direct Cost of Sales $0 $1,000 $1,500 $2,500 $4,000 $5,000 $6,500 $7,500 $9,000 $10,000 $11,500 $1,050
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
Martin Shaw 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Facility Manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Security Manager 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
Customer Service Manager 0% $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
Facility Staff 0% $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Security Staff 0% $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200 $3,200
Customer Service Staff 0% $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400 $3,400
Sales Staff 0% $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000 $6,000
Total People 14 14 14 14 14 14 14 14 14 14 14 14
Total Payroll $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100
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 $0 $17,000 $23,000 $32,000 $44,000 $53,000 $63,000 $65,000 $78,000 $85,000 $93,000 $91,000
Direct Cost of Sales $0 $1,000 $1,500 $2,500 $4,000 $5,000 $6,500 $7,500 $9,000 $10,000 $11,500 $1,050
Other Production Expenses $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $1,000 $1,500 $2,500 $4,000 $5,000 $6,500 $7,500 $9,000 $10,000 $11,500 $1,050
Gross Margin $0 $16,000 $21,500 $29,500 $40,000 $48,000 $56,500 $57,500 $69,000 $75,000 $81,500 $89,950
Gross Margin % 0.00% 94.12% 93.48% 92.19% 90.91% 90.57% 89.68% 88.46% 88.46% 88.24% 87.63% 98.85%
Expenses
Payroll $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100
Sales and Marketing and Other Expenses $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000 $3,000
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 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Insurance $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000 $1,000
Rent $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Payroll Taxes 15% $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815 $4,815
Other $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Operating Expenses $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915 $46,915
Profit Before Interest and Taxes ($46,915) ($30,915) ($25,415) ($17,415) ($6,915) $1,085 $9,585 $10,585 $22,085 $28,085 $34,585 $43,035
EBITDA ($46,915) ($30,915) ($25,415) ($17,415) ($6,915) $1,085 $9,585 $10,585 $22,085 $28,085 $34,585 $43,035
Interest Expense $1,229 $1,208 $1,188 $1,167 $1,146 $1,125 $1,104 $1,083 $1,063 $1,042 $1,021 $1,000
Taxes Incurred ($14,443) ($9,637) ($7,981) ($5,575) ($2,418) ($12) $2,544 $2,850 $6,307 $8,113 $10,069 $12,611
Net Profit ($33,701) ($22,486) ($18,622) ($13,007) ($5,643) ($28) $5,937 $6,651 $14,716 $18,930 $23,495 $29,425
Net Profit/Sales 0.00% -132.27% -80.96% -40.65% -12.82% -0.05% 9.42% 10.23% 18.87% 22.27% 25.26% 32.33%
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 $4,250 $5,750 $8,000 $11,000 $13,250 $15,750 $16,250 $19,500 $21,250 $23,250 $22,750
Cash from Receivables $0 $0 $425 $12,900 $17,475 $24,300 $33,225 $40,000 $47,300 $49,075 $58,675 $63,950
Subtotal Cash from Operations $0 $4,250 $6,175 $20,900 $28,475 $37,550 $48,975 $56,250 $66,800 $70,325 $81,925 $86,700
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 $15,000 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $4,250 $6,175 $20,900 $28,475 $52,550 $48,975 $56,250 $66,800 $70,325 $81,925 $86,700
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 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100 $32,100
Bill Payments $53 $1,794 $7,458 $9,635 $13,062 $17,655 $21,063 $25,006 $26,413 $31,277 $34,084 $37,141
Subtotal Spent on Operations $32,153 $33,894 $39,558 $41,735 $45,162 $49,755 $53,163 $57,106 $58,513 $63,377 $66,184 $69,241
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 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500 $2,500
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 $34,653 $36,394 $42,058 $44,235 $47,662 $52,255 $55,663 $59,606 $61,013 $65,877 $68,684 $71,741
Net Cash Flow ($34,653) ($32,144) ($35,883) ($23,335) ($19,187) $295 ($6,688) ($3,356) $5,787 $4,448 $13,241 $14,959
Cash Balance $122,747 $90,603 $54,720 $31,386 $12,199 $12,494 $5,806 $2,450 $8,237 $12,684 $25,925 $40,884
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 $157,400 $122,747 $90,603 $54,720 $31,386 $12,199 $12,494 $5,806 $2,450 $8,237 $12,684 $25,925 $40,884
Accounts Receivable $0 $0 $12,750 $29,575 $40,675 $56,200 $71,650 $85,675 $94,425 $105,625 $120,300 $131,375 $135,675
Other Current Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Current Assets $157,400 $122,747 $103,353 $84,295 $72,061 $68,399 $84,144 $91,481 $96,875 $113,862 $132,984 $157,300 $176,559
Long-term Assets
Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Accumulated Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Long-term Assets $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Assets $157,400 $122,747 $103,353 $84,295 $72,061 $68,399 $84,144 $91,481 $96,875 $113,862 $132,984 $157,300 $176,559
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 $1,548 $7,140 $9,204 $12,477 $16,958 $20,230 $24,131 $25,374 $30,145 $32,837 $36,158 $28,493
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 $1,548 $7,140 $9,204 $12,477 $16,958 $20,230 $24,131 $25,374 $30,145 $32,837 $36,158 $28,493
Long-term Liabilities $150,000 $147,500 $145,000 $142,500 $140,000 $137,500 $135,000 $132,500 $130,000 $127,500 $125,000 $122,500 $120,000
Total Liabilities $150,000 $149,048 $152,140 $151,704 $152,477 $154,458 $155,230 $156,631 $155,374 $157,645 $157,837 $158,658 $148,493
Paid-in Capital $350,000 $350,000 $350,000 $350,000 $350,000 $350,000 $365,000 $365,000 $365,000 $365,000 $365,000 $365,000 $365,000
Retained Earnings ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600) ($342,600)
Earnings $0 ($33,701) ($56,187) ($74,809) ($87,816) ($93,459) ($93,487) ($87,550) ($80,899) ($66,183) ($47,253) ($23,758) $5,666
Total Capital $7,400 ($26,301) ($48,787) ($67,409) ($80,416) ($86,059) ($71,087) ($65,150) ($58,499) ($43,783) ($24,853) ($1,358) $28,066
Total Liabilities and Capital $157,400 $122,747 $103,353 $84,295 $72,061 $68,399 $84,144 $91,481 $96,875 $113,862 $132,984 $157,300 $176,559
Net Worth $7,400 ($26,301) ($48,787) ($67,409) ($80,416) ($86,059) ($71,087) ($65,150) ($58,499) ($43,783) ($24,853) ($1,358) $28,067