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.
.
.
.
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
.
.