| Sales Forecast | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Sales | |||||||||||||
| Training | 0% | £0 | £0 | £0 | £0 | £7,200 | £12,000 | £18,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 |
| Broodmare w/foal | 0% | £0 | £660 | £660 | £1,320 | £2,880 | £5,760 | £7,200 | £8,640 | £8,640 | £8,640 | £8,640 | £8,640 |
| Boarding other | 0% | £1,070 | £650 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £600 | £1,800 | £6,000 | £6,000 | £6,000 |
| Home-grown sales | 0% | £2,000 | £0 | £0 | £0 | £6,000 | £0 | £0 | £10,000 | £0 | £0 | £0 | £0 |
| Total Sales | £3,070 | £1,310 | £1,710 | £2,370 | £17,130 | £18,810 | £26,250 | £43,240 | £34,440 | £38,640 | £38,640 | £38,640 | |
| Direct Cost of Sales | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Training | £0 | £0 | £0 | £0 | £600 | £1,000 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Broodmare w/foal | £0 | £100 | £100 | £100 | £400 | £800 | £1,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Boarding other | £300 | £200 | £300 | £300 | £300 | £300 | £300 | £100 | £300 | £1,000 | £1,000 | £1,000 | |
| Home-grown sales | £0 | £8,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Personnel Plan | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Owner | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Head Trainer | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Groom 1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,203 | £1,203 | £1,203 | £1,203 | £1,203 | £1,203 |
| Groom 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,203 | £1,203 | £1,203 | £1,203 |
| Total People | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| General Assumptions | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 5.50% | 5.50% | 5.50% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 30.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Sales | £3,070 | £1,310 | £1,710 | £2,370 | £17,130 | £18,810 | £26,250 | £43,240 | £34,440 | £38,640 | £38,640 | £38,640 | |
| Direct Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Gross Margin | £2,770 | (£6,990) | £1,310 | £1,970 | £15,830 | £16,710 | £23,450 | £39,940 | £30,940 | £34,440 | £34,440 | £34,440 | |
| Gross Margin % | 90.23% | -533.59% | 76.61% | 83.12% | 92.41% | 88.84% | 89.33% | 92.37% | 89.84% | 89.13% | 89.13% | 89.13% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £600 | £780 | £780 | £961 | £961 | £961 | £961 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £200 | £200 | £200 | £200 | £200 | £4,800 | £6,183 | £6,183 | £7,567 | £7,567 | £7,567 | £7,567 | |
| Profit Before Interest and Taxes | £2,570 | (£7,190) | £1,110 | £1,770 | £15,630 | £11,910 | £17,267 | £33,757 | £23,373 | £26,873 | £26,873 | £26,873 | |
| EBITDA | £2,770 | (£6,990) | £1,310 | £1,970 | £15,830 | £12,110 | £17,467 | £33,957 | £23,573 | £27,073 | £27,073 | £27,073 | |
| Interest Expense | £1,185 | £1,185 | £1,185 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | |
| Taxes Incurred | £415 | (£1,926) | (£17) | £133 | £3,321 | £2,465 | £3,697 | £7,490 | £5,102 | £5,907 | £5,907 | £5,907 | |
| Net Profit | £969 | (£6,449) | (£58) | £446 | £11,118 | £8,254 | £12,378 | £25,076 | £17,080 | £19,775 | £19,775 | £19,775 | |
| Net Profit/Sales | 31.57% | -492.30% | -3.40% | 18.82% | 64.90% | 43.88% | 47.16% | 57.99% | 49.59% | 51.18% | 51.18% | 51.18% | |
| Pro Forma Cash Flow | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £2,610 | £1,114 | £1,454 | £2,015 | £14,561 | £15,989 | £22,313 | £36,754 | £29,274 | £32,844 | £32,844 | £32,844 | |
| Cash from Receivables | £6,469 | £6,484 | £452 | £199 | £260 | £429 | £2,578 | £2,859 | £4,022 | £6,442 | £5,187 | £5,796 | |
| Subtotal Cash from Operations | £9,078 | £7,597 | £1,905 | £2,213 | £14,820 | £16,418 | £24,890 | £39,613 | £33,296 | £39,286 | £38,031 | £38,640 | |
| 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 | £9,078 | £7,597 | £1,905 | £2,213 | £14,820 | £16,418 | £24,890 | £39,613 | £33,296 | £39,286 | £38,031 | £38,640 | |
| Expenditures | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| Bill Payments | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £5,830 | £6,427 | £8,612 | £12,694 | £10,804 | £12,259 | £12,259 | |
| Subtotal Spent on Operations | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £9,830 | £11,630 | £13,815 | £19,100 | £17,210 | £18,665 | £18,665 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £9,830 | £11,630 | £13,815 | £19,100 | £17,210 | £18,665 | £18,665 | |
| Net Cash Flow | £9,015 | £5,508 | (£5,454) | £640 | £12,960 | £6,588 | £13,261 | £25,798 | £14,196 | £22,076 | £19,366 | £19,975 | |
| Cash Balance | £12,297 | £17,805 | £12,350 | £12,990 | £25,950 | £32,538 | £45,799 | £71,597 | £85,793 | £107,869 | £127,235 | £147,210 | |
| Pro Forma Balance Sheet | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £3,282 | £12,297 | £17,805 | £12,350 | £12,990 | £25,950 | £32,538 | £45,799 | £71,597 | £85,793 | £107,869 | £127,235 | £147,210 |
| Accounts Receivable | £12,937 | £6,929 | £642 | £446 | £603 | £2,913 | £5,305 | £6,665 | £10,292 | £11,436 | £10,790 | £11,399 | £11,399 |
| Other Current Assets | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 |
| Total Current Assets | £103,903 | £106,910 | £106,130 | £100,481 | £101,278 | £116,547 | £125,527 | £140,148 | £169,573 | £184,912 | £206,343 | £226,318 | £246,293 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 |
| Accumulated Depreciation | £2,800 | £3,000 | £3,200 | £3,400 | £3,600 | £3,800 | £4,000 | £4,200 | £4,400 | £4,600 | £4,800 | £5,000 | £5,200 |
| Total Long-term Assets | £487,200 | £487,000 | £486,800 | £486,600 | £486,400 | £486,200 | £486,000 | £485,800 | £485,600 | £485,400 | £485,200 | £485,000 | £484,800 |
| Total Assets | £591,103 | £593,910 | £592,930 | £587,081 | £587,678 | £602,747 | £611,527 | £625,948 | £655,173 | £670,312 | £691,543 | £711,318 | £731,093 |
| Liabilities and Capital | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £1,837 | £7,307 | £1,516 | £1,667 | £5,618 | £6,144 | £8,186 | £12,336 | £10,395 | £11,850 | £11,850 | £11,850 |
| Current Borrowing | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £13,000 | £14,837 | £20,307 | £14,516 | £14,667 | £18,618 | £19,144 | £21,186 | £25,336 | £23,395 | £24,850 | £24,850 | £24,850 |
| Long-term Liabilities | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 |
| Total Liabilities | £206,000 | £207,837 | £213,307 | £207,516 | £207,667 | £211,618 | £212,144 | £214,186 | £218,336 | £216,395 | £217,850 | £217,850 | £217,850 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 |
| Earnings | £0 | £969 | (£5,480) | (£5,538) | (£5,092) | £6,026 | £14,280 | £26,658 | £51,734 | £68,814 | £88,590 | £108,365 | £128,140 |
| Total Capital | £385,103 | £386,072 | £379,623 | £379,565 | £380,011 | £391,129 | £399,383 | £411,761 | £436,837 | £453,917 | £473,693 | £493,468 | £513,243 |
| Total Liabilities and Capital | £591,103 | £593,910 | £592,930 | £587,081 | £587,678 | £602,747 | £611,527 | £625,948 | £655,173 | £670,312 | £691,543 | £711,318 | £731,093 |
| Net Worth | £385,103 | £386,072 | £379,623 | £379,565 | £380,011 | £391,129 | £399,383 | £411,761 | £436,837 | £453,917 | £473,693 | £493,468 | £513,243 |
| Sales Forecast | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Sales | |||||||||||||
| Training | 0% | £0 | £0 | £0 | £0 | £7,200 | £12,000 | £18,000 | £24,000 | £24,000 | £24,000 | £24,000 | £24,000 |
| Broodmare w/foal | 0% | £0 | £660 | £660 | £1,320 | £2,880 | £5,760 | £7,200 | £8,640 | £8,640 | £8,640 | £8,640 | £8,640 |
| Boarding other | 0% | £1,070 | £650 | £1,050 | £1,050 | £1,050 | £1,050 | £1,050 | £600 | £1,800 | £6,000 | £6,000 | £6,000 |
| Home-grown sales | 0% | £2,000 | £0 | £0 | £0 | £6,000 | £0 | £0 | £10,000 | £0 | £0 | £0 | £0 |
| Total Sales | £3,070 | £1,310 | £1,710 | £2,370 | £17,130 | £18,810 | £26,250 | £43,240 | £34,440 | £38,640 | £38,640 | £38,640 | |
| Direct Cost of Sales | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Training | £0 | £0 | £0 | £0 | £600 | £1,000 | £1,500 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | |
| Broodmare w/foal | £0 | £100 | £100 | £100 | £400 | £800 | £1,000 | £1,200 | £1,200 | £1,200 | £1,200 | £1,200 | |
| Boarding other | £300 | £200 | £300 | £300 | £300 | £300 | £300 | £100 | £300 | £1,000 | £1,000 | £1,000 | |
| Home-grown sales | £0 | £8,000 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Personnel Plan | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Owner | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Head Trainer | 0% | £0 | £0 | £0 | £0 | £0 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 | £2,000 |
| Groom 1 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £1,203 | £1,203 | £1,203 | £1,203 | £1,203 | £1,203 |
| Groom 2 | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £1,203 | £1,203 | £1,203 | £1,203 |
| Total People | 0 | 0 | 0 | 0 | 0 | 2 | 3 | 3 | 4 | 4 | 4 | 4 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| General Assumptions | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Plan Month | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | |
| Current Interest Rate | 5.50% | 5.50% | 5.50% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | 7.00% | |
| Tax Rate | 30.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | 23.00% | |
| Other | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Pro Forma Profit and Loss | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Sales | £3,070 | £1,310 | £1,710 | £2,370 | £17,130 | £18,810 | £26,250 | £43,240 | £34,440 | £38,640 | £38,640 | £38,640 | |
| Direct Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £300 | £8,300 | £400 | £400 | £1,300 | £2,100 | £2,800 | £3,300 | £3,500 | £4,200 | £4,200 | £4,200 | |
| Gross Margin | £2,770 | (£6,990) | £1,310 | £1,970 | £15,830 | £16,710 | £23,450 | £39,940 | £30,940 | £34,440 | £34,440 | £34,440 | |
| Gross Margin % | 90.23% | -533.59% | 76.61% | 83.12% | 92.41% | 88.84% | 89.33% | 92.37% | 89.84% | 89.13% | 89.13% | 89.13% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| Sales and Marketing and Other Expenses | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Depreciation | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Rent | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £600 | £780 | £780 | £961 | £961 | £961 | £961 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £200 | £200 | £200 | £200 | £200 | £4,800 | £6,183 | £6,183 | £7,567 | £7,567 | £7,567 | £7,567 | |
| Profit Before Interest and Taxes | £2,570 | (£7,190) | £1,110 | £1,770 | £15,630 | £11,910 | £17,267 | £33,757 | £23,373 | £26,873 | £26,873 | £26,873 | |
| EBITDA | £2,770 | (£6,990) | £1,310 | £1,970 | £15,830 | £12,110 | £17,467 | £33,957 | £23,573 | £27,073 | £27,073 | £27,073 | |
| Interest Expense | £1,185 | £1,185 | £1,185 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | £1,191 | |
| Taxes Incurred | £415 | (£1,926) | (£17) | £133 | £3,321 | £2,465 | £3,697 | £7,490 | £5,102 | £5,907 | £5,907 | £5,907 | |
| Net Profit | £969 | (£6,449) | (£58) | £446 | £11,118 | £8,254 | £12,378 | £25,076 | £17,080 | £19,775 | £19,775 | £19,775 | |
| Net Profit/Sales | 31.57% | -492.30% | -3.40% | 18.82% | 64.90% | 43.88% | 47.16% | 57.99% | 49.59% | 51.18% | 51.18% | 51.18% | |
| Pro Forma Cash Flow | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Cash Received | |||||||||||||
| Cash from Operations | |||||||||||||
| Cash Sales | £2,610 | £1,114 | £1,454 | £2,015 | £14,561 | £15,989 | £22,313 | £36,754 | £29,274 | £32,844 | £32,844 | £32,844 | |
| Cash from Receivables | £6,469 | £6,484 | £452 | £199 | £260 | £429 | £2,578 | £2,859 | £4,022 | £6,442 | £5,187 | £5,796 | |
| Subtotal Cash from Operations | £9,078 | £7,597 | £1,905 | £2,213 | £14,820 | £16,418 | £24,890 | £39,613 | £33,296 | £39,286 | £38,031 | £38,640 | |
| 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 | £9,078 | £7,597 | £1,905 | £2,213 | £14,820 | £16,418 | £24,890 | £39,613 | £33,296 | £39,286 | £38,031 | £38,640 | |
| Expenditures | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Expenditures from Operations | |||||||||||||
| Cash Spending | £0 | £0 | £0 | £0 | £0 | £4,000 | £5,203 | £5,203 | £6,406 | £6,406 | £6,406 | £6,406 | |
| Bill Payments | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £5,830 | £6,427 | £8,612 | £12,694 | £10,804 | £12,259 | £12,259 | |
| Subtotal Spent on Operations | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £9,830 | £11,630 | £13,815 | £19,100 | £17,210 | £18,665 | £18,665 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Cash Spent | £63 | £2,089 | £7,359 | £1,573 | £1,860 | £9,830 | £11,630 | £13,815 | £19,100 | £17,210 | £18,665 | £18,665 | |
| Net Cash Flow | £9,015 | £5,508 | (£5,454) | £640 | £12,960 | £6,588 | £13,261 | £25,798 | £14,196 | £22,076 | £19,366 | £19,975 | |
| Cash Balance | £12,297 | £17,805 | £12,350 | £12,990 | £25,950 | £32,538 | £45,799 | £71,597 | £85,793 | £107,869 | £127,235 | £147,210 | |
| Pro Forma Balance Sheet | |||||||||||||
| May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | ||
| Assets | Starting Balances | ||||||||||||
| Current Assets | |||||||||||||
| Cash | £3,282 | £12,297 | £17,805 | £12,350 | £12,990 | £25,950 | £32,538 | £45,799 | £71,597 | £85,793 | £107,869 | £127,235 | £147,210 |
| Accounts Receivable | £12,937 | £6,929 | £642 | £446 | £603 | £2,913 | £5,305 | £6,665 | £10,292 | £11,436 | £10,790 | £11,399 | £11,399 |
| Other Current Assets | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 | £87,684 |
| Total Current Assets | £103,903 | £106,910 | £106,130 | £100,481 | £101,278 | £116,547 | £125,527 | £140,148 | £169,573 | £184,912 | £206,343 | £226,318 | £246,293 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 | £490,000 |
| Accumulated Depreciation | £2,800 | £3,000 | £3,200 | £3,400 | £3,600 | £3,800 | £4,000 | £4,200 | £4,400 | £4,600 | £4,800 | £5,000 | £5,200 |
| Total Long-term Assets | £487,200 | £487,000 | £486,800 | £486,600 | £486,400 | £486,200 | £486,000 | £485,800 | £485,600 | £485,400 | £485,200 | £485,000 | £484,800 |
| Total Assets | £591,103 | £593,910 | £592,930 | £587,081 | £587,678 | £602,747 | £611,527 | £625,948 | £655,173 | £670,312 | £691,543 | £711,318 | £731,093 |
| Liabilities and Capital | May | Jun | Jul | Aug | Sep | Oct | Nov | Dec | Jan | Feb | Mar | Apr | |
| Current Liabilities | |||||||||||||
| Accounts Payable | £0 | £1,837 | £7,307 | £1,516 | £1,667 | £5,618 | £6,144 | £8,186 | £12,336 | £10,395 | £11,850 | £11,850 | £11,850 |
| Current Borrowing | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 | £13,000 |
| Other Current Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Subtotal Current Liabilities | £13,000 | £14,837 | £20,307 | £14,516 | £14,667 | £18,618 | £19,144 | £21,186 | £25,336 | £23,395 | £24,850 | £24,850 | £24,850 |
| Long-term Liabilities | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 | £193,000 |
| Total Liabilities | £206,000 | £207,837 | £213,307 | £207,516 | £207,667 | £211,618 | £212,144 | £214,186 | £218,336 | £216,395 | £217,850 | £217,850 | £217,850 |
| Paid-in Capital | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Retained Earnings | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 | £385,103 |
| Earnings | £0 | £969 | (£5,480) | (£5,538) | (£5,092) | £6,026 | £14,280 | £26,658 | £51,734 | £68,814 | £88,590 | £108,365 | £128,140 |
| Total Capital | £385,103 | £386,072 | £379,623 | £379,565 | £380,011 | £391,129 | £399,383 | £411,761 | £436,837 | £453,917 | £473,693 | £493,468 | £513,243 |
| Total Liabilities and Capital | £591,103 | £593,910 | £592,930 | £587,081 | £587,678 | £602,747 | £611,527 | £625,948 | £655,173 | £670,312 | £691,543 | £711,318 | £731,093 |
| Net Worth | £385,103 | £386,072 | £379,623 | £379,565 | £380,011 | £391,129 | £399,383 | £411,761 | £436,837 | £453,917 | £473,693 | £493,468 | £513,243 |