AZTUProgrammes

Subject · Economics-master's degree

Practicum: financial modeling and decision support (excel, @risk) / process automation (rpa)Topics

MM-21066 creditsSpring semesterMandatory2025-2026

Topic plan

The subject's topics and the learning outcomes attached to each one.

5 topics

  1. 1. Introduction to financial modeling in excel: structure, best practices & model design

    Lecture

    Introduction to financial modeling in excel: structure, best practices & model design

  2. 2. Building dynamic DCF models: assumptions, drivers, and sensitivity

    Lecture

    Building dynamic DCF models: assumptions, drivers, and sensitivity

  3. 3. Advanced excel functions for finance: offset, index/match, array formulas

    Lecture

    Advanced excel functions for finance: offset, index/match, array formulas

  4. 4. Scenario analysis and data tables in financial models

    Lecture

    Scenario analysis and data tables in financial models

  5. 5. Introduction to @risk: monte carlo simulation fundamentals

    Lecture

    Introduction to @risk: monte carlo simulation fundamentals