The Handbook of Financial Modeling A Practical Approach to Creating and Implementing Valuation Projection Models
The ability to create and understand financial models that assess the valuation of a company, the projects it undertakes, and its future earnings/profit projections is one of the most valued skills in corporate finance. However, while many business professionals are familiar with financial statement...
| Autor principal: | |
|---|---|
| Formato: | Libro electrónico |
| Idioma: | Inglés |
| Publicado: |
Berkeley, CA :
Apress
2013.
|
| Edición: | 1st ed. 2013. |
| Materias: | |
| Ver en Biblioteca Universitat Ramon Llull: | https://discovery.url.edu/permalink/34CSUC_URL/1im36ta/alma991009466377306719 |
Tabla de Contenidos:
- ""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""
