| 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 | |||||||||||||
| Inventory Sales | 0% | £16,000 | £20,800 | £24,960 | £22,464 | £20,217 | £23,250 | £26,737 | £32,084 | £38,501 | £46,202 | £41,581 | £37,423 |
| Internet Marketing | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Total Sales | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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 | |
| Inventory | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Internet Marketing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| 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 | ||
| Tim Jones | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Molly Jones | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Salesperson (PT) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Salesperson (FT) | 0% | £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 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| 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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| Direct Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Gross Margin | £6,200 | £7,640 | £8,888 | £8,139 | £7,465 | £8,375 | £9,421 | £11,025 | £12,950 | £15,261 | £13,874 | £12,627 | |
| Gross Margin % | 35.63% | 34.41% | 33.72% | 34.11% | 34.53% | 33.98% | 33.48% | 32.93% | 32.46% | 32.06% | 32.28% | 32.52% | |
| Expenses | |||||||||||||
| Payroll | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Marketing/Promotion | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Depreciation | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | |
| Vehicle Expense | £150 | £150 | £150 | £125 | £125 | £125 | £125 | £150 | £150 | £150 | £150 | £150 | |
| Credit Card Surcharge | £160 | £208 | £249 | £224 | £202 | £232 | £267 | £320 | £385 | £462 | £415 | £374 | |
| Inbound Freight Charges | £224 | £350 | £350 | £314 | £284 | £326 | £374 | £450 | £540 | £646 | £582 | £524 | |
| Office Supplies | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Security/alarm | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | |
| Telephone | £150 | £156 | £187 | £168 | £150 | £174 | £200 | £240 | £288 | £346 | £311 | £280 | |
| Accounting Costs | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Rent | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,454 | £5,634 | £5,706 | £5,601 | £5,531 | £5,627 | £5,736 | £5,930 | £6,133 | £6,374 | £6,228 | £6,098 | |
| Profit Before Interest and Taxes | £746 | £2,006 | £3,182 | £2,538 | £1,934 | £2,748 | £3,685 | £5,095 | £6,817 | £8,887 | £7,646 | £6,529 | |
| EBITDA | £1,091 | £2,351 | £3,527 | £2,883 | £2,279 | £3,093 | £4,030 | £5,440 | £7,162 | £9,232 | £7,991 | £6,874 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £224 | £602 | £955 | £761 | £580 | £824 | £1,106 | £1,529 | £2,045 | £2,666 | £2,294 | £1,959 | |
| Net Profit | £522 | £1,404 | £2,227 | £1,777 | £1,354 | £1,924 | £2,580 | £3,567 | £4,772 | £6,221 | £5,352 | £4,570 | |
| Net Profit/Sales | 3.00% | 6.33% | 8.45% | 7.44% | 6.26% | 7.80% | 9.17% | 10.65% | 11.96% | 13.07% | 12.45% | 11.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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| Subtotal Cash from Operations | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Bill Payments | £2,104 | £3,151 | £4,120 | £16,602 | £17,566 | £16,206 | £22,623 | £25,891 | £31,691 | £37,767 | £44,324 | £31,426 | |
| Subtotal Spent on Operations | £4,304 | £5,351 | £6,320 | £18,802 | £19,766 | £18,406 | £24,823 | £28,091 | £33,891 | £39,967 | £46,524 | £33,626 | |
| 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 | £4,304 | £5,351 | £6,320 | £18,802 | £19,766 | £18,406 | £24,823 | £28,091 | £33,891 | £39,967 | £46,524 | £33,626 | |
| Net Cash Flow | £13,096 | £16,849 | £20,040 | £5,062 | £1,851 | £6,244 | £3,314 | £5,393 | £6,010 | £7,635 | (£3,543) | £5,197 | |
| Cash Balance | £14,096 | £30,944 | £50,984 | £56,046 | £57,897 | £64,141 | £67,456 | £72,849 | £78,859 | £86,494 | £82,952 | £88,149 | |
| 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 | £1,000 | £14,096 | £30,944 | £50,984 | £56,046 | £57,897 | £64,141 | £67,456 | £72,849 | £78,859 | £86,494 | £82,952 | £88,149 |
| Inventory | £50,000 | £38,800 | £24,240 | £19,219 | £17,298 | £15,567 | £17,903 | £20,588 | £24,705 | £29,646 | £35,575 | £32,018 | £28,816 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £51,000 | £52,896 | £55,184 | £70,203 | £73,344 | £73,464 | £82,044 | £88,043 | £97,554 | £108,505 | £122,070 | £114,969 | £116,965 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 |
| Accumulated Depreciation | £0 | £345 | £690 | £1,035 | £1,380 | £1,725 | £2,070 | £2,415 | £2,760 | £3,105 | £3,450 | £3,795 | £4,140 |
| Total Long-term Assets | £29,000 | £28,655 | £28,310 | £27,965 | £27,620 | £27,275 | £26,930 | £26,585 | £26,240 | £25,895 | £25,550 | £25,205 | £24,860 |
| Total Assets | £80,000 | £81,551 | £83,494 | £98,168 | £100,964 | £100,739 | £108,974 | £114,628 | £123,794 | £134,400 | £147,620 | £140,174 | £141,825 |
| 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 | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| 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 | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| Paid-in Capital | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 |
| Retained Earnings | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) |
| Earnings | £0 | £522 | £1,926 | £4,154 | £5,930 | £7,284 | £9,208 | £11,787 | £15,354 | £20,126 | £26,347 | £31,699 | £36,269 |
| Total Capital | £78,000 | £78,522 | £79,926 | £82,154 | £83,930 | £85,284 | £87,208 | £89,787 | £93,354 | £98,126 | £104,347 | £109,699 | £114,269 |
| Total Liabilities and Capital | £80,000 | £81,551 | £83,494 | £98,168 | £100,964 | £100,739 | £108,974 | £114,628 | £123,794 | £134,400 | £147,620 | £140,174 | £141,825 |
| Net Worth | £78,000 | £78,522 | £79,926 | £82,154 | £83,930 | £85,284 | £87,208 | £89,787 | £93,354 | £98,126 | £104,347 | £109,699 | £114,269 |
| 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 | |||||||||||||
| Inventory Sales | 0% | £16,000 | £20,800 | £24,960 | £22,464 | £20,217 | £23,250 | £26,737 | £32,084 | £38,501 | £46,202 | £41,581 | £37,423 |
| Internet Marketing | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Total Sales | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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 | |
| Inventory | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Internet Marketing | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Subtotal Direct Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| 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 | ||
| Tim Jones | 0% | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 | £1,400 |
| Molly Jones | 0% | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 | £800 |
| Salesperson (PT) | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Salesperson (FT) | 0% | £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 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| 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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| Direct Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Other Costs of Sales | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Cost of Sales | £11,200 | £14,560 | £17,472 | £15,725 | £14,152 | £16,275 | £18,716 | £22,459 | £26,951 | £32,341 | £29,107 | £26,196 | |
| Gross Margin | £6,200 | £7,640 | £8,888 | £8,139 | £7,465 | £8,375 | £9,421 | £11,025 | £12,950 | £15,261 | £13,874 | £12,627 | |
| Gross Margin % | 35.63% | 34.41% | 33.72% | 34.11% | 34.53% | 33.98% | 33.48% | 32.93% | 32.46% | 32.06% | 32.28% | 32.52% | |
| Expenses | |||||||||||||
| Payroll | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Marketing/Promotion | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | £150 | |
| Depreciation | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | £345 | |
| Vehicle Expense | £150 | £150 | £150 | £125 | £125 | £125 | £125 | £150 | £150 | £150 | £150 | £150 | |
| Credit Card Surcharge | £160 | £208 | £249 | £224 | £202 | £232 | £267 | £320 | £385 | £462 | £415 | £374 | |
| Inbound Freight Charges | £224 | £350 | £350 | £314 | £284 | £326 | £374 | £450 | £540 | £646 | £582 | £524 | |
| Office Supplies | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | £50 | |
| Security/alarm | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | £30 | |
| Telephone | £150 | £156 | £187 | £168 | £150 | £174 | £200 | £240 | £288 | £346 | £311 | £280 | |
| Accounting Costs | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | £125 | |
| Rent | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Utilities | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | £200 | |
| Insurance | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | £70 | |
| Payroll Taxes | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Other | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Total Operating Expenses | £5,454 | £5,634 | £5,706 | £5,601 | £5,531 | £5,627 | £5,736 | £5,930 | £6,133 | £6,374 | £6,228 | £6,098 | |
| Profit Before Interest and Taxes | £746 | £2,006 | £3,182 | £2,538 | £1,934 | £2,748 | £3,685 | £5,095 | £6,817 | £8,887 | £7,646 | £6,529 | |
| EBITDA | £1,091 | £2,351 | £3,527 | £2,883 | £2,279 | £3,093 | £4,030 | £5,440 | £7,162 | £9,232 | £7,991 | £6,874 | |
| Interest Expense | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Taxes Incurred | £224 | £602 | £955 | £761 | £580 | £824 | £1,106 | £1,529 | £2,045 | £2,666 | £2,294 | £1,959 | |
| Net Profit | £522 | £1,404 | £2,227 | £1,777 | £1,354 | £1,924 | £2,580 | £3,567 | £4,772 | £6,221 | £5,352 | £4,570 | |
| Net Profit/Sales | 3.00% | 6.33% | 8.45% | 7.44% | 6.26% | 7.80% | 9.17% | 10.65% | 11.96% | 13.07% | 12.45% | 11.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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| Subtotal Cash from Operations | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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 | £17,400 | £22,200 | £26,360 | £23,864 | £21,617 | £24,650 | £28,137 | £33,484 | £39,901 | £47,602 | £42,981 | £38,823 | |
| 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,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | £2,200 | |
| Bill Payments | £2,104 | £3,151 | £4,120 | £16,602 | £17,566 | £16,206 | £22,623 | £25,891 | £31,691 | £37,767 | £44,324 | £31,426 | |
| Subtotal Spent on Operations | £4,304 | £5,351 | £6,320 | £18,802 | £19,766 | £18,406 | £24,823 | £28,091 | £33,891 | £39,967 | £46,524 | £33,626 | |
| 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 | £4,304 | £5,351 | £6,320 | £18,802 | £19,766 | £18,406 | £24,823 | £28,091 | £33,891 | £39,967 | £46,524 | £33,626 | |
| Net Cash Flow | £13,096 | £16,849 | £20,040 | £5,062 | £1,851 | £6,244 | £3,314 | £5,393 | £6,010 | £7,635 | (£3,543) | £5,197 | |
| Cash Balance | £14,096 | £30,944 | £50,984 | £56,046 | £57,897 | £64,141 | £67,456 | £72,849 | £78,859 | £86,494 | £82,952 | £88,149 | |
| 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 | £1,000 | £14,096 | £30,944 | £50,984 | £56,046 | £57,897 | £64,141 | £67,456 | £72,849 | £78,859 | £86,494 | £82,952 | £88,149 |
| Inventory | £50,000 | £38,800 | £24,240 | £19,219 | £17,298 | £15,567 | £17,903 | £20,588 | £24,705 | £29,646 | £35,575 | £32,018 | £28,816 |
| Other Current Assets | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Current Assets | £51,000 | £52,896 | £55,184 | £70,203 | £73,344 | £73,464 | £82,044 | £88,043 | £97,554 | £108,505 | £122,070 | £114,969 | £116,965 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 | £29,000 |
| Accumulated Depreciation | £0 | £345 | £690 | £1,035 | £1,380 | £1,725 | £2,070 | £2,415 | £2,760 | £3,105 | £3,450 | £3,795 | £4,140 |
| Total Long-term Assets | £29,000 | £28,655 | £28,310 | £27,965 | £27,620 | £27,275 | £26,930 | £26,585 | £26,240 | £25,895 | £25,550 | £25,205 | £24,860 |
| Total Assets | £80,000 | £81,551 | £83,494 | £98,168 | £100,964 | £100,739 | £108,974 | £114,628 | £123,794 | £134,400 | £147,620 | £140,174 | £141,825 |
| 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 | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| 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 | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| Long-term Liabilities | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total Liabilities | £2,000 | £3,028 | £3,568 | £16,015 | £17,033 | £15,455 | £21,766 | £24,841 | £30,440 | £36,274 | £43,273 | £30,476 | £27,555 |
| Paid-in Capital | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 | £80,625 |
| Retained Earnings | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) | (£2,625) |
| Earnings | £0 | £522 | £1,926 | £4,154 | £5,930 | £7,284 | £9,208 | £11,787 | £15,354 | £20,126 | £26,347 | £31,699 | £36,269 |
| Total Capital | £78,000 | £78,522 | £79,926 | £82,154 | £83,930 | £85,284 | £87,208 | £89,787 | £93,354 | £98,126 | £104,347 | £109,699 | £114,269 |
| Total Liabilities and Capital | £80,000 | £81,551 | £83,494 | £98,168 | £100,964 | £100,739 | £108,974 | £114,628 | £123,794 | £134,400 | £147,620 | £140,174 | £141,825 |
| Net Worth | £78,000 | £78,522 | £79,926 | £82,154 | £83,930 | £85,284 | £87,208 | £89,787 | £93,354 | £98,126 | £104,347 | £109,699 | £114,269 |