CONTACT US

Tell us about your project...

Get Started With Our Free Course: Essential Financial Modelling

Category Archive: Financial modelling

What is a Merger Model?

Gridlines

A merger model represents the financial position arising on the combination of two companies. Companies can combine in a number of ways including a merger under a mutual agreement to form a consolidated entity or an acquisition. An M&A model is an advanced model used to evaluate the pro forma accretion/dilution of earnings per share […]

Leave a Comment

Killer Errors – Base Dates

Gridlines

Another group of killer errors that can cause big problems are base dates for indexation, discounting, and NPV calculations. This is one close to my heart as many years ago, believe it or not, I had included an incorrect base date in an NPV calc! Thankfully it came to light before the bid went in, […]

Leave a Comment

What is a Three Statement Model?

Gridlines

A Three statement model is a basic setup for financial modelling. This type of model includes three different statements: Income statement Balance sheet Cash flow These are all linked with Excel formulas. The objective is to set it up so all the accounts are connected and a set of assumptions can drive changes in the […]

Leave a Comment

Sign up to receive “The Project” – a fortnightly quick hit of insight and resources for PF, infra, energy and PPP professionals.