OpenCourser brand icon
Sign in
We may earn an affiliate commission when you visit our partners.

Financial Modelling, Financial Planning and DCF Valuation

Michael Olafusi

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life.

This is a fully hands-on course that will take you from a blank Excel file to creating a robust, dynamic and fully automated financial model that can be used for a startup or an existing company. It also prepares you for the Advanced Financial Modeler (AFM) certification.

It covers the following sections:

Read more

We do regular live support sessions to give a more enriching experience and help you align what you are learning with career growth. Enroll now to get this benefit for life.

This is a fully hands-on course that will take you from a blank Excel file to creating a robust, dynamic and fully automated financial model that can be used for a startup or an existing company. It also prepares you for the Advanced Financial Modeler (AFM) certification.

It covers the following sections:

  • Financial Model template creation and Excel tips

  • Fleshing out a dedicated Model Input sheet to aggregate all the client's plans

  • Creating scenarios Optimistic, Conservative, Pessimistic that will flow dynamically into the entire financial statements forecast

  • Creating the Revenue Schedule

  • Creating the Cost of Sales Schedule

  • Creating the Working Capital Schedule

  • Creating the Depreciation Schedule

  • Creating the Debt Schedule

  • Creating the Equity Schedule

  • Creating the Tax Schedule

  • Creating the Income Statement dynamically

  • Creating the Balance Sheet dynamically

  • Creating the Cashflow Sheet dynamically

  • Carrying out the DCF Valuation

  • Computing the Financial Ratios

Enroll now

What's inside

Learning objectives

  • How to build financial models from scratch
  • Build financial models for startups
  • Build financial models for existing companies
  • Do dcf valuation
  • Create beautiful, robust, scalable and real-world financial model templates

Syllabus

How to create from a blank Excel file, a very beautiful, robust, scalable and comprehensive financial model template
Introduction: Financial Modelling, Financial Planning and DCF Valuation
Read more
Important Information on Extensive Support and Live Virtual Sessions
Creating the Financial Model template from scratch - part 1
Creating the Financial Model template from scratch - part 2
Creating the Financial Model template from scratch - part 3
You will learn to create the sheets for the client to provide his plans and the inputs into the financial model
Model Inputs and Financial Plans - part 1
Model Inputs and Financial Plans - part 2
Model Inputs and Financial Plans - part 3
Model Inputs and Financial Plans - part 4
Model Inputs and Financial Plans - part 5

This quiz is to help establish that you thoroughly understand the importance of having a dedicated input sheet and ensuring all plans are captured there.

Create the traditional 3 cases scenarios (Optimistic/Best case, Conservative/Base case, Pessimistic/Worst case). Make them dynamic and professional looking.
Model Scenarios - part 1
Model Scenarios - part 2
Model Scenarios - part 3
Model Scenarios - part 4

Helping you remember the need for the Scenarios sheet

How to create the Financial Model revenue schedule from the Model Inputs and Scenario sheets, factoring in the selected scenario (Optimistic/Conservative/Pessimistic)
Revenue Schedule
How to create the Financial Model cost of sales schedule from the Model Inputs and Scenario sheets, factoring in the selected scenario (Optimistic/Conservative/Pessimistic)
Cost of Sales Schedule
How to create the Financial Model working capital schedule from the Model Inputs, Revenue and Cost of Sales sheets, factoring in the selected scenario (Optimistic/Conservative/Pessimistic)
Working Capital Schedule
How to create the Financial Model depreciation schedule from the Model Inputs in a dynamic way to factor in CapEx changes (in both value and timing)
Depreciation Schedule - part 1
Depreciation Schedule - part 2
How to create the Financial Model debt schedule from the Model Inputs in a dynamic way to factor in new loans and changes in both amount and timing.
Debt Schedule
How to create the Financial Model equity schedule from the Model Inputs in a dynamic way to factor in new equity injection or buyback and changes in both amount and timing.
Equity Schedule
How to create the tax schedule with ability to factor in difference in government tax computation (timing of Capex spread) and changes in deferred tax.
Tax Schedule
How to create the Income Statement from scratch linking to the necessary schedules in a dynamic way.
Income Statement - part 1
Income Statement - part 2
Income Statement - part 3
How to create the Balance Sheet from scratch linking to the necessary schedules in a dynamic way.
Balance Sheet - part 1
Balance Sheet - part 2
Balance Sheet - part 3
How to create the Cshflow Statement from scratch linking to the necessary schedules in a dynamic way.
Cashflow Statement - part 1
Cashflow Statement - part 2
Cashflow Statement - part 3
Cashflow Statement - part 4
How to create the DCF Valuation from scratch: extracting the unlevered free cash flow (UFCF), computing the WACC and the Enterprise Value.
DCF Valuation - part 1
DCF Valuation - part 2
DCF Valuation - part 3
DCF Valuation - part 4
DCF Valuation - part 5
WACC Calculation Update
How to compute the important financial performance ratios.
Financial Ratios - part 1
Financial Ratios - part 2

Good to know

Know what's good
, what to watch for
, and possible dealbreakers
Prepares learners for the Advanced Financial Modeler (AFM) certification, which can help them demonstrate their skills and knowledge to employers
Begins with a blank Excel file and guides learners through creating a financial model, which is ideal for those with limited prior experience
Teaches how to build financial models for startups and existing companies, which can help them make informed decisions about their businesses
Covers the creation of various financial schedules, including revenue, cost of sales, working capital, depreciation, debt, equity, and tax schedules
Explores DCF valuation, which is a core skill for finance professionals who need to assess the value of investments and companies
Requires the use of Microsoft Excel, which may require learners to purchase a license if they do not already have access

Save this course

Save Financial Modelling, Financial Planning and DCF Valuation to your list so you can find it easily later:
Save

Activities

Be better prepared before your course. Deepen your understanding during and after it. Supplement your coursework and achieve mastery of the topics covered in Financial Modelling, Financial Planning and DCF Valuation with these activities:
Review Accounting Principles
Reinforce your understanding of fundamental accounting principles to better grasp the construction of financial statements within the models.
Browse courses on Financial Accounting
Show steps
  • Review key accounting concepts like accruals and matching.
  • Practice preparing basic journal entries.
  • Analyze sample financial statements.
Excel Shortcuts and Functions Practice
Improve your Excel proficiency by practicing essential shortcuts and functions used in financial modeling.
Show steps
  • Create a list of common Excel shortcuts.
  • Practice using functions like VLOOKUP, INDEX, MATCH, and SUMIFS.
  • Time yourself completing tasks using only shortcuts.
Read "Financial Modeling & Valuation: A Practical Guide to Investment Banking and Private Equity"
Study a comprehensive guide to financial modeling to gain a deeper understanding of valuation techniques and industry best practices.
View Financial Modeling and Valuation: A Practical... on Amazon
Show steps
  • Read the chapters on DCF valuation and financial statement modeling.
  • Work through the example models provided in the book.
  • Compare the book's approach to the methods taught in the course.
Four other activities
Expand to see all activities and additional details
Show all seven activities
Document Your Modeling Assumptions
Improve model transparency and communication by creating a detailed document outlining your key assumptions.
Show steps
  • Identify the key assumptions in your financial model.
  • Write a clear and concise explanation of each assumption.
  • Justify your assumptions with data and reasoning.
  • Organize your assumptions into a well-formatted document.
Model a Publicly Traded Company
Apply your financial modeling skills by building a DCF model for a real-world company.
Show steps
  • Choose a publicly traded company to model.
  • Gather the company's financial statements (10-K and 10-Q reports).
  • Build a DCF model based on the company's financials and your assumptions.
  • Analyze the results and compare your valuation to the company's market capitalization.
Read "Investment Valuation: Tools and Techniques for Determining the Value of Any Asset"
Study a comprehensive guide to investment valuation to gain a deeper understanding of valuation techniques and industry best practices.
View Investment Valuation, University Edition: Tools... on Amazon
Show steps
  • Read the chapters on DCF valuation and relative valuation.
  • Work through the example valuations provided in the book.
  • Compare the book's approach to the methods taught in the course.
Sensitivity Analysis Dashboard
Enhance your model's usability by creating a dashboard that allows users to easily perform sensitivity analysis on key assumptions.
Show steps
  • Identify the key drivers of your model's valuation.
  • Create input cells for these drivers in your Excel model.
  • Use data tables or other Excel tools to perform sensitivity analysis.
  • Create charts and graphs to visualize the results of the sensitivity analysis.

Career center

Learners who complete Financial Modelling, Financial Planning and DCF Valuation will develop knowledge and skills that may be useful to these careers:
Financial Analyst
A financial analyst uses financial models to evaluate a company's performance, project future results, and inform investment decisions. This course, with its focus on building financial models from scratch, provides a strong foundation for the core responsibilities of a financial analyst. The methods taught in this course, such as creating dynamic income statements, balance sheets, cash flow, and DCF valuation, are essential skills for a financial analyst. The course's hands-on approach is particularly relevant, as a financial analyst needs to be adept at building and using these models in practice. The financial model templates created in the course directly translate into the kind of work a financial analyst would perform. The course's sections on revenue, cost of sales, working capital, depreciation, debt, equity, and tax schedules, are all necessary competencies for a financial analyst role. Also, its live support sessions can help connect what they learn with career growth.
See salaries and explore the career path for Financial Analyst
Investment Banking Analyst
An investment banking analyst is responsible for building complex financial models to appraise companies, analyze potential mergers, and assess capital raising. This course, with its comprehensive hands-on approach to creating dynamic financial models, is tremendously helpful for anyone aspiring to be an investment banking analyst. The course content, that covers topics such as revenue and cost of sales schedules creation, working capital, depreciation, debt, equity, and tax schedules, prepares you for the tasks that investment banking analyst need to execute. Additionally, the course's detailed focus on DCF valuation and the generation of financial ratios are all applicable skills of an investment banking analyst. The focus on creating various scenarios, like optimistic, conservative, and pessimistic allows an investment banking analyst to improve their understanding of the uncertainty of financial forecasting. An investment banking analyst needs to be able to create similar models for a variety of real-world scenarios, and this course helps prepare them for this.
See salaries and explore the career path for Investment Banking Analyst
Corporate Finance Analyst
A corporate finance analyst is responsible for financial planning and analysis within a company, often involving the creation of financial models for budgeting, forecasting, and strategic decision-making. The detailed and comprehensive methods taught in this course can help considerably in the work of a corporate finance analyst. The course will help an aspiring corporate finance analyst to gain competencies in creating dynamic financial statements such as income statements, balance sheets, and cash flow statements, which are frequently used by corporate finance analysts. Learning to build models with varying scenarios is essential to analyze different strategic outcomes that can be a very useful skill for a corporate finance analyst. The course's focus on automated models is beneficial as it teaches efficient processes. The course's focus on real-world financial model templates is helpful for any corporate finance analyst, as they often need to create presentations and models for their organization.
See salaries and explore the career path for Corporate Finance Analyst
Equity Research Analyst
An equity research analyst analyzes financial information, builds financial models, and creates reports to make recommendations on publicly traded stocks. This course provides a strong base for the work of an equity research analyst by focusing on the creation of comprehensive financial models and DCF valuation. An equity research analyst must be able to evaluate financial information and build models, which is made easier by the course's hands-on approach. The course provides the skillset to build income statements, balance sheets and cash flow statements, which are essential abilities for an equity research analyst. Also, the course goes in depth into subjects such as revenue, cost of sales, working capital, depreciation, debt, equity and tax schedules which will be valuable for an equity research analyst. The training on creation of financial ratios and scenarios will boost an equity research analyst's ability to evaluate companies.
See salaries and explore the career path for Equity Research Analyst
Financial Consultant
A financial consultant provides financial advice and guidance to clients, often including financial model creation as part of the service. This course, with its focus on creating robust and dynamic financial models, provides a crucial foundation for a successful financial consultant. The course's hands-on approach to building financial models, including creating various scenarios, is very useful for a financial consultant. Also, the detailed focus on all the key components of financial models, and the skills to create income statements, balance sheets, and cash flow statements will be highly relevant to the work of a financial consultant. Being able to do DCF valuation is a critical skill that this course provides to potential financial consultant. The financial model templates and the training included in the course will make it easier for a financial consultant to quickly create robust client solutions.
See salaries and explore the career path for Financial Consultant
FP&A Analyst
A Financial Planning and Analysis analyst, or FP&A Analyst, uses financial modeling to inform budgeting, forecasting, and strategic planning within a company. This course, designed to teach how to build financial models, helps a great deal in the essential tasks of a FP&A analyst. The course covers the creation of financial statements like income statements, balance sheets, and cash flow statements, skills that are directly used by FP&A analysts. The course's emphasis on dynamic scenarios is invaluable when developing forecasts for the future, which is a frequent duty for a FP&A analyst. The course's focus on real-world templates is especially useful for a FP&A analyst to quickly build financial models for a range of projects. Furthermore, the course's section on financial ratios is a valuable tool for evaluating an organization's performance, a useful ability for any FP&A analyst.
See salaries and explore the career path for FP&A Analyst
Valuation Analyst
A valuation analyst specializes in determining the economic value of companies, assets, or securities, often relying heavily on financial modeling and Discounted Cash Flow analysis. This course, with its focus on DCF valuation and the creation of financial models, is ideal to help you start a career as a valuation analyst. The course's content has sections on building financial model templates, creating revenue and cost of sales schedules, and dynamic financial statements. These are critical skills for a valuation analyst. Additionally, the course’s emphasis on creating scenarios and calculating financial ratios builds a foundation for the tasks that valuation analyst perform. The practice in the course of creating a DCF valuation from scratch is particularly relevant, as this is a key responsibility for a valuation analyst. The preparation for the Advanced Financial Modeler (AFM) certification will help a valuation analyst demonstrate their expertise.
See salaries and explore the career path for Valuation Analyst
Private Equity Analyst
A private equity analyst evaluates potential investment opportunities, often involving extensive financial modeling and valuation analysis. This course, focused on creating comprehensive and dynamic financial models, can be very helpful for a career as a private equity analyst. The course covers the key aspects of financial modeling that a private equity analyst requires, including the creation of income statements, balance sheets, and cash flow statements. In addition, the course covers creating scenarios, which is incredibly useful for a private equity analyst when evaluating the risk and reward of an investment. The course's focus on DCF valuation is also relevant, since this is often used in private equity to determine an investment's true value. A private equity analyst must be able to perform these types of calculations, and this course will provide a good training ground.
See salaries and explore the career path for Private Equity Analyst
Financial Planner
A financial planner helps individuals manage their finances, create budgets, and plan for their future. While this course is focused on corporate finance and modeling, the skills it teaches such as financial planning, building models, and scenarios might be useful to a financial planner. The course covers how to create a financial model template from scratch, which helps a financial planner's ability create financial forecasts and scenarios. The course's coverage of income statements, balance sheets, and cash flow statements can help a financial planner to quickly create such models. This course also touches on financial planning which is essential to a financial planner. The course's live support sessions may help a financial planner connect their learning with career growth.
See salaries and explore the career path for Financial Planner
Management Consultant
A management consultant advises organizations on how to improve their performance and efficiency. This may include developing financial models and creating financial forecasts. This course may be useful to help develop some of the skills that a management consultant uses. The course's hands-on approach to creating dynamic financial models and the focus on real-world settings may be beneficial skills for a management consultant. The course's focus on building financial statements, such as income statements, balance sheets, and cash flow statements from scratch can help build a foundation for any management consultant. Also, the skills to create scenarios and financial ratios may be helpful when analyzing an organization's performance in a management consultant role. A management consultant may find the course helpful for situations involving financial analysis.
See salaries and explore the career path for Management Consultant
Business Analyst
A business analyst works to understand an organization's needs or challenges and propose solutions. This might include using financial models to assess feasibility. This course may be helpful for a business analyst who needs to understand financial information and models. The course provides knowledge about creating financial models dynamically, and helps build familiarity with financial statements such as income statements, balance sheets, and cash flow statements. These skills may be useful when a business analyst needs to make a financial assessment of a business. The course's sections on revenue, cost of sales, working capital, depreciation, debt, equity, and tax schedules, may also be helpful to a business analyst .
See salaries and explore the career path for Business Analyst
Project Manager
A project manager is responsible for the planning, execution, and closing of projects. This course may be useful for a project manager when they are working on projects that depend on financial forecasts. The course's detailed approach to financial modeling, including the creation of revenue and cost of sales schedules, and working capital, may be beneficial for a project manager working on a project that involves financial analysis. A project manager may also find value in the course's training on creating financial statements, which includes income statements, balance sheets and cash flow statements. The course may help familiarize a project manager with the process of constructing a DCF valuation.
See salaries and explore the career path for Project Manager
Entrepreneur
An entrepreneur may create their own startup or business. This course may help an entrepreneur build financial models to determine their financial needs. This course focuses on creating financial models for startups and existing companies. The course covers many of the schedules needed to create complete financial models, such as revenue, cost of sales, working capital, depreciation, debt, equity and tax schedules. The course also teaches how to make different scenarios, like optimistic, conservative and pessimistic. The course's instruction on DCF valuation may be useful for determining the valuation of a business. The course will be valuable to an entrepreneur looking to properly model their business.
See salaries and explore the career path for Entrepreneur
Accountant
Accountants prepare and examine financial records to ensure accuracy and compliance. This course may help an accountant who needs to understand financial modeling techniques and financial analysis. The course's focus on generating financial statements such as income statements, balance sheets, and cash flow statements may prove useful to an accountant. The methods taught in the course for creating revenue and cost of sales schedules, working capital, depreciation, debt, equity, and tax schedules may be helpful to an accountant who needs more in depth training in financial modeling. Also, the course's focus on creating financial ratios may help an accountant who is tasked with financial analysis.
See salaries and explore the career path for Accountant
Real Estate Analyst
A real estate analyst assesses the financial viability of real estate investments. While this course is focused on general corporate financial modeling, a real estate analyst may find some of the concepts useful. The course's training on how to create financial models and how to perform DCF valuation may be relevant for a role as a real estate analyst. The course's sections on how to create income statements, balance sheets, and cash flow statements may provide a useful understanding of the financial metrics. The course's training on how to create a financial ratio may be helpful when analyzing the financial health of a prospective investment.
See salaries and explore the career path for Real Estate Analyst

Reading list

We've selected two books that we think will supplement your learning. Use these to develop background knowledge, enrich your coursework, and gain a deeper understanding of the topics covered in Financial Modelling, Financial Planning and DCF Valuation.
Cover image
Investment Valuation, University Edition
Save
Comprehensive guide to valuation techniques, covering a wide range of assets and industries. It provides a detailed explanation of DCF valuation, relative valuation, and contingent claim valuation. It valuable resource for understanding the theoretical underpinnings of valuation. This book is commonly used as a textbook at academic institutions.
Investment Valuation, University Edition: Tools and...
Kindle Edition
$$$
Cover image
Financial Modeling and Valuation
Save
Provides a comprehensive guide to financial modeling techniques used in investment banking and private equity. It covers topics such as DCF valuation, LBO modeling, and merger modeling. It valuable resource for understanding the practical application of financial modeling concepts. This book is commonly used by industry professionals.
Financial Modeling and Valuation: A Practical Guide...
Hardcover
$$$
Financial Modeling and Valuation: A Practical Guide...
Audible Audiobook
$$
Financial Modeling and Valuation: A Practical Guide...
Kindle Edition
$$$

Share

Help others find this course page by sharing it with your friends and followers:
Facebook
LinkedIn
Reddit
X
Link
Email

Similar courses

Similar courses are unavailable at this time. Please try again later.
Effort
6.5 total hours
Via
Udemy
Instructor
Michael Olafusi
Language
English
Good to know
Prepares learners for the Advanced Financial Modeler (AFM) certification, which can help them demonstrate their skills and knowledge to employers
Begins with a blank Excel file and guides learners through creating a financial model, which is ideal for those with limited prior experience
Teaches how to build financial models for startups and existing companies, which can help them make informed decisions about their businesses
Covers the creation of various financial schedules, including revenue, cost of sales, working capital, depreciation, debt, equity, and tax schedules
Explores DCF valuation, which is a core skill for finance professionals who need to assess the value of investments and companies
Requires the use of Microsoft Excel, which may require learners to purchase a license if they do not already have access
Share and help others discover this course.
Facebook LinkedIn X Reddit Link Email
Don't miss out
Enroll today to gain access to this course
Enroll in this course
Our mission

OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.

Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.

Find this site helpful? Tell a friend about us.

Affiliate disclosure

We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.

Your purchases help us maintain our catalog and keep our servers humming without ads.

Thank you for supporting OpenCourser.

© 2016 - 2025 OpenCourser