Providing cost-effective Excel and financial modelling training courses.

This author has not yet filled in any details.
So far admin has created 24 blog entries.

## Modelling an Arrangement Fee Circularity

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 model this circularity. What is an Excel circularity? In basic terms an Excel circularity is where a calculation refers to itself. In Excel you can allow circularities and [...]

By | 2013-01-03T12:16:46+00:00 January 3rd, 2013|Blog|3 Comments

## Naming Cells and Ranges in Excel

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 article http://www.fimodo.com/2009/08/3-approaches-to-avoid-complex-off-sheet-references/ which fimodo produced regarding off-sheet references. Whilst fimodo is great and has a lot of fantastic articles, we tended to disagree with the extensive use of [...]

By | 2013-01-01T02:29:53+00:00 January 1st, 2013|Blog|0 Comments

## 5 Must Know Excel Charting Tips

This is a quick video blog tutorial showing you some of the must know Excel charting tips. You can follow on with some examples by opening both the above Excel spreadsheet and the video tutorial. Tip 1: F11 to quickly chart Simply select data and then press F11 to chart the data. You can also [...]

By | 2012-12-25T15:28:29+00:00 December 25th, 2012|Blog|1 Comment

## Checks and Balances – Excel 2007 Conditional Formatting

What is conditional formatting? Conditional formatting in Excel ensures cells are formatted based on certain criteria. For example if we have a cell is equal to “No” and we want to colour all cells equal to “No” red, then we can do this using conditional formatting. Why use it in financial modelling? There are a [...]

By | 2012-12-19T03:53:29+00:00 December 19th, 2012|Blog|0 Comments

## Mini-Perms in Project Finance

In this blog tutorial the Video Financial Modelling team dives into the world of mini-perms. And no we are talking about those 80’s hairstyles. What are Mini-Perms? Mini-perms are lending instruments which are intended to be refinanced out after a short timeframe usually 5-7 years. A number of project finance and PFI deals have been [...]

By | 2012-10-03T07:21:37+00:00 October 3rd, 2012|Blog|1 Comment

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

In part 2 of our “Why you don’t need to be a macro master to build a Financial Model” we are going to look at the main types of macros you’ll need to produce an advanced financial model. The three types of macros we are going to look at are: A goal seek macro – [...]

By | 2012-09-22T10:19:39+00:00 September 22nd, 2012|Blog|3 Comments

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

Many self-proclaimed financial modeling experts will tell you that you need to have a good grasp of Visual Basic for Applications (VBA) and macros. Well at Video Financial Modelling we are here to tell you that you don’t. Well not if you’ve read this article. Why do we need macros? In simplistic terms a macro [...]

By | 2012-09-11T18:48:10+00:00 September 11th, 2012|Blog|1 Comment

## Brownfield Infrastructure Asset Valuation

Ever wonder how to value a Brownfield infrastructure asset? Well check out our Ezine article. Click here. Also grab the video and accompanying spreadsheet.

By | 2012-09-01T12:23:01+00:00 September 1st, 2012|Blog|0 Comments