Corporate valuation modeling: a step-by-step guide
Gespeichert in:
| 1. Verfasser: | |
|---|---|
| Format: | Buch |
| Sprache: | English |
| Veröffentlicht: |
Hoboken, NJ
Wiley
2010
|
| Schlagworte: | |
| Online-Zugang: | Inhaltsverzeichnis |
| Beschreibung: | Includes index. |
| Beschreibung: | XI, 275 S. Ill., graph. Darst. |
| ISBN: | 9780470481790 |
Internformat
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV036449118 | ||
| 003 | DE-604 | ||
| 005 | 20160715 | ||
| 007 | t | ||
| 008 | 100511s2010 xxuad|| |||| 00||| eng d | ||
| 010 | |a 2009027783 | ||
| 020 | |a 9780470481790 |9 978-0-470-48179-0 | ||
| 035 | |a (OCoLC)705502816 | ||
| 035 | |a (DE-599)BVBBV036449118 | ||
| 040 | |a DE-604 |b ger |e aacr | ||
| 041 | 0 | |a eng | |
| 044 | |a xxu |c US | ||
| 049 | |a DE-1050 |a DE-739 | ||
| 050 | 0 | |a HG4028.V3 | |
| 082 | 0 | |a 332.63/2042 | |
| 084 | |a QP 770 |0 (DE-625)141937: |2 rvk | ||
| 084 | |a QP 820 |0 (DE-625)141943: |2 rvk | ||
| 100 | 1 | |a Allman, Keith A. |d 1977- |e Verfasser |0 (DE-588)173917089 |4 aut | |
| 245 | 1 | 0 | |a Corporate valuation modeling |b a step-by-step guide |c Keith A. Allman |
| 264 | 1 | |a Hoboken, NJ |b Wiley |c 2010 | |
| 300 | |a XI, 275 S. |b Ill., graph. Darst. | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Includes index. | ||
| 650 | 4 | |a Unternehmen | |
| 650 | 4 | |a Corporations |x Valuation | |
| 650 | 4 | |a Business enterprises |x Valuation | |
| 650 | 0 | 7 | |a Handelsbilanz |0 (DE-588)4023231-1 |2 gnd |9 rswk-swf |
| 689 | 0 | 0 | |a Handelsbilanz |0 (DE-588)4023231-1 |D s |
| 689 | 0 | |5 DE-604 | |
| 856 | 4 | 2 | |m HBZ Datenaustausch |q application/pdf |u http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321301&sequence=000004&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |3 Inhaltsverzeichnis |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-020321301 | ||
Datensatz im Suchindex
| _version_ | 1804142935177953280 |
|---|---|
| adam_text | Titel: Corporate valuation modeling
Autor: Allman, Keith A.
Jahr: 2010
Contents
Preface ix
Acknowledgments xi
CHAPTER1
Introduction 1
Overview of the Corporate Valuation Process 1
Conceptual Roadmap 4
Technical Roadmap 5
A Few Best Practices Regarding Financial Modeling 7
How This Book Works 8
Model Builder 1.1: Initial Settings and Assumptions Sheet Setup 10
Toolbox: Naming Cells 15
CHAPTER 2
Dates and Timing 17
The Need for a Flexible System 17
The Forecast Period 18
The Terminal Period 19
Historical Time Periods 19
Event Timing 21
Model Builder 2.1: Dates and Timing on the Assumptions Sheet 22
Model Builder 2.2: Introducing the Vectors Sheet 23
Summary of Dates and Timing 25
Toolbox 25
CHAPTERS
Revenue, Costs, and the income Statement 38
Revenue 39
Model Builder 3.1: Three Methods for Estimating Revenue Based on
Historical Data 41
Costs 51
Organizing Revenue and Cost Assumptions for Scenario Analysis 53
Model Builder 3.2: Installing an Excel-Based Scenario Selector System 54
Vi CONTENTS
Bringing Revenues and Costs Together: The Income Statement 58
Model Builder 3.3: Integrating the Income Statement 58
A Work in Progress 64
Toolbox 65
CHAPTHI4
Capital Structure and Balance Sheet 75
What the Company Owns 77
Model Builder 4.1: Starting the Balance Sheet with Assets 81
What the Company Owes 86
Model Builder 4.2: Continuing the Balance Sheet with Liabilities 89
What the Company Has Already Paid For 91
Model Builder 4.3: Continuing the Balance Sheet with Equity 93
Toolbox: Be Careful with Growth 94
CHAPTER5
Capital Expenditures, Depreciation, bitangmtes, and Amortization 95
Capital Expenditures 95
Depreciation 96
A Balance Sheet or an Income Statement Item? 97
Concept Status 97
Model Builder 5.1: Capital Expenditure Schedules Setup 99
Model Builder 5.2: Depreciation Schedules Setup 101
Intangibles 105
Amortization 105
Model Builder 5.3: Intangibles and Amortization Schedules 106
Income Statement and Balance Sheet Effects 108
Model Builder 5.4: Integrating Capital Expenditures, Depreciation,
Intangibles, and Amortization 109
Toolbox 111
CHAPTBI6
Long-Term Debt 117
What Is Long-Term Debt? 117
Using Debt for a Reason 117
Modeling Debt: Debt Components in Detail 119
Model Builder 6.1: Setting Up Debt and Calculating What Is Due 121
Paying Liabilities 133
Model Builder 6.2: Paying the Correct Liability Amount 138
Model Builder 6.3: Integrating Long-Term Debt into the Income
Statement and Balance Sheet 147
Toolbox 149
Contents wi
CHAPTER 7
Balancing the Model 153
Model Builder 7.1: Calculating Cash and Short-Term
Debt Interest 153
Working with the Model 161
The Model as an Analysis Tool 164
Toolbox: Excel s Calculation Modes 164
CHAPTBI8
Reconciling Cash now 167
The Cash Flow Statement 167
Working Capital 168
Model Builder 8.1: Calculating Working Capital 169
Model Builder 8.2: Building the Cash Flow Statement 171
Preventing Error through Internal Validation 178
Model Builder 8.3: Implementing Internal Validations 178
Other Validations 181
Toolbox 181
CHAPTB9
Free Cash Row, Terminal value, and Discount Rates and Methods 185
Free Cash Flow: A Matter of Perspective 185
Model Builder 9.1: Implementing Free Cash Flow 189
Terminal Value: Beyond the Forecast Period 191
Model Builder 9.2: Calculating and Integrating a Stable-Growth
Terminal Value 194
Discount Rates and Methods 199
Model Builder 9.3: Calculating and Implementing the Weighted
Average Cost of Capital 203
Model Builder 9.4: Discounting with Multiple Rates to Determine
the Corporate Value 206
After the Corporate Valuation 207
Toolbox 207
CHAPTHHO
Output Reporting 215
Output Summary 215
Model Builder 10.1: Preparing for the Output Summary Sheet 216
Web Downloads 216
Model Builder 10.2: Connecting the Example Model to the Web 217
Model Builder 10.3: Creating the Output Summary Sheet 221
Charts 223
Model Builder 10.4: Creating Dynamic Charts 224
Toolbox 226
Vi CONTENTS
CHAPTB111
Automation Using Visual Basic Applications (VBA) 233
The Object-Oriented Programming Language (OOP) 233
Follow the Rules 235
The Visual Basic Editor 235
Writing Code: Subroutines and Functions 238
Understanding VBA Code and Practicing Coding Techniques 239
Model Builder 11.1: Moving Data Using VBA 240
Model Builder 11.2: A First Look at Loops and Variables in VBA 244
Common Errors for First-Time VBA Programmers 247
VBA within a Financial Modeling Context 247
Model Builder 11.3: Eliminating Circular References 248
Model Builder 11.4: Creating a Scenario Generator 252
Model Builder 11.5: Automatic Sheet Printing 257
Continuing with VBA 261
Conclusion 262
About the CD-ROM 263
About the Author 266
Mex 267
|
| any_adam_object | 1 |
| author | Allman, Keith A. 1977- |
| author_GND | (DE-588)173917089 |
| author_facet | Allman, Keith A. 1977- |
| author_role | aut |
| author_sort | Allman, Keith A. 1977- |
| author_variant | k a a ka kaa |
| building | Verbundindex |
| bvnumber | BV036449118 |
| callnumber-first | H - Social Science |
| callnumber-label | HG4028 |
| callnumber-raw | HG4028.V3 |
| callnumber-search | HG4028.V3 |
| callnumber-sort | HG 44028 V3 |
| callnumber-subject | HG - Finance |
| classification_rvk | QP 770 QP 820 |
| ctrlnum | (OCoLC)705502816 (DE-599)BVBBV036449118 |
| dewey-full | 332.63/2042 |
| dewey-hundreds | 300 - Social sciences |
| dewey-ones | 332 - Financial economics |
| dewey-raw | 332.63/2042 |
| dewey-search | 332.63/2042 |
| dewey-sort | 3332.63 42042 |
| dewey-tens | 330 - Economics |
| discipline | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>01491nam a2200421zc 4500</leader><controlfield tag="001">BV036449118</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20160715 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">100511s2010 xxuad|| |||| 00||| eng d</controlfield><datafield tag="010" ind1=" " ind2=" "><subfield code="a">2009027783</subfield></datafield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9780470481790</subfield><subfield code="9">978-0-470-48179-0</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)705502816</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV036449118</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">aacr</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="044" ind1=" " ind2=" "><subfield code="a">xxu</subfield><subfield code="c">US</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-1050</subfield><subfield code="a">DE-739</subfield></datafield><datafield tag="050" ind1=" " ind2="0"><subfield code="a">HG4028.V3</subfield></datafield><datafield tag="082" ind1="0" ind2=" "><subfield code="a">332.63/2042</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 770</subfield><subfield code="0">(DE-625)141937:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 820</subfield><subfield code="0">(DE-625)141943:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Allman, Keith A.</subfield><subfield code="d">1977-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)173917089</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">Corporate valuation modeling</subfield><subfield code="b">a step-by-step guide</subfield><subfield code="c">Keith A. Allman</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Hoboken, NJ</subfield><subfield code="b">Wiley</subfield><subfield code="c">2010</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">XI, 275 S.</subfield><subfield code="b">Ill., graph. Darst.</subfield></datafield><datafield tag="336" ind1=" " ind2=" "><subfield code="b">txt</subfield><subfield code="2">rdacontent</subfield></datafield><datafield tag="337" ind1=" " ind2=" "><subfield code="b">n</subfield><subfield code="2">rdamedia</subfield></datafield><datafield tag="338" ind1=" " ind2=" "><subfield code="b">nc</subfield><subfield code="2">rdacarrier</subfield></datafield><datafield tag="500" ind1=" " ind2=" "><subfield code="a">Includes index.</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Unternehmen</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Corporations</subfield><subfield code="x">Valuation</subfield></datafield><datafield tag="650" ind1=" " ind2="4"><subfield code="a">Business enterprises</subfield><subfield code="x">Valuation</subfield></datafield><datafield tag="650" ind1="0" ind2="7"><subfield code="a">Handelsbilanz</subfield><subfield code="0">(DE-588)4023231-1</subfield><subfield code="2">gnd</subfield><subfield code="9">rswk-swf</subfield></datafield><datafield tag="689" ind1="0" ind2="0"><subfield code="a">Handelsbilanz</subfield><subfield code="0">(DE-588)4023231-1</subfield><subfield code="D">s</subfield></datafield><datafield tag="689" ind1="0" ind2=" "><subfield code="5">DE-604</subfield></datafield><datafield tag="856" ind1="4" ind2="2"><subfield code="m">HBZ Datenaustausch</subfield><subfield code="q">application/pdf</subfield><subfield code="u">http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321301&sequence=000004&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA</subfield><subfield code="3">Inhaltsverzeichnis</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-020321301</subfield></datafield></record></collection> |
| id | DE-604.BV036449118 |
| illustrated | Illustrated |
| indexdate | 2024-07-09T22:39:40Z |
| institution | BVB |
| isbn | 9780470481790 |
| language | English |
| lccn | 2009027783 |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-020321301 |
| oclc_num | 705502816 |
| open_access_boolean | |
| owner | DE-1050 DE-739 |
| owner_facet | DE-1050 DE-739 |
| physical | XI, 275 S. Ill., graph. Darst. |
| publishDate | 2010 |
| publishDateSearch | 2010 |
| publishDateSort | 2010 |
| publisher | Wiley |
| record_format | marc |
| spelling | Allman, Keith A. 1977- Verfasser (DE-588)173917089 aut Corporate valuation modeling a step-by-step guide Keith A. Allman Hoboken, NJ Wiley 2010 XI, 275 S. Ill., graph. Darst. txt rdacontent n rdamedia nc rdacarrier Includes index. Unternehmen Corporations Valuation Business enterprises Valuation Handelsbilanz (DE-588)4023231-1 gnd rswk-swf Handelsbilanz (DE-588)4023231-1 s DE-604 HBZ Datenaustausch application/pdf http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321301&sequence=000004&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA Inhaltsverzeichnis |
| spellingShingle | Allman, Keith A. 1977- Corporate valuation modeling a step-by-step guide Unternehmen Corporations Valuation Business enterprises Valuation Handelsbilanz (DE-588)4023231-1 gnd |
| subject_GND | (DE-588)4023231-1 |
| title | Corporate valuation modeling a step-by-step guide |
| title_auth | Corporate valuation modeling a step-by-step guide |
| title_exact_search | Corporate valuation modeling a step-by-step guide |
| title_full | Corporate valuation modeling a step-by-step guide Keith A. Allman |
| title_fullStr | Corporate valuation modeling a step-by-step guide Keith A. Allman |
| title_full_unstemmed | Corporate valuation modeling a step-by-step guide Keith A. Allman |
| title_short | Corporate valuation modeling |
| title_sort | corporate valuation modeling a step by step guide |
| title_sub | a step-by-step guide |
| topic | Unternehmen Corporations Valuation Business enterprises Valuation Handelsbilanz (DE-588)4023231-1 gnd |
| topic_facet | Unternehmen Corporations Valuation Business enterprises Valuation Handelsbilanz |
| url | http://bvbr.bib-bvb.de:8991/F?func=service&doc_library=BVB01&local_base=BVB01&doc_number=020321301&sequence=000004&line_number=0001&func_code=DB_RECORDS&service_type=MEDIA |
| work_keys_str_mv | AT allmankeitha corporatevaluationmodelingastepbystepguide |