Mastering Financial Modeling: A Professional’s Guide to Building Financial Models in Excel
Seiten
2013
McGraw-Hill Professional (Verlag)
978-0-07-180850-7 (ISBN)
McGraw-Hill Professional (Verlag)
978-0-07-180850-7 (ISBN)
All the precision of financial modeling - and none of the complexity. Evidence-based decision making is only as good as the external evidence on which it is based. This title offers a simplified method for building the fast and accurate financial models serious evidence based decision makers need.
All the precision of financial modeling--and none of the complexityEvidence-based decision making is only as good as the external evidence on which it is based. Financial models uncover potential risks on a company’s balance sheet, but the complexity of these instruments has limited their effectiveness.
Now, Mastering Financial Modeling offers asimplified method for building the fast and accurate financial models serious evidencebased decision makers need.
What sets this practical guide apart is its "learning-on-the-job" approach. Unlike other books that teach modeling in a vacuum, this superior method uses a diverse collection of case studies to convey each step of the building process. "Learning on the job" connects the dots between the proper Excel formulas and functions and the real-world situations where you want to use them. By learning through association, you can absorb the information quickly and have it ready to use whenyou need it.
The book starts right off on building models--from creating a standalone cash flow model through integrating it with an income statement and balance sheet. Along the way, you will master the skill set you need to build advanced financial models. With only a basic knowledgeof accounting and finance, individual investors and financial professionals alike can:Create a core model and customize it for companies in most industriesUnderstand every working component of a financial model and what each one tells you about a companyFormat cells and sheets in Excel for easily repeatable modeling
Written with the practitioner in mind, MasteringFinancial Modeling shows you how to ensure your model is ready for real-world application by safeguarding it against modeling errors. It covers a full array of Excel's builtin auditing and testing tools and illustrates how to build customized error-checking tools of your own to catch the inaccuracies that typically fall through the cracks.
Get the most out of your data with Mastering Financial Modeling.
Mastering Financial Modeling brings the power of financial models down to earth and puts it in the hands of investors, bankers, and private equity professionals whodon't have a passion for crunching numbers.
Nowhere else can you get step-by-step instruction on building these valuable tools from an elite World Bank investment officer. Starting from the ground up, EricSoubeiga shows you how to interpret and build financial models in Microsoft Excel that will accurately assess any company’s valuation and profit potential. Even if youhave unsuccessfully tried financial modeling in the past, this book will reach you because it associates every lesson to the business world you work in daily.
Chapter by chapter, you will master financial modeling, and in the end, you will:
Command authority over building every aspect of a financial modelBe capable of explaining the accounting and finance concepts behind the mechanics of modelingConfidently determine a company’s ability to generate cash flows for its capital investors with discounted cash flow (DCF) modelingExecute powerful spreadsheet calculations in Excel
Most importantly, as a decision maker, the insight you bring to the table through your sophisticated understanding and application of financial modeling will benefit every stakeholder.
See what leading professionals around the world already know--Mastering Financial Modeling is the most comprehensive guide on the market for designing, building,and implementing valuation projection models. What it does from there is up to you.
All the precision of financial modeling--and none of the complexityEvidence-based decision making is only as good as the external evidence on which it is based. Financial models uncover potential risks on a company’s balance sheet, but the complexity of these instruments has limited their effectiveness.
Now, Mastering Financial Modeling offers asimplified method for building the fast and accurate financial models serious evidencebased decision makers need.
What sets this practical guide apart is its "learning-on-the-job" approach. Unlike other books that teach modeling in a vacuum, this superior method uses a diverse collection of case studies to convey each step of the building process. "Learning on the job" connects the dots between the proper Excel formulas and functions and the real-world situations where you want to use them. By learning through association, you can absorb the information quickly and have it ready to use whenyou need it.
The book starts right off on building models--from creating a standalone cash flow model through integrating it with an income statement and balance sheet. Along the way, you will master the skill set you need to build advanced financial models. With only a basic knowledgeof accounting and finance, individual investors and financial professionals alike can:Create a core model and customize it for companies in most industriesUnderstand every working component of a financial model and what each one tells you about a companyFormat cells and sheets in Excel for easily repeatable modeling
Written with the practitioner in mind, MasteringFinancial Modeling shows you how to ensure your model is ready for real-world application by safeguarding it against modeling errors. It covers a full array of Excel's builtin auditing and testing tools and illustrates how to build customized error-checking tools of your own to catch the inaccuracies that typically fall through the cracks.
Get the most out of your data with Mastering Financial Modeling.
Mastering Financial Modeling brings the power of financial models down to earth and puts it in the hands of investors, bankers, and private equity professionals whodon't have a passion for crunching numbers.
Nowhere else can you get step-by-step instruction on building these valuable tools from an elite World Bank investment officer. Starting from the ground up, EricSoubeiga shows you how to interpret and build financial models in Microsoft Excel that will accurately assess any company’s valuation and profit potential. Even if youhave unsuccessfully tried financial modeling in the past, this book will reach you because it associates every lesson to the business world you work in daily.
Chapter by chapter, you will master financial modeling, and in the end, you will:
Command authority over building every aspect of a financial modelBe capable of explaining the accounting and finance concepts behind the mechanics of modelingConfidently determine a company’s ability to generate cash flows for its capital investors with discounted cash flow (DCF) modelingExecute powerful spreadsheet calculations in Excel
Most importantly, as a decision maker, the insight you bring to the table through your sophisticated understanding and application of financial modeling will benefit every stakeholder.
See what leading professionals around the world already know--Mastering Financial Modeling is the most comprehensive guide on the market for designing, building,and implementing valuation projection models. What it does from there is up to you.
Eric Soubeiga is Investment Officer at the World Bank. His finance career spans private equity, investment banking, and transactional advisory gained in the City of London. Prior to his finance career, Eric worked in academia and was involved in research and teaching atthe University of Nottingham (UK).
Contents
Preface ix
Acknowledgments xiii
PART 1 Modeling Theory1 Introduction to Modeling 3
2 Best Practice Principles 7
PART 2 Modeling Practice—Initial Case Studies
3 Case Study 1: The Phone Factory 19
4 Case Study 1: Modeling the Front and Inputs Sheets 23
5 Case Study 1: Modeling the Calculations Sheet 35
6 Case Study 1: Modeling the Outputs Sheets 63
7 Case Study 2: Options Appraisal 75
PART 3 Modeling Practice —Further Case Studies
8 Case Study 3: The Phone Factory Revisited 93
9 Case Study 4: Growth Capital 125
10 Case Study 5: Leveraged Buyout 181
11 Other Tricky Modeling Case Studies 251
PART 4 Modeling Practice —Model Audit
12 Checking for and Fixing Modeling Errors 273
PART 5 Conclusion
13 Conclusion 289
Index 293vii
| Erscheint lt. Verlag | 16.8.2013 |
|---|---|
| Zusatzinfo | 50 Illustrations |
| Sprache | englisch |
| Maße | 183 x 231 mm |
| Gewicht | 578 g |
| Themenwelt | Mathematik / Informatik ► Mathematik ► Angewandte Mathematik |
| Wirtschaft ► Betriebswirtschaft / Management ► Finanzierung | |
| Wirtschaft ► Betriebswirtschaft / Management ► Unternehmensführung / Management | |
| ISBN-10 | 0-07-180850-7 / 0071808507 |
| ISBN-13 | 978-0-07-180850-7 / 9780071808507 |
| Zustand | Neuware |
| Haben Sie eine Frage zum Produkt? |
Mehr entdecken
aus dem Bereich
aus dem Bereich
Anwendungen und Theorie von Funktionen, Distributionen und Tensoren
Buch | Softcover (2023)
De Gruyter Oldenbourg (Verlag)
CHF 97,90
Buch | Hardcover (2024)
Hanser (Verlag)
CHF 55,95
Ausgewählte Kapitel für das Master-Studium
Buch | Hardcover (2024)
Carl Hanser (Verlag)
CHF 55,95
