Integrated Financial Management Service

This page is not visible on mobile devices. Please open this on a desktop or tablet device.

Data Management

Gather updated information from your teams and service providers and convert it into the data that feed your models.
Scope
Set Up
(reviewed monthly)
Delivery
(monthly)
Requeriments
(to be provided by Customer)
Reporting Structure

Set up data structure for every investement vehicle, stablishing:

  • Key Activies
  • Investment Indicators
Underwriting / Budgeting / Modeling template
Accounting Criteria

Structure accounting data for cash flow models, consisting on:

  • Map Chart of Accounts to Reporting Structure
Chart of Accounts
Accounting data

Gather accounting entries for all assets and vehicles, delivering:

  • Reconciled balances (CF vs. Accounting)
  • Updated Actuals model (asset & vehicle)
General Ledger (updated monthly)
Forecast data

Gather budgeting information from operating key team members, delivering:

  • Forecast analysis by key activities
  • Updated Forecast models (asset & vehicle)
Criteria/updates from
Asset/Portfolio Mananger

Parametric Modeling

Build and update your investment models, track key investment indicators and alert you of relevant changes.
Scope
Set Up
(reviewed monthly)
Delivery
(monthly)
Requeriments
(to be provided by Customer)
Base Model

Combine Actuals and Forecast models, establishing:

  • Overlapping criteria
  • Closing criteria
Criteria/updates from
Asset/Portfolio Mananger
Scheduling

Define scheduling parameters for both Assets and Vehicle, establishing:

  • Alternative schedules
  • Milestones for Base and Alternative schedules
Criteria/updates from
Asset/Portfolio Mananger
Contingencies

Define contingency parameters for both Assets and Vehicle, establishing:

  • Contingency types
  • Modification criteria
Criteria/updates from
Asset/Portfolio Mananger
Scenarios

Create/update multiple scenarios (combination of schedules + contingencies), delivering:

  • Tracking of Investment Indicators
  • Auditing of relevant variations of Investment Indicators

Bespoke Reporting

Provide bespoke reporting outputs to respond to your stakeholders’ requirements and enhance your performance.
Scope
Set Up
(reviewed monthly)
Delivery
(monthly)
Requeriments
(to be provided by Customer)
Reporting Templates

Set up reporting content and formats, including:

  • Scenarios
  • Investment Indicators (over 100 different metrics)
Reporting template
Export Reports

Export bespoke reports on various output formats:

  • PDF / XLS
  • Tableau
Preliminary Analysis

Provide a preliminary analysis of the reporting data, identifying:

  • Opportunity/risk situations (outliers, gaps,...)
  • Potential errors and missing data
DataBase Archive

Archive all relevant data in a proprietary data base to allow for future:

  • Auditability of any critical change in the models (When / Why / Who / How)
  • Feeding a future AI deployment
CONTACT US >
Portfolio Lifecycle Management for CRE
© Copyright 2021 by ExcelSense, LLC. All rights reserved.