Excel

This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…

Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…

A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…

In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…

Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…

My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…

 CryptoCurrency Portfolio Dashboard in Microsoft Excel

A sales dashboard is a tool that enables c-level executives and managers to effectively control sales KPIs and monitor them…

 Financial Planning Calculators in Excel & What IF Analysis. CREDIT CARD INSTALLMENTS | CAR LOAN | PERSONAL LOAN. Example of…

 Loan Amortization Schedule in Microsoft Excel

 

Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…

This is a comprehensive Dashboard Template for typical kinds of Analysis including Sales Analysis, Variance Analysis, etc.

This is the second part of my publication explaining an advanced and little-known method of using data tables for sensitivity…

The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate…