Excel

Guiding Principles of Financial Modelling Guiding Principles of Financial Modelling
(0)
8,222
1210
This is an attempt to list and explain the key concepts of developing financial models (also applicable to any other…
Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below) Waterfall Chart for Pre-2016 Excel users (Excel 2013 and below)
(2)
10,217
848
Making a waterfall chart is a powerful yet simple, visually attractive and compact way of visualizing the cost structure of…
Charts and Dashboards in Excel (short version) Charts and Dashboards in Excel (short version)
(0)
8,000
811
Very few people think of Excel as being able to produce professional-quality business charts. But this is true - Excel…
Analysing data in Excel Analysing data in Excel
(0)
8,928
812
In this post I have collected a handful of techniques for working with data in Excel: looking up values, matching…
Monte Carlo analysis without macros Monte Carlo analysis without macros
(0)
7,963
768
A traditional sensitivity analysis involves testing a limited number of scenarios (e.g. base, upside and downside). Each scenario is a…
Unlocking Full Potential of Excel Data Tables (Part 1) Unlocking Full Potential of Excel Data Tables (Part 1)
(0)
7,436
698
Data tables is a powerful tool to analyze sensitivities in Excel financial models. A conventional data table is a one-…
Array Formulas in Excel Array Formulas in Excel
(0)
4,255
591
My publication on this obscure to the many yet a useful and powerful feature of Excel shows how array formulas…
Financial Model for Startup in Microsoft Excel | Entrepreneurship Financial Model for Startup in Microsoft Excel | Entrepreneurship
(0)
3,192
415
Financial Model for Startup | EntrepreneurshipNUMBERS THAT EXPLAIN YOUR STARTUP’S POTENTIALThis template includes the following worksheets:1. Capital Structure and Details2.…
CryptoCurrency Portfolio Dashboard in Microsoft Excel CryptoCurrency Portfolio Dashboard in Microsoft Excel
(0)
3,756
304
 CryptoCurrency Portfolio Dashboard in Microsoft Excel
Discounted Cash Flow (DCF) Model Discounted Cash Flow (DCF) Model
(0)
2,648
210
The Macabacus DCF template implements key concepts and best practices related to DCF modeling. It computes the perpetuity growth rate…
Venture Capital Returns Venture Capital Returns
(0)
2,155
157
The Macabacus capitalization ("cap") table and venture capital returns analysis template identifies how much venture capital a start-up requires and…
Sales Analytics Dashboard in Microsoft Excel Sales Analytics Dashboard in Microsoft Excel
(0)
2,493
191
A sales dashboard is a tool that enables c-level executives and managers to effectively control sales KPIs and monitor them…
Leveraged Buyout (LBO) Model - Short Form Leveraged Buyout (LBO) Model - Short Form
(0)
2,424
157
The Macabacus short form LBO model implements key concepts related to LBO modeling, and is an excellent starting point for…
Operating Model Operating Model
(0)
2,439
147
The Macabacus operating model implements key accounting and tax concepts, and is a foundational building block for our merger and…
Aged Receivables Dashboard in Excel Aged Receivables Dashboard in Excel
(0)
2,053
133
Aged Receivables Dashboard in ExcelThis Excel dashboard allows you to easily access your customer contact information (including customer contact information,…