Financial models in Excel allow investment analysts and other finance professionals to take the laborious number crunching out of financial analysis and forecasting. Models help them to gain meaningful insights into the way that a business is working and focus attention on areas to improve bottom-line results. They can also be used as powerful tools to test the potential impact of various risks on business performance. In this brand new guide, financial modelling expert Paul Lower presents step-by-step instructions for seven spreadsheet models that will help the user to gain a better understanding of the financial data coming out of a business. These seven models can be used to: 1. Assess how a business is performing on key financial indicators. 2. Produce sales and cost forecasts. 3. Create a cash flow forecast. 4. Understand the impact of product price changes on profitability. 5. Assess potential investment decisions. 6. Check the sensitivity of key financial measures to risk events. 7. Produce a business valuation. With this suite of seven tools, a financial analyst will be equipped to use Excel to achieve a deep understanding of a business and its financial data.
Binding Type: Hardcover
Publisher: Harriman House
Published: 06/17/2019
ISBN: 9780857195739
Pages: 204
Weight: 1.17lbs
Size: 9.61h x 6.69w x 0.50d