Blog 2017-07-10T10:38:52+00:00

Modelling an Arrangement Fee Circularity

January 3rd, 2013|3 Comments

Ok, in project finance deals you’re going to come across a particularly circularity around calculating senior debt arrangement fees. This blog tutorial will focus on how to [...]

Naming Cells and Ranges in Excel

January 1st, 2013|0 Comments

At Video Financial Modelling we like to keep up to date with opinions of other financial modelling and Excel professionals. We had a quick look at an [...]

Modelling a Major Maintenance Reserve Account (MMRA)

December 30th, 2012|0 Comments

In project finance deals, major maintenance is usually very costly and infrequent in nature. For example in a toll road the road surface may need to be [...]

5 Must Know Excel Charting Tips

December 25th, 2012|1 Comment

This is a quick video blog tutorial showing you some of the must know Excel charting tips. [...]

Checks and Balances – Excel 2007 Conditional Formatting

December 19th, 2012|0 Comments

What is conditional formatting? Conditional formatting in Excel ensures cells are formatted based on certain criteria. For [...]

Mini-Perms in Project Finance

October 3rd, 2012|1 Comment

In this blog tutorial the Video Financial Modelling team dives into the world of mini-perms. And no [...]

Why you don't need to be a VBA Macro master to build a Financial Model – Part 2

September 22nd, 2012|3 Comments

In part 2 of our “Why you don’t need to be a macro master to build a [...]

Why you don't need to be a VBA Macro master to build a Financial Model – Part 1

September 11th, 2012|1 Comment

Many self-proclaimed financial modeling experts will tell you that you need to have a good grasp of [...]

Brownfield Infrastructure Asset Valuation

September 1st, 2012|0 Comments

Ever wonder how to value a Brownfield infrastructure asset? Well check out our Ezine article. Click here. [...]

Modelling a Debt Service Reserve Account (DSRA)

February 2nd, 2012|1 Comment

Blog Downloads: This tutorial looks at modelling a debt service reserve account or DSRA. What is a [...]

Working Capital – Debtors and Creditors

December 6th, 2011|1 Comment

Blog Downloads: If you've been working or studying in finance you have probably heard of working capital [...]

Financial Modelling – Sensitivity and Scenario Analysis

November 21st, 2011|3 Comments

Blog Downloads: If a financial model is setup using best practice modelling techniques then putting sensitivities and [...]

MOD Function – Bridging the Time Gap in Excel

November 14th, 2011|5 Comments

Blog Downloads: Say you had quarterly data and you want to collect this data onto a yearly [...]

Construction Funding and Interest during Construction

October 17th, 2011|6 Comments

Blog Downloads: Introduction Greenfield (think of new build) project finance deals consist of both construction and operations [...]

Free Bonus Excel Shortcuts

September 28th, 2011|4 Comments

Blog Downloads: Instructions for downloading your free shortcuts download and copy the Macrostarter.xlsm to your desktop go [...]

Excel and Financial Modelling Training Courses

September 20th, 2011|1 Comment

For those of you who don’t know Video Financial Modelling has recently launched their face-to-face group Excel [...]

Corkscrew accounts. What the?

September 10th, 2011|2 Comments

Blog Downloads: Introduction Now if you have been following Video Financial Modelling for a while, you should [...]

CFADS and DSCR – Sculpting

August 17th, 2011|3 Comments

Blog Downloads: OK, so you have grasped the project finance definition of CFADS and DSCR from our [...]

CFADS and DSCR – Words from a Foreign Language?

July 28th, 2011|5 Comments

Blog Downloads: Some of you might be wondering whether CFADS and DSCR are words from another language. [...]

Calling all Excel Logical Operators

July 20th, 2011|2 Comments

Blog Downloads: Forget telephone operators, who almost always put you on hold, today we’re talking about Excel [...]

Excel NPV Function

July 15th, 2011|0 Comments

Blog Downloads: What is an NPV? Simply put an NPV or net present value is a way [...]

5 Must Know Excel Shortcuts

July 1st, 2011|1 Comment

Blog Downloads: There is one word for improving your efficiency in Excel. Shortcuts. In laymen terms shortcuts [...]

Car Indicators – How they can help you model in Excel

June 4th, 2011|2 Comments

Blog Downloads: How could flickering car indicators possibly help you model in Excel. All will be revealed [...]

As Exciting as the Birth of your First Child

May 26th, 2011|0 Comments

Whilst it might not be the birth of your first child the Video Financial Modelling Blog launch [...]