Our biggest savings of the year
Insurance Solutions, LLC
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 |