About Financial Modeling Dashboards
Dashboards are a great way to output the results of a financial modelTypes of Financial ModelsThe most common types of financial models include: 3 statement model, DCF model, M&A model, LBO model, budget model. Discover the top 10 types of Excel models in this detailed guide, including images and examples of each. Financial modeling is performed for many reasons including to value a business, raise money. By creating a 1-2 page summary with charts, graphs, and table, an Analyst can clearly explain what the numbers in the model are saying. Common features of a dashboard from a financial model include (1) revenueSales RevenueSales revenue is the starting point of the income statement. Sales or revenue is the money earned from the company providing its goods or services, income, margins, and profit charts, (2) cash flow bar charts, (3) balance sheet items, (4) bullet charts showing actual vs. target results, (5) combination of bar and line charts, and (6) data tables showing sensitivity analysisWhat is Sensitivity Analysis?Sensitivity Analysis is a tool used in financial modeling to analyze how the different values for a set of independent variables affect a dependent variable under certain specific conditions. Sensitivity Analysis is performed in Excel to asses risks, measure potential outcomes, and plan for an uncertain future.
