Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

DataCamp

Financial Modeling in Excel

via DataCamp

Overview

DataCamp Flash Sale:
50% Off - Build Data and AI Skills!
Grab it
Learn about Excel financial modeling, including cash flow, scenario analysis, time value, and capital budgeting.

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!

Syllabus

  • 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.
  • 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.
  • 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.
  • 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.

Taught by

Nick Edwards

Reviews

4.3 rating at DataCamp based on 18 ratings

Start your review of Financial Modeling in Excel

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.