Step by Step Process to Complete Exams – Edward Bodmer

This page describes some ideas of how you could prepare for interview exams. The first step is to be able to quickly and efficiently complete a model with annual data and without any circular references without any scenarios without any adjustments for periodic payments and other complexities. I argue that you should practice the first case many times until you become very comfortable with the structure, timelines and the model equations. Once you complete the basic case you can move to a more complex case that includes INDEX, LOOKUP and SUMIF to incorporate scenarios; to incorporate monthly variation and to model semi-annual repayments in the context of monthly flows.

Step 1: Basic Model

The file for the first part is attached to the button below.

Excel file with Inputs for Simple Hydrogen Analysis that You Can Use to Practice Making a Financial Model

Step 2: Monthly Model with INDEX, LOOKUP and SUMIF

The second file and video describe more complex issues with modelling. If you can become comfortable with this model you are on the way to being able to complete more complex modelling issues.

Excel File with Monthly Inputs that is Used for Modelling with INDEX, LOOKUP and SUMIF Functions

If you really want to learn modelling and have a weekend or two you can open the file below that contains a whole lot of excel exercises as well as links to videos that explain each subject. The videos are all about two and half hours and you can try to work along with the videos if you have time. I include some simple modelling and work through to more complex modelling issues. I include the file below in various different parts of this website, so don’t be surprised if you open this file again. If you are new to modelling, I suggest you start with the first couple of subjects and make sure you can understand how to go fast in modelling and see the fundamental structure of any sheet. I put the initial table of contents generated from

File with Multiple Exercises and Associated Links to Class Videos for Working through Project Finance Modelling Issues