DCF – Company Valuation Model with Excel Templates

Focused View

Arda Yanik@ProjePark-Workshop

2:10:35

12 View

1. Introduction

1. Welcome - Course Introduction.mp4

02:12

2. How you can valuate a company.mp4

02:25

3. Company valuation approaches.mp4

02:50

4. When you need company valuation.mp4

01:25

2. DCF Model Terminology

1. Section Overview.mp4

01:03

2. What is Discounted Cash Flow Model.mp4

02:15

3. Time value of money.mp4

01:53

4. Free Cash Flow.mp4

02:56

5. Part 1 - WACC - Discount Rate.mp4

01:15

6. Make assumptions about raising 100K USD for your App Development Company.html

7. Part 2 - WACC - Discount Rate.mp4

03:49

8. How you can use WACC for an investment decision.html

9. Part 3 - WACC - Discount Rate.mp4

03:49

10. Terminal Value & Terminal Growth Rate.mp4

02:20

11. Break Even Point.mp4

02:18

3. Statement Components of DCF

1. Section Overview.mp4

02:18

2.1 Lecture-15-Income-Statement.xlsx

2. Income Statement.mp4

27:33

3.1 Lecture-16-CAPEX-Depreciation.xlsx

3. CAPEX & Depreciation.mp4

09:35

4.1 Lecture-17-Balance-Sheet.xlsx

4. Balance Sheet.mp4

17:47

5.1 Lecture-18-Cash-Flow-Statement.xlsx

5. Cash Flow Statement.mp4

13:40

4. DCF Excel for Company Valuation

1. Section Overview.mp4

00:57

2.1 Lecture-20-Using-metrics-from-3-financial-statements.xlsx

2. Using metrics from 3 financial statements.mp4

06:46

3.1 Lecture-21-EBITDA-Multiple-Method.xlsx

3. EBITDA Multiple Method.mp4

01:55

4.1 Lecture-22-Perpetual-Growth-Method.xlsx

4. Perpetual Growth Method.mp4

02:43

5.1 Lecture-23-Equity-Value-Calculation-with-DCF.xlsx

5. Equity Value calculation with DCF.mp4

06:31

6.1 Lecture-24-DCF-What-if-Analysis.xlsx

6. DCF What if Analysis.mp4

03:27

5. Additional Content Pitch Deck and Investment Meetings

1. Section Overview.mp4

02:01

2. Investor Meeting Part1 Who are you.mp4

00:53

3. Investor Meeting Part2 What you want from investors.mp4

00:55

4. Investor Meeting Part3 What is the problem you are solving.mp4

00:40

5. Investor Meeting Part4 How you will use the fund.mp4

00:28

6. Investor Meeting Part5 Return of Investment.mp4

00:31

6. Conclusion

1. Congratulations and Final Words.mp4

01:25

Description

Learn financial modeling techniques with fundamental analysis to value a company and design 3 Financial Statements

What You'll Learn?

You can learn basic terminology of financial modeling and company valuation methods
You can valuate your company without any prior financial background
You can use Excel for designing a Discounted Cash Flow Analysis Template
You can learn the structure of the Pitch Decks and Investor Meetings

Who is this for?

Newly Graduates and Students with different backgrounds, who wants to learn about company valuation

Entrepreneurs

Co Founders

Managers

Anyone who would like to learn basic terminology of DCF Valuation Model

What You Need to Know?

No financial background needed, basic understanding of Excel is a plus to follow up the course content.

More details

Description
Welcome to â€œDCF â€“ Company Valuation Model for Beginners Courseâ€
This course is designed for students who want to learn company valuation methods especially Discounted Cash Flow Model.
I have 20 years of experience in project management and business development background, and with the help of my entrepreneurship skills I designed this course to solve your common problems:
Â· How you can learn the basic terminology of financial modeling and company valuation methods?
Â· How you can value your company without any prior financial background?
Â· How you can use Excel for designing a Discounted Cash Flow Analysis Template?
Â· How you can learn the structure of the Pitch Deck and Investor Meetings?
In this course first of all you will learn the basic terminology of financial modeling and company valuation, you will become familiar with 3 financial statements (Income Statement, Balance Sheet, and Cash Flow Statement) the course will be based on real-life case studies and you will learn how you can design an excel template with basic formulas to valuate your company with DCF method, as additional content for this course, we will give to you some information about pitch decks and presentations.
You can also download Excel templates, modify them with your numbers and use them for your future DCF Analysis.
If you want to learn about company valuation methods and valuate your company in a simple and robust way, you are in the right place, enroll today and be ready to move your business to the next level.
Who this course is for:
Newly Graduates and Students with different backgrounds, who wants to learn about company valuation
Entrepreneurs
Co Founders
Managers
Anyone who would like to learn basic terminology of DCF Valuation Model

User Reviews

Rating

average 0

Total votes0

Focused display

I have 20 years of experience in project management and business development. I have been teaching in these fields for five years, I taught in Istanbul Bilgi University Digital Game Design Department and continue to organize courses in Istanbul Beykoz University Art and Design Faculty and ProjePark Workshop.During my professional career in ProjePark, I have been involved in dozens of game-based education and multiplayer gaming projects, one of our latest projects is called “6 Steps of a Call Game” designed for Mondelez International and is the winner of the Gold Stevie Award (Best Selling and Coaching Program of the year 2018).I am also giving business consultancy services to entrepreneurs, company owners, start-ups, and new graduates.My teaching methodologies are focusing on increasing the creativity and productivity of my students. I am happy to bring my years of experience and knowledge to those building their career in high-tech areas of the future.

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.