50% Discount on Business Plan Pro Premier Edition
Click here to buy now or call 0845 351 9924
 

Industry-specific Software Business Plan

Insurance Solutions, LLC

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
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
previous
next
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