LEADER 06943nam 22007095 450 001 9910438067403321 005 20200919111533.0 010 $a9781430262060 010 $a1430262060 024 7 $a10.1007/978-1-4302-6206-0 035 $a(CKB)3710000000074017 035 $a(EBL)1636369 035 $a(OCoLC)871223921 035 $a(SSID)ssj0001090893 035 $a(PQKBManifestationID)11587241 035 $a(PQKBTitleCode)TC0001090893 035 $a(PQKBWorkID)11026378 035 $a(PQKB)10169254 035 $a(DE-He213)978-1-4302-6206-0 035 $a(MiAaPQ)EBC1636369 035 $a(CaSebORM)9781430262053 035 $a(PPN)176096043 035 $a(OCoLC)870551006 035 $a(OCoLC)ocn870551006 035 $a(EXLCZ)993710000000074017 100 $a20131202d2013 u| 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 14$aThe Handbook of Financial Modeling $eA Practical Approach to Creating and Implementing Valuation Projection Models /$fby Jack Avon 205 $a1st ed. 2013. 210 1$aBerkeley, CA :$cApress :$cImprint: Apress,$d2013. 215 $a1 online resource (484 p.) 300 $aDescription based upon print version of record. 311 08$a9781430262053 311 08$a1430262052 320 $aIncludes bibliographical references and index. 327 $a""Contents""; ""About the Author""; ""Acknowledgments""; ""Introduction""; ""Chapter 1: Financial Modeling: An Overview""; ""Financial Modeling: A Definition""; ""Microsoft Excel as the Modelera???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"" 327 $a""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"" 327 $a""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(a???)""; ""SUMIF(a???), COUNTIF(a???), AVERAGEIF(a???)""; ""SUMIFS(a???)""; ""Lookup Functions""; ""VLOOKUP(a???)""; ""MATCH(a???)""; ""INDEX(a???)""; ""OFFSET(a???)""; ""CHOOSE(a???)""; ""Date and Time Functions""; ""NETWORKDAYS.INTL(a???)""; ""DATEDIF(a???)""; ""WORKDAY(a???)"" 327 $a""EOMONTH(a???)""""DAYS360(a???)""; ""DATE(a???)""; ""Math Functions""; ""MOD(a???)""; ""PRODUCT(a???)""; ""SUM(a???)""; ""Logical Functions""; ""AND(a???)""; ""OR(a???)""; ""ISERROR(a???)""; ""Functions That Use Arrays""; ""SUMPRODUCT(a???)""; ""Working with Custom Functions or UDFs""; ""What Are UDFs?""; ""When Would You Design and Use UDFs?""; ""LINKADDRESS(a???)""; ""EFFINDEX(a???)""; ""SUMCOLOR(a???)""; ""SUMTB(a???)""; ""ISDATE(a???)""; ""WORKSHEETSTATS(a???)""; ""Typical Modeling Issues and How to Address Them with Functions""; ""Dealing with Text When You Need Values"" 327 $a""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"" 327 $a""The Benefits of Model Specification"" 330 $aThe 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 statements and accounting reports, few are truly proficient at building an accurate and effective financial model from the ground up. That's why, in The Financial Modeling Handbook, Jack Avon equips financial professionals with all the tools they need to precisely and effectively monitor a company's assets and project its future performance. Based on the author's extensive experience building models in business and finance?and teaching others to do the same?The Handbook of Financial Modeling takes readers step by step through the financial modeling process, starting with a general overview of the history and evolution of financial modeling. It then moves on to more technical topics, such as the principles of financial modeling and the proper way to approach a financial modeling assignment, before covering key application areas for modeling in Microsoft Excel.  Designed for intermediate and advanced modelers who wish to expand and enhance their knowledge, The Handbook of Financial Modeling also covers: The accounting and finance concepts that underpin working financial models; How to approach financial issues and solutions from a modeler's perspective; The importance of thinking about end users when developing a financial model; How to plan, design, and build a fully functional financial model; And more. A nuts-to-bolts guide to solving common financial problems with spreadsheets, The Handbook of Financial Modeling is a one-stop resource for anyone who needs to build or analyze financial models. 606 $aBusiness 606 $aManagement science 606 $aBusiness and Management, general$3https://scigraph.springernature.com/ontologies/product-market-codes/500000 615 0$aBusiness. 615 0$aManagement science. 615 14$aBusiness and Management, general. 676 $a330 676 $a650 676 $a658.05 700 $aAvon$b Jack$4aut$4http://id.loc.gov/vocabulary/relators/aut$01063059 801 0$bUMI 801 1$bUMI 906 $aBOOK 912 $a9910438067403321 996 $aThe Handbook of Financial Modeling$92529887 997 $aUNINA