| 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 | |||||||||||||
| Photo Memories | 0% | 15 | 20 | 40 | 50 | 60 | 60 | 70 | 80 | 95 | 90 | 100 | 120 |
| News Story Reels | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 10 | 16 | 25 | 40 | 65 |
| Tampa Bay Video | 0% | 0 | 0 | 0 | 2 | 3 | 5 | 12 | 2 | 2 | 18 | 2 | 2 |
| Other Projects | 0% | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| Total Unit Sales | 16 | 20 | 41 | 52 | 64 | 65 | 87 | 92 | 114 | 133 | 143 | 187 | |
| 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 | |
| Photo Memories | £200.00 | £200.00 | £200.00 | £200.00 | £250.00 | £250.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| News Story Reels | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| Tampa Bay Video | £0.00 | £0.00 | £0.00 | £0.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | |
| Other Projects | £1,000.00 | £0.00 | £1,000.00 | £0.00 | £1,000.00 | £0.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Sales | |||||||||||||
| Photo Memories | £3,000 | £4,000 | £8,000 | £10,000 | £15,000 | £15,000 | £14,000 | £16,000 | £19,000 | £18,000 | £20,000 | £24,000 | |
| News Story Reels | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £2,000 | £3,200 | £5,000 | £8,000 | £13,000 | |
| Tampa Bay Video | £0 | £0 | £0 | £0 | £150 | £250 | £600 | £100 | £100 | £900 | £100 | £100 | |
| Other Projects | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | |
| Total Sales | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | |
| Photo Memories | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| News Story Reels | 0.00% | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 |
| Tampa Bay Video | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 |
| Other Projects | 0.00% | £75.00 | £0.00 | £50.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Photo Memories | £45 | £60 | £120 | £150 | £180 | £180 | £210 | £240 | £285 | £270 | £300 | £360 | |
| News Story Reels | £0 | £0 | £0 | £0 | £0 | £0 | £60 | £150 | £240 | £375 | £600 | £975 | |
| Tampa Bay Video | £0 | £0 | £0 | £0 | £15 | £25 | £60 | £10 | £10 | £90 | £10 | £10 | |
| Other Projects | £75 | £0 | £50 | £0 | £500 | £0 | £500 | £0 | £500 | £0 | £500 | £0 | |
| Subtotal Direct Cost of Sales | £120 | £60 | £170 | £150 | £695 | £205 | £830 | £400 | £1,035 | £735 | £1,410 | £1,345 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Photo Editor | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | |
| Additional Employees (3 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Employees (5 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £6,000 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketing Manager (President) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| News Sales Representative | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,666 | £1,666 | £1,666 | |
| News Sales Representative Commission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £1,000 | £1,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,166 | £2,666 | £3,166 | |
| General and Administrative Personnel | |||||||||||||
| Store Manager | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Store Manager Commission | £0 | £300 | £300 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Store Manager (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,600 | £1,600 | |
| Store Manager Commission (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | |
| Store Mgr/Commission (3 & 5 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £1,900 | £1,900 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Other Personnel | |||||||||||||
| President | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Operations Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Home Division Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| B2B Division Manager | £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 | |
| Subtotal | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Total People | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 5 | 6 | 6 | 8 | |
| Total Payroll | £2,500 | £4,400 | £4,400 | £6,000 | £7,500 | £7,500 | £8,500 | £8,500 | £10,000 | £12,666 | £15,166 | £17,166 | |
| 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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | |
| Long-term Interest Rate | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| Direct Cost of Sales | £120 | £60 | £170 | £150 | £695 | £205 | £830 | £400 | £1,035 | £735 | £1,410 | £1,345 | |
| Production Payroll | £0 | £0 | £0 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £6,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £120 | £60 | £170 | £1,650 | £3,695 | £3,205 | £3,830 | £3,400 | £5,535 | £5,235 | £5,910 | £7,345 | |
| Gross Margin | £3,880 | £3,940 | £8,830 | £8,350 | £12,455 | £12,045 | £12,570 | £14,700 | £17,765 | £18,665 | £23,190 | £29,755 | |
| Gross Margin % | 97.00% | 98.50% | 98.11% | 83.50% | 77.12% | 78.98% | 76.65% | 81.22% | 76.24% | 78.10% | 79.69% | 80.20% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,166 | £2,666 | £3,166 | |
| Advertising/Promotion | £2,000 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £1,500 | £1,000 | £1,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,500 | |
| Total Sales and Marketing Expenses | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £3,250 | £3,250 | £3,250 | £3,250 | £6,166 | £6,166 | £7,166 | |
| Sales and Marketing % | 62.50% | 50.00% | 22.22% | 25.00% | 15.48% | 21.31% | 19.82% | 17.96% | 13.95% | 25.80% | 21.19% | 19.32% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £1,900 | £1,900 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £160 | |
| Insurance | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £160 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £1,500 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £930 | £2,830 | £2,830 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £4,930 | £5,820 | |
| General and Administrative % | 23.25% | 70.75% | 31.44% | 29.30% | 18.14% | 19.21% | 17.87% | 16.19% | 12.58% | 12.26% | 16.94% | 15.69% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Other % | 62.50% | 62.50% | 27.78% | 25.00% | 15.48% | 16.39% | 21.34% | 19.34% | 15.02% | 16.74% | 13.75% | 10.78% | |
| Total Operating Expenses | £5,930 | £7,330 | £7,330 | £7,930 | £7,930 | £8,680 | £9,680 | £9,680 | £9,680 | £13,096 | £15,096 | £16,986 | |
| Profit Before Interest and Taxes | (£2,050) | (£3,390) | £1,500 | £420 | £4,525 | £3,365 | £2,890 | £5,020 | £8,085 | £5,569 | £8,094 | £12,769 | |
| EBITDA | (£2,050) | (£3,390) | £1,500 | £420 | £4,525 | £3,365 | £2,890 | £5,020 | £8,085 | £5,569 | £8,094 | £12,769 | |
| Interest Expense | £54 | £44 | £42 | £40 | £38 | £36 | £34 | £32 | £30 | £28 | £26 | £24 | |
| Taxes Incurred | (£631) | (£858) | £365 | £95 | £1,122 | £832 | £714 | £1,247 | £2,014 | £1,385 | £2,017 | £3,186 | |
| Net Profit | (£1,473) | (£2,575) | £1,094 | £285 | £3,366 | £2,497 | £2,142 | £3,741 | £6,042 | £4,156 | £6,051 | £9,559 | |
| Net Profit/Sales | -36.82% | -64.38% | 12.15% | 2.85% | 20.84% | 16.37% | 13.06% | 20.67% | 25.93% | 17.39% | 20.80% | 25.77% | |
| 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 | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| Subtotal Cash from Operations | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | £5,000 | £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 | £9,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | £2,500 | £4,400 | £4,400 | £6,000 | £7,500 | £7,500 | £8,500 | £8,500 | £10,000 | £12,666 | £15,166 | £17,166 | |
| Bill Payments | £528 | £3,795 | £2,156 | £3,344 | £3,632 | £5,571 | £5,082 | £6,050 | £5,539 | £7,866 | £7,366 | £8,106 | |
| Subtotal Spent on Operations | £3,028 | £8,195 | £6,556 | £9,344 | £11,132 | £13,071 | £13,582 | £14,550 | £15,539 | £20,532 | £22,532 | £25,272 | |
| 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 | £980 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,028 | £9,175 | £6,741 | £9,529 | £11,317 | £13,256 | £13,767 | £14,735 | £15,724 | £20,717 | £22,717 | £25,457 | |
| Net Cash Flow | £5,972 | (£5,175) | £2,259 | £471 | £4,833 | £1,994 | £2,633 | £3,365 | £7,576 | £3,183 | £6,383 | £11,643 | |
| Cash Balance | £20,072 | £14,897 | £17,156 | £17,627 | £22,460 | £24,453 | £27,086 | £30,451 | £38,027 | £41,210 | £47,593 | £59,236 | |
| 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 | £14,100 | £20,072 | £14,897 | £17,156 | £17,627 | £22,460 | £24,453 | £27,086 | £30,451 | £38,027 | £41,210 | £47,593 | £59,236 |
| Inventory | £0 | £880 | £820 | £650 | £500 | £805 | £600 | £913 | £513 | £1,139 | £1,404 | £1,551 | £1,480 |
| Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total Current Assets | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| 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 | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| 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 | £400 | £3,724 | £2,045 | £3,225 | £3,446 | £5,403 | £4,880 | £5,868 | £5,277 | £7,621 | £7,098 | £7,762 | £9,960 |
| Current Borrowing | £0 | £5,000 | £4,020 | £3,835 | £3,650 | £3,465 | £3,280 | £3,095 | £2,910 | £2,725 | £2,540 | £2,355 | £2,170 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £400 | £8,724 | £6,065 | £7,060 | £7,096 | £8,868 | £8,160 | £8,963 | £8,187 | £10,346 | £9,638 | £10,117 | £12,130 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £400 | £8,724 | £6,065 | £7,060 | £7,096 | £8,868 | £8,160 | £8,963 | £8,187 | £10,346 | £9,638 | £10,117 | £12,130 |
| Paid-in Capital | £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 |
| Retained Earnings | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) |
| Earnings | £0 | (£1,473) | (£4,048) | (£2,954) | (£2,669) | £697 | £3,194 | £5,336 | £9,078 | £15,119 | £19,275 | £25,327 | £34,886 |
| Total Capital | £14,200 | £12,727 | £10,152 | £11,246 | £11,531 | £14,897 | £17,394 | £19,536 | £23,278 | £29,319 | £33,475 | £39,527 | £49,086 |
| Total Liabilities and Capital | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| Net Worth | £14,200 | £12,727 | £10,152 | £11,246 | £11,531 | £14,897 | £17,394 | £19,536 | £23,278 | £29,319 | £33,475 | £39,527 | £49,086 |
| 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 | |||||||||||||
| Photo Memories | 0% | 15 | 20 | 40 | 50 | 60 | 60 | 70 | 80 | 95 | 90 | 100 | 120 |
| News Story Reels | 0% | 0 | 0 | 0 | 0 | 0 | 0 | 4 | 10 | 16 | 25 | 40 | 65 |
| Tampa Bay Video | 0% | 0 | 0 | 0 | 2 | 3 | 5 | 12 | 2 | 2 | 18 | 2 | 2 |
| Other Projects | 0% | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 | 1 | 0 |
| Total Unit Sales | 16 | 20 | 41 | 52 | 64 | 65 | 87 | 92 | 114 | 133 | 143 | 187 | |
| 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 | |
| Photo Memories | £200.00 | £200.00 | £200.00 | £200.00 | £250.00 | £250.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| News Story Reels | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £0.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | £200.00 | |
| Tampa Bay Video | £0.00 | £0.00 | £0.00 | £0.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | £50.00 | |
| Other Projects | £1,000.00 | £0.00 | £1,000.00 | £0.00 | £1,000.00 | £0.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | £1,000.00 | |
| Sales | |||||||||||||
| Photo Memories | £3,000 | £4,000 | £8,000 | £10,000 | £15,000 | £15,000 | £14,000 | £16,000 | £19,000 | £18,000 | £20,000 | £24,000 | |
| News Story Reels | £0 | £0 | £0 | £0 | £0 | £0 | £800 | £2,000 | £3,200 | £5,000 | £8,000 | £13,000 | |
| Tampa Bay Video | £0 | £0 | £0 | £0 | £150 | £250 | £600 | £100 | £100 | £900 | £100 | £100 | |
| Other Projects | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | £1,000 | £0 | |
| Total Sales | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | |
| Photo Memories | 0.00% | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 | £3.00 |
| News Story Reels | 0.00% | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 | £15.00 |
| Tampa Bay Video | 0.00% | £0.00 | £0.00 | £0.00 | £0.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 | £5.00 |
| Other Projects | 0.00% | £75.00 | £0.00 | £50.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 | £500.00 | £0.00 |
| Direct Cost of Sales | |||||||||||||
| Photo Memories | £45 | £60 | £120 | £150 | £180 | £180 | £210 | £240 | £285 | £270 | £300 | £360 | |
| News Story Reels | £0 | £0 | £0 | £0 | £0 | £0 | £60 | £150 | £240 | £375 | £600 | £975 | |
| Tampa Bay Video | £0 | £0 | £0 | £0 | £15 | £25 | £60 | £10 | £10 | £90 | £10 | £10 | |
| Other Projects | £75 | £0 | £50 | £0 | £500 | £0 | £500 | £0 | £500 | £0 | £500 | £0 | |
| Subtotal Direct Cost of Sales | £120 | £60 | £170 | £150 | £695 | £205 | £830 | £400 | £1,035 | £735 | £1,410 | £1,345 | |
| 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 | ||
| Production Personnel | |||||||||||||
| Photo Editor | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Photo Editor (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,500 | |
| Additional Employees (3 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Additional Employees (5 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £6,000 | |
| Sales and Marketing Personnel | |||||||||||||
| Marketing Manager (President) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| News Sales Representative | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,666 | £1,666 | £1,666 | |
| News Sales Representative Commission | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £500 | £1,000 | £1,500 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,166 | £2,666 | £3,166 | |
| General and Administrative Personnel | |||||||||||||
| Store Manager | £0 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Store Manager Commission | £0 | £300 | £300 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | £400 | |
| Store Manager (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,600 | £1,600 | |
| Store Manager Commission (2) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £400 | £400 | |
| Store Mgr/Commission (3 & 5 stores) | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal | £0 | £1,900 | £1,900 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Other Personnel | |||||||||||||
| President | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Operations Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Home Division Manager | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| B2B Division Manager | £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 | |
| Subtotal | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Total People | 1 | 2 | 2 | 3 | 4 | 4 | 4 | 4 | 5 | 6 | 6 | 8 | |
| Total Payroll | £2,500 | £4,400 | £4,400 | £6,000 | £7,500 | £7,500 | £8,500 | £8,500 | £10,000 | £12,666 | £15,166 | £17,166 | |
| 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 | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | 13.00% | |
| Long-term Interest Rate | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | 0.80% | |
| Tax Rate | 30.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.00% | 25.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 | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| Direct Cost of Sales | £120 | £60 | £170 | £150 | £695 | £205 | £830 | £400 | £1,035 | £735 | £1,410 | £1,345 | |
| Production Payroll | £0 | £0 | £0 | £1,500 | £3,000 | £3,000 | £3,000 | £3,000 | £4,500 | £4,500 | £4,500 | £6,000 | |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £120 | £60 | £170 | £1,650 | £3,695 | £3,205 | £3,830 | £3,400 | £5,535 | £5,235 | £5,910 | £7,345 | |
| Gross Margin | £3,880 | £3,940 | £8,830 | £8,350 | £12,455 | £12,045 | £12,570 | £14,700 | £17,765 | £18,665 | £23,190 | £29,755 | |
| Gross Margin % | 97.00% | 98.50% | 98.11% | 83.50% | 77.12% | 78.98% | 76.65% | 81.22% | 76.24% | 78.10% | 79.69% | 80.20% | |
| Operating Expenses | |||||||||||||
| Sales and Marketing Expenses | |||||||||||||
| Sales and Marketing Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £2,166 | £2,666 | £3,166 | |
| Advertising/Promotion | £2,000 | £1,500 | £1,500 | £2,000 | £2,000 | £2,000 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | £1,500 | |
| Travel | £0 | £0 | £0 | £0 | £0 | £750 | £750 | £750 | £750 | £1,500 | £1,000 | £1,000 | |
| Miscellaneous | £500 | £500 | £500 | £500 | £500 | £500 | £1,000 | £1,000 | £1,000 | £1,000 | £1,000 | £1,500 | |
| Total Sales and Marketing Expenses | £2,500 | £2,000 | £2,000 | £2,500 | £2,500 | £3,250 | £3,250 | £3,250 | £3,250 | £6,166 | £6,166 | £7,166 | |
| Sales and Marketing % | 62.50% | 50.00% | 22.22% | 25.00% | 15.48% | 21.31% | 19.82% | 17.96% | 13.95% | 25.80% | 21.19% | 19.32% | |
| General and Administrative Expenses | |||||||||||||
| General and Administrative Payroll | £0 | £1,900 | £1,900 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £4,000 | £4,000 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Leased Equipment | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Utilities | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £160 | |
| Insurance | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £80 | £160 | |
| Rent | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £750 | £1,500 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other General and Administrative Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total General and Administrative Expenses | £930 | £2,830 | £2,830 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £2,930 | £4,930 | £5,820 | |
| General and Administrative % | 23.25% | 70.75% | 31.44% | 29.30% | 18.14% | 19.21% | 17.87% | 16.19% | 12.58% | 12.26% | 16.94% | 15.69% | |
| Other Expenses: | |||||||||||||
| Other Payroll | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Contract/Consultants | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Other Expenses | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £2,500 | £3,500 | £3,500 | £3,500 | £4,000 | £4,000 | £4,000 | |
| Other % | 62.50% | 62.50% | 27.78% | 25.00% | 15.48% | 16.39% | 21.34% | 19.34% | 15.02% | 16.74% | 13.75% | 10.78% | |
| Total Operating Expenses | £5,930 | £7,330 | £7,330 | £7,930 | £7,930 | £8,680 | £9,680 | £9,680 | £9,680 | £13,096 | £15,096 | £16,986 | |
| Profit Before Interest and Taxes | (£2,050) | (£3,390) | £1,500 | £420 | £4,525 | £3,365 | £2,890 | £5,020 | £8,085 | £5,569 | £8,094 | £12,769 | |
| EBITDA | (£2,050) | (£3,390) | £1,500 | £420 | £4,525 | £3,365 | £2,890 | £5,020 | £8,085 | £5,569 | £8,094 | £12,769 | |
| Interest Expense | £54 | £44 | £42 | £40 | £38 | £36 | £34 | £32 | £30 | £28 | £26 | £24 | |
| Taxes Incurred | (£631) | (£858) | £365 | £95 | £1,122 | £832 | £714 | £1,247 | £2,014 | £1,385 | £2,017 | £3,186 | |
| Net Profit | (£1,473) | (£2,575) | £1,094 | £285 | £3,366 | £2,497 | £2,142 | £3,741 | £6,042 | £4,156 | £6,051 | £9,559 | |
| Net Profit/Sales | -36.82% | -64.38% | 12.15% | 2.85% | 20.84% | 16.37% | 13.06% | 20.67% | 25.93% | 17.39% | 20.80% | 25.77% | |
| 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 | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| Subtotal Cash from Operations | £4,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | £5,000 | £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 | £9,000 | £4,000 | £9,000 | £10,000 | £16,150 | £15,250 | £16,400 | £18,100 | £23,300 | £23,900 | £29,100 | £37,100 | |
| 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 | £2,500 | £4,400 | £4,400 | £6,000 | £7,500 | £7,500 | £8,500 | £8,500 | £10,000 | £12,666 | £15,166 | £17,166 | |
| Bill Payments | £528 | £3,795 | £2,156 | £3,344 | £3,632 | £5,571 | £5,082 | £6,050 | £5,539 | £7,866 | £7,366 | £8,106 | |
| Subtotal Spent on Operations | £3,028 | £8,195 | £6,556 | £9,344 | £11,132 | £13,071 | £13,582 | £14,550 | £15,539 | £20,532 | £22,532 | £25,272 | |
| 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 | £980 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | £185 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £3,028 | £9,175 | £6,741 | £9,529 | £11,317 | £13,256 | £13,767 | £14,735 | £15,724 | £20,717 | £22,717 | £25,457 | |
| Net Cash Flow | £5,972 | (£5,175) | £2,259 | £471 | £4,833 | £1,994 | £2,633 | £3,365 | £7,576 | £3,183 | £6,383 | £11,643 | |
| Cash Balance | £20,072 | £14,897 | £17,156 | £17,627 | £22,460 | £24,453 | £27,086 | £30,451 | £38,027 | £41,210 | £47,593 | £59,236 | |
| 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 | £14,100 | £20,072 | £14,897 | £17,156 | £17,627 | £22,460 | £24,453 | £27,086 | £30,451 | £38,027 | £41,210 | £47,593 | £59,236 |
| Inventory | £0 | £880 | £820 | £650 | £500 | £805 | £600 | £913 | £513 | £1,139 | £1,404 | £1,551 | £1,480 |
| Other Current Assets | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 |
| Total Current Assets | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| 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 | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| 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 | £400 | £3,724 | £2,045 | £3,225 | £3,446 | £5,403 | £4,880 | £5,868 | £5,277 | £7,621 | £7,098 | £7,762 | £9,960 |
| Current Borrowing | £0 | £5,000 | £4,020 | £3,835 | £3,650 | £3,465 | £3,280 | £3,095 | £2,910 | £2,725 | £2,540 | £2,355 | £2,170 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £400 | £8,724 | £6,065 | £7,060 | £7,096 | £8,868 | £8,160 | £8,963 | £8,187 | £10,346 | £9,638 | £10,117 | £12,130 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £400 | £8,724 | £6,065 | £7,060 | £7,096 | £8,868 | £8,160 | £8,963 | £8,187 | £10,346 | £9,638 | £10,117 | £12,130 |
| Paid-in Capital | £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 |
| Retained Earnings | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) | (£800) |
| Earnings | £0 | (£1,473) | (£4,048) | (£2,954) | (£2,669) | £697 | £3,194 | £5,336 | £9,078 | £15,119 | £19,275 | £25,327 | £34,886 |
| Total Capital | £14,200 | £12,727 | £10,152 | £11,246 | £11,531 | £14,897 | £17,394 | £19,536 | £23,278 | £29,319 | £33,475 | £39,527 | £49,086 |
| Total Liabilities and Capital | £14,600 | £21,452 | £16,217 | £18,306 | £18,627 | £23,765 | £25,553 | £28,499 | £31,464 | £39,665 | £43,113 | £49,644 | £61,216 |
| Net Worth | £14,200 | £12,727 | £10,152 | £11,246 | £11,531 | £14,897 | £17,394 | £19,536 | £23,278 | £29,319 | £33,475 | £39,527 | £49,086 |