Set up data structure for every investement vehicle, stablishing:

• Key Activies
• Investment Indicators

Structure accounting data for cash flow models, consisting on:

• Map Chart of Accounts to Reporting Structure

Gather accounting entries for all assets and vehicles, delivering:

• Reconciled balances (CF vs. Accounting)
• Updated Actuals model (asset & vehicle)

Gather budgeting information from operating key team members, delivering:

• Forecast analysis by key activities
• Updated Forecast models (asset & vehicle)

Combine Actuals and Forecast models, establishing:

• Overlapping criteria
• Closing criteria

Define scheduling parameters for both Assets and Vehicle, establishing:

• Alternative schedules
• Milestones for Base and Alternative schedules

Define contingency parameters for both Assets and Vehicle, establishing:

• Contingency types
• Modification criteria

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

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

Set up reporting content and formats, including:

• Scenarios
• Investment Indicators (over 100 different metrics)

Export bespoke reports on various output formats:

• PDF / XLS
• Tableau

Provide a preliminary analysis of the reporting data, identifying:

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

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