Originally published: 22/07/2016 12:06
Last version published: 22/10/2016 14:41
Publication number: ELQ-11545-2

Evaluating Financial Performance and Forecasting

Set of worksheets related to financial analysis and forecasting

by Matt Evans
Retired consultant in Washington D.C.

25 reviews780 views|Start the discussion!|download for free

evaluation finance financial performance forecasting financial analysis

Description
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

Discuss

Further information

Use it if

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.

Reviews

- 4.8 / 5 (25 votes)
  - 88%
  - 8%
  - 4%
  - -
  - -
- Rate this Downloadable Best Practice
  Write a review
Ayah AlBtoosh(last updated: 06/11/2020 15:25)
Kỳ Tử(last updated: 14/08/2020 18:17)
*ban* Arhat Bhagwatkar(last updated: 06/07/2020 06:22)
Vu Pham(last updated: 27/06/2020 04:51)
Sukhee Turkhuu(last updated: 18/05/2020 01:21)
Παπαζαχαρίου Πέτρος(last updated: 19/04/2020 17:45)
WalidD(last updated: 31/03/2020 09:48)
Anthony Ku(last updated: 18/03/2020 09:13)
hilary sule(last updated: 27/02/2020 20:32)
Amir Ganic(last updated: 07/01/2020 13:53)
Mohamed elmasry14(last updated: 01/11/2019 15:33)
chanyanud semsantad(last updated: 30/10/2019 07:04)
Ian Karlo(last updated: 30/09/2019 19:55)
nabali&sheikh concrete(last updated: 07/09/2019 09:21)
Big Worm28(last updated: 30/05/2019 00:39)
John Smith743(last updated: 29/05/2019 06:29)
Arowolo Jelil O. ACA,CISA(last updated: 07/02/2019 10:41)
Academy of Excellence(last updated: 31/01/2019 13:52)
Tenemba Anna Samake(last updated: 03/01/2019 09:50)
敏哲王(last updated: 28/11/2018 08:27)
Thi Thu Trang Nguyen(last updated: 18/11/2018 15:39)
Dinesh Singh(last updated: 14/11/2018 07:29)
Scott Donald(last updated: 21/09/2018 05:59)
John Hanssler(last updated: 09/09/2018 13:49)
Natalija Burgieva(last updated: 18/06/2018 09:37)