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.

Introduction to financial modeling

Options

Revenue

Expenses

Revenue or expense?

Financial modeling in Excel

Reviewing the financials

That's Cap

As the years go by

Exit now!

Financial modeling

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.

What-if analysis

What is what-if?

What-if analysis in financial models

Talk to my manager

Seek and you shall find

Data tables with one input variable

Two is better than one

What-if Analysis in Financial Models

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. 

The time value of money

Sorting out the future from the present

Time value of money calculations in Excel

Return on investment

Future value

Present value

Time Value of Money

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.

Introduction to Capital Budgeting

Discounting NPV

Capital budgeting in Excel

Net present value

XNPV with time series

Internal rate of return

Your final recommendation

Congratulations!

Capital Budgeting

Excel Formula Translations

Exercises and Datasets

This course is designed to transform you into a proficient financial analyst using Excel. Starting with the fundamentals of cash flow analysis, you will learn to construct financial models, calculate net income, and deconstruct income statements, laying a strong foundation in financial modeling. The course then progresses to advanced scenario analysis techniques, teaching participants to forecast different outcomes and conduct sensitivity analyses using Excel's diverse functionalities. A key component of the course is mastering the time value of money, a crucial concept in financial decision-making, where students will learn to calculate present and future values with precision. The final segment focuses on capital budgeting skills, equipping you with the ability to make data-driven decisions using key metrics like net present value and internal rate of return, and to provide actionable recommendations in various financial scenarios. By the end of the course, you will not only grasp complex financial concepts but also possess the practical skills to apply them effectively, becoming adept at financial modeling in Excel.

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.

<h2>Discover the Power of Cash Flows</h2>
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.<br><br>

<h2>Master Scenario Analysis Techniques</h2>
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.<br><br>

<h2>Unlock the Secrets of Time Value of Money</h2>
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.<br><br>

<h2>Becoming a Capital Budgeting Pro</h2>
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.<br><br>

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!


Data Preparation in Excel

Data Analysis in Excel

Enter the world of financial modeling in Excel and learn all about cash flow, scenario analysis, time value of money, and capital budgeting.

Financial Modeling in Excel

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

Reviewing the financials

Financial Modeling in Excel

Latihan interaktif praktis