The Basics of Financial Modeling [[electronic resource] /] / by Jack Avon |
Autore | Avon Jack |
Edizione | [1st ed. 2015.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 |
Descrizione fisica | 1 online resource (237 p.) |
Disciplina | 650 |
Soggetto topico |
Business
Management science Business and Management, general |
ISBN | 1-4842-0871-4 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Record Nr. | UNINA-9910298518703321 |
Avon Jack
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2015 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The handbook of financial modeling : a practical approach to creating and implementing valuation projection models / / Jack Avon |
Autore | Avon Jack |
Edizione | [Second edition.] |
Pubbl/distr/stampa | New York, New York State : , : APress, , [2021] |
Descrizione fisica | 1 online resource (XII, 351 p. 225 illus.) |
Disciplina | 330.015118 |
Soggetto topico |
Finance - Mathematical models
Visual Basic (Computer program language) |
ISBN |
1-5231-5073-4
1-4842-6540-8 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto | 1. The Role of Financial Modelers today -- 2. Types of Financial Models -- 3. Review of Best Practices for Modeling -- 4. The Modeling Lifecycle explained -- 5. Planning and designing models -- 6. It's All About the Model Outputs -- 7. Model Build -- 8. Financial Modeling and Accountancy -- 9. The Implications and Rules of Accounting for Modelers -- 10. Modeling Scenarios Explained -- 11. Calculations for Financial Modelers -- 12. The Importance of Documentation -- 13. Model Stress Testing -- 14. Model Audit and Review -- 15. The Role of VBA in Financial Models -- 16. Operis -- 17. Financial Modelling, Where Next? -- Appendix A: Modelling Glossary and Terminology -- Appendix B: Ready-Made Functions -- Appendix C: References. . |
Record Nr. | UNINA-9910483490503321 |
Avon Jack
![]() |
||
New York, New York State : , : APress, , [2021] | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|
The Handbook of Financial Modeling : A Practical Approach to Creating and Implementing Valuation Projection Models / / by Jack Avon |
Autore | Avon Jack |
Edizione | [1st ed. 2013.] |
Pubbl/distr/stampa | Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 |
Descrizione fisica | 1 online resource (484 p.) |
Disciplina |
330
650 658.05 |
Soggetto topico |
Business
Management science Business and Management, general |
ISBN | 1-4302-6206-0 |
Formato | Materiale a stampa ![]() |
Livello bibliografico | Monografia |
Lingua di pubblicazione | eng |
Nota di contenuto |
""Contents""; ""About the Author""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Financial Modeling: An Overview""; ""Financial Modeling: A Definition""; ""Microsoft Excel as the Modeler�s Tool""; ""Where Are Financial Models Used?""; ""The Role of the Financial Modeler""; ""Chapter 2: Financial Modeling Best Practices""; ""What Are the Best Practices of Financial Modeling?""; ""Keep the Constituents Separate""; ""Reduce Implicit Assumptions to a Minimum""; ""Avoid Using Constants Inside Formulas""; ""Let Inputs Drive Your Models, Not Calculations""
""Have Only One Input for Each Assumption""""Specify Measurement Units for All Input Assumptions""; ""The Logical Flow of Calculations and Circularity""; ""Use Consistent Formulas Across Rows""; ""Avoid Mixing Time Periods of Different Lengths""; ""Break Up Long Formulas into Simple Pieces""; ""Include Automatic Error Checks""; ""Errors Explained""; ""The Reasons for Errors""; ""Unskilled Users""; ""Lack of Planning""; ""Data and Recycling""; ""Intrusions""; ""Who Will Review or Check for Errors?""; ""Real-Life Errors""; ""A Tip on Errors""; ""Catching and Trapping Errors"" ""How to Work with Errors in Models""""Adding Error Checks""; ""Best Practices in a Nutshell""; ""Case Study: Financial Model Gone Awry""; ""The Non-best Practice Model""; ""The Best Practice Model""; ""Chapter 3: Modeling Functions and Tools""; ""Excel Formulas and Functions for Modelers""; ""Most Used Functions""; ""IF(�)""; ""SUMIF(�), COUNTIF(�), AVERAGEIF(�)""; ""SUMIFS(�)""; ""Lookup Functions""; ""VLOOKUP(�)""; ""MATCH(�)""; ""INDEX(�)""; ""OFFSET(�)""; ""CHOOSE(�)""; ""Date and Time Functions""; ""NETWORKDAYS.INTL(�)""; ""DATEDIF(�)""; ""WORKDAY(�)"" ""EOMONTH(�)""""DAYS360(�)""; ""DATE(�)""; ""Math Functions""; ""MOD(�)""; ""PRODUCT(�)""; ""SUM(�)""; ""Logical Functions""; ""AND(�)""; ""OR(�)""; ""ISERROR(�)""; ""Functions That Use Arrays""; ""SUMPRODUCT(�)""; ""Working with Custom Functions or UDFs""; ""What Are UDFs?""; ""When Would You Design and Use UDFs?""; ""LINKADDRESS(�)""; ""EFFINDEX(�)""; ""SUMCOLOR(�)""; ""SUMTB(�)""; ""ISDATE(�)""; ""WORKSHEETSTATS(�)""; ""Typical Modeling Issues and How to Address Them with Functions""; ""Dealing with Text When You Need Values"" ""Case Study: Using Modeling Functions and Tools""""Chapter 4: Planning Your Model""; ""Introduction to the Financial Modeling Life Cycle""; ""Here is a list of the ten key development stages:""; ""Planning to Build a Model""; ""Is There a Clear Understanding of Cash?""; ""How Much Detail Is Required?""; ""Create Scenario Analysis and Sensitivity Analysis""; ""Assumptions: How Realistic Are They?""; ""Missing Key Elements in Financial Statements""; ""Developing a Feasibility Assessment""; ""Scoping the Modeling Project""; ""The Specification & Strategy"" ""The Benefits of Model Specification"" |
Record Nr. | UNINA-9910438067403321 |
Avon Jack
![]() |
||
Berkeley, CA : , : Apress : , : Imprint : Apress, , 2013 | ||
![]() | ||
Lo trovi qui: Univ. Federico II | ||
|