LEADER 05414nam 2200673 450 001 9910830163603321 005 20230519132750.0 010 $a1-119-19923-9 010 $a1-280-99530-0 010 $a9786613766915 010 $a1-118-13285-8 035 $a(CKB)2670000000229342 035 $a(EBL)827093 035 $a(OCoLC)799767320 035 $a(SSID)ssj0000697084 035 $a(PQKBManifestationID)12316136 035 $a(PQKBTitleCode)TC0000697084 035 $a(PQKBWorkID)10682996 035 $a(PQKB)10320683 035 $a(MiAaPQ)EBC827093 035 $a(MiAaPQ)EBC5345601 035 $a(CaSebORM)9781118132876 035 $a(EXLCZ)992670000000229342 100 $a20180913d2012 uy 0 101 0 $aeng 135 $aur|n|---||||| 181 $ctxt 182 $cc 183 $acr 200 10$aUsing Excel for business analysis $ea guide to financial modelling fundamentals /$fDanielle Stein Fairhurst 205 $a1st edition 210 1$aSingapore :$cJohn Wiley & Sons Singapore Pte. Ltd.,$d2012. 215 $a1 online resource (338 p.) 225 1 $aWiley Finance 300 $aIncludes index. 311 $a1-118-13287-4 311 $a1-118-13284-X 320 $aIncludes bibliographical references and index. 327 $aUsing Excel for Business Analysis: A Guide to Financial Modelling Fundamentals; Contents; Preface; 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; Is Excel Really the Best Option?; Evaluating Modelling Tools; Budgeting and Forecasting; Microsoft Office Tools: Excel, Access, and Project; The Final Decision; What Skills Do You Need to Be a Good Financial Modeller?; Spreadsheet and Technical Excel Skills; Industry Knowledge; Accounting Knowledge; Business Knowledge 327 $aAesthetic Design SkillsCommunication and Language Skills; Numeracy Skills; Ability to Think Logically; The Ideal Financial Modeller; What's the Typical Background for a Financial Modeller?; Training Courses; Do You Really Need an Advanced Excel Course?; Summary; Chapter 2: Building a Model; Model Design; Practical Example 1-Assumptions Layout; Practical Example 2-Summary Categorisation; The Golden Rules for Model Design; Separate Inputs, Calculations, and Results, Where Possible; Use Each Column for the Same Purpose; Use One Formula per Row or Column; Refer to the Left and Above 327 $aUse Multiple WorksheetsInclude Documentation Sheets; Design Issues; The Workbook Anatomy of a Model; Workbook Anatomy Issues; Project Planning Your Model; How Long Does It Take to Build a Financial Model?; Building a Model under Pressure; Model Layout Flow Charting; Steps to Building a Model; The Streamlined Version; The Team Version; Information Requests; Version-Control Documentation; File Structure; Summary; Chapter 3: Best Practice Principles of Modelling; Document Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas 327 $aFormat and Label ClearlyMethods and Tools of Assumptions Documentation; In-Cell Comments; Footnoting; Hyperlinks; Hard-Coded Text; Linked Dynamic Text Assumptions Documentation; Practical Exercise 1; Practical Exercise 2; Practical Exercise 3; What Makes a Good Model?; Standards in Financial Modelling; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; Avoiding Simple Formula Errors; Avoiding Logic Errors; How Long Should a Formula Be?; Linking to External Files; Why You Should Use Named Ranges in External Links 327 $aDealing with Links and the Potential Errors They Can CauseLinking Do's and Don'ts; Building Error Checks; Error Check Exercise; Allowing Tolerance for Error; Error-Check Alerts; Avoid Error Displays in Formulas; Circular References; How to Fix Circular References; Circular References in Interest Calculations; Enabling Iterative Calculations; Summary; Chapter 5: Using Excel in Financial Modelling; Formulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Windows Shortcuts; Mac Shortcuts; Basic Excel Functions; SUM(); MAX(); MIN(); COUNT(); AVERAGE(); Combining Basic Functions 327 $aLogical Functions 330 $aA clear, concise, and easy-to-use guide to financial modelling suitable for practitioners at every level Using a fundamental approach to financial modelling that's accessible to both new and experienced professionals, Using Excel for Business Analysis: A Guide to Financial Modelling Fundamentals + Website offers practical guidance for anyone looking to build financial models for business proposals, to evaluate opportunities, or to craft financial reports. Comprehensive in nature, the book covers the principles and best practices of financial modelling, including the Excel tools 410 0$aWiley finance series. 606 $aCorporations$xFinance 606 $aCorporations$xFinance$xComputer programs 615 0$aCorporations$xFinance. 615 0$aCorporations$xFinance$xComputer programs. 676 $a658.150285554 700 $aFairhurst$b Danielle Stein$01608128 801 0$bMiAaPQ 801 1$bMiAaPQ 801 2$bMiAaPQ 906 $aBOOK 912 $a9910830163603321 996 $aUsing Excel for business analysis$93939444 997 $aUNINA