Insurance Solutions, LLC

Start your own business plan »

Industry-specific Software 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
IV-Consumer 0% $0 $20,000 $25,000 $31,250 $39,063 $48,828 $61,035 $75,000 $85,000 $92,000 $100,000 $130,000
IV - Insurance 0% $0 $0 $100,000 $0 $100,000 $0 $0 $100,000 $0 $100,000 $0 $100,000
IV - Small Business Lenders 0% $0 $0 $0 $0 $0 $0 $0 $100,000 $0 $100,000 $0 $100,000
IV - Mortgage Providers 0% $0 $0 $0 $0 $0 $0 $0 $100,000 $0 $0 $100,000 $100,000
Maintenance Contracts 20% $0 $4,000 $25,000 $6,250 $27,813 $9,766 $12,207 $75,000 $17,000 $58,400 $40,000 $86,000
Documents Plus 0% $0 $20,000 $22,000 $24,200 $26,520 $29,282 $32,210 $35,431 $38,974 $42,872 $47,159 $51,875
Total Sales $0 $44,000 $172,000 $61,700 $193,395 $87,876 $105,452 $485,431 $140,974 $393,272 $287,159 $567,875
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
CD-ROM Production $0 $1,320 $5,160 $1,851 $5,802 $2,636 $3,164 $14,563 $4,229 $11,798 $8,615 $17,036
Packaging and Shipping $0 $2,200 $8,600 $3,085 $9,670 $4,394 $5,273 $24,272 $7,049 $19,664 $14,358 $28,394
Subtotal Direct Cost of Sales $0 $3,520 $13,760 $4,936 $15,472 $7,030 $8,436 $38,834 $11,278 $31,462 $22,973 $45,430
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
Hugh Lloyd-Thomas CEO 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Mark Purowitz COO 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Mark Metcalf, CIO 0% $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000 $10,000
Administrative Assistant 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Operations Support 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
Technical Assistant 0% $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000 $5,000
HR & Operations Manager 0% $0 $0 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500 $7,500
Sales Staff 0% $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400 $10,400
Total People 8 8 9 9 9 9 9 9 9 9 9 9
Total Payroll $55,400 $55,400 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900
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 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 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50% 6.50%
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 $44,000 $172,000 $61,700 $193,395 $87,876 $105,452 $485,431 $140,974 $393,272 $287,159 $567,875
Direct Cost of Sales $0 $3,520 $13,760 $4,936 $15,472 $7,030 $8,436 $38,834 $11,278 $31,462 $22,973 $45,430
Other Costs of Goods $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Cost of Sales $0 $3,520 $13,760 $4,936 $15,472 $7,030 $8,436 $38,834 $11,278 $31,462 $22,973 $45,430
Gross Margin $0 $40,480 $158,240 $56,764 $177,923 $80,846 $97,016 $446,597 $129,696 $361,810 $264,186 $522,445
Gross Margin % 0.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00% 92.00%
Expenses
Payroll $55,400 $55,400 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900
Marketing/Promotion $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000 $8,000
Depreciation $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Rent $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Web Services Hosting $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000 $4,000
Travel $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000 $2,000
Stationary and Postage $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100 $100
Legal Advisory Services $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900 $900
Accounting/Tax Advisor $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Property Data Access License Fee $0 $0 $0 $25,000 $0 $0 $25,000 $0 $0 $25,000 $0 $0
Software Distribution License Fee $0 $0 $25,000 $0 $0 $25,000 $0 $0 $25,000 $0 $0 $0
Utilities $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150 $150
Insurance $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200 $200
Payroll Taxes 25% $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
Total Operating Expenses $72,950 $72,950 $105,450 $105,450 $80,450 $105,450 $105,450 $80,450 $105,450 $105,450 $80,450 $80,450
Profit Before Interest and Taxes ($72,950) ($32,470) $52,790 ($48,686) $97,473 ($24,604) ($8,434) $366,147 $24,246 $256,360 $183,736 $441,995
EBITDA ($72,950) ($32,470) $52,790 ($48,686) $97,473 ($24,604) ($8,434) $366,147 $24,246 $256,360 $183,736 $441,995
Interest Expense $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Taxes Incurred ($21,885) ($9,741) $15,837 ($14,606) $29,242 ($7,381) ($2,530) $109,844 $7,274 $76,908 $55,121 $132,599
Net Profit ($51,065) ($22,729) $36,953 ($34,080) $68,231 ($17,223) ($5,904) $256,303 $16,972 $179,452 $128,615 $309,397
Net Profit/Sales 0.00% -51.66% 21.48% -55.24% 35.28% -19.60% -5.60% 52.80% 12.04% 45.63% 44.79% 54.48%
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 $44,000 $172,000 $61,700 $193,395 $87,876 $105,452 $485,431 $140,974 $393,272 $287,159 $567,875
Subtotal Cash from Operations $0 $44,000 $172,000 $61,700 $193,395 $87,876 $105,452 $485,431 $140,974 $393,272 $287,159 $567,875
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 $1,000,000 $0 $0 $0 $0 $0 $0 $0
Subtotal Cash Received $0 $44,000 $172,000 $61,700 $1,193,395 $87,876 $105,452 $485,431 $140,974 $393,272 $287,159 $567,875
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 $55,400 $55,400 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900 $62,900
Bill Payments ($4,335) ($3,813) $13,356 $70,838 $33,860 $61,595 $42,407 $52,382 $162,724 $64,096 $149,077 $98,975
Subtotal Spent on Operations $51,065 $51,587 $76,256 $133,738 $96,760 $124,495 $105,307 $115,282 $225,624 $126,996 $211,977 $161,875
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 $50,000 $0 $50,000 $0 $50,000 $0 $50,000
Subtotal Cash Spent $51,065 $51,587 $76,256 $133,738 $96,760 $174,495 $105,307 $165,282 $225,624 $176,996 $211,977 $211,875
Net Cash Flow ($51,065) ($7,587) $95,744 ($72,038) $1,096,635 ($86,619) $145 $320,149 ($84,650) $216,276 $75,182 $356,000
Cash Balance $52,935 $45,348 $141,092 $69,053 $1,165,689 $1,079,070 $1,079,215 $1,399,364 $1,314,714 $1,530,990 $1,606,172 $1,962,172
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 $104,000 $52,935 $45,348 $141,092 $69,053 $1,165,689 $1,079,070 $1,079,215 $1,399,364 $1,314,714 $1,530,990 $1,606,172 $1,962,172
Other Current Assets $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000 $15,000
Total Current Assets $119,000 $67,935 $60,348 $156,092 $84,053 $1,180,689 $1,094,070 $1,094,215 $1,414,364 $1,329,714 $1,545,990 $1,621,172 $1,977,172
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 $119,000 $67,935 $60,348 $156,092 $84,053 $1,180,689 $1,094,070 $1,094,215 $1,414,364 $1,329,714 $1,545,990 $1,621,172 $1,977,172
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 $0 $15,142 $73,933 $35,975 $64,379 $44,983 $51,031 $164,878 $63,256 $150,080 $96,646 $193,250
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 $0 $15,142 $73,933 $35,975 $64,379 $44,983 $51,031 $164,878 $63,256 $150,080 $96,646 $193,250
Long-term Liabilities $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0 $0
Total Liabilities $0 $0 $15,142 $73,933 $35,975 $64,379 $44,983 $51,031 $164,878 $63,256 $150,080 $96,646 $193,250
Paid-in Capital $292,250 $292,250 $292,250 $292,250 $292,250 $1,292,250 $1,292,250 $1,292,250 $1,292,250 $1,292,250 $1,292,250 $1,292,250 $1,292,250
Retained Earnings ($173,250) ($173,250) ($173,250) ($173,250) ($173,250) ($173,250) ($223,250) ($223,250) ($273,250) ($273,250) ($323,250) ($323,250) ($373,250)
Earnings $0 ($51,065) ($73,794) ($36,841) ($70,921) ($2,690) ($19,913) ($25,817) $230,486 $247,458 $426,910 $555,526 $864,922
Total Capital $119,000 $67,935 $45,206 $82,159 $48,079 $1,116,310 $1,049,087 $1,043,183 $1,249,486 $1,266,458 $1,395,910 $1,524,526 $1,783,922
Total Liabilities and Capital $119,000 $67,935 $60,348 $156,092 $84,053 $1,180,689 $1,094,070 $1,094,215 $1,414,364 $1,329,714 $1,545,990 $1,621,172 $1,977,172
Net Worth $119,000 $67,935 $45,206 $82,159 $48,079 $1,116,310 $1,049,087 $1,043,183 $1,249,486 $1,266,458 $1,395,910 $1,524,526 $1,783,922