Select Guide Rating

• ConventionsOverview       1     IntroductionScope of the bookExample modelObjectives of risk modellingSummary        2     Review of model designIntroductionDesign objectivesCommon errorsExcel featuresFormatsNumber formatsLines and bordersColour and patternsSpecific colour for inputs and resultsData validationControls – combo boxes and buttonsConditional formattingUse of functions and types of functionsAdd-ins for more functionsText and updated labelsRecording a version number, author, etc.Using namesPasting a names tableComment cellsGraphicsDynamic graphs to plot individual seriesData tablesScenariosSpreadsheet auditingSummary        3     Risk and uncertaintyIntroductionRiskUncertaintyResponse to riskMethodsSummary        4     Project financeIntroductionRequirementsAdvantagesRisksRisk analysisRisk mitigationFinancial modelInputsSensitivity and cost of capitalConstruction, borrowing and outputAccounting schedulesManagement analysis and summariesSummary        5     SimulationIntroductionBuilding blocksProcedureReal estate exampleSummary        6     Financial analysisIntroduction

Select Guide Rating

• ConventionsOverview       1     IntroductionScope of the bookExample modelObjectives of risk modellingSummary        2     Review of model designIntroductionDesign objectivesCommon errorsExcel featuresFormatsNumber formatsLines and bordersColour and patternsSpecific colour for inputs and resultsData validationControls – combo boxes and buttonsConditional formattingUse of functions and types of functionsAdd-ins for more functionsText and updated labelsRecording a version number, author, etc.Using namesPasting a names tableComment cellsGraphicsDynamic graphs to plot individual seriesData tablesScenariosSpreadsheet auditingSummary        3     Risk and uncertaintyIntroductionRiskUncertaintyResponse to riskMethodsSummary        4     Project financeIntroductionRequirementsAdvantagesRisksRisk analysisRisk mitigationFinancial modelInputsSensitivity and cost of capitalConstruction, borrowing and outputAccounting schedulesManagement analysis and summariesSummary        5     SimulationIntroductionBuilding blocksProcedureReal estate exampleSummary        6     Financial analysisIntroduction

Select Guide Rating

• ConventionsOverview       1     IntroductionScope of the bookExample modelObjectives of risk modellingSummary        2     Review of model designIntroductionDesign objectivesCommon errorsExcel featuresFormatsNumber formatsLines and bordersColour and patternsSpecific colour for inputs and resultsData validationControls – combo boxes and buttonsConditional formattingUse of functions and types of functionsAdd-ins for more functionsText and updated labelsRecording a version number, author, etc.Using namesPasting a names tableComment cellsGraphicsDynamic graphs to plot individual seriesData tablesScenariosSpreadsheet auditingSummary        3     Risk and uncertaintyIntroductionRiskUncertaintyResponse to riskMethodsSummary        4     Project financeIntroductionRequirementsAdvantagesRisksRisk analysisRisk mitigationFinancial modelInputsSensitivity and cost of capitalConstruction, borrowing and outputAccounting schedulesManagement analysis and summariesSummary        5     SimulationIntroductionBuilding blocksProcedureReal estate exampleSummary        6     Financial analysisIntroduction