Basics of Financial Modeling (eBook)
IX, 248 Seiten
Apress (Verlag)
978-1-4842-0871-7 (ISBN)
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. In his short book, The Basics of Financial Modeling—an abridgement of his Handbook of Financial Modeling—Jack Avon equips financial professionals with a quick overview of the tools they need to monitor a company's assets and project its future performance and prospects for specific initiatives.
Based on the author's extensive experience building models in business and finance—and teaching others to do the same—The Basics of Financial Modeling takes readers step by step in a quick-read format 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 beginning to intermediate modelers who wish to expand and enhance their knowledge of using Excel to build financial models, The Basics of Financial Modeling 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 financial model
A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Basics of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models.
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.
Learn to create and understand financial models that assess the value of your company, the projects it undertakes, and its future earnings/profit projections. Follow this step-by-step guide organized in a quick-read format to build an accurate and effective financial model from the ground up.In this short book, The Basics of Financial Modeling-an abridgment of the Handbook of Financial Modeling-author Jack Avon equips business professionals who are familiar with financial statements and accounting reports to become truly proficient. Based on the author's extensive experience building models in business and finance, and teaching others to do the same, this book takes you 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.What You'll LearnUnderstand the accounting and finance concepts that underpin working financial modelsApproach financial issues and solutions from a modeler's perspectiveThink about end users when developing a financial modelPlan, design, and build a financial modelWho This Book Is ForBeginning to intermediate modelers who wish to expand and enhance their knowledge of using Excel to build and analyze financial models
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.
Chapter 1. Financial Modeling: An OverviewChapter 2. Financial Modeling Best PracticeChapter 3. Modeling Functions and ToolChapter 4. Planning Your ModelChapter 5. Testing and Documenting Your ModelChapter 6. Designing and Building Your ModelChapter 7. Financial-Based CalculationsChapter 8. Logical and Structural-Based Calculations Appendix A. Keyboard Shortcuts
Erscheint lt. Verlag | 21.11.2014 |
---|---|
Zusatzinfo | IX, 248 p. 159 illus. |
Verlagsort | Berkeley |
Sprache | englisch |
Themenwelt | Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung |
Wirtschaft ► Betriebswirtschaft / Management ► Unternehmensführung / Management | |
ISBN-10 | 1-4842-0871-4 / 1484208714 |
ISBN-13 | 978-1-4842-0871-7 / 9781484208717 |
Haben Sie eine Frage zum Produkt? |
Größe: 14,2 MB
DRM: Digitales Wasserzeichen
Dieses eBook enthält ein digitales Wasserzeichen und ist damit für Sie personalisiert. Bei einer missbräuchlichen Weitergabe des eBooks an Dritte ist eine Rückverfolgung an die Quelle möglich.
Dateiformat: PDF (Portable Document Format)
Mit einem festen Seitenlayout eignet sich die PDF besonders für Fachbücher mit Spalten, Tabellen und Abbildungen. Eine PDF kann auf fast allen Geräten angezeigt werden, ist aber für kleine Displays (Smartphone, eReader) nur eingeschränkt geeignet.
Systemvoraussetzungen:
PC/Mac: Mit einem PC oder Mac können Sie dieses eBook lesen. Sie benötigen dafür einen PDF-Viewer - z.B. den Adobe Reader oder Adobe Digital Editions.
eReader: Dieses eBook kann mit (fast) allen eBook-Readern gelesen werden. Mit dem amazon-Kindle ist es aber nicht kompatibel.
Smartphone/Tablet: Egal ob Apple oder Android, dieses eBook können Sie lesen. Sie benötigen dafür einen PDF-Viewer - z.B. die kostenlose Adobe Digital Editions-App.
Buying eBooks from abroad
For tax law reasons we can sell eBooks just within Germany and Switzerland. Regrettably we cannot fulfill eBook-orders from other countries.
aus dem Bereich