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

Security Guard Business Plan

Batten-Hatchez Security

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
Security Guards £6,000 £10,800 £19,440 £34,992 £55,987 £78,382 £94,058 £96,880 £99,787 £102,780 £105,864 £109,040
Security Audits £500 £700 £980 £1,372 £1,921 £2,689 £3,765 £5,271 £7,379 £10,331 £14,463 £20,248
Commissions £0 £500 £700 £980 £1,372 £1,921 £2,689 £3,765 £5,271 £7,379 £10,331 £14,463
Total Sales £6,500 £12,000 £21,120 £37,344 £59,280 £82,992 £100,513 £105,916 £112,436 £120,490 £130,657 £143,750
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
Job Supplies £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
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
Chindit Batten £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Viipuri Hatchez £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Administrative/Call Center Assistants £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
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 £6,500 £12,000 £21,120 £37,344 £59,280 £82,992 £100,513 £105,916 £112,436 £120,490 £130,657 £143,750
Direct Cost of Sales £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
Security Guard Labor £3,575 £6,600 £11,616 £20,539 £32,604 £45,646 £55,282 £58,254 £61,840 £66,270 £71,861 £79,063
Total Cost of Sales £3,875 £7,140 £12,588 £22,289 £35,403 £49,565 £59,985 £63,098 £66,829 £71,409 £77,155 £84,515
Gross Margin £2,625 £4,860 £8,532 £15,055 £23,877 £33,427 £40,528 £42,818 £45,607 £49,082 £53,503 £59,236
Gross Margin % 40.38% 40.50% 40.40% 40.31% 40.28% 40.28% 40.32% 40.43% 40.56% 40.73% 40.95% 41.21%
Expenses
Payroll £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
Marketing/Promotion £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £2,000 £2,000 £2,000
Depreciation £28 £34 £39 £45 £50 £56 £61 £67 £72 £78 £84 £89
Rent £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Utilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Insurance £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Surety Bond £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Payroll Taxes 15% £1,136 £1,590 £2,342 £3,681 £5,491 £7,447 £9,492 £9,938 £10,476 £11,140 £11,979 £13,059
Employee Benefits 10% £758 £1,060 £1,562 £2,454 £3,660 £4,965 £6,328 £6,625 £6,984 £7,427 £7,986 £8,706
Training 15% £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Licenses and Permits £500 £600 £700 £700 £800 £800 £900 £900 £1,000 £1,000 £1,000 £8,000
Total Operating Expenses £10,422 £11,284 £12,643 £14,879 £18,001 £21,267 £28,782 £29,530 £30,532 £30,645 £32,049 £40,855
Profit Before Interest and Taxes (£7,797) (£6,424) (£4,111) £176 £5,875 £12,160 £11,746 £13,288 £15,075 £18,436 £21,454 £18,381
EBITDA (£7,769) (£6,390) (£4,072) £220 £5,926 £12,216 £11,807 £13,355 £15,147 £18,514 £21,537 £18,470
Interest Expense £60 £58 £55 £53 £50 £48 £45 £43 £40 £38 £35 £33
Taxes Incurred (£2,357) (£1,944) (£1,250) £37 £1,748 £3,634 £3,510 £3,974 £4,510 £5,520 £6,426 £5,505
Net Profit (£5,500) (£4,537) (£2,916) £86 £4,078 £8,479 £8,191 £9,272 £10,524 £12,879 £14,993 £12,844
Net Profit/Sales -84.61% -37.81% -13.81% 0.23% 6.88% 10.22% 8.15% 8.75% 9.36% 10.69% 11.48% 8.93%
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 £1,950 £3,600 £6,336 £11,203 £17,784 £24,898 £30,154 £31,775 £33,731 £36,147 £39,197 £43,125
Cash from Receivables £0 £2,427 £6,603 £11,805 £20,841 £34,330 £50,349 £64,635 £72,376 £76,575 £81,712 £88,139
Subtotal Cash from Operations £1,950 £6,027 £12,939 £23,008 £38,625 £59,228 £80,502 £96,410 £106,107 £112,723 £120,909 £131,264
Additional Cash Received
Sales Tax, VAT, HST/GST Received 7.00% £455 £840 £1,478 £2,614 £4,150 £5,809 £7,036 £7,414 £7,871 £8,434 £9,146 £10,063
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 £2,405 £6,867 £14,418 £25,622 £42,775 £65,037 £87,538 £103,824 £113,978 £121,157 £130,055 £141,326
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 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
Bill Payments £266 £8,123 £12,753 £20,438 £33,811 £51,796 £70,917 £84,405 £88,753 £94,029 £99,801 £108,088
Subtotal Spent on Operations £4,266 £12,123 £16,753 £24,438 £37,811 £55,796 £78,917 £92,405 £96,753 £102,029 £107,801 £116,088
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out £455 £840 £1,478 £2,614 £4,150 £5,809 £7,036 £7,414 £7,871 £8,434 £9,146 £10,063
Principal Repayment of Current Borrowing £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
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 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Dividends £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Spent £5,121 £13,363 £18,631 £27,452 £42,361 £62,005 £86,353 £100,219 £105,023 £110,864 £117,347 £126,551
Net Cash Flow (£2,716) (£6,496) (£4,214) (£1,830) £414 £3,032 £1,185 £3,606 £8,954 £10,293 £12,708 £14,775
Cash Balance £37,284 £30,788 £26,575 £24,745 £25,159 £28,191 £29,376 £32,982 £41,936 £52,229 £64,937 £79,712
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 £40,000 £37,284 £30,788 £26,575 £24,745 £25,159 £28,191 £29,376 £32,982 £41,936 £52,229 £64,937 £79,712
Accounts Receivable £0 £4,550 £10,523 £18,704 £33,040 £53,695 £77,459 £97,470 £106,975 £113,305 £121,072 £130,820 £143,307
Other Current Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Current Assets £40,000 £41,834 £41,312 £45,279 £57,785 £78,854 £105,650 £126,845 £139,957 £155,240 £173,301 £195,757 £223,019
Long-term Assets
Long-term Assets £1,000 £1,200 £1,400 £1,600 £1,800 £2,000 £2,200 £2,400 £2,600 £2,800 £3,000 £3,200 £3,400
Accumulated Depreciation £0 £28 £62 £101 £145 £196 £251 £313 £380 £452 £530 £614 £703
Total Long-term Assets £1,000 £1,172 £1,338 £1,499 £1,655 £1,804 £1,949 £2,087 £2,220 £2,348 £2,470 £2,586 £2,697
Total Assets £41,000 £43,006 £42,650 £46,778 £59,439 £80,658 £107,599 £128,933 £142,177 £157,588 £175,771 £198,343 £225,716
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 £7,706 £12,086 £19,331 £32,106 £49,447 £68,109 £81,452 £85,625 £90,712 £96,215 £103,995 £118,723
Current Borrowing £5,000 £4,800 £4,600 £4,400 £4,200 £4,000 £3,800 £3,600 £3,400 £3,200 £3,000 £2,800 £2,600
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £5,000 £12,506 £16,686 £23,731 £36,306 £53,447 £71,909 £85,052 £89,025 £93,912 £99,215 £106,795 £121,323
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £5,000 £12,506 £16,686 £23,731 £36,306 £53,447 £71,909 £85,052 £89,025 £93,912 £99,215 £106,795 £121,323
Paid-in Capital £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700
Retained Earnings (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700)
Earnings £0 (£5,500) (£10,036) (£12,953) (£12,866) (£8,789) (£310) £7,881 £17,153 £27,677 £40,556 £55,549 £68,393
Total Capital £36,000 £30,500 £25,964 £23,047 £23,134 £27,211 £35,690 £43,881 £53,153 £63,677 £76,556 £91,549 £104,393
Total Liabilities and Capital £41,000 £43,006 £42,650 £46,778 £59,439 £80,658 £107,599 £128,933 £142,177 £157,588 £175,771 £198,343 £225,716
Net Worth £36,000 £30,500 £25,964 £23,047 £23,134 £27,211 £35,690 £43,881 £53,153 £63,677 £76,556 £91,549 £104,393
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
Security Guards £6,000 £10,800 £19,440 £34,992 £55,987 £78,382 £94,058 £96,880 £99,787 £102,780 £105,864 £109,040
Security Audits £500 £700 £980 £1,372 £1,921 £2,689 £3,765 £5,271 £7,379 £10,331 £14,463 £20,248
Commissions £0 £500 £700 £980 £1,372 £1,921 £2,689 £3,765 £5,271 £7,379 £10,331 £14,463
Total Sales £6,500 £12,000 £21,120 £37,344 £59,280 £82,992 £100,513 £105,916 £112,436 £120,490 £130,657 £143,750
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
Job Supplies £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
Other £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Direct Cost of Sales £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
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
Chindit Batten £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Viipuri Hatchez £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000
Administrative/Call Center Assistants £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total People 2 2 2 2 2 2 2 2 2 2 2 2
Total Payroll £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
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 £6,500 £12,000 £21,120 £37,344 £59,280 £82,992 £100,513 £105,916 £112,436 £120,490 £130,657 £143,750
Direct Cost of Sales £300 £540 £972 £1,750 £2,799 £3,919 £4,703 £4,844 £4,989 £5,139 £5,293 £5,452
Security Guard Labor £3,575 £6,600 £11,616 £20,539 £32,604 £45,646 £55,282 £58,254 £61,840 £66,270 £71,861 £79,063
Total Cost of Sales £3,875 £7,140 £12,588 £22,289 £35,403 £49,565 £59,985 £63,098 £66,829 £71,409 £77,155 £84,515
Gross Margin £2,625 £4,860 £8,532 £15,055 £23,877 £33,427 £40,528 £42,818 £45,607 £49,082 £53,503 £59,236
Gross Margin % 40.38% 40.50% 40.40% 40.31% 40.28% 40.28% 40.32% 40.43% 40.56% 40.73% 40.95% 41.21%
Expenses
Payroll £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
Marketing/Promotion £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £3,000 £2,000 £2,000 £2,000
Depreciation £28 £34 £39 £45 £50 £56 £61 £67 £72 £78 £84 £89
Rent £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Utilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Insurance £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400 £400
Surety Bond £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Payroll Taxes 15% £1,136 £1,590 £2,342 £3,681 £5,491 £7,447 £9,492 £9,938 £10,476 £11,140 £11,979 £13,059
Employee Benefits 10% £758 £1,060 £1,562 £2,454 £3,660 £4,965 £6,328 £6,625 £6,984 £7,427 £7,986 £8,706
Training 15% £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500 £500
Licenses and Permits £500 £600 £700 £700 £800 £800 £900 £900 £1,000 £1,000 £1,000 £8,000
Total Operating Expenses £10,422 £11,284 £12,643 £14,879 £18,001 £21,267 £28,782 £29,530 £30,532 £30,645 £32,049 £40,855
Profit Before Interest and Taxes (£7,797) (£6,424) (£4,111) £176 £5,875 £12,160 £11,746 £13,288 £15,075 £18,436 £21,454 £18,381
EBITDA (£7,769) (£6,390) (£4,072) £220 £5,926 £12,216 £11,807 £13,355 £15,147 £18,514 £21,537 £18,470
Interest Expense £60 £58 £55 £53 £50 £48 £45 £43 £40 £38 £35 £33
Taxes Incurred (£2,357) (£1,944) (£1,250) £37 £1,748 £3,634 £3,510 £3,974 £4,510 £5,520 £6,426 £5,505
Net Profit (£5,500) (£4,537) (£2,916) £86 £4,078 £8,479 £8,191 £9,272 £10,524 £12,879 £14,993 £12,844
Net Profit/Sales -84.61% -37.81% -13.81% 0.23% 6.88% 10.22% 8.15% 8.75% 9.36% 10.69% 11.48% 8.93%
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 £1,950 £3,600 £6,336 £11,203 £17,784 £24,898 £30,154 £31,775 £33,731 £36,147 £39,197 £43,125
Cash from Receivables £0 £2,427 £6,603 £11,805 £20,841 £34,330 £50,349 £64,635 £72,376 £76,575 £81,712 £88,139
Subtotal Cash from Operations £1,950 £6,027 £12,939 £23,008 £38,625 £59,228 £80,502 £96,410 £106,107 £112,723 £120,909 £131,264
Additional Cash Received
Sales Tax, VAT, HST/GST Received 7.00% £455 £840 £1,478 £2,614 £4,150 £5,809 £7,036 £7,414 £7,871 £8,434 £9,146 £10,063
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 £2,405 £6,867 £14,418 £25,622 £42,775 £65,037 £87,538 £103,824 £113,978 £121,157 £130,055 £141,326
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 £4,000 £4,000 £4,000 £4,000 £4,000 £4,000 £8,000 £8,000 £8,000 £8,000 £8,000 £8,000
Bill Payments £266 £8,123 £12,753 £20,438 £33,811 £51,796 £70,917 £84,405 £88,753 £94,029 £99,801 £108,088
Subtotal Spent on Operations £4,266 £12,123 £16,753 £24,438 £37,811 £55,796 £78,917 £92,405 £96,753 £102,029 £107,801 £116,088
Additional Cash Spent
Sales Tax, VAT, HST/GST Paid Out £455 £840 £1,478 £2,614 £4,150 £5,809 £7,036 £7,414 £7,871 £8,434 £9,146 £10,063
Principal Repayment of Current Borrowing £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
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 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200 £200
Dividends £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Spent £5,121 £13,363 £18,631 £27,452 £42,361 £62,005 £86,353 £100,219 £105,023 £110,864 £117,347 £126,551
Net Cash Flow (£2,716) (£6,496) (£4,214) (£1,830) £414 £3,032 £1,185 £3,606 £8,954 £10,293 £12,708 £14,775
Cash Balance £37,284 £30,788 £26,575 £24,745 £25,159 £28,191 £29,376 £32,982 £41,936 £52,229 £64,937 £79,712
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 £40,000 £37,284 £30,788 £26,575 £24,745 £25,159 £28,191 £29,376 £32,982 £41,936 £52,229 £64,937 £79,712
Accounts Receivable £0 £4,550 £10,523 £18,704 £33,040 £53,695 £77,459 £97,470 £106,975 £113,305 £121,072 £130,820 £143,307
Other Current Assets £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Current Assets £40,000 £41,834 £41,312 £45,279 £57,785 £78,854 £105,650 £126,845 £139,957 £155,240 £173,301 £195,757 £223,019
Long-term Assets
Long-term Assets £1,000 £1,200 £1,400 £1,600 £1,800 £2,000 £2,200 £2,400 £2,600 £2,800 £3,000 £3,200 £3,400
Accumulated Depreciation £0 £28 £62 £101 £145 £196 £251 £313 £380 £452 £530 £614 £703
Total Long-term Assets £1,000 £1,172 £1,338 £1,499 £1,655 £1,804 £1,949 £2,087 £2,220 £2,348 £2,470 £2,586 £2,697
Total Assets £41,000 £43,006 £42,650 £46,778 £59,439 £80,658 £107,599 £128,933 £142,177 £157,588 £175,771 £198,343 £225,716
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 £7,706 £12,086 £19,331 £32,106 £49,447 £68,109 £81,452 £85,625 £90,712 £96,215 £103,995 £118,723
Current Borrowing £5,000 £4,800 £4,600 £4,400 £4,200 £4,000 £3,800 £3,600 £3,400 £3,200 £3,000 £2,800 £2,600
Other Current Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Subtotal Current Liabilities £5,000 £12,506 £16,686 £23,731 £36,306 £53,447 £71,909 £85,052 £89,025 £93,912 £99,215 £106,795 £121,323
Long-term Liabilities £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Liabilities £5,000 £12,506 £16,686 £23,731 £36,306 £53,447 £71,909 £85,052 £89,025 £93,912 £99,215 £106,795 £121,323
Paid-in Capital £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700 £72,700
Retained Earnings (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700) (£36,700)
Earnings £0 (£5,500) (£10,036) (£12,953) (£12,866) (£8,789) (£310) £7,881 £17,153 £27,677 £40,556 £55,549 £68,393
Total Capital £36,000 £30,500 £25,964 £23,047 £23,134 £27,211 £35,690 £43,881 £53,153 £63,677 £76,556 £91,549 £104,393
Total Liabilities and Capital £41,000 £43,006 £42,650 £46,778 £59,439 £80,658 £107,599 £128,933 £142,177 £157,588 £175,771 £198,343 £225,716
Net Worth £36,000 £30,500 £25,964 £23,047 £23,134 £27,211 £35,690 £43,881 £53,153 £63,677 £76,556 £91,549 £104,393