Review & Export
The five-year P&L, monthly run-rate and investment case, assembled from every section. Export the investor pack once all inputs are complete.
7 sections still to confirm: Concept & Format · Site & Build Costs · Revenue Model · COGS & Menu · Labour & Staffing · Operating Costs · Financing — sections tick off as soon as you edit them.
Five-year profit & loss
Year 1 is the current run-rate · revenue +4%/yr · cost inflation +3%/yr — placeholder assumptions
Year 1Year 2Year 3Year 4Year 5
Revenue £1,659,840£1,726,234£1,795,283£1,867,094£1,941,778
Cost of goods sold −£479,362−£498,536−£518,478−£539,217−£560,785
Gross profit £1,180,478£1,227,697£1,276,805£1,327,877£1,380,993
Labour −£397,340−£409,260−£421,538−£434,184−£447,210
Overheads (incl. rent) −£552,000−£568,560−£585,617−£603,185−£621,281
Operating profit £231,138£249,877£269,650£290,508£312,502
Debt service −£59,038−£59,038−£59,038−£59,038−£59,038
Net profit £172,100£190,839£210,612£231,470£253,464
Net margin 10.4%11.1%11.7%12.4%13.1%
Cumulative net cash £172,100£362,939£573,551£805,020£1,058,484
Initial investment of £599,500 is repaid from net cash during Year 4 (3.5 yrs at the year-1 rate).
Monthly profit & loss
Harbour & Vine · Draft v3
Revenue £138,320 100%
Cost of goods sold −£39,947 28.9%
Gross profit £98,373 71.1%
Labour −£33,112 23.9%
Overheads (incl. rent) −£46,000 33.3%
Operating profit £19,262 13.9%
Debt service −£4,920 3.6%
Net profit £14,342 10.4%
Investment
Fit-out £380,000
Kitchen & equipment £120,000
Pre-opening £45,000
Contingency £54,500 10%
Total investment £599,500
Funded by equity £359,700 60.0%
Funded by debt £239,800 £4,920 / mo
Viability
Prime cost 52.8% ceiling 60%
Break-even revenue £107,923 per month
Payback period 3.5 yrs on net cash
Year-1 return on investment 28.7%