- InstantOn purchase
- Full bookAll chapters
- Any devicePC, tablet, phone
- SecureSSL checkout
Principles of Financial Modelling Model Design and Best Practices Using Excel and VBA
by John Wiley & Sons
Lowest price online, guaranteed. One-time payment, no subscription.
Download link emailed instantly after payment, 24/7
Your download link is sent to the email you enter. Double-check it before completing your order.
File issue? We replace it or refund you, no questions asked.
You'll receive a download link by email immediately after checkout.
Send us the book cover via live chat and we'll request it for you. Typical response time: 10 minutes.
What's inside
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.
From checkout to chapter one in seconds
Check out securely
Pay by card or wallet. Use an email address you can access right now.
Get your link
Your download link arrives by email the moment your payment clears, 24/7.
Read anywhere
Open it on your laptop, tablet or phone. Save it and keep it.
Smarter than paying full price
Authorised by publisher: licensed copy, never pirated.
Less than Amazon Kindle, with our lowest-price guarantee.
Delivered the moment your payment clears, day or night.
Complete edition: every chapter, no missing pages.
Good to know
How do I receive my ebook?
Right after checkout we email you a download link. Check your spam folder if it doesn't arrive within a few minutes.
Which devices can I read it on?
Any computer, tablet or phone. PDF opens in any browser or free reader app.
I entered the wrong email. What now?
Contact us via live chat with your order number and we'll resend the link to the right address.
What if there's a problem with the file?
We'll replace it or refund you within 30 days, no questions asked.