| 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 | |||||||||||||
| Room night @ 110.00 per night | 10% | £2,509 | £2,760 | £3,036 | £3,339 | £3,673 | £4,041 | £4,445 | £4,889 | £5,378 | £5,916 | £6,508 | £7,158 |
| Suite night @ 175.00 per night | 10% | £1,597 | £1,757 | £1,932 | £2,126 | £2,338 | £2,572 | £2,829 | £3,112 | £3,423 | £3,766 | £4,142 | £4,556 |
| Museum & Tour of Mansion @ 3.00 pp | 10% | £300 | £330 | £363 | £399 | £439 | £483 | £531 | £585 | £643 | £707 | £778 | £856 |
| Total Sales | £4,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| 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 | |
| Room night @ 20.00 cost | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | |
| Suite night @ 30.00 cost | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | |
| Museum and Tour of Mansion | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Subtotal Direct Cost of Sales | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Tax 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% | |
| 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,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Direct Cost of Sales | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | |
| Other | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | |
| Total Cost of Sales | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | |
| Gross Margin | £2,776 | £3,217 | £3,701 | £4,234 | £4,821 | £5,466 | £6,175 | £6,956 | £7,815 | £8,759 | £9,798 | £10,941 | |
| Gross Margin % | 63.00% | 66.37% | 69.43% | 72.21% | 74.73% | 77.03% | 79.12% | 81.02% | 82.74% | 84.31% | 85.74% | 87.03% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales & Marketing & Other Expenses | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Annual web and Assoc fees | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Tax | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Total Operating Expenses | £2,100 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Profit Before Interest and Taxes | £676 | £1,617 | £2,101 | £2,634 | £3,221 | £3,866 | £4,575 | £5,356 | £6,215 | £7,159 | £8,198 | £9,341 | |
| EBITDA | £776 | £1,717 | £2,201 | £2,734 | £3,321 | £3,966 | £4,675 | £5,456 | £6,315 | £7,259 | £8,298 | £9,441 | |
| Interest Expense | £403 | £400 | £397 | £394 | £391 | £388 | £385 | £382 | £379 | £376 | £373 | £370 | |
| Taxes Incurred | £35 | £158 | £222 | £291 | £368 | £452 | £545 | £647 | £759 | £882 | £1,017 | £1,166 | |
| Net Profit | £237 | £1,058 | £1,483 | £1,949 | £2,462 | £3,026 | £3,646 | £4,327 | £5,077 | £5,901 | £6,808 | £7,805 | |
| Net Profit/Sales | 5.39% | 21.84% | 27.81% | 33.24% | 38.16% | 42.64% | 46.71% | 50.40% | 53.76% | 56.80% | 59.57% | 62.08% | |
| 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,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Subtotal Cash from Operations | £4,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 13.00% | £573 | £630 | £693 | £762 | £839 | £922 | £1,015 | £1,116 | £1,228 | £1,351 | £1,486 | £1,634 |
| 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 | £4,979 | £5,477 | £6,024 | £6,627 | £7,289 | £8,018 | £8,820 | £9,702 | £10,672 | £11,740 | £12,914 | £14,205 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £1,649 | £3,108 | £3,277 | £3,725 | £3,852 | £3,930 | £4,015 | £4,109 | £4,213 | £4,328 | £4,454 | £4,593 | |
| Subtotal Spent on Operations | £1,649 | £3,108 | £3,277 | £3,725 | £3,852 | £3,930 | £4,015 | £4,109 | £4,213 | £4,328 | £4,454 | £4,593 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £573 | £630 | £693 | £762 | £839 | £922 | £1,015 | £1,116 | £1,228 | £1,351 | £1,486 | £1,634 | |
| 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 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| 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 | £2,822 | £4,338 | £4,570 | £5,088 | £5,291 | £5,452 | £5,630 | £5,825 | £6,041 | £6,278 | £6,540 | £6,827 | |
| Net Cash Flow | £2,157 | £1,138 | £1,454 | £1,539 | £1,999 | £2,566 | £3,191 | £3,877 | £4,631 | £5,461 | £6,374 | £7,378 | |
| Cash Balance | £26,157 | £27,295 | £28,749 | £30,288 | £32,287 | £34,853 | £38,044 | £41,921 | £46,552 | £52,013 | £58,387 | £65,765 | |
| 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 | £24,000 | £26,157 | £27,295 | £28,749 | £30,288 | £32,287 | £34,853 | £38,044 | £41,921 | £46,552 | £52,013 | £58,387 | £65,765 |
| Inventory | £2,500 | £1,730 | £960 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 |
| Other Current Assets | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 |
| Total Current Assets | £40,167 | £41,554 | £41,922 | £43,263 | £44,802 | £46,801 | £49,367 | £52,558 | £56,435 | £61,066 | £66,527 | £72,901 | £80,279 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £56,000 | £55,900 | £55,800 | £55,700 | £55,600 | £55,500 | £55,400 | £55,300 | £55,200 | £55,100 | £55,000 | £54,900 | £54,800 |
| Total Assets | £96,167 | £97,454 | £97,722 | £98,963 | £100,402 | £102,301 | £104,767 | £107,858 | £111,635 | £116,166 | £121,527 | £127,801 | £135,079 |
| 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 | £1,649 | £1,459 | £1,818 | £1,908 | £1,944 | £1,985 | £2,030 | £2,079 | £2,134 | £2,194 | £2,260 | £2,333 |
| 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 | £1,649 | £1,459 | £1,818 | £1,908 | £1,944 | £1,985 | £2,030 | £2,079 | £2,134 | £2,194 | £2,260 | £2,333 |
| Long-term Liabilities | £81,210 | £80,610 | £80,010 | £79,410 | £78,810 | £78,210 | £77,610 | £77,010 | £76,410 | £75,810 | £75,210 | £74,610 | £74,010 |
| Total Liabilities | £81,210 | £82,259 | £81,469 | £81,228 | £80,718 | £80,154 | £79,595 | £79,040 | £78,489 | £77,944 | £77,404 | £76,870 | £76,343 |
| Paid-in Capital | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 |
| Retained Earnings | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) |
| Earnings | £0 | £237 | £1,296 | £2,779 | £4,728 | £7,190 | £10,215 | £13,861 | £18,188 | £23,265 | £29,167 | £35,974 | £43,779 |
| Total Capital | £14,957 | £15,194 | £16,253 | £17,736 | £19,685 | £22,147 | £25,172 | £28,818 | £33,145 | £38,222 | £44,124 | £50,931 | £58,736 |
| Total Liabilities and Capital | £96,167 | £97,454 | £97,722 | £98,963 | £100,402 | £102,301 | £104,767 | £107,858 | £111,635 | £116,166 | £121,527 | £127,801 | £135,079 |
| Net Worth | £14,957 | £15,194 | £16,253 | £17,736 | £19,685 | £22,147 | £25,172 | £28,818 | £33,145 | £38,222 | £44,124 | £50,931 | £58,736 |
| 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 | ||
| Kayman | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Jenne | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Housekeeping/Grounds Maintenance | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| 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 | |||||||||||||
| Room night @ 110.00 per night | 10% | £2,509 | £2,760 | £3,036 | £3,339 | £3,673 | £4,041 | £4,445 | £4,889 | £5,378 | £5,916 | £6,508 | £7,158 |
| Suite night @ 175.00 per night | 10% | £1,597 | £1,757 | £1,932 | £2,126 | £2,338 | £2,572 | £2,829 | £3,112 | £3,423 | £3,766 | £4,142 | £4,556 |
| Museum & Tour of Mansion @ 3.00 pp | 10% | £300 | £330 | £363 | £399 | £439 | £483 | £531 | £585 | £643 | £707 | £778 | £856 |
| Total Sales | £4,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| 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 | |
| Room night @ 20.00 cost | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | £460 | |
| Suite night @ 30.00 cost | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | £270 | |
| Museum and Tour of Mansion | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | £40 | |
| Subtotal Direct Cost of Sales | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | |
| 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 | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Long-term Interest Rate | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | 6.00% | |
| Tax 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% | |
| 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,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Direct Cost of Sales | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | £770 | |
| Other | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | £860 | |
| Total Cost of Sales | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | £1,630 | |
| Gross Margin | £2,776 | £3,217 | £3,701 | £4,234 | £4,821 | £5,466 | £6,175 | £6,956 | £7,815 | £8,759 | £9,798 | £10,941 | |
| Gross Margin % | 63.00% | 66.37% | 69.43% | 72.21% | 74.73% | 77.03% | 79.12% | 81.02% | 82.74% | 84.31% | 85.74% | 87.03% | |
| Expenses | |||||||||||||
| Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Sales & Marketing & Other Expenses | £1,000 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | £500 | |
| Depreciation | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Annual web and Assoc fees | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | £100 | |
| Utilities | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| Payroll Tax | 15% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Insurance | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | £300 | |
| Total Operating Expenses | £2,100 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | £1,600 | |
| Profit Before Interest and Taxes | £676 | £1,617 | £2,101 | £2,634 | £3,221 | £3,866 | £4,575 | £5,356 | £6,215 | £7,159 | £8,198 | £9,341 | |
| EBITDA | £776 | £1,717 | £2,201 | £2,734 | £3,321 | £3,966 | £4,675 | £5,456 | £6,315 | £7,259 | £8,298 | £9,441 | |
| Interest Expense | £403 | £400 | £397 | £394 | £391 | £388 | £385 | £382 | £379 | £376 | £373 | £370 | |
| Taxes Incurred | £35 | £158 | £222 | £291 | £368 | £452 | £545 | £647 | £759 | £882 | £1,017 | £1,166 | |
| Net Profit | £237 | £1,058 | £1,483 | £1,949 | £2,462 | £3,026 | £3,646 | £4,327 | £5,077 | £5,901 | £6,808 | £7,805 | |
| Net Profit/Sales | 5.39% | 21.84% | 27.81% | 33.24% | 38.16% | 42.64% | 46.71% | 50.40% | 53.76% | 56.80% | 59.57% | 62.08% | |
| 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,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Subtotal Cash from Operations | £4,406 | £4,847 | £5,331 | £5,864 | £6,451 | £7,096 | £7,805 | £8,586 | £9,445 | £10,389 | £11,428 | £12,571 | |
| Additional Cash Received | |||||||||||||
| Sales Tax, VAT, HST/GST Received | 13.00% | £573 | £630 | £693 | £762 | £839 | £922 | £1,015 | £1,116 | £1,228 | £1,351 | £1,486 | £1,634 |
| 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 | £4,979 | £5,477 | £6,024 | £6,627 | £7,289 | £8,018 | £8,820 | £9,702 | £10,672 | £11,740 | £12,914 | £14,205 | |
| 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 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |
| Bill Payments | £1,649 | £3,108 | £3,277 | £3,725 | £3,852 | £3,930 | £4,015 | £4,109 | £4,213 | £4,328 | £4,454 | £4,593 | |
| Subtotal Spent on Operations | £1,649 | £3,108 | £3,277 | £3,725 | £3,852 | £3,930 | £4,015 | £4,109 | £4,213 | £4,328 | £4,454 | £4,593 | |
| Additional Cash Spent | |||||||||||||
| Sales Tax, VAT, HST/GST Paid Out | £573 | £630 | £693 | £762 | £839 | £922 | £1,015 | £1,116 | £1,228 | £1,351 | £1,486 | £1,634 | |
| 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 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | £600 | |
| 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 | £2,822 | £4,338 | £4,570 | £5,088 | £5,291 | £5,452 | £5,630 | £5,825 | £6,041 | £6,278 | £6,540 | £6,827 | |
| Net Cash Flow | £2,157 | £1,138 | £1,454 | £1,539 | £1,999 | £2,566 | £3,191 | £3,877 | £4,631 | £5,461 | £6,374 | £7,378 | |
| Cash Balance | £26,157 | £27,295 | £28,749 | £30,288 | £32,287 | £34,853 | £38,044 | £41,921 | £46,552 | £52,013 | £58,387 | £65,765 | |
| 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 | £24,000 | £26,157 | £27,295 | £28,749 | £30,288 | £32,287 | £34,853 | £38,044 | £41,921 | £46,552 | £52,013 | £58,387 | £65,765 |
| Inventory | £2,500 | £1,730 | £960 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 | £847 |
| Other Current Assets | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 | £13,667 |
| Total Current Assets | £40,167 | £41,554 | £41,922 | £43,263 | £44,802 | £46,801 | £49,367 | £52,558 | £56,435 | £61,066 | £66,527 | £72,901 | £80,279 |
| Long-term Assets | |||||||||||||
| Long-term Assets | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 | £56,000 |
| Accumulated Depreciation | £0 | £100 | £200 | £300 | £400 | £500 | £600 | £700 | £800 | £900 | £1,000 | £1,100 | £1,200 |
| Total Long-term Assets | £56,000 | £55,900 | £55,800 | £55,700 | £55,600 | £55,500 | £55,400 | £55,300 | £55,200 | £55,100 | £55,000 | £54,900 | £54,800 |
| Total Assets | £96,167 | £97,454 | £97,722 | £98,963 | £100,402 | £102,301 | £104,767 | £107,858 | £111,635 | £116,166 | £121,527 | £127,801 | £135,079 |
| 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 | £1,649 | £1,459 | £1,818 | £1,908 | £1,944 | £1,985 | £2,030 | £2,079 | £2,134 | £2,194 | £2,260 | £2,333 |
| 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 | £1,649 | £1,459 | £1,818 | £1,908 | £1,944 | £1,985 | £2,030 | £2,079 | £2,134 | £2,194 | £2,260 | £2,333 |
| Long-term Liabilities | £81,210 | £80,610 | £80,010 | £79,410 | £78,810 | £78,210 | £77,610 | £77,010 | £76,410 | £75,810 | £75,210 | £74,610 | £74,010 |
| Total Liabilities | £81,210 | £82,259 | £81,469 | £81,228 | £80,718 | £80,154 | £79,595 | £79,040 | £78,489 | £77,944 | £77,404 | £76,870 | £76,343 |
| Paid-in Capital | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 | £24,840 |
| Retained Earnings | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) | (£9,883) |
| Earnings | £0 | £237 | £1,296 | £2,779 | £4,728 | £7,190 | £10,215 | £13,861 | £18,188 | £23,265 | £29,167 | £35,974 | £43,779 |
| Total Capital | £14,957 | £15,194 | £16,253 | £17,736 | £19,685 | £22,147 | £25,172 | £28,818 | £33,145 | £38,222 | £44,124 | £50,931 | £58,736 |
| Total Liabilities and Capital | £96,167 | £97,454 | £97,722 | £98,963 | £100,402 | £102,301 | £104,767 | £107,858 | £111,635 | £116,166 | £121,527 | £127,801 | £135,079 |
| Net Worth | £14,957 | £15,194 | £16,253 | £17,736 | £19,685 | £22,147 | £25,172 | £28,818 | £33,145 | £38,222 | £44,124 | £50,931 | £58,736 |
| 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 | ||
| Kayman | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Jenne | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Housekeeping/Grounds Maintenance | 0% | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 |
| Total People | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | 0 | |
| Total Payroll | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | £0 | |