The Handbook of Financial Modeling - A Practical Approach to Creating and Implementing Valuation Projection Models

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance-and teaching others to do the same-The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.

Sommario

1. Financial Modeling: An Overview
2. Financial Modeling Best Practices
3. Modeling Functions and Tools
4. Planning Your Model
5. Testing and Documenting Your Model
6. Designing and Building Your Model
7. The Model User: Inputs
8. An Introduction to Finance and Accounting for Modelers
9. Managing and Evaluating a Business for Modelers
10. The Implications and Rules of Accounting for Modelers
11. Financial Based Calculations
12. Logical and Structural Based Calculations
13. How to Capture Document and Track Assumptions in Your Model
14. Modeling to Give the User Transparency
15. Model Testing and Auditing
16. Modeling Handover Dos and Don'ts.
17. Case Study: Building a Full Life Cycle Model
18. Additional Tools and VBA for Financial Models
19. What is the Future of Financial Modeling?
20. Keyboard Shortcuts
21. Finance and Accounting Glossary
22. Readymade Functions
23. Sample Outputs
24. Housekeeping
25. References

Info autore

Jack Avon is the principal consultant at Isys Systems, an international provider of financial modeling and analysis services. He specializes in integrating in-house ERP systems and bespoke financial models, automated dashboards, and automated reporting packages using Microsoft Access, Excel, VBA, SQL Server, and SQL. He trains corporate personnel and develops training manuals in financial data analysis and financial reporting. Clients include British Telecom, Huawei, HSBC, Crossrail, Fujitsu, and the UK Electoral Commission. Avon is the author of The Handbook of Financial Modeling and The Basics of Financial Modeling. He holds his MBA in Information Technology and BS from Bournemouth University and his MS from the University of London.

Riassunto

The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance.


Based on the author's extensive experience building models in business and finance—and teaching others to do the same—The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel. 


Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers:

• The accounting and finance concepts that underpin working financial models;


• How to approach financial issues and solutions from a modeler's perspective;


• The importance of thinking about end users when developing a financial model;


• How to plan, design, and build a fully functional financial model;


• And more.

A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.

Dettagli sul prodotto

• Autori: Jack Avon
• Editore: Springer, Berlin
• Lingue: Inglese
• Formato: Tascabile
• Pubblicazione: 13.11.2013
• EAN: 9781430262053
• ISBN: 978-1-4302-6205-3
• Pagine: 504
• Dimensioni: 174 mm x 231 mm x 30 mm
• Peso: 723 g
• Illustrazioni: 299 SW-Abb.
• Categoria: Scienze sociali, diritto, economia > Economia > Management