Are you need IT Support Engineer? Free Consultant

Applying Financial Modeling Techniques – Sensitivity Analysis

  • By admin
  • July 1, 2016

How Does A Financial Model Work?

Financial models are quite handy when it comes to analyzing the performance of Business research outsourcing on projected/historical basis. It gives the analyst the opportunity of analyzing:

Time series results:

This compares the performance of a company in the current or base year to the company itself in past or subsequent years.

Cross-sectional results:

This compares the performance of a company to ‘substitute’ companies within the same industry segment.

Predictive Assumption

Once the financial results based on historical evidence and performance assumptions, have been fed into the system by the analyst, he can then use these numbers for the interpretation and calculation of ratios and profit margins, inventory turnovers and cash collection, among a number of other operational metrics.

These financial models hold facts but also a predictive assumption. This means that the forward looking suppositions may not always be true. Nonetheless, scenario manager allows for the incorporation of several different possibilities into the financial model. This is a good thing, as expectations often change with time.

It is never a good idea to make a claim that your financial model results are final. You cannot be certain about the future. This makes absolute perfect prediction impossible. This is because the model was developed with the aim to gain some market insight and to get a possible range of outcomes of future performances and behavior. It was not developed to get any final correct answer. For this very reason, sensitivity models when applied to financial models can be really useful.

Innumerable Possibilities:

Sensitivity analysis models are also known as data tables or ‘what-if’ analysis tables. These tables are powerful Excel tools. It allows the user to gauge the possibilities and results of the model under different circumstances. It allows for users to work with two variables or assumptions, and also see how the results change under the new assumptions. It perfectly complements the scenario manager in Excel, adding even greater functionality to the valuation models in terms of presentation and analysis.

Many a time in fact, it is not out of place for the Business research outsourcing client to simply go over the data table as well as the financial data without taking into consideration the various models presented in the report by the analyst. For this reason, it becomes doubly important that the analyst fully understands the mechanics involved in creating data tables.

It has frequently been found that excel lists often perform calculations and tabulations automatically except when it comes to data tables.

Therefore, if your data table isn’t working properly, you could do the following:

  • Press F9 so that the entire data table can be recalculated.
  • If you are using a 2003 version of excel, press Alt-T-O and select the ‘Calculations’ tab, in order to set-up Excel.
  • Or if you are using Excel 2007, hit Alt-M-X and then make your selection.

Concluding Statement:

A data table makes presentable to the Business research outsourcing client, effective financial information in an easy to understand form. It gives him the complete range of probable outcomes for a particular research. It can draw attention to the margin of safety before things turn erroneous or go out of hand. For instance, what is the break-even point of revenue growth beyond which EPS becomes negative?

Once you get used to data tables, you’ll realize how efficient and effective they really are. Best part is that constructing data tables takes no time at all when the work is handled by a team of Business research outsourcing professionals. There is thus, absolutely no reason to not include data tables in your financial modeling projects.

For any information with regards to data tables and financial models, write to us at