Financial Modelling, Financial Planning and DCF Valuation from Udemy

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

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

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

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.

Helping you remember the need for the Scenarios sheet

Traffic lights

Read about what's good

what should give you pause

and possible dealbreakers

Prepares learners for the Advanced Financial Modeler (AFM) certification, demonstrating its alignment with industry standards and professional development goals

Begins with a blank Excel file and guides learners through creating a fully automated financial model, making it suitable for those with basic Excel skills

Covers creating various financial schedules, including revenue, cost of sales, working capital, depreciation, debt, equity, and tax, providing a comprehensive understanding of financial modeling

Requires learners to use Microsoft Excel, which may require a separate purchase or subscription for those who do not already have access

Explores creating optimistic, conservative, and pessimistic scenarios, which allows learners to understand the sensitivity of financial models to different assumptions

Teaches DCF valuation, which is a core skill for finance professionals involved in investment analysis and corporate finance

Reviews summary

Comprehensive financial modeling and valuation

According to students who would ideally review this course, given its strong focus on practical skills, learners say this course provides a highly practical and hands-on approach to building financial models from scratch in Excel. It covers the entire process from inputs to financial statements and DCF valuation. Many likely find the step-by-step guidance and the focus on creating robust, dynamic, and scalable templates particularly valuable for career development. The emphasis on real-world application and preparation for certifications like AFM is a significant plus. Potential learners should note it requires dedication and possibly some prior Excel familiarity.

Learning to create different scenarios.

"Creating optimistic, conservative, and pessimistic scenarios dynamically was a powerful takeaway."

"Being able to switch scenarios easily in the model is crucial for planning."

"Understanding how scenarios flow through the financials is clearly explained."

Helpful for certification exam prep.

"The course content aligns well with the AFM certification topics."

"I feel much better prepared for the AFM exam after taking this."

"Focuses on the practical Excel skills tested in the AFM."

Skills are directly applicable to jobs.

"The methods taught here are exactly what I need for my job."

"I can immediately use these templates for startup or existing company valuations."

"This training feels directly relevant to financial analyst roles."

Covers full financials and DCF valuation.

"This course covered all the schedules needed to build integrated financial statements."

"Learning to build the Income Statement, Balance Sheet, and Cash Flow dynamically was key."

"The DCF valuation section clearly explained UFCF, WACC, and enterprise value calculations."

Practical, step-by-step modeling in Excel.

"Building the models from a blank sheet really solidified my understanding."

"I appreciated the detailed walkthroughs for each schedule (revenue, costs, debt, etc.)."

"The focus on dynamic linking between sheets was very helpful for building robust models."

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

Show steps

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

Show steps

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"

Show steps

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

Show steps

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

Show steps

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"

Show steps

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

Show steps

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