Skip to main content
HomeExcel

Financial Modeling in Excel

4.3+
18 reviews
Intermediate

Learn about Excel financial modeling, including cash flow, scenario analysis, time value, and capital budgeting.

Start Course for Free
3 hours9 videos28 exercises10,026 learnersTrophyStatement of Accomplishment

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.
Group

Training 2 or more people?

Try DataCamp for Business

Loved by learners at thousands of companies


Course Description

Are you ready to dive deep into the world of financial modeling and hone your Excel skills? In this comprehensive course, you'll embark on a journey that will empower you with the knowledge and tools to excel in financial analysis.

Discover the Power of Cash Flows

Begin your journey by unraveling the intricacies of cash flows. You'll construct a financial model, calculate net income, and gain a solid understanding of what makes up an income statement. These skills will form the foundation of your financial modeling prowess.

Master Scenario Analysis Techniques

Take your modeling skills to the next level by diving into scenario analysis. You'll learn how to forecast multiple outcomes, conduct sensitivity analysis, and effortlessly manipulate growth rates using Excel's versatile tools.

Unlock the Secrets of Time Value of Money

Understand the critical concept of the time value of money and its pivotal role in decision-making. You'll calculate present and future values and apply these skills with precision.

Becoming a Capital Budgeting Pro

Empower yourself with the ability to make data-driven decisions using metrics like net present value, internal rate of return. You'll compare results against benchmarks and provide actionable recommendations that drive success in financial scenarios.

Upon completing this course, you'll be equipped with the expertise to excel in financial modeling using Excel. You'll have a deep understanding of financial concepts and the practical skills to apply them effectively. Join us on this journey and unlock your potential as a modeling master!
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.
DataCamp for BusinessFor a bespoke solution book a demo.
  1. 1

    Financial modeling

    Free

    Use financial data from an income statement to create a financial model to forecast income, expenses, and net income and evaluate the purchase and sale price of the property using dynamic modeling features.

    Play Chapter Now
    Introduction to financial modeling
    50 xp
    Revenue or expense?
    100 xp
    Financial modeling in Excel
    50 xp
    Reviewing the financials
    100 xp
    That's Cap
    100 xp
    As the years go by
    100 xp
    Exit now!
    100 xp
  2. 2

    What-if Analysis in Financial Models

    Use Excel’s What-If toolkit to enhance the power of financial modeling. Analyze and compare different hypothetical scenarios with the Scenario Manager, Goal Seek, and Data Table tools.

    Play Chapter Now
  3. 3

    Time Value of Money

    Time is money! Use the time value of money to analyze cash flows through the lens of an investor with return on investment, future value, and present value.

    Play Chapter Now
  4. 4

    Capital Budgeting

    Prioritize projects and make actionable investment recommendations using capital budgeting techniques. Calculate the net present value and the internal rate of return for the acquisition of West Ridge North.

    Play Chapter Now
For Business

Training 2 or more people?

Get your team access to the full DataCamp platform, including all the features.

datasets

Exercises and DatasetsExcel Formula Translations

collaborators

Collaborator's avatar
Carl Rosseel
Collaborator's avatar
Iason Prassides
Nick Edwards HeadshotNick Edwards

Analyst at Roofstock

Nick Edwards is an Analyst at Roofstock, a PropTech startup, where he uses data and BI tools to unlock the full strength of financial analysis. With over seven years of experience in finance, he realized honing data science skills would greatly benefit his career and believes it will for you, too!
See More

Don’t just take our word for it

*4.3
from 18 reviews
56%
28%
11%
6%
0%
Sort by
  • Hansel P.
    15 days

    essentials to start financial modeling

  • Tselote H.
    about 1 month

    I love it

  • Biase A.
    about 1 month

    *

  • David A.
    3 months

    Great lessons taught in simplicity

  • Yuli S.
    4 months

    This course helped a lot to start understanding the financial modeling as a accountant who wants to start a career in finance.

"essentials to start financial modeling"

Hansel P.

"I love it"

Tselote H.

"*"

Biase A.

FAQs

Join over 15 million learners and start Financial Modeling in Excel today!

Create Your Free Account

GoogleLinkedInFacebook

or

By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.