Financial Model Version Tracker

Description
When you release a new version of a financial model, the first thing that the receiver wants to know is : What has been changed? And what’s the impact of the changes on the key project metrics?

You can always put it in writing but a lazy and efficient way to do the version comparison is to include a tracker sheet and save the key inputs and outputs of different versions of the model.

In the accompanying excel sheet, I’ve put together a template that does this. The template is just the skeleton and you need to link your key assumptions and results to bring life into it.

I also use this sheet to do scenario analysis. I find it quite helpful when I’m running simulations live in a meeting and use it to compare saved scenarios.

The excel template contains a number of VBA codes:
- a copy and paste code to save the active scenario and color code it.
- User Defined Functions to get the last saved date and the last user name

the accompanied PDF manual explain the steps on how to use the excel template and insert it within your own financial model. It also touches on the importance of having a file naming conventions and gives you example of naming conventions that you can adopt across your model versions.

Password Protected VBA: No

Cost: Free