Udemy
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
  •  
Development
Web Development Data Science Mobile Development Programming Languages Game Development Database Design & Development Software Testing Software Engineering Development Tools No-Code Development
Business
Entrepreneurship Communications Management Sales Business Strategy Operations Project Management Business Law Business Analytics & Intelligence Human Resources Industry E-Commerce Media Real Estate Other Business
Finance & Accounting
Accounting & Bookkeeping Compliance Cryptocurrency & Blockchain Economics Finance Finance Cert & Exam Prep Financial Modeling & Analysis Investing & Trading Money Management Tools Taxes Other Finance & Accounting
IT & Software
IT Certification Network & Security Hardware Operating Systems Other IT & Software
Office Productivity
Microsoft Apple Google SAP Oracle Other Office Productivity
Personal Development
Personal Transformation Personal Productivity Leadership Career Development Parenting & Relationships Happiness Esoteric Practices Religion & Spirituality Personal Brand Building Creativity Influence Self Esteem & Confidence Stress Management Memory & Study Skills Motivation Other Personal Development
Design
Web Design Graphic Design & Illustration Design Tools User Experience Design Game Design Design Thinking 3D & Animation Fashion Design Architectural Design Interior Design Other Design
Marketing
Digital Marketing Search Engine Optimization Social Media Marketing Branding Marketing Fundamentals Marketing Analytics & Automation Public Relations Advertising Video & Mobile Marketing Content Marketing Growth Hacking Affiliate Marketing Product Marketing Other Marketing
Lifestyle
Arts & Crafts Beauty & Makeup Esoteric Practices Food & Beverage Gaming Home Improvement Pet Care & Training Travel Other Lifestyle
Photography & Video
Digital Photography Photography Portrait Photography Photography Tools Commercial Photography Video Design Other Photography & Video
Health & Fitness
Fitness General Health Sports Nutrition Yoga Mental Health Dieting Self Defense Safety & First Aid Dance Meditation Other Health & Fitness
Music
Instruments Music Production Music Fundamentals Vocal Music Techniques Music Software Other Music
Teaching & Academics
Engineering Humanities Math Science Online Education Social Science Language Teacher Training Test Prep Other Teaching & Academics
AWS Certification Microsoft Certification AWS Certified Solutions Architect - Associate AWS Certified Cloud Practitioner CompTIA A+ Cisco CCNA Amazon AWS AWS Certified Developer - Associate CompTIA Security+
Photoshop Graphic Design Adobe Illustrator Drawing Digital Painting InDesign Character Design Canva Figure Drawing
Life Coach Training Neuro-Linguistic Programming Mindfulness Personal Development Personal Transformation Meditation Life Purpose Coaching Neuroscience
Web Development JavaScript React CSS Angular PHP WordPress Node.Js Python
Google Flutter Android Development iOS Development Swift React Native Dart Programming Language Mobile Development Kotlin SwiftUI
Digital Marketing Google Ads (Adwords) Social Media Marketing Google Ads (AdWords) Certification Marketing Strategy Internet Marketing YouTube Marketing Email Marketing Retargeting
SQL Microsoft Power BI Tableau Business Analysis Business Intelligence MySQL Data Analysis Data Modeling Big Data
Business Fundamentals Entrepreneurship Fundamentals Business Strategy Online Business Business Plan Startup Freelancing Blogging Home Business
Unity Game Development Fundamentals Unreal Engine C# 3D Game Development C++ 2D Game Development Unreal Engine Blueprints Blender
30-Day Money-Back Guarantee

This course includes:

  • 4 hours on-demand video
  • 1 article
  • 115 downloadable resources
  • Full lifetime access
  • Access on mobile and TV
Finance & Accounting Financial Modeling & Analysis Company Valuation

Financial Modeling: Build a Complete DCF Valuation Model

The Ultimate Guide to Company Valuation For Aspiring Investment Bankers and Corporate Finance Practitioners
Bestseller
Rating: 4.5 out of 54.5 (3,157 ratings)
18,807 students
Created by 365 Careers
Last updated 11/2020
English
English [Auto], French [Auto]
30-Day Money-Back Guarantee

What you'll learn

  • Be able to build a Cash Flow statement
  • Know how to value a company
  • Be able to build a Valuation model from scratch
  • Know how to create a model with multiple scenarios
  • Be able to perform sensitivity analysis
  • Know how to create professional and good-looking advanced charts
Curated for the Udemy for Business collection

Requirements

  • Basic Microsoft Excel knowledge
  • A high level of concentration
  • Basic understanding of Financial Statements

Description

Would you like to learn how to value a company?

Even people who don't have a Finance degree can take this course and learn how to build a complete Discounted Cash Flow Model! 

Attention! You will have to go through the videos and the course materials in order to obtain the promised result! 

If you want to:

  • Improve your Microsoft Excel modeling skills

  • Learn how to value a company

  • Understand what drives a company's value

Then this is the right course for you!

What we offer:

  • Well designed and easy to understand materials

  • Detailed and comprehensible explanations

  • Regular course updates

By the completion of this course you will:

  • Be able to build a Cash Flow statement

  • Know how to value a company

  • Be able to build a Valuation model from scratch

  • Know how to create a model with multiple scenarios

  • Be able to perform sensitivity analysis

  • Know how to create professional and good-looking advanced charts

The instructor of this course has extensive experience in Financial Modeling:

  • Worked in the Financial advisory unit of a top-tier consulting firm

  • Experience in M&A transactions carried out in Italy, Germany, Switzerland and Poland

  • Worked in the in-house Mergers & Acquisitions department of one of the largest semiconductor firms in the world

  • Financial advisor in multiple M&A deals with sizes ranging from €2 million up to €5 billion

++++++++++++++++++++++++++++++++++++++++++++++++++++++

About the course:

  • An unconditional Udemy 30 day money-back guarantee – because we believe in the quality of our content

  • No significant previous experience is needed in order to understand the course well and benefit fully from its content

  • Unlimited access to all course materials

  • Emphasis on learning by doing

  • You can always contact us for any clarification free of charge

  • Our goal is to take your Valuation skills to the next level

Make an investment that will pay for itself in terms of career perspectives, positive feedback and personal growth. 

Just go ahead and subscribe to this course! Nowadays the job market has become very competitive. If you don't acquire these skills now you will miss an opportunity to separate yourself from others. Don't risk your future success! 

Let's start learning together now! 

Who this course is for:

  • Aspiring Investment Bankers
  • Graduates who pursue a career in Corporate Finance
  • Professionals who would like to deepen their Valuation skills

Course content

11 sections • 76 lectures • 4h 14m total length

  • Preview01:36
  • Company valuation - Theoretical framework
    10 pages
  • The investor's perspective
    03:12
  • What drives a firm's value?
    01:57

  • Calculating Unlevered free cash flows
    04:33
  • Using an appropriate discount factor
    03:58
  • Estimating cost of debt
    00:55
  • Preview04:41
  • Forecasting future cash flows
    02:31
  • Caclulating Terminal value
    02:24
  • Discounting future cash flows
    01:44
  • Calculating Enterprise and Equity value of the firm
    01:10

  • Preview01:03
  • Preview06:34
  • Let's go through the structure of the DCF model we will create in Excel
    02:57
  • A glimpse at the company we are valuing - Cheeseco
    01:11

  • Modeling the top line of the financial model
    03:56
  • This is how you can build flexible financial models in Excel
    02:16
  • Modeling other items: Other revenues and Cogs
    03:51
  • Modeling other items: Operating expenses and D&A
    02:27
  • Modeling other items: Interest expenses, Extraordinary Items and Taxes
    02:43

  • How to forecast balance sheet items - The practical and easy to understand way
    00:42
  • A key concept for finance practitioners - the "Days" methodology
    01:34
  • Preview01:20
  • How to use "Days" in order to project the future development of some BS items
    02:22
  • Forecasting Property, plant & equipment, Other assets and Other liabilities
    02:21

  • Excel best practices! Create a good-looking and clean output sheet in your model
    02:36
  • Applying what we learned in practice - Populating the P&L sheet
    02:29
  • This is how you can create a clean output Balance Sheet in your financial model
    01:53
  • Completing the Output BS Sheet For the Historical Period
    03:43

  • Learn how to calculate unlevered free cash flows
    03:18
  • Important! Reconcile UFCF to Net Cash flow
    01:53
  • A very useful lesson! Learn how to calculate cash flows
    06:38
  • Preview03:57
  • The fast and effective way to modify multiple cell references in Excel
    04:01

  • Introducing weighted average cost of capital and perpetuity growth rate
    01:55
  • Learn how to find the present value of future cash flows in financial models
    02:59

  • Calculating continuing value and enterprise value of the business
    02:21
  • Final steps! Calculate equity value of the business under consideration
    01:27

  • Excel tools in practice - sensitivity analysis for WACC and perpetuity growth
    04:40
  • Excel tools in practice - An application of Goal Seek
    01:41
  • Recap of the financial model with charts and hypothesis testing
    04:27
  • Congratulations! You made it!
    02:06
  • Introduction to Mergers & Acquisitions
    15 pages

Instructor

365 Careers
Creating opportunities for Business & Finance students
365 Careers
  • 4.5 Instructor Rating
  • 373,656 Reviews
  • 1,276,598 Students
  • 68 Courses

365 Careers is the #1 best-selling provider of finance courses on Udemy. The company’s courses have been taken by more than 1,000,000 students in 210 countries. People working at world-class firms like Apple, PayPal, and Citibank have completed 365 Careers trainings.  

Currently, the firm focuses on the following topics on Udemy:  

1) Finance – Finance fundamentals, Financial modeling in Excel, Valuation, Accounting, Capital budgeting, Financial statement analysis (FSA), Investment banking (IB), Leveraged buyout (LBO), Financial planning and analysis (FP&A), Corporate budgeting, applying Python for Finance, Tesla valuation case study, CFA, ACCA, and CPA

2) Data science – Statistics, Mathematics, Probability, SQL, Python programming, Python for Finance, Business Intelligence, R, Machine Learning, TensorFlow, Tableau, the integration of SQL and Tableau, the integration of SQL, Python, Tableau, Power BI, Credit Risk Modeling, and Credit Analytics

3) Entrepreneurship – Business Strategy, Management and HR Management, Marketing, Decision Making, Negotiation, and Persuasion, Tesla's Strategy and Marketing

4) Office productivity – Microsoft Excel, PowerPoint, Microsoft Word, and Microsoft Outlook

5) Blockchain for Business

All of the company’s courses are:  

Pre-scripted  

Hands-on  

Laser-focused  

Engaging  

Real-life tested  

By choosing 365 Careers, you make sure you will learn from proven experts, who have a passion for teaching, and can take you from beginner to pro in the shortest possible amount of time.  

If you want to become a financial analyst, a finance manager, an FP&A analyst, an investment banker, a business executive, an entrepreneur, a business intelligence analyst, a data analyst, or a data scientist, 365 Careers’ courses are the perfect place to start. 

  • Udemy for Business
  • Teach on Udemy
  • Get the app
  • About us
  • Contact us
  • Careers
  • Blog
  • Help and Support
  • Affiliate
  • Terms
  • Privacy policy
  • Cookie settings
  • Sitemap
  • Featured courses
Udemy
© 2021 Udemy, Inc.