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

Photography Studio Business Plan

Phoebe's Photo Studio

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
Unit Sales
Portraits 0% 4 8 12 20 24 24 20 20 48 48 36 36
Family Photos On-Site 0% 1 2 3 4 5 5 5 6 12 24 18 24
Weddings 0% 0 0 1 2 4 5 4 4 4 4 2 2
Total Unit Sales 5 10 16 26 33 34 29 30 64 76 56 62
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Portraits £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00
Family Photos On-Site £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00
Weddings £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00
Sales
Portraits £400 £800 £1,200 £2,000 £2,400 £2,400 £2,000 £2,000 £4,800 £4,800 £3,600 £3,600
Family Photos On-Site £200 £400 £600 £800 £1,000 £1,000 £1,000 £1,200 £2,400 £4,800 £3,600 £4,800
Weddings £0 £0 £2,500 £5,000 £10,000 £12,500 £10,000 £10,000 £10,000 £10,000 £5,000 £5,000
Total Sales £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Portraits 10.00% £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00
Family Photos On-Site 10.00% £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00
Weddings 20.00% £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00
Direct Cost of Sales
Portraits £40 £80 £120 £200 £240 £240 £200 £200 £480 £480 £360 £360
Family Photos On-Site £20 £40 £60 £80 £100 £100 £100 £120 £240 £480 £360 £480
Weddings £0 £0 £500 £1,000 £2,000 £2,500 £2,000 £2,000 £2,000 £2,000 £1,000 £1,000
Subtotal Direct Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
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
Owner 0% £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Employee 0% £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
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 £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Direct Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
Gross Margin £540 £1,080 £3,620 £6,520 £11,060 £13,060 £10,700 £10,880 £14,480 £16,640 £10,480 £11,560
Gross Margin % 90.00% 90.00% 84.19% 83.59% 82.54% 82.14% 82.31% 82.42% 84.19% 84.90% 85.90% 86.27%
Expenses
Payroll £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
Marketing/Promotion £1,000 £1,000 £1,000 £1,000 £1,000 £300 £300 £300 £300 £300 £300 £300
Depreciation £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330
Rent £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800
Utilities £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Maintenance of Cameras and Equipment £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50
Offsite file backups and support £60 £60 £60 £60 £60 £60 £60 £60 £60 £60 £60 £60
Software upgrades £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Insurance £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25
Payroll Taxes 15% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Total Operating Expenses £6,965 £6,965 £6,965 £6,965 £6,965 £6,265 £6,265 £6,265 £6,265 £6,265 £6,265 £6,265
Profit Before Interest and Taxes (£6,425) (£5,885) (£3,345) (£445) £4,095 £6,795 £4,435 £4,615 £8,215 £10,375 £4,215 £5,295
EBITDA (£5,095) (£4,555) (£2,015) £885 £5,425 £8,125 £5,765 £5,945 £9,545 £11,705 £5,545 £6,625
Interest Expense £825 £817 £809 £801 £793 £785 £777 £769 £761 £753 £745 £737
Taxes Incurred (£2,175) (£2,011) (£1,246) (£374) £990 £1,803 £1,097 £1,154 £2,236 £2,886 £1,041 £1,367
Net Profit (£5,075) (£4,692) (£2,908) (£872) £2,311 £4,207 £2,560 £2,692 £5,218 £6,735 £2,429 £3,190
Net Profit/Sales -845.87% -390.97% -67.63% -11.19% 17.25% 26.46% 19.70% 20.39% 30.33% 34.36% 19.91% 23.81%
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 £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Subtotal Cash from Operations £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
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 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
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 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
Bill Payments £28 £852 £1,106 £2,427 £3,923 £6,279 £6,821 £5,612 £5,727 £7,182 £7,932 £4,956
Subtotal Spent on Operations £3,528 £4,352 £4,606 £5,927 £7,423 £9,779 £10,321 £9,112 £9,227 £10,682 £11,432 £8,456
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 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960
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 £4,488 £5,312 £5,566 £6,887 £8,383 £10,739 £11,281 £10,072 £10,187 £11,642 £12,392 £9,416
Net Cash Flow (£3,888) (£4,112) (£1,266) £913 £5,017 £5,161 £1,719 £3,128 £7,013 £7,958 (£192) £3,984
Cash Balance £6,882 £2,769 £1,504 £2,417 £7,434 £12,595 £14,314 £17,442 £24,455 £32,413 £32,221 £36,205
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 £10,770 £6,882 £2,769 £1,504 £2,417 £7,434 £12,595 £14,314 £17,442 £24,455 £32,413 £32,221 £36,205
Other Current Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Total Current Assets £20,770 £16,882 £12,769 £11,504 £12,417 £17,434 £22,595 £24,314 £27,442 £34,455 £42,413 £42,221 £46,205
Long-term Assets
Long-term Assets £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500
Accumulated Depreciation £0 £1,330 £2,660 £3,990 £5,320 £6,650 £7,980 £9,310 £10,640 £11,970 £13,300 £14,630 £15,960
Total Long-term Assets £60,500 £59,170 £57,840 £56,510 £55,180 £53,850 £52,520 £51,190 £49,860 £48,530 £47,200 £45,870 £44,540
Total Assets £81,270 £76,052 £70,609 £68,014 £67,597 £71,284 £75,115 £75,504 £77,302 £82,985 £89,613 £88,091 £90,745
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 £817 £1,026 £2,299 £3,714 £6,050 £6,634 £5,423 £5,489 £6,914 £7,767 £4,777 £5,200
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 £817 £1,026 £2,299 £3,714 £6,050 £6,634 £5,423 £5,489 £6,914 £7,767 £4,777 £5,200
Long-term Liabilities £100,000 £99,040 £98,080 £97,120 £96,160 £95,200 £94,240 £93,280 £92,320 £91,360 £90,400 £89,440 £88,480
Total Liabilities £100,000 £99,857 £99,106 £99,419 £99,874 £101,250 £100,874 £98,703 £97,809 £98,274 £98,167 £94,217 £93,680
Paid-in Capital £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Retained Earnings (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730)
Earnings £0 (£5,075) (£9,767) (£12,675) (£13,547) (£11,236) (£7,029) (£4,469) (£1,777) £3,441 £10,176 £12,604 £15,795
Total Capital (£18,730) (£23,805) (£28,497) (£31,405) (£32,277) (£29,966) (£25,759) (£23,199) (£20,507) (£15,289) (£8,554) (£6,126) (£2,935)
Total Liabilities and Capital £81,270 £76,052 £70,609 £68,014 £67,597 £71,284 £75,115 £75,504 £77,302 £82,985 £89,613 £88,091 £90,745
Net Worth (£18,730) (£23,805) (£28,497) (£31,405) (£32,277) (£29,966) (£25,759) (£23,199) (£20,507) (£15,290) (£8,554) (£6,126) (£2,935)
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
Unit Sales
Portraits 0% 4 8 12 20 24 24 20 20 48 48 36 36
Family Photos On-Site 0% 1 2 3 4 5 5 5 6 12 24 18 24
Weddings 0% 0 0 1 2 4 5 4 4 4 4 2 2
Total Unit Sales 5 10 16 26 33 34 29 30 64 76 56 62
Unit Prices Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Portraits £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00 £100.00
Family Photos On-Site £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00 £200.00
Weddings £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00 £2,500.00
Sales
Portraits £400 £800 £1,200 £2,000 £2,400 £2,400 £2,000 £2,000 £4,800 £4,800 £3,600 £3,600
Family Photos On-Site £200 £400 £600 £800 £1,000 £1,000 £1,000 £1,200 £2,400 £4,800 £3,600 £4,800
Weddings £0 £0 £2,500 £5,000 £10,000 £12,500 £10,000 £10,000 £10,000 £10,000 £5,000 £5,000
Total Sales £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Direct Unit Costs Month 1 Month 2 Month 3 Month 4 Month 5 Month 6 Month 7 Month 8 Month 9 Month 10 Month 11 Month 12
Portraits 10.00% £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00 £10.00
Family Photos On-Site 10.00% £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00 £20.00
Weddings 20.00% £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00 £500.00
Direct Cost of Sales
Portraits £40 £80 £120 £200 £240 £240 £200 £200 £480 £480 £360 £360
Family Photos On-Site £20 £40 £60 £80 £100 £100 £100 £120 £240 £480 £360 £480
Weddings £0 £0 £500 £1,000 £2,000 £2,500 £2,000 £2,000 £2,000 £2,000 £1,000 £1,000
Subtotal Direct Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
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
Owner 0% £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000 £2,000
Employee 0% £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500 £1,500
Total People 0 0 0 0 0 0 0 0 0 0 0 0
Total Payroll £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
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 £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Direct Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
Other Costs of Sales £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Total Cost of Sales £60 £120 £680 £1,280 £2,340 £2,840 £2,300 £2,320 £2,720 £2,960 £1,720 £1,840
Gross Margin £540 £1,080 £3,620 £6,520 £11,060 £13,060 £10,700 £10,880 £14,480 £16,640 £10,480 £11,560
Gross Margin % 90.00% 90.00% 84.19% 83.59% 82.54% 82.14% 82.31% 82.42% 84.19% 84.90% 85.90% 86.27%
Expenses
Payroll £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
Marketing/Promotion £1,000 £1,000 £1,000 £1,000 £1,000 £300 £300 £300 £300 £300 £300 £300
Depreciation £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330 £1,330
Rent £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800 £800
Utilities £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Maintenance of Cameras and Equipment £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50 £50
Offsite file backups and support £60 £60 £60 £60 £60 £60 £60 £60 £60 £60 £60 £60
Software upgrades £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Insurance £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25 £25
Payroll Taxes 15% £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0 £0
Other £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100 £100
Total Operating Expenses £6,965 £6,965 £6,965 £6,965 £6,965 £6,265 £6,265 £6,265 £6,265 £6,265 £6,265 £6,265
Profit Before Interest and Taxes (£6,425) (£5,885) (£3,345) (£445) £4,095 £6,795 £4,435 £4,615 £8,215 £10,375 £4,215 £5,295
EBITDA (£5,095) (£4,555) (£2,015) £885 £5,425 £8,125 £5,765 £5,945 £9,545 £11,705 £5,545 £6,625
Interest Expense £825 £817 £809 £801 £793 £785 £777 £769 £761 £753 £745 £737
Taxes Incurred (£2,175) (£2,011) (£1,246) (£374) £990 £1,803 £1,097 £1,154 £2,236 £2,886 £1,041 £1,367
Net Profit (£5,075) (£4,692) (£2,908) (£872) £2,311 £4,207 £2,560 £2,692 £5,218 £6,735 £2,429 £3,190
Net Profit/Sales -845.87% -390.97% -67.63% -11.19% 17.25% 26.46% 19.70% 20.39% 30.33% 34.36% 19.91% 23.81%
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 £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
Subtotal Cash from Operations £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
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 £0 £0 £0 £0 £0 £0 £0
Subtotal Cash Received £600 £1,200 £4,300 £7,800 £13,400 £15,900 £13,000 £13,200 £17,200 £19,600 £12,200 £13,400
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 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500 £3,500
Bill Payments £28 £852 £1,106 £2,427 £3,923 £6,279 £6,821 £5,612 £5,727 £7,182 £7,932 £4,956
Subtotal Spent on Operations £3,528 £4,352 £4,606 £5,927 £7,423 £9,779 £10,321 £9,112 £9,227 £10,682 £11,432 £8,456
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 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960 £960
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 £4,488 £5,312 £5,566 £6,887 £8,383 £10,739 £11,281 £10,072 £10,187 £11,642 £12,392 £9,416
Net Cash Flow (£3,888) (£4,112) (£1,266) £913 £5,017 £5,161 £1,719 £3,128 £7,013 £7,958 (£192) £3,984
Cash Balance £6,882 £2,769 £1,504 £2,417 £7,434 £12,595 £14,314 £17,442 £24,455 £32,413 £32,221 £36,205
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 £10,770 £6,882 £2,769 £1,504 £2,417 £7,434 £12,595 £14,314 £17,442 £24,455 £32,413 £32,221 £36,205
Other Current Assets £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Total Current Assets £20,770 £16,882 £12,769 £11,504 £12,417 £17,434 £22,595 £24,314 £27,442 £34,455 £42,413 £42,221 £46,205
Long-term Assets
Long-term Assets £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500 £60,500
Accumulated Depreciation £0 £1,330 £2,660 £3,990 £5,320 £6,650 £7,980 £9,310 £10,640 £11,970 £13,300 £14,630 £15,960
Total Long-term Assets £60,500 £59,170 £57,840 £56,510 £55,180 £53,850 £52,520 £51,190 £49,860 £48,530 £47,200 £45,870 £44,540
Total Assets £81,270 £76,052 £70,609 £68,014 £67,597 £71,284 £75,115 £75,504 £77,302 £82,985 £89,613 £88,091 £90,745
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 £817 £1,026 £2,299 £3,714 £6,050 £6,634 £5,423 £5,489 £6,914 £7,767 £4,777 £5,200
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 £817 £1,026 £2,299 £3,714 £6,050 £6,634 £5,423 £5,489 £6,914 £7,767 £4,777 £5,200
Long-term Liabilities £100,000 £99,040 £98,080 £97,120 £96,160 £95,200 £94,240 £93,280 £92,320 £91,360 £90,400 £89,440 £88,480
Total Liabilities £100,000 £99,857 £99,106 £99,419 £99,874 £101,250 £100,874 £98,703 £97,809 £98,274 £98,167 £94,217 £93,680
Paid-in Capital £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000 £10,000
Retained Earnings (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730) (£28,730)
Earnings £0 (£5,075) (£9,767) (£12,675) (£13,547) (£11,236) (£7,029) (£4,469) (£1,777) £3,441 £10,176 £12,604 £15,795
Total Capital (£18,730) (£23,805) (£28,497) (£31,405) (£32,277) (£29,966) (£25,759) (£23,199) (£20,507) (£15,289) (£8,554) (£6,126) (£2,935)
Total Liabilities and Capital £81,270 £76,052 £70,609 £68,014 £67,597 £71,284 £75,115 £75,504 £77,302 £82,985 £89,613 £88,091 £90,745
Net Worth (£18,730) (£23,805) (£28,497) (£31,405) (£32,277) (£29,966) (£25,759) (£23,199) (£20,507) (£15,290) (£8,554) (£6,126) (£2,935)