| Title : | Financial Modeling in Practice : a Concise Guide Using Excel and VBA for Intermediate and Advanced Level | | Material Type: | printed text | | Authors: | Michael Rees, Author | | Publisher: | John Wiley & Sons, Inc | | Publication Date: | 2018 | | Pagination: | xxix, 512 p. | | Size: | 25 cm | | ISBN (or other code): | 978-1-11-890401-5 | | General note: | Includes index (p. 483-512) | | Languages : | English (eng) Original Language : English (eng) | | Descriptors: | Corporations - Finance
Finance - Mathematical models
Microsoft Excel (Computer file)
Microsoft Office
Visual Basic for Applications (Computer program language)
| | Class number: | 332.028 | | Abstract: | The comprehensive, broadly-applicable, real-world guide to financial modelling Financial Modelling in Practice, Second Edition covers the full spectrum of financial modelling tools and techniques to provide practical skills grounded in real-world scenarios. | | Contents note: | Introduction to modelling, core themes and best practices; Models of models; Using models in decision support; Core competencies and best practices : meta-themes; Model design and planning; Defining sensitivity and flexibility requirements; Database versus formulae-driven approaches; Designing the workbook structure; Model building, testing and auditing; Creating transparency : formula structure, flow and format; Building robust and transparent formulae; Choosing Excel functions for transparency, flexibility and efficiency; Dealing with circularity; Model review, auditing and validation; Sensitivity and scenario analysis, simulation and optimisation; Sensitivity and scenario analysis : core techniques; Using Goalseek and Solver; Using VBA macros to conduct sensitivity and scenario analyses; Introduction to simulation and optimisation; The modelling of risk and uncertainty, and using simulation; Excel functions and functionality; Core arithmetic and logical functions; Array functions and formulae; Mathematical functions; Financial functions; Statistical functions; Information functions; Date and time functions; Text functions and functionality; Lookup and reference functions; Filters, database functions and pivottables; Selected short-cuts and other features; Foundations of VBA and macros; Getting started; Working with objects and ranges; Controlling execution; Writing robust code; Manipulation and analysis of data sets with VBA; User-defined functions; | | Record link: | https://library.seeu.edu.mk/index.php?lvl=notice_display&id=21936 |
|  |
EBSCOhost
World Bank
EconBiz
De Gruyter
OpenEdition
European Respiratory Journal
Mathematical Sciences Publishers Journals
332 
Make a suggestion Refine your searchFinancial Modeling in Practice / Michael Rees
