Atnaujinkite slapukų nuostatas

Corporate Valuation Modeling: A Step-by-Step Guide [Multiple-component retail product, part(s) enclosed]

3.67/5 (12 ratings by Goodreads)
  • Formatas: Multiple-component retail product, part(s) enclosed, 304 pages, aukštis x plotis x storis: 236x193x15 mm, weight: 531 g, Screen captures: 183 B&W, 0 Color, Contains 1 Paperback / softback and 1 CD-ROM
  • Serija: Wiley Finance
  • Išleidimo metai: 05-Mar-2010
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 047048179X
  • ISBN-13: 9780470481790
Kitos knygos pagal šią temą:
Corporate Valuation Modeling: A Step-by-Step GuideDidesnis paveikslėlis
  • Formatas: Multiple-component retail product, part(s) enclosed, 304 pages, aukštis x plotis x storis: 236x193x15 mm, weight: 531 g, Screen captures: 183 B&W, 0 Color, Contains 1 Paperback / softback and 1 CD-ROM
  • Serija: Wiley Finance
  • Išleidimo metai: 05-Mar-2010
  • Leidėjas: John Wiley & Sons Inc
  • ISBN-10: 047048179X
  • ISBN-13: 9780470481790
Kitos knygos pagal šią temą:
Pastovi nuoroda: https://www.kriso.lt/db/9780470481790.html
Raktažodžiai:
"Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter skillfully discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly." "Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling."--BOOK JACKET.

A critical guide to corporate valuation modeling

Valuation is at the heart of everything that Wall Street does. Every day, millions of transactions to purchase or sell companies take place based on prices created by the activities of all market participants. In this book, author Keith Allman provides you with a core model to value companies.

Corporate Valuation Modeling takes you step-by-step through the process of creating a powerful corporate valuation model. Each chapter skillfully discusses the theory of the concept, followed by Model Builder instructions that inform you of every step necessary to create the template model. Many chapters also include a validation section that shows techniques and implementations that you can employ to make sure the model is working properly.

  • Walks you through the full process of constructing a fully dynamic corporate valuation model
  • A Tool Box section at the end of each chapter assists readers who may be less skilled in Excel techniques and functions

Complete with a companion CD-ROM that contains constructed models, this book is an essential guide to understanding the intricacies of corporate valuation modeling

Preface ix
Acknowledgments xi
Introduction
1(16)
Overview of the Corporate Valuation Process
1(3)
Conceptual Roadmap
4(1)
Technical Roadmap
5(2)
A Few Best Practices Regarding Financial Modeling
7(1)
How This Book Works
8(2)
Initial Settings and Assumptions Sheet Setup
10(5)
Toolbox: Naming Cells
15(2)
Dates and Timing
17(21)
The Need for a Flexible System
17(1)
The Forecast Period
18(1)
The Terminal Period
19(1)
Historical Time Periods
19(2)
Event Timing
21(1)
Dates and Timing on the Assumptions Sheet
22(1)
Introducing the Vectors Sheet
23(2)
Summary of Dates and Timing
25(1)
Toolbox
25(13)
Revenue, Costs, and the Income Statement
38(37)
Revenue
39(2)
Three Methods for Estimating Revenue Based on Historical Data
41(10)
Costs
51(2)
Organizing Revenue and Cost Assumptions for Scenario Analysis
53(1)
Installing an Excel-Based Scenario Selector System
54(4)
Bringing Revenues and Costs Together: The Income Statement
58(1)
Integrating the Income Statement
58(6)
A Work in Progress
64(1)
Toolbox
65(10)
Capital Structure and Balance Sheet
75(20)
What the Company Owns
77(4)
Starting the Balance Sheet with Assets
81(5)
What the Company Owes
86(3)
Continuing the Balance Sheet with Liabilities
89(2)
What the Company has Already Paid for
91(2)
Continuing the Balance Sheet with Equity
93(1)
Toolbox: Be Careful with Growth
94(1)
Capital Expenditures, Depreciation, Intangibles, and Amortization
95(22)
Capital Expenditures
95(1)
Depreciation
96(1)
A Balance Sheet or an Income Statement Item?
97(1)
Concept Status
97(2)
Capital Expenditure Schedules Setup
99(2)
Depreciation Schedules Setup
101(4)
Intangibles
105(1)
Amortization
105(1)
Intangibles and Amortization Schedules
106(2)
Income Statement and Balance Sheet Effects
108(1)
Integrating Capital Expenditures, Depreciation, Intangibles, and Amortization
109(2)
Toolbox
111(6)
Long-Term Debt
117(36)
What is Long-Term Debt?
117(1)
Using Debt for a Reason
117(2)
Debt Components in Detail
119(2)
Setting Up Debt and Calculating What is Due
121(12)
Paying Liabilities
133(5)
Paying the Correct Liability Amount
138(9)
Integrating Long-Term Debt into the Income Statement and Balance Sheet
147(2)
Toolbox
149(4)
Balancing the Model
153(14)
Calculating Cash and Short-Term Debt Interest
153(8)
Working with the Model
161(3)
The Model as an Analysis Tool
164(1)
Toolbox: Excel's Calculation Modes
164(3)
Reconclling Cash Flow
167(18)
The Cash Flow Statement
167(1)
Working Capital
168(1)
Calculating Working Capital
169(2)
Building the Cash Flow Statement
171(7)
Preventing Error through Internal Validation
178(1)
Implementing Internal Validations
178(3)
Other Validations
181(1)
Toolbox
181(4)
Free Cash Flow, Terminal Value, and Discount Rates and Methods
185(30)
Free Cash Flow: A Matter of Perspective
185(4)
Implementing Free Cash Flow
189(2)
Terminal Value: Beyond the Forecast Period
191(3)
Calculating and Integrating a Stable-Growth Terminal Value
194(5)
Discount Rates and Methods
199(4)
Calculating and Implementing the Weighted Average Cost of Capital
203(3)
Discounting with Multiple Rates to Determine the Corporate Value
206(1)
After the Corporate Valuation
207(1)
Toolbox
207(8)
Output Reporting
215(18)
Output Summary
215(1)
Preparing for the Output Summary Sheet
216(1)
Web Downloads
216(1)
Connecting the Example Model to the Web
217(4)
Creating the Output Summary Sheet
221(2)
Charts
223(1)
Creating Dynamic Charts
224(2)
Toolbox
226(7)
Automation Using Visual Basic Applications (VBA)
233(30)
The Object-Oriented Programming Language (OOP)
233(2)
Follow the Rules
235(1)
The Visual Basic Editor
235(3)
Writing Code: Subroutines and Functions
238(1)
Understanding VBA Code and Practicing Coding Techniques
239(1)
Moving Data Using VBA
240(4)
A First Look at Loops and Variables in VBA
244(3)
Common Errors for First-Time VBA Programmers
247(1)
VBA within a Financial Modeling Context
247(1)
Eliminating Circular References
248(4)
Creating a Scenario Generator
252(5)
Automatic Sheet Printing
257(4)
Continuing with VBA
261(1)
Conclusion
262(1)
About the CD-ROM 263(3)
About the Author 266(1)
Index 267
KEITH A. ALLMAN is the manager of analytics and modeling at Pearl Street Capital Group. He is also the founder of Enstruct, a quantitative finance training and consulting company. Prior to this, he was a vice president in the Global Special Situations Group at Citigroup. Allman has also worked in Citigroup's Global Securitized Markets division modeling conduit transactions and in MBIA Corporation's Quantitative Analytics group. He is the author of the Wiley titles Modeling Structured Finance Cash Flows with Microsoft Excel and Reverse Engineering Deals on Wall Street with Microsoft Excel. Allman received a master's degree in international affairs with a concentration in finance and banking from Columbia University and dual bachelor degrees from UCLA.