Dashboard Actuals PnL Model!! Kindly use the latest Microsoft Excel Version before purchasing the model, otherwise the dynamic dashboard will NOT work.!! Dashboard Actuals P&L Model generates a dynamic dashboard which can be filtered both by country and by month. The dashboard is based on 2 tables, namely Revenue Table and Expense Table. The model is intended to be used in a specific calendar year and allow the user to enter actual data for both revenue items and expense items.

you can also adjust the payments per year of the tranches (maximum 12)

In the Graphs tab: Various graphs present the investment and operating costs

and then the initial working capital

Total Capital and Leverage Ratios)

minimum and maximum

- Expense Forecasting: operating expenses

Permits and Other

and then the user needs to split the equity financing between the sponsor and the investor

Equity and Liabilities

and the loan life coverage ratio

- Costs (Variable and Fixed): cost of food

and revenue enhancement