The Essentials of financial modeling in Excel: a concise guide to concepts and methods
Saved in:
| Main Author: | |
|---|---|
| Format: | Book |
| Language: | English |
| Published: |
Newark
John Wiley & Sons, Incorporated
2023
|
| Item Description: | Description based on publisher supplied metadata and other sources |
| Physical Description: | xi, 316 Seiten Illustrationen, Diagramme |
| ISBN: | 9781394157785 |
Staff View
MARC
| LEADER | 00000nam a2200000zc 4500 | ||
|---|---|---|---|
| 001 | BV049502230 | ||
| 003 | DE-604 | ||
| 005 | 20240219 | ||
| 007 | t | ||
| 008 | 240116s2023 a||| |||| 00||| eng d | ||
| 020 | |a 9781394157785 |9 978-1-394-15778-5 | ||
| 035 | |a (OCoLC)1418702819 | ||
| 035 | |a (DE-599)BVBBV049502230 | ||
| 040 | |a DE-604 |b ger |e rda | ||
| 041 | 0 | |a eng | |
| 049 | |a DE-N2 | ||
| 084 | |a QP 700 |0 (DE-625)141926: |2 rvk | ||
| 100 | 1 | |a Rees, Michael |d 1964- |e Verfasser |0 (DE-588)136694659 |4 aut | |
| 245 | 1 | 0 | |a The Essentials of financial modeling in Excel |b a concise guide to concepts and methods |
| 264 | 1 | |a Newark |b John Wiley & Sons, Incorporated |c 2023 | |
| 264 | 4 | |c ©2023 | |
| 300 | |a xi, 316 Seiten |b Illustrationen, Diagramme | ||
| 336 | |b txt |2 rdacontent | ||
| 337 | |b n |2 rdamedia | ||
| 338 | |b nc |2 rdacarrier | ||
| 500 | |a Description based on publisher supplied metadata and other sources | ||
| 505 | 8 | |a Cover -- Title Page -- Copyright Page -- Contents -- About This Book -- The Author -- Part One Introduction to Modeling -- Chapter 1 Modeling and Its Uses -- 1.1 What Is a Model? -- 1.2 What Are Models Used For? -- Chapter 2 Principles of Model Design -- 2.1 Introduction -- 2.2 Decision Identification, Framing, and Structure -- 2.3 Decision Criteria and Information Needs -- 2.4 Sensitivity-Based Design -- 2.5 Data and Data Sources -- 2.6 Model Mapping and Approximations -- 2.7 Building and Testing -- 2.8 Results Presentation -- 2.9 Biases -- Part Two Essentials of Excel -- Chapter 3 Menus, Operations, Functions, and Features -- 3.1 Introduction -- 3.2 Structure and Menus -- 3.3 Calculations Using Arithmetic -- 3.4 Function Basics -- 3.5 A Core Function Set -- 3.6 Further Properties and Uses of Functions -- 3.7 Calculation Settings and Options -- 3.8 KeyTips and Shortcuts -- 3.9 Absolute and Relative Referencing -- 3.10 Auditing and Logic Tracing -- 3.11 Named Ranges -- 3.12 Best Practices: Overview -- 3.13 Best Practices: Flow -- 3.14 Best Practices: Time Axis -- 3.15 Best Practices: Multiple Worksheets -- 3.16 Best Practices: Formatting -- 3.17 Model Testing, Checking, and Error Management -- 3.18 Graphs and Charts -- Chapter 4 Sensitivity and Scenario Analysis -- 4.1 Introduction -- 4.2 Basic or Manual Sensitivity Analysis -- 4.3 Automating Sensitivity Analysis: An Introduction -- 4.4 Using DataTables -- 4.5 Checking the Results, Limitations, and Tips -- 4.6 Creating Flexibility in the Outputs That Are Analyzed -- 4.7 Scenario Analysis -- 4.8 Variations Analysis -- 4.9 Using GoalSeek -- 4.10 Further Topics: Optimization, Risk, Uncertainty, and Simulation -- Part Three General Calculations and Structures -- Chapter 5 Growth Calculations for Forecasting -- 5.1 Introduction -- 5.2 Growth Measurement and Forecasting -- 5.3 Logic Reversals | |
| 505 | 8 | |a 5.4 Forecasting Structures in Practice -- 5.5 Simplifying the Sensitivity Analysis and Reducing the Number of Parameters -- 5.6 Dealing with Inflation -- 5.7 Conversions for Model Periods -- 5.8 Further Topics: Logarithmic and Exponential Growth -- Chapter 6 Modular Structures and Summary Reports -- 6.1 Introduction -- 6.2 Motivation for Summary Areas and Their Placement -- 6.3 Example I: Summaries and Conditional Summaries -- 6.4 Example II: Targets, Flags, and Matching -- 6.5 Sensitivity Analysis -- 6.6 Comments on Formatting -- 6.7 Initialization Areas -- Chapter 7 Scaling and Ratio-driven Forecasts -- 7.1 Introduction -- 7.2 Basic Uses -- 7.3 Links to Length of Model Periods -- 7.4 Days' Equivalent Approaches -- 7.5 Example I: Forecasting from Revenues to EBITDA -- 7.6 Using Ratio-Based Forecasting Effectively -- 7.7 Example II: Ratio-Based Forecasting of Capital Items -- 7.8 Further Topics: Links to General Ratio Analysis -- Chapter 8 Corkscrews and Reverse Corkscrews -- 8.1 Introduction -- 8.2 Classical Corkscrews -- 8.3 Benefits and Further Uses -- 8.4 Reverse Corkscrews -- Chapter 9 Waterfall Allocations -- 9.1 Introduction -- 9.2 Example I: Cost Sharing -- 9.3 Example II: Tax Calculations -- 9.4 Options for Layout and Structure -- 9.5 Further Topics: Waterfalls for Sharing Capital Returns or Carried Interest -- Chapter 10 Interpolations and Allocations -- 10.1 Introduction -- 10.2 Example I: Linear Smoothing -- 10.3 Example II: Proportional Smoothing -- 10.4 Uses of Tapering and Interpolation -- 10.5 Triangles -- 10.6 Further Topics: Triangles -- Part Four Economic Foundations and Evaluation -- Chapter 11 Breakeven and Payback Analysis -- 11.1 Introduction -- 11.2 Single-Period Breakeven Analysis: Prices and Volumes -- 11.3 Breakeven Time and Payback Periods -- Chapter 12 Interest Rates and Compounding -- 12.1 Introduction | |
| 505 | 8 | |a 12.2 Stated Rates and Calculations without Compounding -- 12.3 Compounding Types and Effective Rates -- 12.4 Conversion of Effective Rates for Periods of Different Lengths -- 12.5 Average Effective Rates -- 12.6 Implied Rates and Bootstrapping -- Chapter 13 Loan Repayment Calculations -- 13.1 Introduction -- 13.2 Effective Rates for Interest-Only Repayments -- 13.3 Aligning Model Periods with Interest Repayments -- 13.4 Constant Repayment Loans Using the PMT Function -- 13.5 Constant Repayment Loans: Other Functions -- 13.6 Periods of Different Lengths -- Chapter 14 Discounting, Present Values, and Annuities -- 14.1 Introduction -- 14.2 The Time Value of Money -- 14.3 Calculation Options for Present Values -- 14.4 Annuities and Perpetuities -- 14.5 Multi-Period Approaches and Terminal Values -- 14.6 Further Topics I: Mathematics of Annuities -- 14.7 Further Topics II: Cash Flow Timing -- Chapter 15 Returns and Internal Rate of Return -- 15.1 Introduction -- 15.2 Single Investments and Paybacks -- 15.3 Multiple Paybacks: Average Returns and the Internal Rate of Return -- 15.4 Using Economic Metrics to Guide Investment Decisions -- 15.5 Properties and Comparison of NPV and IRR -- Part Five Corporate Finance and Valuation -- Chapter 16 The Cost of Capital -- 16.1 Introduction -- 16.2 Returns, Costs, and Opportunity Costs of Capital -- 16.3 The Role of Risk in Determining the Cost of Capital -- 16.4 The Properties and Benefits of Debt -- 16.5 The Financing Mix and The Weighted Average Cost of Capital -- 16.6 Modigliani-Miller and Leverage Adjustments -- 16.7 The Capital Asset Pricing Model -- 16.8 Further Topics: Derivation of Leveraging and Deleveraging Formulas -- Chapter 17 Financial Statement Modeling -- 17.1 Introduction -- 17.2 Financial Statement Essentials -- 17.3 Key Challenges in Building Integrated Financial Statement Models | |
| 505 | 8 | |a 17.4 Forecasting of the Integrated Statements: A Simple Example -- 17.5 The Dynamic Financing Adjustment Mechanism -- 17.6 Generalizing the Model Features and Capabilities -- 17.7 Steps and Principles in Building a Financial Statement Model -- 17.8 Further Topics: Avoiding Circularities -- Chapter 18 Corporate Valuation Modeling -- 18.1 Introduction -- 18.2 Overview of Valuation Methods -- 18.3 Principles of Cash Flow Valuation -- 18.4 Free Cash Flow for Enterprise Valuation -- 18.5 The Role of the Explicit Forecast -- 18.6 Example: Explicit Forecast with Terminal Value Calculation -- 18.7 Further Topics I: Enterprise Value Based on Free Cash Flow and Equivalences -- 18.8 Further Topics II: Value-Driver Formulas -- 18.9 Further Topics III: Implied Cost of Equity -- Chapter 19 Ratio Analysis -- 19.1 Introduction -- 19.2 Use and Principles -- 19.3 Ratios for Profitability and Valuation -- 19.4 Ratios Relating to Operations and Efficiency -- 19.5 Ratios for Liquidity and Leverage -- 19.6 DuPont Analysis -- 19.7 Variations Analysis within the DuPont Framework -- 19.8 Further Topics: Portfolios and The Piotroski F-Score -- Part Six Data and Statistical Analysis -- Chapter 20 Statistical Analysis and Measures -- 20.1 Introduction -- 20.2 Data Structures in Excel and The Impact on Functionality -- 20.3 Averages and Spread -- 20.4 The AGGREGATE Function -- 20.5 Conditional Aggregations -- 20.6 Database Functions -- 20.7 Correlations, Covariance, and Regression -- 20.8 Excel Tables -- 20.9 Pivot Tables -- 20.10 Further Topics: More on Averages, Correlations, and Confidence Intervals -- Chapter 21 Data Preparation: Sourcing, Manipulation, and Integration -- 21.1 Introduction -- 21.2 Modeling Considerations -- 21.3 Overview of Data Manipulation Process -- 21.4 Cleaning Excel Data Sets -- 21.5 Integration of Excel Data Sets | |
| 505 | 8 | |a 21.6 Further Topics I: Introduction to PowerQuery - Appending Tables -- 21.7 Further Topics II: Introduction to PowerQuery - Data Manipulation -- 21.8 Further Topics III: Introduction to PowerPivot and the Data Model -- Index -- EULA. | |
| 776 | 0 | 8 | |i Erscheint auch als |n Druck-Ausgabe |a Rees, Michael |t The Essentials of Financial Modeling in Excel |d Newark : John Wiley & Sons, Incorporated,c2023 |z 9781394157785 |
| 776 | 0 | 8 | |i Erscheint auch als |n Online-Ausgabe |z 978-1-394-15780-8 |
| 999 | |a oai:aleph.bib-bvb.de:BVB01-034847377 | ||
Record in the Search Index
| _version_ | 1804186309976129536 |
|---|---|
| adam_txt | |
| any_adam_object | |
| any_adam_object_boolean | |
| author | Rees, Michael 1964- |
| author_GND | (DE-588)136694659 |
| author_facet | Rees, Michael 1964- |
| author_role | aut |
| author_sort | Rees, Michael 1964- |
| author_variant | m r mr |
| building | Verbundindex |
| bvnumber | BV049502230 |
| classification_rvk | QP 700 |
| contents | Cover -- Title Page -- Copyright Page -- Contents -- About This Book -- The Author -- Part One Introduction to Modeling -- Chapter 1 Modeling and Its Uses -- 1.1 What Is a Model? -- 1.2 What Are Models Used For? -- Chapter 2 Principles of Model Design -- 2.1 Introduction -- 2.2 Decision Identification, Framing, and Structure -- 2.3 Decision Criteria and Information Needs -- 2.4 Sensitivity-Based Design -- 2.5 Data and Data Sources -- 2.6 Model Mapping and Approximations -- 2.7 Building and Testing -- 2.8 Results Presentation -- 2.9 Biases -- Part Two Essentials of Excel -- Chapter 3 Menus, Operations, Functions, and Features -- 3.1 Introduction -- 3.2 Structure and Menus -- 3.3 Calculations Using Arithmetic -- 3.4 Function Basics -- 3.5 A Core Function Set -- 3.6 Further Properties and Uses of Functions -- 3.7 Calculation Settings and Options -- 3.8 KeyTips and Shortcuts -- 3.9 Absolute and Relative Referencing -- 3.10 Auditing and Logic Tracing -- 3.11 Named Ranges -- 3.12 Best Practices: Overview -- 3.13 Best Practices: Flow -- 3.14 Best Practices: Time Axis -- 3.15 Best Practices: Multiple Worksheets -- 3.16 Best Practices: Formatting -- 3.17 Model Testing, Checking, and Error Management -- 3.18 Graphs and Charts -- Chapter 4 Sensitivity and Scenario Analysis -- 4.1 Introduction -- 4.2 Basic or Manual Sensitivity Analysis -- 4.3 Automating Sensitivity Analysis: An Introduction -- 4.4 Using DataTables -- 4.5 Checking the Results, Limitations, and Tips -- 4.6 Creating Flexibility in the Outputs That Are Analyzed -- 4.7 Scenario Analysis -- 4.8 Variations Analysis -- 4.9 Using GoalSeek -- 4.10 Further Topics: Optimization, Risk, Uncertainty, and Simulation -- Part Three General Calculations and Structures -- Chapter 5 Growth Calculations for Forecasting -- 5.1 Introduction -- 5.2 Growth Measurement and Forecasting -- 5.3 Logic Reversals 5.4 Forecasting Structures in Practice -- 5.5 Simplifying the Sensitivity Analysis and Reducing the Number of Parameters -- 5.6 Dealing with Inflation -- 5.7 Conversions for Model Periods -- 5.8 Further Topics: Logarithmic and Exponential Growth -- Chapter 6 Modular Structures and Summary Reports -- 6.1 Introduction -- 6.2 Motivation for Summary Areas and Their Placement -- 6.3 Example I: Summaries and Conditional Summaries -- 6.4 Example II: Targets, Flags, and Matching -- 6.5 Sensitivity Analysis -- 6.6 Comments on Formatting -- 6.7 Initialization Areas -- Chapter 7 Scaling and Ratio-driven Forecasts -- 7.1 Introduction -- 7.2 Basic Uses -- 7.3 Links to Length of Model Periods -- 7.4 Days' Equivalent Approaches -- 7.5 Example I: Forecasting from Revenues to EBITDA -- 7.6 Using Ratio-Based Forecasting Effectively -- 7.7 Example II: Ratio-Based Forecasting of Capital Items -- 7.8 Further Topics: Links to General Ratio Analysis -- Chapter 8 Corkscrews and Reverse Corkscrews -- 8.1 Introduction -- 8.2 Classical Corkscrews -- 8.3 Benefits and Further Uses -- 8.4 Reverse Corkscrews -- Chapter 9 Waterfall Allocations -- 9.1 Introduction -- 9.2 Example I: Cost Sharing -- 9.3 Example II: Tax Calculations -- 9.4 Options for Layout and Structure -- 9.5 Further Topics: Waterfalls for Sharing Capital Returns or Carried Interest -- Chapter 10 Interpolations and Allocations -- 10.1 Introduction -- 10.2 Example I: Linear Smoothing -- 10.3 Example II: Proportional Smoothing -- 10.4 Uses of Tapering and Interpolation -- 10.5 Triangles -- 10.6 Further Topics: Triangles -- Part Four Economic Foundations and Evaluation -- Chapter 11 Breakeven and Payback Analysis -- 11.1 Introduction -- 11.2 Single-Period Breakeven Analysis: Prices and Volumes -- 11.3 Breakeven Time and Payback Periods -- Chapter 12 Interest Rates and Compounding -- 12.1 Introduction 12.2 Stated Rates and Calculations without Compounding -- 12.3 Compounding Types and Effective Rates -- 12.4 Conversion of Effective Rates for Periods of Different Lengths -- 12.5 Average Effective Rates -- 12.6 Implied Rates and Bootstrapping -- Chapter 13 Loan Repayment Calculations -- 13.1 Introduction -- 13.2 Effective Rates for Interest-Only Repayments -- 13.3 Aligning Model Periods with Interest Repayments -- 13.4 Constant Repayment Loans Using the PMT Function -- 13.5 Constant Repayment Loans: Other Functions -- 13.6 Periods of Different Lengths -- Chapter 14 Discounting, Present Values, and Annuities -- 14.1 Introduction -- 14.2 The Time Value of Money -- 14.3 Calculation Options for Present Values -- 14.4 Annuities and Perpetuities -- 14.5 Multi-Period Approaches and Terminal Values -- 14.6 Further Topics I: Mathematics of Annuities -- 14.7 Further Topics II: Cash Flow Timing -- Chapter 15 Returns and Internal Rate of Return -- 15.1 Introduction -- 15.2 Single Investments and Paybacks -- 15.3 Multiple Paybacks: Average Returns and the Internal Rate of Return -- 15.4 Using Economic Metrics to Guide Investment Decisions -- 15.5 Properties and Comparison of NPV and IRR -- Part Five Corporate Finance and Valuation -- Chapter 16 The Cost of Capital -- 16.1 Introduction -- 16.2 Returns, Costs, and Opportunity Costs of Capital -- 16.3 The Role of Risk in Determining the Cost of Capital -- 16.4 The Properties and Benefits of Debt -- 16.5 The Financing Mix and The Weighted Average Cost of Capital -- 16.6 Modigliani-Miller and Leverage Adjustments -- 16.7 The Capital Asset Pricing Model -- 16.8 Further Topics: Derivation of Leveraging and Deleveraging Formulas -- Chapter 17 Financial Statement Modeling -- 17.1 Introduction -- 17.2 Financial Statement Essentials -- 17.3 Key Challenges in Building Integrated Financial Statement Models 17.4 Forecasting of the Integrated Statements: A Simple Example -- 17.5 The Dynamic Financing Adjustment Mechanism -- 17.6 Generalizing the Model Features and Capabilities -- 17.7 Steps and Principles in Building a Financial Statement Model -- 17.8 Further Topics: Avoiding Circularities -- Chapter 18 Corporate Valuation Modeling -- 18.1 Introduction -- 18.2 Overview of Valuation Methods -- 18.3 Principles of Cash Flow Valuation -- 18.4 Free Cash Flow for Enterprise Valuation -- 18.5 The Role of the Explicit Forecast -- 18.6 Example: Explicit Forecast with Terminal Value Calculation -- 18.7 Further Topics I: Enterprise Value Based on Free Cash Flow and Equivalences -- 18.8 Further Topics II: Value-Driver Formulas -- 18.9 Further Topics III: Implied Cost of Equity -- Chapter 19 Ratio Analysis -- 19.1 Introduction -- 19.2 Use and Principles -- 19.3 Ratios for Profitability and Valuation -- 19.4 Ratios Relating to Operations and Efficiency -- 19.5 Ratios for Liquidity and Leverage -- 19.6 DuPont Analysis -- 19.7 Variations Analysis within the DuPont Framework -- 19.8 Further Topics: Portfolios and The Piotroski F-Score -- Part Six Data and Statistical Analysis -- Chapter 20 Statistical Analysis and Measures -- 20.1 Introduction -- 20.2 Data Structures in Excel and The Impact on Functionality -- 20.3 Averages and Spread -- 20.4 The AGGREGATE Function -- 20.5 Conditional Aggregations -- 20.6 Database Functions -- 20.7 Correlations, Covariance, and Regression -- 20.8 Excel Tables -- 20.9 Pivot Tables -- 20.10 Further Topics: More on Averages, Correlations, and Confidence Intervals -- Chapter 21 Data Preparation: Sourcing, Manipulation, and Integration -- 21.1 Introduction -- 21.2 Modeling Considerations -- 21.3 Overview of Data Manipulation Process -- 21.4 Cleaning Excel Data Sets -- 21.5 Integration of Excel Data Sets 21.6 Further Topics I: Introduction to PowerQuery - Appending Tables -- 21.7 Further Topics II: Introduction to PowerQuery - Data Manipulation -- 21.8 Further Topics III: Introduction to PowerPivot and the Data Model -- Index -- EULA. |
| ctrlnum | (OCoLC)1418702819 (DE-599)BVBBV049502230 |
| discipline | Wirtschaftswissenschaften |
| discipline_str_mv | Wirtschaftswissenschaften |
| format | Book |
| fullrecord | <?xml version="1.0" encoding="UTF-8"?><collection xmlns="http://www.loc.gov/MARC21/slim"><record><leader>09025nam a2200373zc 4500</leader><controlfield tag="001">BV049502230</controlfield><controlfield tag="003">DE-604</controlfield><controlfield tag="005">20240219 </controlfield><controlfield tag="007">t</controlfield><controlfield tag="008">240116s2023 a||| |||| 00||| eng d</controlfield><datafield tag="020" ind1=" " ind2=" "><subfield code="a">9781394157785</subfield><subfield code="9">978-1-394-15778-5</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(OCoLC)1418702819</subfield></datafield><datafield tag="035" ind1=" " ind2=" "><subfield code="a">(DE-599)BVBBV049502230</subfield></datafield><datafield tag="040" ind1=" " ind2=" "><subfield code="a">DE-604</subfield><subfield code="b">ger</subfield><subfield code="e">rda</subfield></datafield><datafield tag="041" ind1="0" ind2=" "><subfield code="a">eng</subfield></datafield><datafield tag="049" ind1=" " ind2=" "><subfield code="a">DE-N2</subfield></datafield><datafield tag="084" ind1=" " ind2=" "><subfield code="a">QP 700</subfield><subfield code="0">(DE-625)141926:</subfield><subfield code="2">rvk</subfield></datafield><datafield tag="100" ind1="1" ind2=" "><subfield code="a">Rees, Michael</subfield><subfield code="d">1964-</subfield><subfield code="e">Verfasser</subfield><subfield code="0">(DE-588)136694659</subfield><subfield code="4">aut</subfield></datafield><datafield tag="245" ind1="1" ind2="0"><subfield code="a">The Essentials of financial modeling in Excel</subfield><subfield code="b">a concise guide to concepts and methods</subfield></datafield><datafield tag="264" ind1=" " ind2="1"><subfield code="a">Newark</subfield><subfield code="b">John Wiley & Sons, Incorporated</subfield><subfield code="c">2023</subfield></datafield><datafield tag="264" ind1=" " ind2="4"><subfield code="c">©2023</subfield></datafield><datafield tag="300" ind1=" " ind2=" "><subfield code="a">xi, 316 Seiten</subfield><subfield code="b">Illustrationen, Diagramme</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">Description based on publisher supplied metadata and other sources</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">Cover -- Title Page -- Copyright Page -- Contents -- About This Book -- The Author -- Part One Introduction to Modeling -- Chapter 1 Modeling and Its Uses -- 1.1 What Is a Model? -- 1.2 What Are Models Used For? -- Chapter 2 Principles of Model Design -- 2.1 Introduction -- 2.2 Decision Identification, Framing, and Structure -- 2.3 Decision Criteria and Information Needs -- 2.4 Sensitivity-Based Design -- 2.5 Data and Data Sources -- 2.6 Model Mapping and Approximations -- 2.7 Building and Testing -- 2.8 Results Presentation -- 2.9 Biases -- Part Two Essentials of Excel -- Chapter 3 Menus, Operations, Functions, and Features -- 3.1 Introduction -- 3.2 Structure and Menus -- 3.3 Calculations Using Arithmetic -- 3.4 Function Basics -- 3.5 A Core Function Set -- 3.6 Further Properties and Uses of Functions -- 3.7 Calculation Settings and Options -- 3.8 KeyTips and Shortcuts -- 3.9 Absolute and Relative Referencing -- 3.10 Auditing and Logic Tracing -- 3.11 Named Ranges -- 3.12 Best Practices: Overview -- 3.13 Best Practices: Flow -- 3.14 Best Practices: Time Axis -- 3.15 Best Practices: Multiple Worksheets -- 3.16 Best Practices: Formatting -- 3.17 Model Testing, Checking, and Error Management -- 3.18 Graphs and Charts -- Chapter 4 Sensitivity and Scenario Analysis -- 4.1 Introduction -- 4.2 Basic or Manual Sensitivity Analysis -- 4.3 Automating Sensitivity Analysis: An Introduction -- 4.4 Using DataTables -- 4.5 Checking the Results, Limitations, and Tips -- 4.6 Creating Flexibility in the Outputs That Are Analyzed -- 4.7 Scenario Analysis -- 4.8 Variations Analysis -- 4.9 Using GoalSeek -- 4.10 Further Topics: Optimization, Risk, Uncertainty, and Simulation -- Part Three General Calculations and Structures -- Chapter 5 Growth Calculations for Forecasting -- 5.1 Introduction -- 5.2 Growth Measurement and Forecasting -- 5.3 Logic Reversals</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">5.4 Forecasting Structures in Practice -- 5.5 Simplifying the Sensitivity Analysis and Reducing the Number of Parameters -- 5.6 Dealing with Inflation -- 5.7 Conversions for Model Periods -- 5.8 Further Topics: Logarithmic and Exponential Growth -- Chapter 6 Modular Structures and Summary Reports -- 6.1 Introduction -- 6.2 Motivation for Summary Areas and Their Placement -- 6.3 Example I: Summaries and Conditional Summaries -- 6.4 Example II: Targets, Flags, and Matching -- 6.5 Sensitivity Analysis -- 6.6 Comments on Formatting -- 6.7 Initialization Areas -- Chapter 7 Scaling and Ratio-driven Forecasts -- 7.1 Introduction -- 7.2 Basic Uses -- 7.3 Links to Length of Model Periods -- 7.4 Days' Equivalent Approaches -- 7.5 Example I: Forecasting from Revenues to EBITDA -- 7.6 Using Ratio-Based Forecasting Effectively -- 7.7 Example II: Ratio-Based Forecasting of Capital Items -- 7.8 Further Topics: Links to General Ratio Analysis -- Chapter 8 Corkscrews and Reverse Corkscrews -- 8.1 Introduction -- 8.2 Classical Corkscrews -- 8.3 Benefits and Further Uses -- 8.4 Reverse Corkscrews -- Chapter 9 Waterfall Allocations -- 9.1 Introduction -- 9.2 Example I: Cost Sharing -- 9.3 Example II: Tax Calculations -- 9.4 Options for Layout and Structure -- 9.5 Further Topics: Waterfalls for Sharing Capital Returns or Carried Interest -- Chapter 10 Interpolations and Allocations -- 10.1 Introduction -- 10.2 Example I: Linear Smoothing -- 10.3 Example II: Proportional Smoothing -- 10.4 Uses of Tapering and Interpolation -- 10.5 Triangles -- 10.6 Further Topics: Triangles -- Part Four Economic Foundations and Evaluation -- Chapter 11 Breakeven and Payback Analysis -- 11.1 Introduction -- 11.2 Single-Period Breakeven Analysis: Prices and Volumes -- 11.3 Breakeven Time and Payback Periods -- Chapter 12 Interest Rates and Compounding -- 12.1 Introduction</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">12.2 Stated Rates and Calculations without Compounding -- 12.3 Compounding Types and Effective Rates -- 12.4 Conversion of Effective Rates for Periods of Different Lengths -- 12.5 Average Effective Rates -- 12.6 Implied Rates and Bootstrapping -- Chapter 13 Loan Repayment Calculations -- 13.1 Introduction -- 13.2 Effective Rates for Interest-Only Repayments -- 13.3 Aligning Model Periods with Interest Repayments -- 13.4 Constant Repayment Loans Using the PMT Function -- 13.5 Constant Repayment Loans: Other Functions -- 13.6 Periods of Different Lengths -- Chapter 14 Discounting, Present Values, and Annuities -- 14.1 Introduction -- 14.2 The Time Value of Money -- 14.3 Calculation Options for Present Values -- 14.4 Annuities and Perpetuities -- 14.5 Multi-Period Approaches and Terminal Values -- 14.6 Further Topics I: Mathematics of Annuities -- 14.7 Further Topics II: Cash Flow Timing -- Chapter 15 Returns and Internal Rate of Return -- 15.1 Introduction -- 15.2 Single Investments and Paybacks -- 15.3 Multiple Paybacks: Average Returns and the Internal Rate of Return -- 15.4 Using Economic Metrics to Guide Investment Decisions -- 15.5 Properties and Comparison of NPV and IRR -- Part Five Corporate Finance and Valuation -- Chapter 16 The Cost of Capital -- 16.1 Introduction -- 16.2 Returns, Costs, and Opportunity Costs of Capital -- 16.3 The Role of Risk in Determining the Cost of Capital -- 16.4 The Properties and Benefits of Debt -- 16.5 The Financing Mix and The Weighted Average Cost of Capital -- 16.6 Modigliani-Miller and Leverage Adjustments -- 16.7 The Capital Asset Pricing Model -- 16.8 Further Topics: Derivation of Leveraging and Deleveraging Formulas -- Chapter 17 Financial Statement Modeling -- 17.1 Introduction -- 17.2 Financial Statement Essentials -- 17.3 Key Challenges in Building Integrated Financial Statement Models</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">17.4 Forecasting of the Integrated Statements: A Simple Example -- 17.5 The Dynamic Financing Adjustment Mechanism -- 17.6 Generalizing the Model Features and Capabilities -- 17.7 Steps and Principles in Building a Financial Statement Model -- 17.8 Further Topics: Avoiding Circularities -- Chapter 18 Corporate Valuation Modeling -- 18.1 Introduction -- 18.2 Overview of Valuation Methods -- 18.3 Principles of Cash Flow Valuation -- 18.4 Free Cash Flow for Enterprise Valuation -- 18.5 The Role of the Explicit Forecast -- 18.6 Example: Explicit Forecast with Terminal Value Calculation -- 18.7 Further Topics I: Enterprise Value Based on Free Cash Flow and Equivalences -- 18.8 Further Topics II: Value-Driver Formulas -- 18.9 Further Topics III: Implied Cost of Equity -- Chapter 19 Ratio Analysis -- 19.1 Introduction -- 19.2 Use and Principles -- 19.3 Ratios for Profitability and Valuation -- 19.4 Ratios Relating to Operations and Efficiency -- 19.5 Ratios for Liquidity and Leverage -- 19.6 DuPont Analysis -- 19.7 Variations Analysis within the DuPont Framework -- 19.8 Further Topics: Portfolios and The Piotroski F-Score -- Part Six Data and Statistical Analysis -- Chapter 20 Statistical Analysis and Measures -- 20.1 Introduction -- 20.2 Data Structures in Excel and The Impact on Functionality -- 20.3 Averages and Spread -- 20.4 The AGGREGATE Function -- 20.5 Conditional Aggregations -- 20.6 Database Functions -- 20.7 Correlations, Covariance, and Regression -- 20.8 Excel Tables -- 20.9 Pivot Tables -- 20.10 Further Topics: More on Averages, Correlations, and Confidence Intervals -- Chapter 21 Data Preparation: Sourcing, Manipulation, and Integration -- 21.1 Introduction -- 21.2 Modeling Considerations -- 21.3 Overview of Data Manipulation Process -- 21.4 Cleaning Excel Data Sets -- 21.5 Integration of Excel Data Sets</subfield></datafield><datafield tag="505" ind1="8" ind2=" "><subfield code="a">21.6 Further Topics I: Introduction to PowerQuery - Appending Tables -- 21.7 Further Topics II: Introduction to PowerQuery - Data Manipulation -- 21.8 Further Topics III: Introduction to PowerPivot and the Data Model -- Index -- EULA.</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Druck-Ausgabe</subfield><subfield code="a">Rees, Michael</subfield><subfield code="t">The Essentials of Financial Modeling in Excel</subfield><subfield code="d">Newark : John Wiley & Sons, Incorporated,c2023</subfield><subfield code="z">9781394157785</subfield></datafield><datafield tag="776" ind1="0" ind2="8"><subfield code="i">Erscheint auch als</subfield><subfield code="n">Online-Ausgabe</subfield><subfield code="z">978-1-394-15780-8</subfield></datafield><datafield tag="999" ind1=" " ind2=" "><subfield code="a">oai:aleph.bib-bvb.de:BVB01-034847377</subfield></datafield></record></collection> |
| id | DE-604.BV049502230 |
| illustrated | Illustrated |
| index_date | 2024-07-03T23:21:36Z |
| indexdate | 2024-07-10T10:09:05Z |
| institution | BVB |
| isbn | 9781394157785 |
| language | English |
| oai_aleph_id | oai:aleph.bib-bvb.de:BVB01-034847377 |
| oclc_num | 1418702819 |
| open_access_boolean | |
| owner | DE-N2 |
| owner_facet | DE-N2 |
| physical | xi, 316 Seiten Illustrationen, Diagramme |
| publishDate | 2023 |
| publishDateSearch | 2023 |
| publishDateSort | 2023 |
| publisher | John Wiley & Sons, Incorporated |
| record_format | marc |
| spelling | Rees, Michael 1964- Verfasser (DE-588)136694659 aut The Essentials of financial modeling in Excel a concise guide to concepts and methods Newark John Wiley & Sons, Incorporated 2023 ©2023 xi, 316 Seiten Illustrationen, Diagramme txt rdacontent n rdamedia nc rdacarrier Description based on publisher supplied metadata and other sources Cover -- Title Page -- Copyright Page -- Contents -- About This Book -- The Author -- Part One Introduction to Modeling -- Chapter 1 Modeling and Its Uses -- 1.1 What Is a Model? -- 1.2 What Are Models Used For? -- Chapter 2 Principles of Model Design -- 2.1 Introduction -- 2.2 Decision Identification, Framing, and Structure -- 2.3 Decision Criteria and Information Needs -- 2.4 Sensitivity-Based Design -- 2.5 Data and Data Sources -- 2.6 Model Mapping and Approximations -- 2.7 Building and Testing -- 2.8 Results Presentation -- 2.9 Biases -- Part Two Essentials of Excel -- Chapter 3 Menus, Operations, Functions, and Features -- 3.1 Introduction -- 3.2 Structure and Menus -- 3.3 Calculations Using Arithmetic -- 3.4 Function Basics -- 3.5 A Core Function Set -- 3.6 Further Properties and Uses of Functions -- 3.7 Calculation Settings and Options -- 3.8 KeyTips and Shortcuts -- 3.9 Absolute and Relative Referencing -- 3.10 Auditing and Logic Tracing -- 3.11 Named Ranges -- 3.12 Best Practices: Overview -- 3.13 Best Practices: Flow -- 3.14 Best Practices: Time Axis -- 3.15 Best Practices: Multiple Worksheets -- 3.16 Best Practices: Formatting -- 3.17 Model Testing, Checking, and Error Management -- 3.18 Graphs and Charts -- Chapter 4 Sensitivity and Scenario Analysis -- 4.1 Introduction -- 4.2 Basic or Manual Sensitivity Analysis -- 4.3 Automating Sensitivity Analysis: An Introduction -- 4.4 Using DataTables -- 4.5 Checking the Results, Limitations, and Tips -- 4.6 Creating Flexibility in the Outputs That Are Analyzed -- 4.7 Scenario Analysis -- 4.8 Variations Analysis -- 4.9 Using GoalSeek -- 4.10 Further Topics: Optimization, Risk, Uncertainty, and Simulation -- Part Three General Calculations and Structures -- Chapter 5 Growth Calculations for Forecasting -- 5.1 Introduction -- 5.2 Growth Measurement and Forecasting -- 5.3 Logic Reversals 5.4 Forecasting Structures in Practice -- 5.5 Simplifying the Sensitivity Analysis and Reducing the Number of Parameters -- 5.6 Dealing with Inflation -- 5.7 Conversions for Model Periods -- 5.8 Further Topics: Logarithmic and Exponential Growth -- Chapter 6 Modular Structures and Summary Reports -- 6.1 Introduction -- 6.2 Motivation for Summary Areas and Their Placement -- 6.3 Example I: Summaries and Conditional Summaries -- 6.4 Example II: Targets, Flags, and Matching -- 6.5 Sensitivity Analysis -- 6.6 Comments on Formatting -- 6.7 Initialization Areas -- Chapter 7 Scaling and Ratio-driven Forecasts -- 7.1 Introduction -- 7.2 Basic Uses -- 7.3 Links to Length of Model Periods -- 7.4 Days' Equivalent Approaches -- 7.5 Example I: Forecasting from Revenues to EBITDA -- 7.6 Using Ratio-Based Forecasting Effectively -- 7.7 Example II: Ratio-Based Forecasting of Capital Items -- 7.8 Further Topics: Links to General Ratio Analysis -- Chapter 8 Corkscrews and Reverse Corkscrews -- 8.1 Introduction -- 8.2 Classical Corkscrews -- 8.3 Benefits and Further Uses -- 8.4 Reverse Corkscrews -- Chapter 9 Waterfall Allocations -- 9.1 Introduction -- 9.2 Example I: Cost Sharing -- 9.3 Example II: Tax Calculations -- 9.4 Options for Layout and Structure -- 9.5 Further Topics: Waterfalls for Sharing Capital Returns or Carried Interest -- Chapter 10 Interpolations and Allocations -- 10.1 Introduction -- 10.2 Example I: Linear Smoothing -- 10.3 Example II: Proportional Smoothing -- 10.4 Uses of Tapering and Interpolation -- 10.5 Triangles -- 10.6 Further Topics: Triangles -- Part Four Economic Foundations and Evaluation -- Chapter 11 Breakeven and Payback Analysis -- 11.1 Introduction -- 11.2 Single-Period Breakeven Analysis: Prices and Volumes -- 11.3 Breakeven Time and Payback Periods -- Chapter 12 Interest Rates and Compounding -- 12.1 Introduction 12.2 Stated Rates and Calculations without Compounding -- 12.3 Compounding Types and Effective Rates -- 12.4 Conversion of Effective Rates for Periods of Different Lengths -- 12.5 Average Effective Rates -- 12.6 Implied Rates and Bootstrapping -- Chapter 13 Loan Repayment Calculations -- 13.1 Introduction -- 13.2 Effective Rates for Interest-Only Repayments -- 13.3 Aligning Model Periods with Interest Repayments -- 13.4 Constant Repayment Loans Using the PMT Function -- 13.5 Constant Repayment Loans: Other Functions -- 13.6 Periods of Different Lengths -- Chapter 14 Discounting, Present Values, and Annuities -- 14.1 Introduction -- 14.2 The Time Value of Money -- 14.3 Calculation Options for Present Values -- 14.4 Annuities and Perpetuities -- 14.5 Multi-Period Approaches and Terminal Values -- 14.6 Further Topics I: Mathematics of Annuities -- 14.7 Further Topics II: Cash Flow Timing -- Chapter 15 Returns and Internal Rate of Return -- 15.1 Introduction -- 15.2 Single Investments and Paybacks -- 15.3 Multiple Paybacks: Average Returns and the Internal Rate of Return -- 15.4 Using Economic Metrics to Guide Investment Decisions -- 15.5 Properties and Comparison of NPV and IRR -- Part Five Corporate Finance and Valuation -- Chapter 16 The Cost of Capital -- 16.1 Introduction -- 16.2 Returns, Costs, and Opportunity Costs of Capital -- 16.3 The Role of Risk in Determining the Cost of Capital -- 16.4 The Properties and Benefits of Debt -- 16.5 The Financing Mix and The Weighted Average Cost of Capital -- 16.6 Modigliani-Miller and Leverage Adjustments -- 16.7 The Capital Asset Pricing Model -- 16.8 Further Topics: Derivation of Leveraging and Deleveraging Formulas -- Chapter 17 Financial Statement Modeling -- 17.1 Introduction -- 17.2 Financial Statement Essentials -- 17.3 Key Challenges in Building Integrated Financial Statement Models 17.4 Forecasting of the Integrated Statements: A Simple Example -- 17.5 The Dynamic Financing Adjustment Mechanism -- 17.6 Generalizing the Model Features and Capabilities -- 17.7 Steps and Principles in Building a Financial Statement Model -- 17.8 Further Topics: Avoiding Circularities -- Chapter 18 Corporate Valuation Modeling -- 18.1 Introduction -- 18.2 Overview of Valuation Methods -- 18.3 Principles of Cash Flow Valuation -- 18.4 Free Cash Flow for Enterprise Valuation -- 18.5 The Role of the Explicit Forecast -- 18.6 Example: Explicit Forecast with Terminal Value Calculation -- 18.7 Further Topics I: Enterprise Value Based on Free Cash Flow and Equivalences -- 18.8 Further Topics II: Value-Driver Formulas -- 18.9 Further Topics III: Implied Cost of Equity -- Chapter 19 Ratio Analysis -- 19.1 Introduction -- 19.2 Use and Principles -- 19.3 Ratios for Profitability and Valuation -- 19.4 Ratios Relating to Operations and Efficiency -- 19.5 Ratios for Liquidity and Leverage -- 19.6 DuPont Analysis -- 19.7 Variations Analysis within the DuPont Framework -- 19.8 Further Topics: Portfolios and The Piotroski F-Score -- Part Six Data and Statistical Analysis -- Chapter 20 Statistical Analysis and Measures -- 20.1 Introduction -- 20.2 Data Structures in Excel and The Impact on Functionality -- 20.3 Averages and Spread -- 20.4 The AGGREGATE Function -- 20.5 Conditional Aggregations -- 20.6 Database Functions -- 20.7 Correlations, Covariance, and Regression -- 20.8 Excel Tables -- 20.9 Pivot Tables -- 20.10 Further Topics: More on Averages, Correlations, and Confidence Intervals -- Chapter 21 Data Preparation: Sourcing, Manipulation, and Integration -- 21.1 Introduction -- 21.2 Modeling Considerations -- 21.3 Overview of Data Manipulation Process -- 21.4 Cleaning Excel Data Sets -- 21.5 Integration of Excel Data Sets 21.6 Further Topics I: Introduction to PowerQuery - Appending Tables -- 21.7 Further Topics II: Introduction to PowerQuery - Data Manipulation -- 21.8 Further Topics III: Introduction to PowerPivot and the Data Model -- Index -- EULA. Erscheint auch als Druck-Ausgabe Rees, Michael The Essentials of Financial Modeling in Excel Newark : John Wiley & Sons, Incorporated,c2023 9781394157785 Erscheint auch als Online-Ausgabe 978-1-394-15780-8 |
| spellingShingle | Rees, Michael 1964- The Essentials of financial modeling in Excel a concise guide to concepts and methods Cover -- Title Page -- Copyright Page -- Contents -- About This Book -- The Author -- Part One Introduction to Modeling -- Chapter 1 Modeling and Its Uses -- 1.1 What Is a Model? -- 1.2 What Are Models Used For? -- Chapter 2 Principles of Model Design -- 2.1 Introduction -- 2.2 Decision Identification, Framing, and Structure -- 2.3 Decision Criteria and Information Needs -- 2.4 Sensitivity-Based Design -- 2.5 Data and Data Sources -- 2.6 Model Mapping and Approximations -- 2.7 Building and Testing -- 2.8 Results Presentation -- 2.9 Biases -- Part Two Essentials of Excel -- Chapter 3 Menus, Operations, Functions, and Features -- 3.1 Introduction -- 3.2 Structure and Menus -- 3.3 Calculations Using Arithmetic -- 3.4 Function Basics -- 3.5 A Core Function Set -- 3.6 Further Properties and Uses of Functions -- 3.7 Calculation Settings and Options -- 3.8 KeyTips and Shortcuts -- 3.9 Absolute and Relative Referencing -- 3.10 Auditing and Logic Tracing -- 3.11 Named Ranges -- 3.12 Best Practices: Overview -- 3.13 Best Practices: Flow -- 3.14 Best Practices: Time Axis -- 3.15 Best Practices: Multiple Worksheets -- 3.16 Best Practices: Formatting -- 3.17 Model Testing, Checking, and Error Management -- 3.18 Graphs and Charts -- Chapter 4 Sensitivity and Scenario Analysis -- 4.1 Introduction -- 4.2 Basic or Manual Sensitivity Analysis -- 4.3 Automating Sensitivity Analysis: An Introduction -- 4.4 Using DataTables -- 4.5 Checking the Results, Limitations, and Tips -- 4.6 Creating Flexibility in the Outputs That Are Analyzed -- 4.7 Scenario Analysis -- 4.8 Variations Analysis -- 4.9 Using GoalSeek -- 4.10 Further Topics: Optimization, Risk, Uncertainty, and Simulation -- Part Three General Calculations and Structures -- Chapter 5 Growth Calculations for Forecasting -- 5.1 Introduction -- 5.2 Growth Measurement and Forecasting -- 5.3 Logic Reversals 5.4 Forecasting Structures in Practice -- 5.5 Simplifying the Sensitivity Analysis and Reducing the Number of Parameters -- 5.6 Dealing with Inflation -- 5.7 Conversions for Model Periods -- 5.8 Further Topics: Logarithmic and Exponential Growth -- Chapter 6 Modular Structures and Summary Reports -- 6.1 Introduction -- 6.2 Motivation for Summary Areas and Their Placement -- 6.3 Example I: Summaries and Conditional Summaries -- 6.4 Example II: Targets, Flags, and Matching -- 6.5 Sensitivity Analysis -- 6.6 Comments on Formatting -- 6.7 Initialization Areas -- Chapter 7 Scaling and Ratio-driven Forecasts -- 7.1 Introduction -- 7.2 Basic Uses -- 7.3 Links to Length of Model Periods -- 7.4 Days' Equivalent Approaches -- 7.5 Example I: Forecasting from Revenues to EBITDA -- 7.6 Using Ratio-Based Forecasting Effectively -- 7.7 Example II: Ratio-Based Forecasting of Capital Items -- 7.8 Further Topics: Links to General Ratio Analysis -- Chapter 8 Corkscrews and Reverse Corkscrews -- 8.1 Introduction -- 8.2 Classical Corkscrews -- 8.3 Benefits and Further Uses -- 8.4 Reverse Corkscrews -- Chapter 9 Waterfall Allocations -- 9.1 Introduction -- 9.2 Example I: Cost Sharing -- 9.3 Example II: Tax Calculations -- 9.4 Options for Layout and Structure -- 9.5 Further Topics: Waterfalls for Sharing Capital Returns or Carried Interest -- Chapter 10 Interpolations and Allocations -- 10.1 Introduction -- 10.2 Example I: Linear Smoothing -- 10.3 Example II: Proportional Smoothing -- 10.4 Uses of Tapering and Interpolation -- 10.5 Triangles -- 10.6 Further Topics: Triangles -- Part Four Economic Foundations and Evaluation -- Chapter 11 Breakeven and Payback Analysis -- 11.1 Introduction -- 11.2 Single-Period Breakeven Analysis: Prices and Volumes -- 11.3 Breakeven Time and Payback Periods -- Chapter 12 Interest Rates and Compounding -- 12.1 Introduction 12.2 Stated Rates and Calculations without Compounding -- 12.3 Compounding Types and Effective Rates -- 12.4 Conversion of Effective Rates for Periods of Different Lengths -- 12.5 Average Effective Rates -- 12.6 Implied Rates and Bootstrapping -- Chapter 13 Loan Repayment Calculations -- 13.1 Introduction -- 13.2 Effective Rates for Interest-Only Repayments -- 13.3 Aligning Model Periods with Interest Repayments -- 13.4 Constant Repayment Loans Using the PMT Function -- 13.5 Constant Repayment Loans: Other Functions -- 13.6 Periods of Different Lengths -- Chapter 14 Discounting, Present Values, and Annuities -- 14.1 Introduction -- 14.2 The Time Value of Money -- 14.3 Calculation Options for Present Values -- 14.4 Annuities and Perpetuities -- 14.5 Multi-Period Approaches and Terminal Values -- 14.6 Further Topics I: Mathematics of Annuities -- 14.7 Further Topics II: Cash Flow Timing -- Chapter 15 Returns and Internal Rate of Return -- 15.1 Introduction -- 15.2 Single Investments and Paybacks -- 15.3 Multiple Paybacks: Average Returns and the Internal Rate of Return -- 15.4 Using Economic Metrics to Guide Investment Decisions -- 15.5 Properties and Comparison of NPV and IRR -- Part Five Corporate Finance and Valuation -- Chapter 16 The Cost of Capital -- 16.1 Introduction -- 16.2 Returns, Costs, and Opportunity Costs of Capital -- 16.3 The Role of Risk in Determining the Cost of Capital -- 16.4 The Properties and Benefits of Debt -- 16.5 The Financing Mix and The Weighted Average Cost of Capital -- 16.6 Modigliani-Miller and Leverage Adjustments -- 16.7 The Capital Asset Pricing Model -- 16.8 Further Topics: Derivation of Leveraging and Deleveraging Formulas -- Chapter 17 Financial Statement Modeling -- 17.1 Introduction -- 17.2 Financial Statement Essentials -- 17.3 Key Challenges in Building Integrated Financial Statement Models 17.4 Forecasting of the Integrated Statements: A Simple Example -- 17.5 The Dynamic Financing Adjustment Mechanism -- 17.6 Generalizing the Model Features and Capabilities -- 17.7 Steps and Principles in Building a Financial Statement Model -- 17.8 Further Topics: Avoiding Circularities -- Chapter 18 Corporate Valuation Modeling -- 18.1 Introduction -- 18.2 Overview of Valuation Methods -- 18.3 Principles of Cash Flow Valuation -- 18.4 Free Cash Flow for Enterprise Valuation -- 18.5 The Role of the Explicit Forecast -- 18.6 Example: Explicit Forecast with Terminal Value Calculation -- 18.7 Further Topics I: Enterprise Value Based on Free Cash Flow and Equivalences -- 18.8 Further Topics II: Value-Driver Formulas -- 18.9 Further Topics III: Implied Cost of Equity -- Chapter 19 Ratio Analysis -- 19.1 Introduction -- 19.2 Use and Principles -- 19.3 Ratios for Profitability and Valuation -- 19.4 Ratios Relating to Operations and Efficiency -- 19.5 Ratios for Liquidity and Leverage -- 19.6 DuPont Analysis -- 19.7 Variations Analysis within the DuPont Framework -- 19.8 Further Topics: Portfolios and The Piotroski F-Score -- Part Six Data and Statistical Analysis -- Chapter 20 Statistical Analysis and Measures -- 20.1 Introduction -- 20.2 Data Structures in Excel and The Impact on Functionality -- 20.3 Averages and Spread -- 20.4 The AGGREGATE Function -- 20.5 Conditional Aggregations -- 20.6 Database Functions -- 20.7 Correlations, Covariance, and Regression -- 20.8 Excel Tables -- 20.9 Pivot Tables -- 20.10 Further Topics: More on Averages, Correlations, and Confidence Intervals -- Chapter 21 Data Preparation: Sourcing, Manipulation, and Integration -- 21.1 Introduction -- 21.2 Modeling Considerations -- 21.3 Overview of Data Manipulation Process -- 21.4 Cleaning Excel Data Sets -- 21.5 Integration of Excel Data Sets 21.6 Further Topics I: Introduction to PowerQuery - Appending Tables -- 21.7 Further Topics II: Introduction to PowerQuery - Data Manipulation -- 21.8 Further Topics III: Introduction to PowerPivot and the Data Model -- Index -- EULA. |
| title | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_auth | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_exact_search | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_exact_search_txtP | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_full | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_fullStr | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_full_unstemmed | The Essentials of financial modeling in Excel a concise guide to concepts and methods |
| title_short | The Essentials of financial modeling in Excel |
| title_sort | the essentials of financial modeling in excel a concise guide to concepts and methods |
| title_sub | a concise guide to concepts and methods |
| work_keys_str_mv | AT reesmichael theessentialsoffinancialmodelinginexcelaconciseguidetoconceptsandmethods |