首页 >
财务 >
财务工程 >
Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

作者： Michael Rees
出版商： John Wiley & Sons
ISBN: 9781118904015
出版时间 March 2018
规格： Hardback , 544 pages
适应领域： International ? 免责申明：
Countri(es) stated herein are used as reference only

List Price: ￥930.00

￥902.10 Save ￥27.90 (3%)

或

下载订单表

加入收藏
| 加入比较

描述
大纲

详细
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.
Preface xxv

About the Author xxvii

About the Website xxix

PART ONE Introduction to Modelling, Core Themes and Best Practices 1

CHAPTER 1 Models of Models 3

CHAPTER 2 Using Models in Decision Support 7

CHAPTER 3 Core Competencies and Best Practices: Meta-themes 15

PART TWO Model Design and Planning 23

CHAPTER 4 Defining Sensitivity and Flexibility Requirements 25

CHAPTER 5 Database Versus Formulae-driven Approaches 37

CHAPTER 6 Designing the Workbook Structure 47

PART THREE Model Building, Testing and Auditing 57

CHAPTER 7 Creating Transparency: Formula Structure, Flow and Format 59

CHAPTER 8 Building Robust and Transparent Formulae 79

CHAPTER 9 Choosing Excel Functions for Transparency, Flexibility and Efficiency 105

CHAPTER 10 Dealing with Circularity 117

CHAPTER 11 Model Review, Auditing and Validation 143

PART FOUR Sensitivity and Scenario Analysis, Simulation and Optimisation 153

CHAPTER 12 Sensitivity and Scenario Analysis: Core Techniques 155

CHAPTER 13 Using GoalSeek and Solver 163

CHAPTER 14 Using VBA Macros to Conduct Sensitivity and Scenario Analyses 171

CHAPTER 15 Introduction to Simulation and Optimisation 177

CHAPTER 16 The Modelling of Risk and Uncertainty, and Using Simulation 187

PART FIVE Excel Functions and Functionality 199

CHAPTER 17 Core Arithmetic and Logical Functions 201

CHAPTER 18 Array Functions and Formulae 217

CHAPTER 19 Mathematical Functions 229

CHAPTER 20 Financial Functions 243

CHAPTER 21 Statistical Functions 257

CHAPTER 22 Information Functions 299

CHAPTER 23 Date and Time Functions 307

CHAPTER 24 Text Functions and Functionality 313

CHAPTER 25 Lookup and Reference Functions 325

CHAPTER 26 Filters, Database Functions and PivotTables 355

CHAPTER 27 Selected Short-cuts and Other Features 387

PART SIX Foundations of VBA and Macros 395

CHAPTER 28 Getting Started 397

CHAPTER 29 Working with Objects and Ranges 413

CHAPTER 30 Controlling Execution 425

CHAPTER 31 Writing Robust Code 441

CHAPTER 32 Manipulation and Analysis of Data Sets with VBA 455

CHAPTER 33 User-defined Functions 473

Index 493

你可能需要


Drafting Employment Documents for Expatriates, 2nd Edition: List Price: ￥1,859.26

￥1,803.47 Save ￥55.78 (3%)


How to Lead a Values-Based Professional Services Firm: 3 Keys to Unlock Purpose and Profit: List Price: ￥372.00

￥360.84 Save ￥11.16 (3%)


Armstrong's Handbook of Human Resource Management Practice, 16th Edition: List Price: ￥581.25

￥563.81 Save ￥17.44 (3%)


Individual Income Tax Planning for Expatriates in China, 6th Edition: List Price: ￥1,190.40

￥595.20 Save ￥595.20 (50%)


Hong Kong Employment Law: A Practical Guide, 5th Edition: List Price: ￥1,395.00

￥1,353.15 Save ￥41.85 (3%)


The Employee Experience: How to Attract Talent, Retain Top Performers, and Drive Results: List Price: ￥260.40

￥252.59 Save ￥7.81 (3%)


Butterworths Employment Law Handbook 2024: List Price: ￥3,685.31

￥3,574.75 Save ￥110.56 (3%)


Hiring Greatness: How to Recruit Your Dream Team and Crush the Competition: List Price: ￥251.10

￥243.57 Save ￥7.53 (3%)


Employees' Intellectual Property Rights, 2nd Edition: List Price: ￥1,720.50

￥1,668.89 Save ￥51.62 (3%)


Employment Law and Practice in Hong Kong, 2nd Edition (Hardcopy + e-book): List Price: ￥4,371.93

￥4,240.77 Save ￥131.16 (3%)


International Employment Law Disputes: List Price: ￥1,953.00

￥1,894.41 Save ￥58.59 (3%)


Settlement of Individual Employment Disputes: List Price: ￥1,383.38

￥1,341.88 Save ￥41.50 (3%)


Developing Human Capital: List Price: ￥558.00

￥541.26 Save ￥16.74 (3%)


Managing Employment Relations, 7th Edition: List Price: ￥558.00

￥541.26 Save ￥16.74 (3%)


Performance Management: List Price: ￥290.63

￥45.57 Save ￥245.06 (84%)

“

Ordering from Professional Bookshop is fantastic, quick delivery great products, great customer service Siti L.
This is a great bookstore and have had no problems with them and all my orders have come on time and in good condition. Yang X.
Everything is perfect. Fast delivery. I highly recommend this website to all my friends and colleagues. Thanks Hoi Man L.
So thankful I am receiving all my books, thank you to all for a great service and excellent products Clinton K.
Professional Bookshop is amazing! I've been a loyal customer for over 5 years. Returns are easy to request, book or delivery complaints are taken seriously and the customer service team is friendly and patient. Mick D.
I wanted to informed you that the customer service is excellent. They were so polite and nice. I would continue to buy books from Professional Bookshop. Jingsong C.
Fast and quick service. Easy transaction method, arrived sooner than expected. Excellent packaging and the books received are in perfect condition! Thank you very much! I love the book and its quality. Saori B.
I can order any accounting books from worldwide from Professional Bookshop. Love this website and save my time to search from internet. Lingxiao R.
It is just so easy to find what you are always looking for and sometimes you can even find it up to 80% off what you would in the normal store. Graeme R.
I love shopping on Professional Bookshop! They have a wide range of accounting book with competent prices. Free shipping in Hong Kong is also really handy! Fergus Y.
Professional Bookshop is a great bookstore, I must say. Buying books in Professional Bookshop is so easy, great and reliable. It is highly recommendable. Deborah D.
A great site to shop accounting books and everything and with discountable prices. It’s my first choice whenever i want to shop something. Most trusted site. Zeng Z.
I found the books I needed and at a very low price. I am very happy and will definitely use it in the future Brian W.
I have been using Professional Bookshop for a while now. I am very impressed with customer service and delivery. When I need to have a return it is done very diligently. Olivia L.
Professional Bookshop is my default go to for finding the best prices and reading details of law books before buying. Detailed book description is very helpful. Tracy W.
I've been using Professional Bookshop since 2011 and they actually great, I always received great service and my book arrives on time. Lisa C.

所有书籍

Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

Free delivery Hong Kong?

详细

你可能需要

What Our Customers Say?

所有书籍

Principles of Financial Modelling: Model Design and Best Practices Using Excel and VBA

Free delivery Hong Kong?

详细

你可能需要

What Our Customers Say?

video title