How to Create Strategic 5-Year Financial Models in Excel

Focused View

Dobromir Dikov

5:45:49

218 View

1. Getting Started

1. Welcome to the Course.mp4

03:41

2. Enable the Developer Tab.mp4

00:59

3. Install Minty Tools (Student Edition).mp4

07:19

4.1 Debt Summary.docx

4.2 Enterprise Value (EV) of the Business.pdf

4.3 Financial Model_Final Version.xlsx

4.4 Group Financials - CY2020-CY2022.xlsx

4.5 Model Assumptions Guidebook.docx

4.6 Model Assumptions Guidebook.pdf

4.7 RockCode Acquistion.docx

4.8 setup.zip

4.9 What is the Cash Conversion Cycle.pdf

4. Download the Course Resources.html

5. Important Excel Formulas.mp4

12:14

6. Essential Excel Shortcuts.mp4

10:17

7.1 Financial Model Working_Lecture 07.xlsx

7. Review the Source Data.mp4

02:01

8. Quiz 1.html

2. Start Working on the Financial Model

1. Outline the Overall Model Structure.mp4

03:29

2.1 Financial Model Working_Lecture 09.xlsx

2. Build the 3-Statement Reporting Framework.mp4

06:37

3.1 Financial Model Working_Lecture 10.xlsx

3. Income Statement Drivers 1.mp4

08:33

4.1 Financial Model Working_Lecture 11.xlsx

4. Income Statement Drivers 2.mp4

04:56

5.1 Debt Summary.docx

5.2 Financial Model Working_Lecture 12.xlsx

5. Add a Debt Schedule.mp4

11:47

6.1 Financial Model Working_Lecture 13.xlsx

6. Start a Changelog.mp4

02:25

7.1 Financial Model Working_Lecture 14.xlsx

7.2 What is the Cash Conversion Cycle.pdf

7. Cash Conversion Cycle and Working Capital.mp4

10:52

8.1 Financial Model Working_Lecture 15.xlsx

8. Add a Property, Plant & Equipment Schedule.mp4

04:20

9.1 Financial Model Working_Lecture 16.xlsx

9. Add the Goodwill and Equity Schedules.mp4

07:38

10.1 Financial Model Working_Lecture 17.xlsx

10. Link the Cash Flow Statement.mp4

04:13

11. Quiz 2.html

3. Modeling the Core Business Entities

1. Congrats and Welcome to the New Section.mp4

00:56

2.1 Financial Model Working_Lecture 19.xlsx

2. Dev Entity Replicate the Model and Copy Historicals.mp4

03:59

3.1 Financial Model Working_Lecture 20.xlsx

3. Dev Entity Adjust Assumptions and Finalize the Model.mp4

08:47

4.1 Financial Model Working_Lecture 21.xlsx

4. Pipeline Entity Replicate the Model and Copy Historicals.mp4

04:09

5.1 Financial Model Working_Lecture 22.xlsx

5. Pipeline Entity Adjust Assumptions and Finalize the Model.mp4

04:26

6.1 Financial Model Working_Lecture 23.xlsx

6. Solids Entity Replicate the Model and Copy Historicals.mp4

02:13

7.1 Financial Model Working_Lecture 24.xlsx

7. Solids Entity Adjust Assumptions and Finalize the Model.mp4

01:42

8. Quiz 3.html

4. Build the RockCode Entity Acquisition Model

1. Congrats and Welcome to the New Section.mp4

00:42

2.1 Financial Model Working_Lecture 26.xlsx

2. Replicate the Model and Copy the Historicals.mp4

04:47

3.1 Financial Model Working_Lecture 27.xlsx

3.2 RockCode Acquistion.docx

3. Add the Acquisition Section.mp4

08:54

4.1 Financial Model Working_Lecture 28.xlsx

4. Adjust the Assumptions for Debt, PPE & Goodwill.mp4

04:24

5.1 Financial Model Working_Lecture 29.xlsx

5. Add Other Liabilities Section and Link Debt, PPE & Goodwill.mp4

07:06

6.1 Financial Model Working_Lecture 30.xlsx

6. Add Proforma & Date of Acquisition Drop-Down.mp4

13:37

7.1 Financial Model Working_Lecture 31.xlsx

7. Fix the Date of Acquisition View and Finalize the Model.mp4

13:33

8. Quiz 4.html

5. Build the Acquisitions Pipeline Model

1. Congrats and Welcome to the New Section.mp4

00:35

2.1 Financial Model Working_Lecture 33.xlsx

2. Add the Config Tab and the Core Business Summary View.mp4

07:29

3.1 Financial Model Working_Lecture 34.xlsx

3. Add Ownership, Number of Acquisitions & Revenue Assumptions.mp4

09:31

4.1 Financial Model Working_Lecture 35.xlsx

4. Model Cost of Sales and EBITDA.mp4

05:07

5.1 Financial Model Working_Lecture 36.xlsx

5. Model the Operating Expenses.mp4

05:35

6.1 Financial Model Working_Lecture 37.xlsx

6. Add the Acquisition Valuation Assumptions.mp4

12:18

7.1 Financial Model Working_Lecture 38.xlsx

7. Add the Acquisition Debt Schedule.mp4

12:45

8.1 Financial Model Working_Lecture 39.xlsx

8. Add the Cash Conversion Cycle and Working Capital.mp4

06:47

9.1 Financial Model Working_Lecture 40.xlsx

9. Add the Acquisition Price Split, CAPEX & PPE Assumptions.mp4

08:52

10.1 Financial Model Working_Lecture 41.xlsx

10. Work on Goodwill, Other Liabilities and the Equity Schedule.mp4

06:59

11. Quiz 5.html

6. Model the New Product Launch

1. Congrats and Welcome to the New Section.mp4

00:27

2.1 Financial Model Working_Lecture 43.xlsx

2. Work on the Income Statement Assumptions.mp4

13:49

3.1 Financial Model Working_Lecture 44.xlsx

3. Fix the Acquisitions Pipeline Taxes Calculation.mp4

01:22

4.1 Financial Model Working_Lecture 45.xlsx

4. Add the Cash Conversion Cycle, PPE & Equity Schedules.mp4

08:20

5.1 Financial Model Working_Lecture 46.xlsx

5. Add Scenarios to the Model.mp4

10:33

6. Quiz 6.html

7. Finalizing the Financial Model

1. Congrats and Welcome to the New Section.mp4

00:16

2.1 Financial Model Working_Lecture 48.xlsx

2. Create the Revenue & Margins Summary.mp4

07:41

3.1 Financial Model Working_Lecture 49.xlsx

3. Create the Consolidated View and Eliminations Schedule.mp4

15:49

4.1 Enterprise Value (EV) of the Business.pdf

4.2 Financial Model Working_Lecture 50.xlsx

4. Create the Company Valuation Tab.mp4

07:33

5.1 Financial Model Working_Lecture 51.xlsx

5. Add a Revenue Step Up Chart.mp4

12:34

6.1 Financial Model Working_Lecture 52.xlsx

6. Add a Table Of Contents and Finalize the Model.mp4

05:26

7.1 Assumptions Guidebook_Lecture 53.docx

7.2 Financial Model Working_Lecture 53.xlsx

7. Create the Assumptions Guidebook for the Model.mp4

03:22

8.1 Financial Model Working_Lecture 54.xlsx

8. Make the Model Open as Read-Only by Default.mp4

01:35

9. Quiz 7.html

10. Congratulations on Completing the Course!.mp4

00:28

8. Bonus Section

1. Bonus Lecture.html

Description

Learn how to build a dynamic assumptions-driven financial model in Excel from scratch!

What You'll Learn?

Create robust & dynamic financial models in Excel from scratch
Identify key drivers and assumptions for performance
Prepare custom outputs to address the needs of investors and stakeholders
Add value to any financial model by introducing dynamic scenarios and sensitivity analysis
Structure complex Excel models that are easy to read
Apply professional formatting that makes your spreadsheets stand out

Who is this for?

Junior to Mid-Senior finance and accounting professionals who work in FP&A

Analysts working in M&A and Debt & Equity Raising

Business owners and entrepreneurs who want to understand how financial modeling works in practice

Managers in start-ups where no finance professionals are available

Students in Finance and Economics majors who wish to get a head start

What You Need to Know?

Microsoft Excel 2010 or later

Comfortable with basic Excel functionality

Basic knowledge on fundamental financial reporting principles

More details

Description
Suppose you currently work in an FP&A role or anywhere between accounting and finance. In that case, thereâ€™s a high chance youâ€™ll probably face the challenge of preparing a 3 or 5-year financial model to plan ahead of time and ensure the business is ready to face any challenges.
This course will teach you how to create dynamic assumptions-driven financial models confidently!
You will start with an empty Excel spreadsheet and build a complete dynamic 5-year financial model you can use for strategic planning and investor purposes!
What youâ€™ll get out of this course?
The Create a Strategic 5-year Financial Model in Excel course will guide you through the practical process of creating a 5-year financial model in Excel, step by step. We will define a clear structure and build a robust dynamic model, which you can reuse repeatedly. I will help you understand the flow of information between different parts of the model and how to optimize these relationships. You will learn how to forecast, define assumptions and perform sensitivity analysis. We will define a consistent formatting framework for our model to make it easier to read and understand, even after time has passed.
I will show you some tips and tricks to tremendously improve the value of your model by adding versatility, dynamic scenarios, and sensitivity analysis. We will take it to the end and prepare summary sheets to share with investors and other stakeholders.
In this course, I follow the exact approach that I use when working for clients so that you see a real-life example.
After taking the Create a Strategic 5-year Financial Model in Excel course, you will be confident to prepare your complex models and bring value to any company you work in.
You will also get Minty Tools (Student Edition) - a free Excel add-in with useful features to streamline and speed up your Excel modeling workflow.
What should you know to take the course?
This course is aimed at an intermediate level of students. We will go over the main shortcuts and formulas we use in the model, and you will have to become familiar with those to follow along. I expect you to have a solid fundamental knowledge of Excel, be able to use formulas, link to cells in other sheets, and know how the standard formatting tools and the ribbon work. This course will be hard to take if you are entirely new to Excel.
To fully understand the model, you will need some basic accounting knowledge. I explain everything whenever we go into specifics. Still, I expect you to be familiar with an Income Statement, Balance Sheet, and Cash Flow Statement and have a general idea of how these are linked together. I would also expect you to understand words like Depreciation and Amortization, Interest, Cash Flows, and other similar terms.
It would be possible to follow along and learn much from the course, even without basic accounting knowledge. Still, I would suggest you familiarize yourself with that and then take the Create a Strategic 5-year Financial Model in Excel course.
I hope you are ready to up your game, learn how to build investor-ready financial models in Excel, and propel your career!
Are you excited to start?
Then enroll in the course, and Iâ€™ll see you in class!
Who this course is for:
Junior to Mid-Senior finance and accounting professionals who work in FP&A
Analysts working in M&AÂ and Debt & Equity Raising
Business owners and entrepreneurs who want to understand how financial modeling works in practice
Managers in start-ups where no finance professionals are available
Students in Finance and Economics majors who wish to get a head start

User Reviews

Rating

average 0

Total votes0

Focused display

Financial Modeling

Dobromir Dikov

Instructor's Courses

For the past ten years, I have been working in the fields of audit, management accounting, financial modeling, budgeting, and reporting. I am excited about delving deep into the specifics of various industries and identifying the best solutions for clients.The best part about my career has been the opportunity to share my knowledge and pass it on to colleagues and friends. I love creating video tutorials, doing one-on-one coaching, and organizing training sessions for businesses.In my spare time, I am into video compositing and writing. The time offline I prefer to spend hanging out with friends, hiking, skiing, or reading a nice fantasy book.

Udemy

View courses Udemy

Students take courses primarily to improve job-related skills.Some courses generate credit toward technical certification. Udemy has made a special effort to attract corporate trainers seeking to create coursework for employees of their company.