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

4 Hours13 Videos52 Exercises
13,462 Learners

or

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

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.

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.

In the following tracks

Collaborators

Erin 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