DCF Sensitivity Analysis using Excel Data Table

The Excel Data Table “What-if Analysis” tool is one of the most powerful, yet underutilised functions in Excel. It is a great way to deliver a high-level, informative what if analysis of a company’s financial position such as its Net Present Value (NPV) from a Discounted Cash Flow (DCF) schedule.

Read More

How to create a dynamic drop-down list from a horizontal range

This is a follow-up to “How to create a dynamic drop-down list in your financial model”, but this article focuses on creating a dynamic drop-down list from a horizontal range or data array. A dynamic drop-down list can equally update and expand seamlessly, whenever additional items are added to a horizontal array of data.

Read More

How to create a Waterfall Chart in Excel

This article shows how to create a simple Waterfall Chart in Excel. It will apply the bar or column chart template with “Stacked Column” properties, which will produce an aesthetically pleasing graph of financial performance; based on a specified key performance indicator (KPI) over a selected time period i.e. EBITDA.

Read More

How to create a dynamic VLOOKUP

Excel’s VLOOKUP function is undoubtedly one of the most popular Excel functions. It can readily interpret and report values in large data arrays; unlike a PivotTable, which needs to be manually updated to reflect source data changes. Often this Excel function finds it difficult to reflect changes to source data. A dynamic VLOOKUP that incorporates the COLUMN function will overcome this challenge of changing source data.

Read More