Evaluating Financial Performance and Forecasting

Set of worksheets related to financial analysis and forecasting

by Matt Evans
Retired consultant in Washington D.C.Follow 46

32 reviews936 views|Start the discussion!|Bookmark download for free

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