Course curriculum

    1. Welcome

    2. About Your Instructor

    1. Lesson 1: Why it is important to have a well structured financial model?

    2. Lesson 2: Best Practice financial modeling standards

    3. Case 1: Preliminary Review of a Financial Model

    1. Lesson 3: Different Financial Model Layouts

    2. Lesson 4: Timeline

    3. Lesson 5: Inputs

    4. Lesson 6: Sensitivity Analysis

    5. Lesson 7: Integrity checks

    6. Lesson 8: Summary

    7. Case 2: Adopting an Existing Financial Model

    1. Lesson 9: Color codes

    2. Lesson 11: Generic Macro

    3. Lesson 12: Example of designing and formatting a Spreadsheet

    4. Case 3: Reformatting of a Financial model

    5. Lesson 10: Worksheet column design

    1. Lesson 13: Financial Model Databook (user manual)

    2. Lesson 14: File naming convention

    3. Lesson 15: Version Tracker

    4. Lesson 16: Keep track of questions and answers

    1. Wrapping Things Up

    2. Resources

About this course

  • Free
  • 23 lessons
  • 1.5 hours of video content

Video

Learn how to build a structured and well designed project finance model