Extent:
Online-Ressource (X, 504 p. 299 illus, online resource)
Series:
Type of publication: Book / Working Paper
Language: English
Notes:
Description based upon print version of record
Contents; 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 CircularityUse 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
Excel Formulas and Functions for ModelersMost 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 FunctionsDealing 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 & StrategyThe Benefits of Model Specification; Defining Model Outputs; Defining Calculations: Techniques for the Model Specifications; Defining the Inputs; Chapter 5: Testing and Documenting Your Model; Testing the Financial Model; Why Test?; Who Should Test?; When to Test?; Types of Tests; Numeric Tests; Robustness Tests; Environment Tests; Boundary Tests; Macro Tests; Specification Tests; Unique Formulas Tests; Common Types of Errors to Test; Formulas Not Copied; Wrong Reference; Sum Over the Wrong Range; Relative and Absolute References; Unit Errors
Commonly Misused Functions
ISBN: 978-1-4302-6206-0 ; 978-1-4302-6205-3
Other identifiers:
10.1007/978-1-4302-6206-0 [DOI]
Source:
ECONIS - Online Catalogue of the ZBW
Persistent link: https://www.econbiz.de/10014017274