Portfolio Insights Dashboard - Product Advisory
November 2021
Business Summary
The Portfolio Insights Dashboard is designed to provide a high-level performance snapshot of your leasing portfolio. Information provided on this dashboard can help executives, CFOs, and controllers monitor important KPIs and analytics that help with critical decision making. This dashboard has 5 tiles that provide data about deal status, classification, NBV, Cost, and Evergreen. Additionally, the analytics section located below the tiles provides month over month, and year over year analysis of natural account balances and activities.
Generating the Dashboard
“Fiscal Month” and “Ledger” are the main drop-downs that generate the dashboard. For Fiscal Month, the drop-down is preselected with prior fiscal month’s end date with respect to system date. The Ledger drop-down is also pre-selected as the ledger with the greatest number of active deals. “Save current parameters and resubmit” check box allows the user to save the preferred ledger that dashboard defaults to, should the user logout or navigate to another section of the environment.
Report Parameter Definitions
Parameter |
Definition |
|---|---|
Fiscal Month |
Filters the fiscal periods and is prepopulated with period end dates. This is a required field. |
Ledger |
Filters the customer ledgers via a drop-down menu. This is a required field. |
Dashboard Output
Below table explains the data each tile represents, how to access options, and how the information can be validated against reports.
Dashboard Output Definitions
Dashboard Tile |
Explanation |
Report Validation/Click Option |
|---|---|---|
Lease Status |
The number of deals that are in Active, Evergreen, and Renewed status for the period/ledger selected. |
BYOR Portfolio can be used to produce detail level report.
Click on each bar to generate schedule level data in a new workspace window. |
Lease Classification |
Classification breakdown of the same deal population associated with the Lease Status tile. The pie chart shows the number of Capital, Capitalized-Operating, Operating, and Non-Lease deals existing in Active, Evergreen, and Renewed status for the period/ledger selected. |
BYOR Portfolio can be used to produce detail level report. Click on each classification to minimize section on the pie chart. Click on each pie chart segment to generate schedule level data in a new workspace window. |
|
NBV of ROU NBV of Liabilities Expense |
The sum of the following YTD account balances as of the Fiscal Month selected. NBV of ROU:
NBV of Liabilities:
Expense:
|
Click on each amount to see exportable schedule level data from Schedule Account Balance Trend Report as well as parameters for running the same report in new workspace window. |
Cost/Month |
Monthly Lease Rental Expense: The sum of "Lease Rental Expense - CapOp Depreciation" and "Lease Rental Expense" account activity of Active, Evergreen, and Renewed deals for the period/ledger selected. Spent Monthly Towards Evergreen:
Percentage is calculated using the following formula:
|
Schedule Account Activity Trend Report can be used to produce detail level report. No click option on this tile. |
Evergreen Cost Last 12 Months |
The graph shows fluctuations in evergreen cost (Spent Monthly Towards Evergreen) for the last 12 accounting periods. |
Schedule Account Activity Trend Report can be used to produce detail level report. Hover over the graph to see the exact evergreen cost per period. |
Analytics
This section of the dashboard demonstrates cross comparison of Month over Month (MoM) and Year over Year (YoY) analysis of Balance Sheet and Income Statement. This analysis is done on natural account level and is exportable into Excel, CSV, and PDF documents. The analytics section is defaulted to MoM variance analysis, however, this can be changed to YoY view by using the analytics drop-down menu. The following describes how Balance Sheet and Income Statement analytics work:
MoM Balance Sheet Analytics represents YTD balances for the period/ledger selected, YTD balances for the prior period, delta between the YTD balances, as well as percentage change of the delta.
MoM Income Statement Analytics represents activity for the period/ledger selected, activity for the prior period, delta between the activities, as well as percentage change of the delta.
YoY Balance Sheet Analytics represents YTD balances for the period/ledger selected, YTD balances for the same period but prior fiscal year, delta between the balances, as well as percentage change of the delta.
YoY Income Statement Analytics represents YTD activity up to the period/ledger selected, YTD activity up to the same period but prior fiscal year, delta between the activities, as well as percentage change of the delta.
Delta is the difference between current and prior period.
Percentage change of the delta = delta / prior period
Additional Notes
Users should be aware of the following important notes:
Data presented on the dashboard is limited to user’s access and visibility to deals in the portfolio. This works the same way with data presented on various reports.
If the value for prior period column of analytics is 0, and current period columns of analytics has value, then the 0 is treated as 1 for percentage change calculation of delta. This function is in place to avoid producing null value for percentage change of the delta.