Corrections to the financial model:
0. Transfer the financial model to Google Sheets
1. Insert the logo
2. Sheet 2 (Investments) - group expenses by categories, with the ability to expand the category and see details.
3. Sheet 3 (Income) - convert everything into one horizontal table with hidden month columns (and the ability to expand them) + add a slice of average indicators per month (average check, occupancy, turnover per month) over years 1-5.
4. Sheet 4 (Financial results and payback): all data in one horizontal table (hide month columns),
- check payback in months
- cumulative net profit (accumulated) starts from the investment value with a minus
- Financial result: add margin and ROI, add a row "Expenses", add a column "on average per month" (revenue, expenses, net profit, occupancy)
5. Add the logo to each sheet
6. Add 1 sheet: General average business indicators:
- Investments
- Income
- Expenses
- Net profit
- Margin
- ROI
- Payback (years)
- Charts (break-even point, pie chart of investments, chart of income/expenses/profit)
- Average check
- Occupancy