Evaluating Financial Performance and Forecasting
Originally published: 22/07/2016 12:06
Last version published: 22/10/2016 14:41
Publication number: ELQ-11545-2
View all versions & Certificate

Evaluating Financial Performance and Forecasting

Set of worksheets related to financial analysis and forecasting

This model is designed To illustrate concepts related to financial analysis and forecasting. The financial analysis uses a combination of ratios and industry averages to evaluate the financial performance of the company. Trend line graphs are also generated, comparing the company's performance with the industry averages.Finally, the historical information is used to prepare a set of pro forma financial statements using both linear and non-linear functions.

You will need to collect financial statements for several reporting periods. If you want to benchmark the performance against the industry, then you will also need to collect industry averages. The spreadsheet is setup to capture five reporting periods (annual, quarterly, monthly). All input fields are highlighted in yellow.
For best results, SEC Filings are suggested since these reports provide more detail than published financial statements.

This Best Practice includes
1 Excel Model

Matt Evans offers you this Best Practice for free!

download for free

Add to bookmarks


Further information

This spreadsheet uses certain financial functions (such as =TREND) which might not be found in your version of Microsoft Excel. To take full advantage of financial and statistical functions, you should install the Add On package titled: Analysis ToolPack.

4.8 / 5 (33 votes)

please wait...