Inheriting a Financial Model

Описание: When you take over and start using a financial model that someone else has built, not only are you inheriting the original modellers’ inputs, assumptions and calculations, but you may also be inheriting their mistakes! Using someone else’s model involves taking responsibility for their work and you want to be confident it’s working correctly. Hear from financial modelling specialist, Danielle Stein Fairhurst during the Financial Modelling Summit as she draws from the second edition of her book, Financial Modelling in Excel for Dummies, to learn some simple ways to check, audit, validate and, if necessary, correct legacy models so that you can be confident of the model’s results. Covered in this session:

• What to check for when “meeting” a model for the first time
• Breaking down long and complex formulas in legacy models
• Audit tools in standard Excel to find and correct errors


6:58 Turning off Manual Calculations
7:56 Checking for external links
8:30 Inspect Document
10:43 Audit Tools
16:40 Using the watch window and the camera tool
18:40 Find & Select
22:02 A financial model audit (model review)
23:35 Dealing with redundant assumptions in legacy models
27:35 Common Excel Errors
29:14 Finding circular references in financial models
31:45 Sharing your work; models built for collaboration


★ Register for a virtual meetup ► https://plumsolutions.com.au/meetup
★ Register for Danielle’s online courses ► https://plumsolutions.com.au/elearning
★ Financial Modelling Summit ► https://www.financialmodellingsummit....
★ Link to Spreadsheet Detective ► https://www.spreadsheetdetective.com/ (use the coupon code Danielle2021 for a 15% discount if you decide to purchase)
★ Financial Modeling in Excel for Dummies ► https://plumsolutions.com.au/dummies