Cargando…
Using Excel for business analysis : a guide to financial modelling fundamentals /
"A 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 Fund...
| Clasificación: | Libro Electrónico |
|---|---|
| Autor principal: | |
| Formato: | Electrónico eBook |
| Idioma: | Inglés |
| Publicado: |
Singapore ; Hoboken, NJ :
John Wiley & Sons,
2012.
|
| Temas: | |
| Acceso en línea: | Texto completo (Requiere registro previo con correo institucional) |
MARC
| LEADER | 00000cam a2200000 a 4500 | ||
|---|---|---|---|
| 001 | OR_ocn817247464 | ||
| 003 | OCoLC | ||
| 005 | 20231017213018.0 | ||
| 006 | m o d | ||
| 007 | cr cnu|||||||| | ||
| 008 | 121101s2012 si a ob 001 0 eng | ||
| 040 | |a AU@ |b eng |e pn |c AU@ |d OCLCO |d UMI |d OCLCQ |d B24X7 |d YDXCP |d COO |d TEFOD |d OCLCF |d HEBIS |d FMG |d CNSPO |d N$T |d RECBK |d TEFOD |d OCLCQ |d TEFOD |d OCLCQ |d LIV |d ESU |d YDX |d EBLCP |d INT |d MERUC |d OCLCO |d OCLCQ |d YOU |d OCLCQ |d VT2 |d OCLCO |d OCLCA |d UKAHL |d OCLCQ | ||
| 016 | 7 | |a 016026417 |2 Uk | |
| 019 | |a 817716692 |a 856993201 |a 865010737 |a 880746993 |a 905349668 |a 1007244487 |a 1058988092 |a 1083236573 |a 1097090919 |a 1103280394 |a 1129363163 |a 1153044092 |a 1192334662 |a 1240523120 | ||
| 020 | |a 1118132858 |q (electronic bk.) | ||
| 020 | |a 9781118132852 |q (electronic bk.) | ||
| 020 | |a 9781118132876 |q (electronic bk.) | ||
| 020 | |a 1118132874 |q (electronic bk.) | ||
| 020 | |a 9781119062455 |q (electronic bk.) | ||
| 020 | |a 1119062454 |q (electronic bk.) | ||
| 020 | |a 9781119062448 |q (electronic bk.) | ||
| 020 | |a 1119062446 |q (electronic bk.) | ||
| 020 | |a 9781119199236 | ||
| 020 | |a 1119199239 | ||
| 020 | |z 9781118132845 |q (pbk.) | ||
| 020 | |z 111813284X |q (pbk.) | ||
| 020 | |z 9781118132869 | ||
| 020 | |z 1118132866 | ||
| 029 | 0 | |a AU@ |b 000050159086 | |
| 029 | 1 | |a AU@ |b 000050886082 | |
| 029 | 1 | |a AU@ |b 000052892223 | |
| 029 | 1 | |a AU@ |b 000067103532 | |
| 029 | 1 | |a AU@ |b 000073064455 | |
| 029 | 1 | |a DEBBG |b BV042739609 | |
| 035 | |a (OCoLC)817247464 |z (OCoLC)817716692 |z (OCoLC)856993201 |z (OCoLC)865010737 |z (OCoLC)880746993 |z (OCoLC)905349668 |z (OCoLC)1007244487 |z (OCoLC)1058988092 |z (OCoLC)1083236573 |z (OCoLC)1097090919 |z (OCoLC)1103280394 |z (OCoLC)1129363163 |z (OCoLC)1153044092 |z (OCoLC)1192334662 |z (OCoLC)1240523120 | ||
| 037 | |a CL0500000175 |b Safari Books Online | ||
| 037 | |a 830D1D83-4606-476B-9E58-CAEA23A842B0 |b OverDrive, Inc. |n http://www.overdrive.com | ||
| 050 | 4 | |a HF5548.4.M523 |b F35 2012 | |
| 072 | 7 | |a BUS |x 082000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 041000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 042000 |2 bisacsh | |
| 072 | 7 | |a BUS |x 085000 |2 bisacsh | |
| 082 | 0 | 4 | |a 005.54 |2 22 |
| 049 | |a UAMI | ||
| 100 | 1 | |a Fairhurst, Danielle Stein. | |
| 245 | 1 | 0 | |a Using Excel for business analysis : |b a guide to financial modelling fundamentals / |c Danielle Stein Fairhurst. |
| 246 | 3 | 0 | |a Guide to financial modelling fundamentals |
| 260 | |a Singapore ; |a Hoboken, NJ : |b John Wiley & Sons, |c 2012. | ||
| 300 | |a 1 online resource. | ||
| 336 | |a text |b txt |2 rdacontent | ||
| 337 | |a computer |b c |2 rdamedia | ||
| 338 | |a online resource |b cr |2 rdacarrier | ||
| 504 | |a Includes bibliographical references and index. | ||
| 588 | 0 | |a Print version record. | |
| 520 | |a "A 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, formulas, and functions to master, and the techniques and strategies necessary to eliminate errors."--Publisher's website | ||
| 505 | 0 | |a Intro; Contents; Title; Copyright; Dedication; 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; What Skills Do you Need to Be a Good Financial Modeller?; The Ideal Financial Modeller; Summary; Chapter 2: Building a Model; Model Design; The Golden Rules for Model Design; Design Issues; The Workbook Anatomy of a Model; Project Planning Your Model; Model Layout Flow Charting; Steps to Building a Model; Information Requests; Version-Control Documentation; Summary. | |
| 505 | 8 | |a Chapter 3: Best Practice Principles of ModellingDocument Your Assumptions; Linking, Not Hard Coding; Only Enter Data Once; Avoid Bad Habits; Use Consistent Formulas; Format and Label Clearly; Methods and Tools of Assumptions Documentation; Linked Dynamic Text Assumptions Documentation; What Makes a Good Model?; Summary; Chapter 4: Financial Modelling Techniques; The Problem with Excel; Error Avoidance Strategies; How Long Should a Formula Be?; Linking to External Files; Building Error Checks; Avoid Error Displays in Formulas; Circular References; Summary. | |
| 505 | 8 | |a Chapter 5: Using Excel in Financial ModellingFormulas and Functions in Excel; Excel Versions; Handy Excel Shortcuts; Basic Excel Functions; Logical Functions; Nesting: Combining Simple Functions to Create Complex Formulas; Cell Referencing Best Practices; Named Ranges; Summary; Chapter 6: Functions for Financial Modelling; Aggregation Functions; LOOKUP Formulas; Other Useful Functions; Working with Dates; Financial Project Evaluation Functions; Loan Calculations; Summary; Chapter 7: Tools for Model Display; Basic Formatting; Custom Formatting; Conditional Formatting; Sparklines. | |
| 505 | 8 | |a Bulletproofing Your ModelCustomising the Display Settings; Form Controls; Summary; Chapter 8: Tools for Financial Modelling; Hiding Sections of a Model; Grouping; Array Formulas; Goal Seeking; Pivot Tables; Macros; User-Defined Functions (UDFs); Summary; Chapter 9: Common Uses of Tools in Financial Modelling; Escalation Methods for Modelling; Understanding Nominal and Effective (Real) Rates; Calculating Cumulative Totals; How to Calculate a Payback Period; Weighted Average Cost of Capital (WACC); Building a Tiering Table; Modelling Depreciation Methods; Break-Even Analysis; Summary. | |
| 505 | 8 | |a Chapter 10: Model ReviewRebuilding an Inherited Model; Auditing a Financial Model; Appendix 10.1: QA Log; Summary; Chapter 11: Stress-Testing, Scenarios, and Sensitivity Analysis in Financial Modelling; What's the Difference between Scenario, Sensitivity, and What-If Analysis?; Overview of Scenario Analysis Tools and Methods; Advanced Conditional Formatting; Comparing Scenario Methods; Summary; Chapter 12: Presenting Model Output; Preparing an Oral Presentation for Model Results; Preparing a Graphic or Written Presentation for Model Results; Chart Types; Working with Charts. | |
| 590 | |a O'Reilly |b O'Reilly Online Learning: Academic/Public Library Edition | ||
| 630 | 0 | 0 | |a Microsoft Excel (Computer file) |
| 630 | 0 | 7 | |a Microsoft Excel (Computer file) |2 fast |0 (OCoLC)fst01366659 |
| 650 | 0 | |a Corporations |x Finance |x Data processing. | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Industrial Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Management Science. |2 bisacsh | |
| 650 | 7 | |a BUSINESS & ECONOMICS |x Organizational Behavior. |2 bisacsh | |
| 650 | 7 | |a Corporations |x Finance |x Data processing. |2 fast |0 (OCoLC)fst00879847 | |
| 650 | 7 | |a Unternehmen |2 gnd | |
| 650 | 7 | |a Finanzierung |2 gnd | |
| 650 | 7 | |a Programm |2 gnd | |
| 776 | 0 | 8 | |i Print version: |a Fairhurst, Danielle Stein. |t Using Excel for business analysis. |d Singapore ; Hoboken, NJ : John Wiley & Sons, 2012 |z 9781118132845 |z 111813284X |
| 856 | 4 | 0 | |u https://learning.oreilly.com/library/view/~/9781118132876/?ar |z Texto completo (Requiere registro previo con correo institucional) |
| 936 | |a BATCHLOAD | ||
| 938 | |a Askews and Holts Library Services |b ASKH |n AH21625083 | ||
| 938 | |a Books 24x7 |b B247 |n bkb00046280 | ||
| 938 | |a ProQuest Ebook Central |b EBLB |n EBL5345601 | ||
| 938 | |a EBSCOhost |b EBSC |n 968961 | ||
| 938 | |a Recorded Books, LLC |b RECE |n rbeEB00066378 | ||
| 938 | |a YBP Library Services |b YANK |n 12348426 | ||
| 938 | |a YBP Library Services |b YANK |n 7593017 | ||
| 938 | |a YBP Library Services |b YANK |n 12639384 | ||
| 938 | |a YBP Library Services |b YANK |n 13107426 | ||
| 938 | |a YBP Library Services |b YANK |n 12348174 | ||
| 994 | |a 92 |b IZTAP | ||