Course
Financial Modeling in Excel
IntermediateSkill Level
Updated 04/2026ExcelApplied Finance3 hr9 videos28 Exercises2,200 XP24,943Statement of Accomplishment
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Loved by learners at thousands of companies
Training 2 or more people?
Try DataCamp for BusinessCourse Description
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!
Prerequisites
Data Preparation in ExcelData Analysis in Excel1
Financial modeling
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.
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.
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.
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.
Financial Modeling in Excel
Course Complete
Earn Statement of Accomplishment
Add this credential to your LinkedIn profile, resume, or CVShare it on social media and in your performance reviewEnroll Now
FAQs
What foundational financial concepts will I learn in this course?
You will start with the fundamentals of cash flow analysis, constructing financial models, calculating net income, and deconstructing income statements. These foundational concepts will provide a strong base for the rest of the course.
What practical skills will I gain from this course?
By the end of the course, you will possess practical skills in constructing financial models, conducting cash flow analysis, performing scenario and sensitivity analyses, calculating the time value of money, and making capital budgeting decisions.
Will this course cover advanced financial analysis techniques?
You will learn to forecast different outcomes and conduct sensitivity analyses using Excel's functionalities, enabling you to assess various financial scenarios and their potential impacts.
Join over 19 million learners and start Financial Modeling in Excel today!
Create Your Free Account
or
By continuing, you accept our Terms of Use, our Privacy Policy and that your data is stored in the USA.Grow your data skills with DataCamp for Mobile
Make progress on the go with our mobile courses and daily 5-minute coding challenges.