Using Analytical Tools in Financial Modeling

Using Analytical Tools in Financial Modeling

Several types of analytical tools are available to help a good financial analyst develop the big picture and perform sanity checks on the results of a financial modeling project to ensure that results are reliable and within expectations.

Horizontal analysis helps identify abnormal changes over time.

Vertical analysis, or common-sized statements, can be used to develop insights into the economic characteristics of different industries and of different firms in the same industry.

Financial ratios are tools for interpreting financial statements to provide a basis for valuing securities and appraising financial and management performance.

Whilst these analytical tools can be deployed easily in an Excel spreadsheet, some financial analysts prefer to use commercial software to perform financial analysis, especially when dealing with large volumes of data or complicated data sets where a high degree of accuracy is required, or to automate manual data consolidation processes.

Examples of such commercial software include Analysis-One, Alight Planning, Quantrix, Whitebirch Planning and Risk Hive, amongst many other packages that exist in the market today.

If you are across other types of commercial financial modeling and analysis software, please do let us know what they are by leaving a comment.

Visit Finance 3.0 - don't miss out on this high quality financial learning opportunity

Comment on this article