Practical Financial Modelling

Visual Basic for Applications Navigation Corkscrews Quality control Project finance Flags Index Top down approach Error handling Risk analysis Monte Carlo analysis Data validation Human Error Iteration Risk modelling Scenario management Macros Model development Sensitivity analysis User Defined Functions Choose Switches Conditional formatting Arithmetical audit check Audit tools and techniques Avoiding IF Calculating dates Array formulas Circularities Combo boxes Custom formatting Define names Create names Data tables Change audit check Charting techniques Drop-down lists Debt sculpting Financial audit check Counters Group and outline Delta sheets IRR and XIRR Dynamic name ranges Late binding functions lookup Macro buttons Environmental audit check Left-to-right consistency Natural language formulas Model review NPV and XNPV Naming variables Printing and reporting Goal seek INDEX and MATCH Operis versus FAST structure Range names in functions Public�private Partnerships (PPP Range names Inputs sheet Relative and absolute references Recorded macros The audit workbook The model review plan The audit sheet Workbook structure Written macros Modelling compliance officer Logical functions Logical masks Multiple inputs sheets what-if analysis P3)Quality assurance R1C1 referencing Outputs sheet Model audit Model Documentation Modelling standards Time-constrained calculations Risk assessment and risk controls Visual Basic Editor The Macpherson report The model reviewer The Name Manager Workings sheet Timing issues Protection and passwords Senior responsible owner Structural audit check