Course curriculum

  • 1

    Welcome to the course!

    • Instructor bio - John Bura
    • Key pointers for this program
    • Joining the Alumni Community
  • 2

    Introduction to the Course

    • Segment - 01 - Introduction to the Course
    • Segment - 02 - Why should you learn Financial Analysis
    • Segment - 03 - Introduction of the Instructor
    • Segment - 04 - Course Requirements (what software, experience)
    • Source File
  • 3

    Excel Statement Models

    • Segment - 05 - What will we learn in this section
    • Segment - 06 - Preparing Data Source for P&I
    • Segment - 07 - Create P&I Structure
    • Segment - 08 - Adding Data to P&I
    • Segment - 09 - Calculating Variencies
    • Segment - 10 - Balance Sheet Structure
    • Segment - 11 - Adding Values on BS from different Files Format
    • Segment - 12 - Cash Flow Structure
    • Segment - 13 - Calculating Cash Flow
    • Segment - 14 - Challenge
    • Source File
  • 4

    Excel Finance Methods

    • Segment - 15 - What will we learn in this section
    • Segment - 16 - Forecast with Scenarios
    • Segment - 17 - How to Calculate Finance Main KPI's
    • Segment - 18 - Fixed Asset Roll Forward
    • Segment - 19 - Loan Schedule
    • Segment - 20 - AR Management Basics
    • Segment - 21 - Customer Rank
    • Segment - 22 - Create Budget Categories
    • Segment - 23 - Challenge
    • Source File
  • 5

    Conclusion

    • Segment - 24 - Course Summary and Next Steps