top

  Info

  • Utilizzare la checkbox di selezione a fianco di ciascun documento per attivare le funzionalità di stampa, invio email, download nei formati disponibili del (i) record.

  Info

  • Utilizzare questo link per rimuovere la selezione effettuata.

Biblioteca

MARC Lista (tabellare)
Financial Modeling with Crystal Ball and Excel [[electronic resource]]
Financial Modeling with Crystal Ball and Excel [[electronic resource]]
Autore Charnes John
Edizione [2nd ed.]
Pubbl/distr/stampa New York, : Wiley, 2012
Descrizione fisica 1 online resource (336 p.)
Disciplina 332.0113
332.0285/554
332.0285554
Collana Wiley Finance
Soggetto topico BUSINESS & ECONOMICS / Investments & Securities
Finance -- Mathematical models
Microsoft Excel (Computer file)
Finance - Mathematical models
Investments - Mathematical models
ISBN 1-119-20321-X
1-280-59278-8
9786613622617
1-118-22705-0
Classificazione BUS036000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart
2.2.3 Overlay Chart 2.3 PRESENTING THE RESULTS; CHAPTER 3 Building A Crystal Ball Model; 3.1 SIMULATION MODELING PROCESS; 3.1.1 Example: AKGolf.xls; 3.2 DEFINING CRYSTAL BALL ASSUMPTIONS AND FORECASTS; 3.2.1 Defining Assumptions; 3.2.2 Defining Profit as a Forecast Cell; 3.3 RUNNING CRYSTAL BALL; 3.4 SOURCES OF ERROR; 3.5 CONTROLLING MODEL ERROR; CHAPTER 4 Selecting Crystal Ball Assumptions; 4.1 CRYSTAL BALL'S BASIC DISTRIBUTIONS; 4.1.1 Yes-No; 4.1.2 Binomial; 4.1.3 Discrete Uniform; 4.1.4 Uniform; 4.1.5 Triangular; 4.1.6 Normal; 4.1.7 Lognormal
4.2 USING HISTORICAL DATA TO CHOOSE DISTRIBUTIONS 4.2.1 Direct Sampling; 4.2.2 Sampling from a Fitted Distribution; 4.2.3 Fitting Distributions to Data; 4.2.4 Goodness-of-Fit Testing; 4.2.5 Eyeball Test; 4.2.6 Caveats; 4.2.7 What If No Historical Data Are Available?; 4.3 SPECIFYING CORRELATIONS; 4.3.1 Pearson Correlation Statistic; 4.3.2 Spearman (Rank) Correlation Statistic; 4.3.3 Using Crystal Ball to Calculate Correlations Between Two Assumptions; 4.3.4 Batch Fit; 4.3.5 Correlation Tool; CHAPTER 5 Using Decision Variables; 5.1 DEFINING DECISION VARIABLES
5.2 DECISION TABLE WITH ONE DECISION VARIABLE 5.2.1 Trend Chart; 5.2.2 Overlay Chart; 5.3 DECISION TABLE WITH TWO DECISION VARIABLES; 5.3.1 Model; 5.3.2 Threshold Values; 5.3.3 Two-Way Decision Table; 5.3.4 Interpreting the Results; 5.4 USING OPTQUEST; 5.4.1 Terminology; 5.4.2 Example; CHAPTER 6 Selecting Run Preferences; 6.1 TRIALS; 6.1.1 Number of Trials to Run; 6.1.2 Stop on Calculation Errors; 6.1.3 Stop When Precision Control Limits Are Reached; 6.2 SAMPLING; 6.2.1 Random Number Generation; 6.2.2 Sampling Method; 6.3 SPEED; 6.3.1 Run Mode; 6.3.2 Chart Windows; 6.4 OPTIONS; 6.5 STATISTICS
CHAPTER 7 Net Present Value and Internal Rate of Return 7.1 DETERMINISTIC NPV AND IRR; 7.2 SIMULATING NPV AND IRR; 7.3 CAPITAL BUDGETING; 7.3.1 Tornado Chart Tool; 7.3.2 Risk Analysis; 7.3.3 Caveats; 7.4 CUSTOMER NET PRESENT VALUE; 7.4.1 Results; CHAPTER 8 Modeling Financial Statements; 8.1 DETERMINISTIC MODEL; 8.2 TORNADO CHART AND SENSITIVITY ANALYSIS; 8.3 CRYSTAL BALL SENSITIVITY CHART; 8.4 CONCLUSION; CHAPTER 9 Portfolio Models; 9.1 SINGLE-PERIOD CRYSTAL BALL MODEL; 9.2 SINGLE-PERIOD ANALYTICAL SOLUTION; 9.3 MULTI-PERIOD CRYSTAL BALL MODEL; CHAPTER 10 Value at Risk; 10.1 VAR
10.2 SHORTCOMINGS OF VAR
Record Nr. UNINA-9910141251103321
Charnes John  
New York, : Wiley, 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial Modeling with Crystal Ball and Excel
Financial Modeling with Crystal Ball and Excel
Autore Charnes John
Edizione [2nd ed.]
Pubbl/distr/stampa New York, : Wiley, 2012
Descrizione fisica 1 online resource (336 p.)
Disciplina 332.0113
332.0285/554
332.0285554
Collana Wiley Finance
Soggetto topico BUSINESS & ECONOMICS / Investments & Securities
Finance -- Mathematical models
Microsoft Excel (Computer file)
Finance - Mathematical models
Investments - Mathematical models
ISBN 1-119-20321-X
1-280-59278-8
9786613622617
1-118-22705-0
Classificazione BUS036000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Financial Modeling with Crystal Ball and Excel; Contents; Preface; Acknowledgments; About the Author; CHAPTER 1 Introduction; 1.1 FINANCIAL MODELING; 1.2 RISK ANALYSIS; 1.3 MONTE CARLO SIMULATION; 1.4 RISK MANAGEMENT; 1.5 BENEFITS AND LIMITATIONS OF USING CRYSTAL BALL; 1.5.1 Benefits; 1.5.2 Limitations; CHAPTER 2 Analyzing Crystal Ball Forecasts; 2.1 SIMULATING A 50-50 PORTFOLIO; 2.1.1 Accumulate.xls; 2.1.2 Frequency Chart; 2.1.3 Cumulative Frequency Chart; 2.1.4 Statistics View; 2.1.5 Forecast Window Percentiles View; 2.2 VARYING THE ALLOCATIONS; 2.2.1 Decision Table Tool; 2.2.2 Trend Chart
2.2.3 Overlay Chart 2.3 PRESENTING THE RESULTS; CHAPTER 3 Building A Crystal Ball Model; 3.1 SIMULATION MODELING PROCESS; 3.1.1 Example: AKGolf.xls; 3.2 DEFINING CRYSTAL BALL ASSUMPTIONS AND FORECASTS; 3.2.1 Defining Assumptions; 3.2.2 Defining Profit as a Forecast Cell; 3.3 RUNNING CRYSTAL BALL; 3.4 SOURCES OF ERROR; 3.5 CONTROLLING MODEL ERROR; CHAPTER 4 Selecting Crystal Ball Assumptions; 4.1 CRYSTAL BALL'S BASIC DISTRIBUTIONS; 4.1.1 Yes-No; 4.1.2 Binomial; 4.1.3 Discrete Uniform; 4.1.4 Uniform; 4.1.5 Triangular; 4.1.6 Normal; 4.1.7 Lognormal
4.2 USING HISTORICAL DATA TO CHOOSE DISTRIBUTIONS 4.2.1 Direct Sampling; 4.2.2 Sampling from a Fitted Distribution; 4.2.3 Fitting Distributions to Data; 4.2.4 Goodness-of-Fit Testing; 4.2.5 Eyeball Test; 4.2.6 Caveats; 4.2.7 What If No Historical Data Are Available?; 4.3 SPECIFYING CORRELATIONS; 4.3.1 Pearson Correlation Statistic; 4.3.2 Spearman (Rank) Correlation Statistic; 4.3.3 Using Crystal Ball to Calculate Correlations Between Two Assumptions; 4.3.4 Batch Fit; 4.3.5 Correlation Tool; CHAPTER 5 Using Decision Variables; 5.1 DEFINING DECISION VARIABLES
5.2 DECISION TABLE WITH ONE DECISION VARIABLE 5.2.1 Trend Chart; 5.2.2 Overlay Chart; 5.3 DECISION TABLE WITH TWO DECISION VARIABLES; 5.3.1 Model; 5.3.2 Threshold Values; 5.3.3 Two-Way Decision Table; 5.3.4 Interpreting the Results; 5.4 USING OPTQUEST; 5.4.1 Terminology; 5.4.2 Example; CHAPTER 6 Selecting Run Preferences; 6.1 TRIALS; 6.1.1 Number of Trials to Run; 6.1.2 Stop on Calculation Errors; 6.1.3 Stop When Precision Control Limits Are Reached; 6.2 SAMPLING; 6.2.1 Random Number Generation; 6.2.2 Sampling Method; 6.3 SPEED; 6.3.1 Run Mode; 6.3.2 Chart Windows; 6.4 OPTIONS; 6.5 STATISTICS
CHAPTER 7 Net Present Value and Internal Rate of Return 7.1 DETERMINISTIC NPV AND IRR; 7.2 SIMULATING NPV AND IRR; 7.3 CAPITAL BUDGETING; 7.3.1 Tornado Chart Tool; 7.3.2 Risk Analysis; 7.3.3 Caveats; 7.4 CUSTOMER NET PRESENT VALUE; 7.4.1 Results; CHAPTER 8 Modeling Financial Statements; 8.1 DETERMINISTIC MODEL; 8.2 TORNADO CHART AND SENSITIVITY ANALYSIS; 8.3 CRYSTAL BALL SENSITIVITY CHART; 8.4 CONCLUSION; CHAPTER 9 Portfolio Models; 9.1 SINGLE-PERIOD CRYSTAL BALL MODEL; 9.2 SINGLE-PERIOD ANALYTICAL SOLUTION; 9.3 MULTI-PERIOD CRYSTAL BALL MODEL; CHAPTER 10 Value at Risk; 10.1 VAR
10.2 SHORTCOMINGS OF VAR
Altri titoli varianti Financial modeling with Oracle Crystal Ball and Excel + website
Record Nr. UNINA-9910816079703321
Charnes John  
New York, : Wiley, 2012
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Autore Helbæk Morten
Edizione [1st edition]
Pubbl/distr/stampa London ; ; New York : , : Routledge, , 2013
Descrizione fisica 1 online resource (447 p.)
Disciplina 332.0285/554
Altri autori (Persone) LøvaasRagnar <1950->
MjølhusJon
Soggetto topico Finance - Mathematical models - Computer programs
Soggetto genere / forma Electronic books.
ISBN 1-134-62027-6
0-415-63058-4
1-134-62020-9
0-203-36288-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel -- Getting started -- Formulas and functions -- Charts and tables -- What-if analysis -- Data analysis -- Basic finance -- Time value of money -- Investments -- Risk and portfolio models -- Valuation -- Valuation of investments and projects -- Real estate -- Bonds -- Stocks -- Options -- Simulations -- Monte Carlo simulations -- VBA -- Visual basic for applications -- Programming in VBA -- Control structures -- Working with VBA -- Procedures -- Arrays -- Userforms.
Record Nr. UNINA-9910463454603321
Helbæk Morten  
London ; ; New York : , : Routledge, , 2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Autore Helbæk Morten
Edizione [1st edition]
Pubbl/distr/stampa London ; ; New York : , : Routledge, , 2013
Descrizione fisica 1 online resource (447 p.)
Disciplina 332.0285/554
Altri autori (Persone) LøvaasRagnar <1950->
MjølhusJon
Soggetto topico Finance - Mathematical models - Computer programs
ISBN 1-134-62027-6
0-415-63058-4
1-134-62020-9
0-203-36288-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel -- Getting started -- Formulas and functions -- Charts and tables -- What-if analysis -- Data analysis -- Basic finance -- Time value of money -- Investments -- Risk and portfolio models -- Valuation -- Valuation of investments and projects -- Real estate -- Bonds -- Stocks -- Options -- Simulations -- Monte Carlo simulations -- VBA -- Visual basic for applications -- Programming in VBA -- Control structures -- Working with VBA -- Procedures -- Arrays -- Userforms.
Record Nr. UNINA-9910786848203321
Helbæk Morten  
London ; ; New York : , : Routledge, , 2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Financial modelling and asset valuation with Excel / / Morten Helbæk, Ragnar Løvaas and Jon Mjølhus
Autore Helbæk Morten
Edizione [1st edition]
Pubbl/distr/stampa London ; ; New York : , : Routledge, , 2013
Descrizione fisica 1 online resource (447 p.)
Disciplina 332.0285/554
Altri autori (Persone) LøvaasRagnar <1950->
MjølhusJon
Soggetto topico Finance - Mathematical models - Computer programs
ISBN 1-134-62027-6
0-415-63058-4
1-134-62020-9
0-203-36288-8
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Excel -- Getting started -- Formulas and functions -- Charts and tables -- What-if analysis -- Data analysis -- Basic finance -- Time value of money -- Investments -- Risk and portfolio models -- Valuation -- Valuation of investments and projects -- Real estate -- Bonds -- Stocks -- Options -- Simulations -- Monte Carlo simulations -- VBA -- Visual basic for applications -- Programming in VBA -- Control structures -- Working with VBA -- Procedures -- Arrays -- Userforms.
Record Nr. UNINA-9910809854603321
Helbæk Morten  
London ; ; New York : , : Routledge, , 2013
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial Simulation Modeling in Excel [[electronic resource] ] : A Step-by-Step Guide
Financial Simulation Modeling in Excel [[electronic resource] ] : A Step-by-Step Guide
Autore Allman Keith
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, : Wiley, 2011
Descrizione fisica 1 online resource (211 p.)
Disciplina 332.0285/554
Altri autori (Persone) LauritoJosh
LohMichael
Collana Wiley Finance
Soggetto topico Finance --Mathematical models --Computer programs
Microsoft Excel (Computer file)
Finance - Mathematical models - Computer programs
ISBN 1-119-20092-X
1-118-13722-1
1-283-26821-3
9786613268211
1-118-13720-5
Classificazione BUS027000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Financial Simulation Modeling in Excel; Contents; Preface; Acknowledgments; About the Authors; CHAPTER 1 Introduction; CHAPTER 2 Random Numbers, Distributions, and Basic Simulation Setup; CHAPTER 3 Correlation; CHAPTER 4 Option Pricing; CHAPTER 5 Corporate Default Simulation; CHAPTER 6 Simulating Pools of Assets; CHAPTER 7 Dealing with Data Deficiencies and Other Issues; CHAPTER 8 Advanced Topics and Further Reading; APPENDIX A Partial Differential Equations; APPENDIX B Newton-Raphson Method; References; Index
Record Nr. UNINA-9910139590803321
Allman Keith  
Hoboken, : Wiley, 2011
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Financial Simulation Modeling in Excel : A Step-by-Step Guide
Financial Simulation Modeling in Excel : A Step-by-Step Guide
Autore Allman Keith
Edizione [1st edition]
Pubbl/distr/stampa Hoboken, : Wiley, 2011
Descrizione fisica 1 online resource (211 p.)
Disciplina 332.0285/554
Altri autori (Persone) LauritoJosh
LohMichael
Collana Wiley Finance
Soggetto topico Finance --Mathematical models --Computer programs
Microsoft Excel (Computer file)
Finance - Mathematical models - Computer programs
ISBN 1-119-20092-X
1-118-13722-1
1-283-26821-3
9786613268211
1-118-13720-5
Classificazione BUS027000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Financial Simulation Modeling in Excel; Contents; Preface; Acknowledgments; About the Authors; CHAPTER 1 Introduction; CHAPTER 2 Random Numbers, Distributions, and Basic Simulation Setup; CHAPTER 3 Correlation; CHAPTER 4 Option Pricing; CHAPTER 5 Corporate Default Simulation; CHAPTER 6 Simulating Pools of Assets; CHAPTER 7 Dealing with Data Deficiencies and Other Issues; CHAPTER 8 Advanced Topics and Further Reading; APPENDIX A Partial Differential Equations; APPENDIX B Newton-Raphson Method; References; Index
Record Nr. UNINA-9910820532003321
Allman Keith  
Hoboken, : Wiley, 2011
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Autore Fairhurst Danielle Stein
Edizione [Third edition.]
Pubbl/distr/stampa Chichester, West Sussex : , : Wiley, , 2019
Descrizione fisica 1 online resource (426 pages)
Disciplina 332.0285/554
Collana Wiley finance
Soggetto topico Corporations - Finance
Corporations - Finance - Computer programs
BUSINESS & ECONOMICS / Finance
Soggetto genere / forma Electronic books.
ISBN 1-119-52035-5
1-119-52034-7
1-119-52037-1
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index.
Record Nr. UNINA-9910467063403321
Fairhurst Danielle Stein  
Chichester, West Sussex : , : Wiley, , 2019
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Autore Fairhurst Danielle Stein
Edizione [Third edition.]
Pubbl/distr/stampa Chichester, West Sussex : , : Wiley, , 2019
Descrizione fisica 1 online resource (426 pages)
Disciplina 332.0285/554
Collana Wiley finance
THEi Wiley ebooks.
Soggetto topico Corporations - Finance
Corporations - Finance - Computer programs
BUSINESS & ECONOMICS / Finance
ISBN 1-119-52035-5
1-119-52034-7
1-119-52037-1
Classificazione BUS027000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index.
Record Nr. UNINA-9910532298403321
Fairhurst Danielle Stein  
Chichester, West Sussex : , : Wiley, , 2019
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Using Excel for business and financial modelling : a practical guide / / Danielle Stein Fairhurst
Autore Fairhurst Danielle Stein
Edizione [Third edition.]
Pubbl/distr/stampa Chichester, West Sussex : , : Wiley, , 2019
Descrizione fisica 1 online resource (426 pages)
Disciplina 332.0285/554
Collana Wiley finance
THEi Wiley ebooks.
Soggetto topico Corporations - Finance
Corporations - Finance - Computer programs
BUSINESS & ECONOMICS / Finance
ISBN 1-119-52035-5
1-119-52034-7
1-119-52037-1
Classificazione BUS027000
Formato Materiale a stampa
Livello bibliografico Monografia
Lingua di pubblicazione eng
Nota di contenuto Machine generated contents note: Chapter 1: What is Financial Modelling? What's the Difference Between a Spreadsheet and a Financial Model? Types and Purposes of Financial Models Tool Selection What Skills Do You Need to Be a Good Financial Modeller? The "Ideal" Financial Modeller Summary Chapter 2: Building a Model Model Design The Golden Rules for Product Design Design Issues The Workbook Anatomy of a Model Project Planning Your Model Model Layout Flowcharting Steps to Building a Model Information Requests Version-Control Documentation Summary Chapter 3: Best-Practice Principles of Modelling Document Your Assumptions Linking, Not Hardcoding Enter Data Only Once Avoid Bad Habits Use Consistent Formulas Format and Label Clearly Methods and Tools of Assumptions Documentation Linked Dynamic Text Assumptions Documentation What Makes a Good Model? Summary Chapter 4: Financial Modelling Techniques The Problem with Excel Error Avoidance Strategies How Long Should a Formula Be? Linking to External Files Building Error Checks Circular References Summary Chapter 5: Using Excel in Financial Modelling Formulas and Functions in Excel Excel Versions Handy Excel Shortcuts Cell Referencing Best Practices Named Ranges Basic Excel Functions Logical Functions Nesting Logical Functions Summary Chapter 6: Functions for Financial Modelling Aggregation Functions LOOKUP Functions Nesting Index and Matching OFFSET Function Regression Analysis Choose Function Working with Dates Financial Project Evaluation Functions Loan Calculations Summary Chapter 7: Tools for Model Display Basic Formatting Custom Formatting Conditional Formatting Sparklines Bulletproofing Your Model Customising the Display Settings Form Controls Summary Chapter 8: Tools for Financial Modelling Hiding Sections of a Model Array Formulas Goal Seeking Structured Reference Tables PivotTables Macros Summary Chapter 9: Common Uses of Tools in Financial Modelling Escalation Methods for Modelling Understanding Nominal and Effective (Real) Rates Calculating a Cumulative Sum (Running Totals) How to Calculate a Payback Period Weighted Average Cost of Capital (WACC) Building a Tiering Table Modelling Depreciation Methods Break-Even Analysis Summary Chapter 10: Model Review Rebuilding an Inherited Model Improving Model Performance Auditing a Financial Model Summary Appendix: QA Log Chapter 11: Stress Testing, Scenarios, and Sensitivity Analysis in Financial Modelling What are the Differences Between Scenario, Sensitivity, and What-If Analyses? Overview of Scenario Analysis Tools and Methods Advanced Conditional Formatting Comparing Scenario Methods Adding Probability to a Data Table Summary Chapter 12: Presenting Model Output Preparing an Oral Presentation for Model Results Preparing a Graphic or Written Presentation for Model Results Chart Types Working with Charts Handy Charting Hints Dynamic Named Ranges Charting with Two Different Axes and Chart Types Bubble Charts Creating a Dynamic Chart Waterfall Charts Summary Index.
Record Nr. UNINA-9910813852303321
Fairhurst Danielle Stein  
Chichester, West Sussex : , : Wiley, , 2019
Materiale a stampa
Lo trovi qui: Univ. Federico II
Opac: Controlla la disponibilità qui