Data Tables is a powerful tool to help you analyze sensitivities in Excel financial models. A conventional data table is a one- or two-dimensional table showing the results of a calculation (model outputs) at various model inputs in the headings of rows and/or columns of the data table. In the attached files, we will study the essential principles of data tables. But the abilities of data tables stretch far beyond that. In the attached files I have collected some advanced methods of using data tables in the sensitivity analysis.
Data Tables Version: Free Template Introduction
Explains the basics of data tables and show how to create them. Then it demonstrates how to perform the following analyses using data tables:
– a summary table showing the key metrics by scenario
– a high-level cash flow summary for each scenario
– a “tornado” chart showing the effect of every input change on the model’s outcome
Data Tables Version: Full Excel Template
This is an extended version of the file which shows how to:
– link several data tables to the same model;
– locate data tables, their input cells, and the model on different sheets
– add a switch (on/off) to speed up calculations;
– draw a waterfall chart.
The tables and charts are updated as you change any input. This is especially effective at a meeting or presentation.
Similar Products
Other customers were also interested in...
Complete Three-Statement Monthly Budget with Scena...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Quarterly Budget with Sce...
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Quarterly Budget
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Three-Statement Monthly Budget
This is a comprehensive set of templates that will help you build your budget. The templates are bui... Read more
Complete Private Equity (LBO) Financial Model
This is a professional financial model which performs a thorough assessment of a private equity proj... Read more
Private Equity Fund Model (Investor Cashflows)
Private Equity Financial Model to analyze fund cashflows and returns available to Limited Partners (... Read more
All My Financial Models, Spreadsheets, Templates, ...
Lifetime access to all future templates as well! Here is a set of spreadsheets that have some of the... Read more
Due Diligence P&L – Exhaustive Revenue a...
Model for in depth understanding of high level profit and loss and revenue analysis. Big-4 like chec... Read more
Advanced Financial Model with DCF & Valuation
New Version Updates:• Model is now dynamic. Users can select the desired forecast length for up to... Read more
Startup Company Financial Model – 5 Year Fin...
Highly-sophisticated and user-friendly financial model for Startup Companies providing a 5-Year adva... Read more
You must log in to submit a review.