CONTACT
London+44 20 7947 4019
Perth+61 8 9211 6119
Singapore+65 6440 8803
Sydney+61 2 9222 9222
Vancouver+1 604 655 4435
Posted by Tim Heng in Blog, Excel Best Practice Finance Modelling, Open Tutorial, Popular Tutorial, Tutorials on April 1st, 2013
If you’re reading this, then you know that we believe in keeping financial models clean and efficient. The modern financial model has become bloated and is often 10MB or greater in size, taking up unnecessary space and creating problems transmitting … read more
Posted by Nick Crawley in Open Tutorial, Tutorials on March 8th, 2013
The OFFSET( ) function returns a cell or range of cells that is a specified number of rows and/or columns from the reference cell. In this Tutorial we will explain the most common offset() applications and mistakes that are made … read more
Posted by Nick Crawley in Open Tutorial, Popular Tutorial, Project Finance Analysis, Tutorials on February 13th, 2013
There are two different ways to calculate the average DSCR (“ADSCR”) that could result in different numerical outcomes. What are the methods? What are the limitations that we should be aware of? And which one shall be used? DSCR (Debt … read more
Posted by Rickard Warnelid in Excel Fundamentals, Open Tutorial, Popular Tutorial, Tutorials on February 12th, 2013
Range names are a useful tool in Excel that allows you to assign a name to a single cell or a range of cells. This tutorial describes how to create range names including the dynamic range and how to work … read more
Posted by Rickard Warnelid in Open Tutorial, Tutorials on January 8th, 2013
Using custom formats in Excel can significantly improve the presentation of your spreadsheets and financial models. In this tutorial we give you an overview of the main functionality and also look closer at some more advanced examples with conditional formatting. … read more
Posted by Grace Utama in Cashflow and Forecasting, Excel Best Practice Finance Modelling, Open Tutorial, Tutorials on September 20th, 2012
It is important to recognize the “Trade Debtors” and “Trade Creditors” in a cashflow model because it captures the cash cycle of the company, i.e. not all of the “Revenue” actually earned in a given period is received in the … read more
Posted by Bing Chien Quek in Excel Best Practice Finance Modelling, Excel Fundamentals, Open Tutorial, Tutorials on August 27th, 2012
Why use a dynamic chart? Charts and/or graphs can be very useful in visually displaying information and statistics to tell the users a story. A dynamic chart within your summary makes it more interactive by having several inputs that can … read more
Posted by Blake McNaughton in Cashflow and Forecasting, Excel Best Practice Finance Modelling, Open Tutorial, Tutorials on March 22nd, 2012
Financial modelling, unlike other areas of finance, is unregulated and lacks generally accepted practice guidelines. Combined with the purpose of most financial models this means that Model Risk is a very real concept. Accordingly, the majority of the world’s financial … read more
London+44 20 7947 4019
Perth+61 8 9211 6119
Singapore+65 6440 8803
Sydney+61 2 9222 9222
Vancouver+1 604 655 4435
