12 Months Rolling Forecast with Budget and Variance Analysis

Overview of Rolling forecast

Download Resources

1. Course Introduction

2. Course Objective

3. What is a Rolling Forecast

4. Rolling forecast vs Static Budget

5. Steps in creating a Rolling Forecast

6. Benefits of a Rolling Forecast

Financial Modeling Best Practice

1. Robust Rolling Forecast model in Excel

2. Key consideration in building a structured model

3. Modeling best practices

4. Rolling Forecast process overview

Monthly forecast in Excel

1. Overview of the modelling process

2. Time periods

3. Historical assumptions & drivers

4. Forecast assumptions & drivers

5. Income statement modeling

6. Working capital schedule

7. Non – current asset schedule

8. Debt schedule

9. Income Statement & Balance Sheet completion

10. Cashflow statement modeling

11. Baseline Budget

12. Building of financial template

Rolling forecast data setup & modeling in Power BI

1. Overview of Power BI

2. Importing data into power query editor

3. Cleaning, transforming & loading data

4. Data modeling & relationship

5. Creating a selection table & selection measure

Dynamic Income Statement forecast, budget and variance analysis.

1. Creating fact Dax measures for Forecast

2. Creating IS Dynamic measures

3. Creating Fact Dax measures for budget & variance

4. Creating Budget IS Dynamic measures

5. Creating a best fit visual

1 of 2

Previous Lesson

2. Course Objective

12 Months Rolling Forecast with Budget and Variance Analysis 2. Course Objective

Previous Lesson