book

Using Excel for Business and Financial Modelling, 3rd Edition

by Danielle Stein Fairhurst

April 2019

Beginner

424 pages

10h 55m

English

Wiley

Read now

Unlock full access

BOOK OVERVIEWACKNOWLEDGEMENTS
WHAT'S THE DIFFERENCE BETWEEN A SPREADSHEET AND A FINANCIAL MODEL?TYPES AND PURPOSES OF FINANCIAL MODELSTOOL SELECTIONWHAT SKILLS DO YOU NEED TO BE A GOOD FINANCIAL MODELLER?THE “IDEAL” FINANCIAL MODELLERSUMMARYNOTES
MODEL DESIGNTHE GOLDEN RULES FOR MODEL DESIGNDESIGN ISSUESTHE WORKBOOK ANATOMY OF A MODELPROJECT PLANNING YOUR MODELMODEL LAYOUT FLOWCHARTINGSTEPS TO BUILDING A MODELINFORMATION REQUESTSVERSION-CONTROL DOCUMENTATIONSUMMARY
DOCUMENT YOUR ASSUMPTIONSLINKING, NOT HARDCODINGENTER DATA ONLY ONCEAVOID BAD HABITSUSE CONSISTENT FORMULASFORMAT AND LABEL CLEARLYMETHODS AND TOOLS OF ASSUMPTIONS DOCUMENTATIONLINKED DYNAMIC TEXT ASSUMPTIONS DOCUMENTATIONWHAT MAKES A GOOD MODEL?SUMMARYNOTE
THE PROBLEM WITH EXCELERROR AVOIDANCE STRATEGIESHOW LONG SHOULD A FORMULA BE?LINKING TO EXTERNAL FILESBUILDING ERROR CHECKSCIRCULAR REFERENCESSUMMARYNOTES
FORMULAS AND FUNCTIONS IN EXCELEXCEL VERSIONSHANDY EXCEL SHORTCUTSCELL REFERENCING BEST PRACTICESNAMED RANGESBASIC EXCEL FUNCTIONSLOGICAL FUNCTIONSNESTING LOGICAL FUNCTIONSSUMMARY
AGGREGATION FUNCTIONSLOOKUP FUNCTIONSNESTING INDEX AND MATCHOFFSET FUNCTIONREGRESSION ANALYSISCHOOSE FUNCTIONWORKING WITH DATESFINANCIAL PROJECT EVALUATION FUNCTIONSLOAN CALCULATIONSSUMMARY
BASIC FORMATTINGCUSTOM FORMATTINGCONDITIONAL FORMATTINGSPARKLINESBULLETPROOFING YOUR MODELCUSTOMISING THE DISPLAY SETTINGSFORM CONTROLSSUMMARY
HIDING SECTIONS OF A MODELGROUPINGARRAY FORMULASGOAL SEEKINGSTRUCTURED REFERENCE TABLESPIVOTTABLESMACROSSUMMARY

ESCALATION METHODS FOR MODELLINGUNDERSTANDING NOMINAL AND EFFECTIVE (REAL) RATESCALCULATING A CUMULATIVE SUM (RUNNING TOTALS)HOW TO CALCULATE A PAYBACK PERIODWEIGHTED AVERAGE COST OF CAPITAL (WACC)BUILDING A TIERING TABLEMODELLING DEPRECIATION METHODSBREAK-EVEN ANALYSISSUMMARY
REBUILDING AN INHERITED MODELIMPROVING MODEL PERFORMANCEAUDITING A FINANCIAL MODELSUMMARYAPPENDIX: QA LOG
WHAT ARE THE DIFFERENCES BETWEEN SCENARIO, SENSITIVITY, AND WHAT-IF ANALYSES?OVERVIEW OF SCENARIO ANALYSIS TOOLS AND METHODSADVANCED CONDITIONAL FORMATTINGCOMPARING SCENARIO METHODSADDING PROBABILITY TO A DATA TABLESUMMARY
PREPARING AN ORAL PRESENTATION FOR MODEL RESULTSPREPARING A GRAPHIC OR WRITTEN PRESENTATION FOR MODEL RESULTSCHART TYPESWORKING WITH CHARTSHANDY CHARTING HINTSDYNAMIC NAMED RANGESCHARTING WITH TWO DIFFERENT AXES AND CHART TYPESBUBBLE CHARTSCREATING A DYNAMIC CHARTWATERFALL CHARTSSUMMARY
DOWNLOADABLE RESOURCES