Video Tutorial: Excel Modules 11 & 12

Two modules in one video. Work through them in order.

Quick Answer

What Do Excel Modules 11 and 12 Cover?

Excel Modules 11 and 12 explain how to calculate the present and future value of money and test how different assumptions affect an investment outcome. They cover Excel functions such as PV, FV and NPV, along with best-case, base-case and worst-case scenarios and sensitivity tables. These skills help investors compare opportunities, identify the variables that matter most and make decisions under uncertainty.

Module 11: Time Value of Money Module 12: Scenario and Sensitivity Analysis
Excel Modules 11 & 12: Complete
Module 11

Time Value of Money

  • Why a dollar today is worth more than tomorrow
  • Present value and future value calculations
  • Using PV, FV, and NPV functions in Excel
  • Applying TVM concepts to investment decisions
Module 12

Scenario and Sensitivity Analysis

  • Building best, base, and worst case scenarios
  • Using data tables for sensitivity testing
  • Identifying which variables drive the most impact
  • Presenting analysis results clearly

💡 Tips for This Video

  • Have Excel open and follow along as you watch
  • Pause after each concept and try it yourself before moving on
  • In Module 12, build your own scenario table using a real investment or business example
AI Robot

Ask Our AI Stock
Learning Assistant

Get instant educational answers about
stocks, investing, and StockEducation.com.

Instant Answers Built With Learners

Educational support only. Not personal financial advice. AI responses may contain errors.

Powered by AI ●

The Ultimate Investing Starter Guide

Free Stock Market
Investing Guide

A beginner friendly guide that covers the essential lessons and concepts every new investor should understand.

Subscription Form

Inside You'll Learn

Stocks & How They Work
Valuation Basics
Compound Interest
Index Funds & Diversification
Warren Buffett Principles
AI Stock Research & More
20+ Pages
of Value
Instant
Download
100% Free
No Strings