1. Home
  2. GRITS Guide
  3. Goals Tab
  4. Scenario Page – Cash Flow Table

Scenario Page – Cash Flow Table

The Cash Flow Table displays all of the transactions and financial savings (projected or actual) associated with your scenario projects. The data is available for each fiscal year in the scenario’s lifespan, which begins with the earliest installed project and ends on the project expiration date furthest in the future. Each row corresponds to a full fiscal year. Click any row to expand it and see a data breakdown for each active project in that year. Active projects are those that are projected for installation before or during the fiscal year being reviewed and have not yet reached the end of their lifespan. All financial information is presented in your institution’s currency.

Several columns appear in the table:

  • Expenditures: The total amount of money spent on projects. The table typically displays the Project Expenditure transaction amount for each project. If a project is Proposed or no expenditure transaction has been created, then its proposed cost is shown instead.
  • Savings: The sum of all financial savings from all active scenario projects. Savings begin to accrue on each project’s projected or actual install complete date and stop at the end of the project lifespan.
  • Rebates: The sum of all Project Rebate transactions from all active scenario projects.
  • Fiscal Year Total: The aggregate cash flow in each fiscal year.
    • Equation: Savings + Rebates – Expenditures
  • Cumulative Total: The running cash flow, showing the overall savings achieved by the scenario. The sum of the current and all prior Fiscal Year Total amounts.