Free Download Mastering Risk Modeling with Excel By Alastair Day
Check content proof, now:
In the corporate world, risks are present everywhere. The busy financial manager can utilize the helpful advice and workable templates in Mastering Risk Modelling to evaluate, apply, and model risk and uncertainty in Excel. The book is made especially to help you if you don’t have the time to start from scratch. It will help you become more proficient with Excel and provide you with a library of fundamental examples that you can use as a starting point for your future work..
It covers:
Review of model design
Risk and uncertainty
Project finance
Financial analysis
Valuation
Options
Bonds
Equities
Value at risk
Simulation
This second edition contains brand new chapters:
Revised models
More material on credit risk modelling e.g. portfolios, bankruptcy models
Shows dual 2003/2007 Excel key strokes
More theory especially on statistics in Excel
Basic statistics in Excel tools and methods
Capacity to borrow and repay
Fixed income risk models
Visual Basic approach
Editorial Reviews
From the Back Cover
A useful manual for modeling is Mastering Risk Modeling. Its purpose is to offer practical templates for implementing risk and uncertainty. The book
- Enhances financial managers’ Excel skills
- Shows how to create Excel models in a methodical way for quicker development and fewer mistakes.
- Offers an attached CD with a library of basic templates for future development that can be used right away.
For anyone working with risk model design or wishing to create more intricate models, this completely updated and redesigned guide is a must-have companion.
This edition’s new content includes:
- Completely updated models
Additional resources on credit risk modeling, including bankruptcy models, portfolios, and VaR
Double keystrokes in Excel for 2003 and 2007
- Excel statistics usage: tools and techniques
Suggestions about borrowing and repayment capabilities
Determining the ideal balance between risk and return
- Risk models for fixed income
- The Visual Basic method
Product details
Language : English
About the Author
Alastair Day
Alastair Day brings over four decades of experience in the financial sector, having worked extensively in both treasury and marketing roles. He previously served as a director at a vendor leasing firm. Following the acquisition of that business by a publicly listed group, Alastair launched Systematic Finance, a consultancy specializing in the following areas:
- Structuring finance and operating leases, both as an advisor and lessor
- Financial modeling—covering design, construction, auditing, and evaluation
- Delivering in-house and public training on modeling, leasing, corporate finance, project finance, energy, and credit analysis
He is the author of several authoritative books on leasing and financial modeling, including:
- Mastering Financial Modelling – Pearson ‘Mastering’ series, 3rd Edition
- Mastering Risk Modelling – Pearson ‘Mastering’ series, 2nd Edition
- Mastering Financial Mathematics in Excel – Pearson ‘Mastering’ series, 3rd Edition
- Mastering Cash Flow and Valuation Modelling – Pearson ‘Mastering’ series
- Applied Lease Finance – SFL/IPN
Alastair holds a degree in Economics and German from London University and earned his MBA from the Open University Business School (OUBS). He has also taught as an associate lecturer at both the OUBS and the ifs School of Business (Chartered Institute of Bankers).
Customer Reviews
TTL
Caution – Excel Files Fall Short of Expectations
I purchased this book assuming it would include comprehensive Excel spreadsheets for all topics covered, complete with relevant code. Generally, when buying a book like this, you expect working, fully developed templates without having to pay extra. Unfortunately, that’s not the case here. The Excel files provided are incomplete—numerous formulas are missing or replaced with static values, which means modifying input data doesn’t update the rest of the model.
Several areas you’d expect to customize are locked down. In many cases, the underlying VBA code is password-protected, so you can’t even access or modify it. What’s more frustrating is that the book offers only minimal explanation of how the spreadsheets function, making it very difficult to rebuild or fix them yourself.
If you’re looking for the complete Excel models, you’ll be directed to a separate website (linked to the author’s company), where you’ll need to pay an additional £500. This makes the book feel more like a teaser for their commercial software than a standalone resource—essentially, a pricey upsell.
Given that the author has written multiple titles in the Mastering series, I’d recommend approaching them with caution based on my experience with this one.
