Course curriculum

  • 1

    Intro to Structured Analysis

    • READ THIS FIRST!

    • Module 1.1

    • Module 1.2

    • Demo_TestingLeverage

    • Exercise_TestingLeverage_Incomplete

    • Exercise_TestingLeverage_Complete

    • Module 1.3

    • Model: Strat_Tool_v1

    • Exercise_StratTool_DataTape

    • Exercise_StratTool_Questions_Incomplete

    • Exercise_StratTool_Questions_Complete

    • Model: Structuring_Model_v1

  • 2

    Excel Fundamentals

    • Module 2.1

    • Demo_IF_AND_OR

    • Exercise_IF_AND_OR_Incomplete

    • Exercise_IF_AND_OR_Complete

    • Module 2.2

    • Demo_MIN_MAX_MOD

    • Exercise_MIN_MAX_MOD_Incomplete

    • Exercise_MIN_MAX_MOD_Complete

    • Module 2.3

    • Demo_EDATE_EOMONTH_DAYS360

    • Exercise_EDATE_EOMONTH_DAYS360_Incomplete

    • Exercise_EDATE_EOMONTH_DAYS360_Complete

    • Module 2.4

    • Demo_PMT_IRR_XIRR

    • Exercise_PMT_IRR_XIRR_Incomplete

    • Exercise_PMT_IRR_XIRR_Complete

    • Module 2.5

    • Demo_MATCH_OFFSET_INDEX

    • Exercise_MATCH_OFFSET_INDEX_Incomplete

    • Exercise_MATCH_OFFSET_INDEX_Complete

    • Module 2.6

    • Demo_SUMPRODUCT_FORECAST

    • Exercise_SUMPRODUCT_FORECAST_Incomplete

    • Exercise_SUMPRODUCT_FORECAST_Complete

    • Module 2.7

  • 3

    Model Set Up

    • Module 3.1

    • Exercise_ModelSetup_Incomplete

    • Exercise_ModelSetup_Complete

    • Module 3.2

    • Demo_DatesTiming

    • Exercise_DatesTiming_Incomplete

    • Exercise_DatesTiming_Complete

  • 4

    Asset Cash Flow Generation

    • Module 4.1

    • Demo_AmortMethods

    • Exercise_AmortMethods_Incomplete

    • Exercise_AmortMethods_Complete

    • Module 4.2

    • Demo_LevelPayAmort

    • Demo_RepLines

    • Exercise_Replines_Incomplete

    • Exercise_RepLines_Complete

  • 5

    Defaults

    • Module 5.1

    • Demo_DefaultCurves

    • Demo_OFFSET_Ranges

    • Module 5.2

    • Exercise_Default_I_Incomplete

    • Exercise_Default_I_Complete

    • Module 5.3

    • Demo_Default

    • Module 5.4

    • Exercise_Default_II_Incomplete

    • Exercise_Default_II_Complete

    • Module 5.5

    • Exercise_Amort_Default_Incomplete

    • Exercise_Amort_Default_Complete

  • 6

    Default Recoveries

    • Module 6.1

    • Demo_Recovery

    • Exercise_Recovery_Incomplete

    • Exercise_Recovery_Complete

    • Module 6.2

    • Exercise_Amort_Recovery_Incomplete

    • Exercise_Amort_Recovery_Complete

  • 7

    Prepayments

    • Module 7.1

    • Demo_Prepayment

    • Exercise_Prepay_Incomplete

    • Exercise_Prepay_Complete

    • Module 7.2

    • Exercise_Amort_Prepayment_Incomplete

    • Exercise_Amort_Prepayment_Complete

  • 8

    Liabilities: Priority of Payments

    • Module 8.1

    • Demo_Fees

    • Exercise_Fees_Incomplete

    • Exercise_Fees_Complete

    • Module 8.2

    • Demo_Interest

    • Exercise_Interest_Incomplete

    • Exercise_Interest_Complete

    • Module 8.3

    • Demo_Principal

    • Module 8.4

    • Exercise_Principal_Incomplete

    • Exercise_Principal_Complete

    • Module 8.5

    • Exercise_Principal_PmtPriorities_Incomplete

    • Exercise_Principal_PmtPriorities_Complete

    • Module 8.6

    • Exercise_Principal_Integration_Incomplete

    • Exercise_Principal_Integration_Complete

  • 9

    Credit Enhancement

    • Module 9.1

    • Demo_ReserveAccounts

    • Exercise_ReserveAcct_Incomplete

    • Exercise_ReserveAcct_Complete

    • Module 9.2

    • Demo_LiquidityFacilities

    • Exercise_LiquidityFacility_Incomplete

    • Exercise_LiquidityFacility_Complete

    • Module 9.3

    • Demo_Triggers

    • Exercise_Triggers_Incomplete

    • Exercise_Triggers_Complete

    • Module 9.4

    • Demo_CE_Analysis

  • 10

    Model Integrity & Analytics

    • Module 10.1

    • Module 10.2

    • Demo_Analytics

    • Exercise_Analytics_Incomplete

    • Exercise_Analytics_Complete

  • 11

    The Rating Agencies

    • Module 11.1

    • Module 11.2

    • Exercise_S&P_Incomplete

    • Exercise_S&P_Complete

    • Module 11.3

    • Model: Lognormal Model

    • Exercise_Moodys_Incomplete

    • Exercise_Moodys_Complete

  • 12

    Deal Analysis

    • Module 12.1

    • Module 12.2

    • Module 12.3

    • Module 12.4

    • Module 12.5

    • Module 12.6

    • Exercise_DealAnalysis_Incomplete

    • Exercise_DealAnalysis_Complete

  • 13

    VBA Crash Course

    • Module 13.1

    • Demo_VBA

    • Module 13.2

    • Module 13.3

    • Exercise_VBA_Incomplete

    • Exercise_VBA_Complete

  • 14

    VBA for Structured Finance Analysis

    • Module 14.1

    • Module 14.2

    • Module 14.3

    • Module 14.4