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…

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

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

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…

Financial Model for Startup | EntrepreneurshipNUMBERS THAT EXPLAIN YOUR STARTUP’S POTENTIALThis template includes the following worksheets:1. Capital Structure and Details2.…

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

 CryptoCurrency Portfolio Dashboard in Microsoft Excel

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

The Macabacus capitalization ("cap") table and venture capital returns analysis template identifies how much venture capital a start-up requires and…

The Macabacus operating model implements key accounting and tax concepts, and is a foundational building block for our merger and…

The Macabacus short form LBO model implements key concepts related to LBO modeling, and is an excellent starting point for…

 

Aged Receivables Dashboard in ExcelThis Excel dashboard allows you to easily access your customer contact information (including customer contact information,…