Skip to main content

Financial Modeling in Spreadsheets

Learn basic business modeling including cash flows, investments, annuities, loan amortization, and more using Sheets.

Start Course for Free
4 Hours13 Videos52 Exercises12,723 Learners

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.

Loved by learners at thousands of companies

Course Description

Have you ever wanted to plan for retirement, understand the stock market, or create a cash flow for your business? In this course, you will learn how to build business and financial models in Sheets. Google Sheets is an excellent technology for business models! You can create a framework for your goal, like understanding the growth of investments, and then update that framework based on current data. You will learn the basics of business modeling focusing on cash flows, investments, annuities, loan amortization, and saving for retirement. By the end of the course, you will have gained referencing and function skills in Sheets that you can apply to all sorts of models.
  1. 1

    What are Models?

    Free

    An introduction to modeling financial statements in Sheets focusing on balance and income statements, which help create cash flow models.

    Play Chapter Now
    How to love models
    50 xp
    Format the income statement
    100 xp
    Create the sum values
    100 xp
    Copy sums for each year
    100 xp
    Continuing simple models with balance sheets
    50 xp
    Format a balance statement model
    100 xp
    Balance all the years
    100 xp
    Common size statement
    100 xp
    Build a cash flow model
    50 xp
    Update the cash flow
    100 xp
    Complete cash flow for all years
    100 xp
    Forecast Cash Flows
    100 xp
  2. 2

    Time Value Money Models

    Learn Sheet's financial model functions by creating investment models with the fv, pv, pmt, and nper functions. You will also learn how to pay off debts in a loan amortization table.

    Play Chapter Now
    Value functions
    50 xp
    Estimate effective interest rates
    100 xp
    How much will I earn?
    100 xp
    Double your money
    100 xp
    Growing your money
    50 xp
    Out-of-state tuition
    100 xp
    Add some starter money
    100 xp
    Can your child pay for college?
    100 xp
    Study abroad for a year
    100 xp
    Reducing your debt
    50 xp
    Start the loan amortization table
    100 xp
    Where did your money go?
    100 xp
    Complete loan model
    100 xp
  3. 3

    Planning and Investing Models

    Saving for retirement is tricky, but in this chapter, you will learn how to create models that help you plan to save and use your money after retirement.

    Play Chapter Now
    Retirement planning in real dollars
    50 xp
    What's your nest egg?
    100 xp
    How much do you need to pay?
    100 xp
    Finish and visualize
    100 xp
    Retirement planning in nominal dollars 1
    50 xp
    Update yearly values
    100 xp
    Add the estimate of fixed income
    100 xp
    Break down the stock balance
    100 xp
    Retirement planning in nominal dollars 2
    50 xp
    Add withdrawals and money made
    100 xp
    Calculate total year-end
    100 xp
    How much initial money?
    100 xp
  4. 4

    Probabilistic Models

    Stock prices go up and down but can we model them? Learn about volatility and simulating stock prices in this final chapter.

    Play Chapter Now
    Living with uncertainty
    50 xp
    Relative price and daily return
    100 xp
    What is the average return?
    100 xp
    Find volatility
    100 xp
    A simple stock model
    50 xp
    Expected return and random values
    100 xp
    Certainty and uncertainty
    100 xp
    Uncertainty charted
    100 xp
    Stock probabilities
    50 xp
    Stepping out the expected return
    100 xp
    Create the steps for min and max stock prices
    100 xp
    What is the most likely stock price?
    50 xp
    Model stock price probability
    100 xp
    Complete the probability table
    100 xp
    Graph the stock distribution
    100 xp

In the following tracks

Finance Fundamentals in Spreadsheets

Collaborators

Chester Ismay
Amy Peterson

Prerequisites

Intermediate Spreadsheets
Erin Buchanan HeadshotErin Buchanan

Professor at Harrisburg University of Science and Technology

Dr. Erin Buchanan is a Professor at Harrisburg University of Science and Technology where she teaches a variety of statistics courses, data science skills, and natural language processing. Her research focuses on applied statistics, the use and misuse of statistics, and computational linguistics. She runs a statistics YouTube channel channel and an associated website for everyone to improve their skills.
See More

What do other learners have to say?

    Join over 11 million learners and start Financial Modeling in Spreadsheets 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.