Blog

We share our latest thinking and discuss current topics in project finance. We welcome your contribution – feel free to comment online or contact the blogger with your comments.

Find the big errors in a financial model quickly
Find the big errors in a financial model quickly

By Nick Crawley on June 7 2009

Using the keyboard in Excel can deliver much more than just time efficiency, there are some pretty cool things hidden away in Excel but finding out what they are can be hard work - little gems like this are covered on our training course so if you didn't know this maybe investigate PFM(A).... Read more
KPMG London win a 1 in 1,000 financial modelling training offer.
KPMG London win a 1 in 1,000 financial modelling training offer.

By Nick Crawley on June 3 2009 | No comments We have today announced the winner of our free training course, the prize goes to Amalia Figueroa from KPMG in London. The prize is a spot on one of our popular two day London financial modelling courses held every quarter which has a value of GBP 1,500. The next course is PFM(A) at the end of this month in London on the 18th and 19th of June.... Read more

Are there cultural hurdles to reducing financial modelling risk?
Are there cultural hurdles to reducing financial modelling risk?

By Anna Kim on June 3 2009 | No comments Our increasing exposure to the Korean market has made me think about how a corporate culture can encourage or discourage certain aspects of Best Practice Modelling. A recent assignment gave me the opportunity to work closely with a client in Seoul. Whilst there I was able to experience first hand the corporate culture and how certain aspects could adversely affect the standard of financial modelling. Certain aspects such as peer review can be regarded as a lack of trust. Challenges like this regardless of country the team and/or company culture can have a big impact on the promotion of new concepts, such as good modelling and quality control. So how can a good team culture improve good financial modelling? Well there are a few angles worth exploring... Read more

6 considerations when calculating the NPV in Excel.
6 considerations when calculating the NPV in Excel.

By Nick Crawley on June 1 2009 | No comments Last week I was asked, more times than usual in a week, “what is the best way to calculate net present value?”.... Read more

VAR(DSCR) is a useful measure for comparing projects.
VAR(DSCR) is a useful measure for comparing projects.

By Nick Crawley on May 28 2009 | No comments I recently had an interesting discussion on my earlier article on how a little more science could make the DSCR a more powerful metric. In summary two project finance professionals debated if running scenario analysis isn’t more meaningful. My comment to this is below and I think articulates my earlier point a little better by putting the ‘variance’ of the DSCR out there as a measure of the ‘base case’ rather than of the sensitivity of the model to movements in underlying assumptions.... Read more

Training - let’s just give it away!
Training - let’s just give it away!

By Nick Crawley on May 27 2009 | No comments Following on from earlier posting that we are working to make Financial Modelling Training FREE I am pleased to report that based on the overwhelming praise we are receiving on the provision of our FREE Tutorials on the web page - I think we are taking a definite step closer. Our London course cost has been reduced to GBP 1,500 (no VAT) and because we really do care and what to ensure you learn that there is a really easy way to being a financial modelling star - if you think its more than you can afford - just tell us!... Read more

DSCR - it can’t be any simpler - but it could be smarter.
DSCR - it can’t be any simpler - but it could be smarter.

By Nick Crawley on May 21 2009 | No comments A big part of my professional life has been spent calculated a very simple ratio, the Debt Service Cover Ratio (the “DSCR”) and I don’t think it could get much easier! Assuming that you are happy calculating this ratio and you understand its importance in the project finance world then how about we step it up a gear? Due to my mathematical grounding before switching to the dark side of the world of finance I am probably biased when I say so much more can be done with this ratio rather than just... Read more

Building financial models with a babel fish!
Building financial models with a babel fish!

By Nick Crawley on May 18 2009 | No comments An interesting parameter of building project financial models is that we get to travel all over the world and / or work with clients in a wide variety of locations. Many of them use different Excel versions and I have had lots of fun with circular references in Japanese and Debug messages in Arabic….to name but a few! The babel fish from hitchhikers guide to the galaxy would be really useful sometimes.... Read more

Circular reference on Debt Service Reserve Account - no thanks!
Circular reference on Debt Service Reserve Account - no thanks!

By Anna Kim on May 7 2009 | No comments Have you ever found yourself building your financial model when your coding of a flexible target for the debt service reserve account (”DSRA”) causes a circular reference? If yes, well welcome to the world of project finance modelling and don’t worry, it is not unusual and you are not the only one at this very minute having the same issue! This situation, in many instances is due to a simple coding error and I would refer you to our tutorial but often, especially if you are repaying debt via a cash sweep mechanism the logic is indeed circular. Further more this is probably because of the interest earned on the DSRA/c balance causing an issue with tax payments.... Read more

Are you for Real?!
Are you for Real?!

By Nick Crawley on May 6 2009 | No comments The age old question in preparing a financial model is whether or not to do so on a real or nominal basis - and it is still going! In a nutshell, real is where economic inflation, such as CPI and labour growth indices are not factored into analysis and nominal is when they are.... Read more

Lynas Corp turbo charge rare earth project!
Lynas Corp turbo charge rare earth project!

By Nick Crawley on May 1 2009 | No comments After months of uncertainty about the future operations of ASX listed Lynas Corp Ltd (Lynas) the company today announced a binding heads of agreement with China Non-Ferrous Metal Mining (Group) Co. Ltd (CNMC) to become the new majority shareholder in Lynas.... Read more

Subscribe to our newsletter

You will go into the draw to WIN a FREE training course.

Instantly unsubscribe at any time. We value your privacy.

Project Finance Training around the globe.

We provide leading project finance professionals with in-house training and four public courses in Asia, Europe, US and the Middle East.

Upcoming Courses: