Principles of financial modelling : model design and best practices using Excel and VBA
(eBook)
Author
Published
Hoboken : Wiley, [2018].
Format
eBook
ISBN
1118903935, 1118903943, 1118904001, 111890401X, 9781118903933, 9781118903940, 9781118904008, 9781118904015
Physical Desc
1 online resource
Status
Description
Loading Description...
Also in this Series
Checking series information...
More Details
Language
English
Notes
General Note
Includes index.
Description
The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling - Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: -Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking -Sensitivity and scenario analysis, simulation, and optimisation -Data manipulation and analysis -The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds.
Reviews from GoodReads
Loading GoodReads Reviews.
Citations
APA Citation, 7th Edition (style guide)
Rees, M. (2018). Principles of financial modelling: model design and best practices using Excel and VBA . Wiley.
Chicago / Turabian - Author Date Citation, 17th Edition (style guide)Rees, Michael, 1964-. 2018. Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA. Wiley.
Chicago / Turabian - Humanities (Notes and Bibliography) Citation, 17th Edition (style guide)Rees, Michael, 1964-. Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA Wiley, 2018.
MLA Citation, 9th Edition (style guide)Rees, Michael. Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA Wiley, 2018.
Note! Citations contain only title, author, edition, publisher, and year published. Citations should be used as a guideline and should be double checked for accuracy. Citation formats are based on standards as of August 2021.
Staff View
Grouped Work ID
c6d62a0d-3cbb-b20f-d157-152a82ba7be7-eng
Grouping Information
Grouped Work ID | c6d62a0d-3cbb-b20f-d157-152a82ba7be7-eng |
---|---|
Full title | principles of financial modelling model design and best practices using excel and vba |
Author | rees michael |
Grouping Category | book |
Last Update | 2024-09-06 16:31:08PM |
Last Indexed | 2024-09-28 04:15:55AM |
Book Cover Information
Image Source | syndetics |
---|---|
First Loaded | Aug 13, 2024 |
Last Used | Sep 22, 2024 |
Marc Record
First Detected | Jul 29, 2024 04:03:33 PM |
---|---|
Last File Modification Time | Sep 06, 2024 04:38:35 PM |
MARC Record
LEADER | 06302cam a2200577 i 4500 | ||
---|---|---|---|
001 | on1028605404 | ||
003 | OCoLC | ||
005 | 20240830103855.0 | ||
006 | m o d | ||
007 | cr ||||||||||| | ||
008 | 180312s2018 nju o 001 0 eng | ||
010 | |a 2018011916 | ||
019 | |a 1100444218|a 1124302132|a 1135503611|a 1165433806|a 1192328928|a 1240526616 | ||
020 | |a 1118903935 | ||
020 | |a 1118903943 | ||
020 | |a 1118904001 | ||
020 | |a 111890401X | ||
020 | |a 9781118903933 | ||
020 | |a 9781118903940|q (pdf) | ||
020 | |a 9781118904008|q (epub) | ||
020 | |a 9781118904015 | ||
035 | |a (OCoLC)1028605404|z (OCoLC)1100444218|z (OCoLC)1124302132|z (OCoLC)1135503611|z (OCoLC)1165433806|z (OCoLC)1192328928|z (OCoLC)1240526616 | ||
037 | |a CL0501000087|b Safari Books Online | ||
040 | |a DLC|b eng|e rda|e pn|c DLC|d N$T|d DG1|d OCLCF|d MERER|d UPM|d UAB|d YDX|d WYU|d RECBK|d DLC|d U3W|d OCLCQ|d OCLCO|d OCLCQ|d AU@|d OCLCQ|d OCLCO|d UKAHL|d UMI|d BWN|d VT2|d DG1|d OCLCO|d K6U|d OCLCQ|d OCLCO|d OCLCL|d SXB | ||
042 | |a pcc | ||
049 | |a FMGA | ||
050 | 0 | 0 | |a HG106 |
082 | 0 | 0 | |a 332.0285/554|2 23 |
100 | 1 | |a Rees, Michael,|d 1964-|e author.|0 http://id.loc.gov/authorities/names/n2008062784 | |
245 | 1 | 0 | |a Principles of financial modelling :|b model design and best practices using Excel and VBA /|c by Michael Rees. |
264 | 1 | |a Hoboken :|b Wiley,|c [2018] | |
300 | |a 1 online resource | ||
336 | |a text|b txt|2 rdacontent | ||
337 | |a computer|b n|2 rdamedia | ||
338 | |a online resource|b nc|2 rdacarrier | ||
490 | 1 | |a Wiley finance series | |
500 | |a Includes index. | ||
505 | 0 | |a 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. | |
520 | |a The comprehensive, broadly-applicable, real-world guide to financial modelling Principles of Financial Modelling - Model Design and Best Practices Using Excel and VBAcovers the full spectrum of financial modelling tools and techniques in order to provide practical skills that are grounded in real-world applications. Based on rigorously-tested materials created for consulting projects and for training courses, this book demonstrates how to plan, design and build financial models that are flexible, robust, transparent, and highly applicable to a wide range of planning, forecasting and decision-support contexts. This book integrates theory and practice to provide a high-value resource for anyone wanting to gain a practical understanding of this complex and nuanced topic. Highlights of its content include extensive coverage of: -Model design and best practices, including the optimisation of data structures and layout, maximising transparency, balancing complexity with flexibility, dealing with circularity, model audit and error-checking -Sensitivity and scenario analysis, simulation, and optimisation -Data manipulation and analysis -The use and choice of Excel functions and functionality, including advanced functions and those from all categories, as well as of VBA and its key areas of application within financial modelling The companion website provides approximately 235 Excel files (screen-clips of most of which are shown in the text), which demonstrate key principles in modelling, as well as providing many examples of the use of Excel functions and VBA macros. These facilitate learning and have a strong emphasis on practical solutions and direct real-world application. For practical instruction, robust technique and clear presentation, Principles of Financial Modelling is the premier guide to real-world financial modelling from the ground up. It provides clear instruction applicable across sectors, settings and countries, and is presented in a well-structured and highly-developed format that is accessible to people with different backgrounds. | ||
588 | 0 | |a Print version record and CIP data provided by publisher. | |
630 | 0 | 0 | |a Microsoft Excel (Computer file)|0 http://id.loc.gov/authorities/names/n86025775 |
630 | 0 | 0 | |a Microsoft Office.|0 http://id.loc.gov/authorities/names/n94101591 |
630 | 0 | 7 | |a Microsoft Excel (Computer file)|2 fast |
630 | 0 | 7 | |a Microsoft Office|2 fast |
650 | 0 | |a Finance|x Mathematical models.|0 http://id.loc.gov/authorities/subjects/sh85048260 | |
650 | 0 | |a Corporations|x Finance|x Mathematical models. | |
650 | 0 | |a Visual Basic for Applications (Computer program language)|0 http://id.loc.gov/authorities/subjects/sh2014000894 | |
758 | |i has work:|a Principles of financial modelling (Text)|1 https://id.oclc.org/worldcat/entity/E39PCFxyX9pfgMrRPDCrqbdjkC|4 https://id.oclc.org/worldcat/ontology/hasWork | ||
776 | 0 | 8 | |i Print version:|a Rees, Michael, 1964-|t Principles of financial modelling.|d Hoboken : Wiley, [2018]|z 9781118904015|w (DLC) 2017057631 |
830 | 0 | |a Wiley finance series.|0 http://id.loc.gov/authorities/names/n00091597 | |
856 | 4 | 0 | |u https://www.aclib.us/OReilly |