7 Financial Models for Analysts, Investors and Finance Professionals: Theory and practical tools to help investors analyse businesses using Excel

Financial models in Excel are used by investment analysts and finance professionals to gain meaningful insights into a business's operations and test the potential impact of risks on performance. This guide provides step-by-step instructions for seven spreadsheet models that can be used to assess financial indicators, produce forecasts, create cash flow forecasts, understand the impact of product price changes, assess investment decisions, check the sensitivity of key financial measures to risk events, and produce a business valuation. The book also includes downloadable spreadsheets of the author's original models and introductory chapters about best practice when modeling in Excel.

Format: Hardback
Length: 204 pages
Publication date: 17 June 2019
Publisher: Harriman House Publishing

Investment analysts and other financial professionals can greatly streamline their financial analysis and forecasting processes by utilizing financial models in Excel. These models provide valuable insights into the inner workings of a business, enabling them to identify areas for improvement that can ultimately enhance bottom-line results. Moreover, financial models serve as powerful tools for assessing the potential impact of various risks on business performance, allowing analysts to make informed decisions based on data-driven analysis.

In this comprehensive guide, financial modeling expert Paul Lower offers step-by-step instructions for seven spreadsheet models that will empower users to gain a deeper understanding of the financial data generated by a business. These models can be employed to:

1. Evaluate a business's performance on key financial indicators.
2. Generate sales and cost forecasts.
3. Create a cash flow forecast.
4. Understand the implications of product price changes on profitability.
5. Assess potential investment opportunities.
6. Evaluate the sensitivity of key financial measures to risk events.
7. Generate a business valuation.

Furthermore, the book includes downloadable spreadsheets of the author's original Excel models, along with introductory chapters that provide valuable best practices for modeling in Excel. By utilizing this suite of seven tools, financial analysts can harness the power of Excel to achieve a profound understanding of a business and its financial data, enabling them to make informed decisions that drive growth and success.

Weight: 534g
Dimension: 248 x 175 x 18 (mm)
ISBN-13: 9780857195739