VersionXL - Enhanced Excel Project Finance Modeling
Project finance modeling is a complex task requiring input from many stakeholders. As Excel is the tool of choice for most modeling, we focused our efforts to help Project Finance Teams build models faster, more accurately within the world of Excel.
Read on below to get a better understanding of how VersionXL can help you with project finance modeling.
What is VersionXL?
VersionXL is an add-on to Excel that provides you with collaboration and control for your project finance models. Without having to leave the Excel world you know, VersionXL provides access management, workflow, collaboration, time-travel, and an audit log.
VersionXL Key Features
Collaboration & Scenario Planning
Improve project finance model accuracy to reduce risks whilst speeding up the process of building models with VersionXL’s collaboration tools. Enhance scenario planning by creating parallel timelines of your models to plan for an array of environmental and economic situations.
- Automated workflows and reviews to your processes: Add those sense checks and monitor the accuracy of your project finance model with bespoke workflows and review processes.
- Analysts can work at the same time on the same model: Build models faster by working concurrently on the same model. With automated merge and conflict resolution tools, eliminate waiting for colleagues and multiple spreadsheet versions being email around.
- Automated merge: Your team of analysts can work simultaneously on the same spreadsheets. Changes can then be automatically merged into the working document.
- Conflict resolution: Eliminate errors and squashing of others’ work with VersionXL’s conflict resolution tools to help your team find the right answers.
- Visualize updated documents: VersionXL enables you to see and compare changes in your spreadsheets, between any period. Something doesn’t look right? Is your model broken and not sure why? View the changes to quickly fix those bugs.
- Time travel: With each iteration of your model you can travel back in time and see what it looked like at that particular time. For example, show stakeholders the project model 12 months previous to understand what’s changed between now and then.
- Parallel timelines: Create parallel timelines that run concurrently with your main project model to add scenario planning that you can update and work with as time and events progress.
Metadata & Context
With so many stakeholders and organizations involved in project finance, communication and understanding are paramount. Lawyers, bankers, analysts, and financiers all require the model for different reasons, so ensuring that context is explained within shared models is an important facet of maintaining efficiency and accuracy.
- Metadata with every iteration: We advise on software development best practices and recommend adding comments and explainers with each commit of a spreadsheet. VersionXL prompts users to add comments about the version they submit to help other users understand changes and data context.
- Time-travel: VersionXL’s time-travel functionality enables project leaders to travel back in time and examine the contextual changes over time to build a perfect understanding of how the model has evolved.
- Show only relevant data: Create parallel copies of your project finance models and make them available to specific stakeholders showing only data relevant to them.
Access Control & Management
Organize your teams from a single dashboard and assign secure access to all of the worksheets that make up the project finance model. Ensure only those who need access to files get it and fine-tune permissions depending on stakeholder requirements.
- Access management: Assign access to spreadsheets from the VersionXL UI.
- Team management: Invite teams to work together on specific documents.
- Access history: See who has accessed what, and when.
Full Commit and Audit History
VersionXL is built using TerminusDB which is an immutable in-memory graph database. As part of the Excel extension, spreadsheet access and data changes are logged providing a full access and commit audit history. Eliminate errors, spot tampering, and identify fraud, VersionXL helps make your project finance model more secure.
- Full commit history: Every change in your project model is logged so that you can see who changed what and when. Perfect for audits and to prevent fraud and tampering.
- Metadata history: As well as a full commit history, VersionXL also provides a contextual history through metadata and helps speed up audit and regulatory requirements by providing context through the entire project history.
- Time-travel: Travel to any instance of your spreadsheets and compare them with each other to see differences. Find out who made the changes via the commit history and act as a cyber-detective.
Security and Compliance
The team at VersionXL is focused on keeping you and your data safe. We are SOC 2 compliant, which means we have demonstrated that we adhere to industry-leading standards to manage our network, secure our application, and set policies across our organization.
We are a google cloud partner.