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

How to love models

Format the income statement

Create the sum values

Copy sums for each year

Continuing simple models with balance sheets

Format a balance statement model

Balance all the years

Common size statement

Build a cash flow model

Update the cash flow

Complete cash flow for all years

Forecast Cash Flows

What are 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. 

Value functions

Estimate effective interest rates

How much will I earn?

Double your money

Growing your money

Out-of-state tuition

Add some starter money

Can your child pay for college?

Study abroad for a year

Reducing your debt

Start the loan amortization table

Where did your money go?

Complete loan model

Time Value Money 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. 

Retirement planning in real dollars

What's your nest egg?

How much do you need to pay?

Finish and visualize

Retirement planning in nominal dollars 1

Update yearly values

Add the estimate of fixed income

Break down the stock balance

Retirement planning in nominal dollars 2

Add withdrawals and money made

Calculate total year-end

How much initial money?

Planning and Investing Models

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

Living with uncertainty

Relative price and daily return

What is the average return?

Find volatility

A simple stock model

Expected return and random values

Certainty and uncertainty

Uncertainty charted

Stock probabilities

Stepping out the expected return

Create the steps for min and max stock prices

What is the most likely stock price?

Model stock price probability

Complete the probability table

Graph the stock distribution

 Probabilistic Models

您是否想过为退休做规划、理解股市，或为您的企业制作现金流？在本课程中，您将学习如何在 Sheets 中构建商业与金融模型。Google Sheets 是进行商业建模的理想工具！您可以先为目标搭建框架，例如理解投资的增长，然后根据最新数据更新该框架。您将学习商业建模的基础，重点涵盖现金流、投资、年金、贷款摊还以及退休储蓄。课程结束时，您将掌握在 Sheets 中的引用与函数技能，能够应用到各类模型中。

<p>
    你是否曾想过为退休做规划、了解股市，或为你的企业制定现金流？这门全面的课程将引导你掌握使用 Google 表格构建稳健的商业和财务模型的全过程。 因其多功能性，Google 表格是创建详细商业模型的绝佳工具。 它使您能够为各种财务目标建立清晰的框架，例如跟踪投资增长，并使您能够使用实时数据更新这一框架。 本入门部分将为您介绍在本课程中可以学到什么以及能够取得什么成果。
</p>

<h2>核心建模技术</h2>
<p>
    这门课程深入讲解商业建模基础，重点聚焦现金流、投资、年金、贷款摊还以及退休规划等关键内容。 您将了解支撑这些金融概念的基本原理，为构建和解读模型打下坚实基础。 本部分旨在帮助您掌握必要的知识，了解不同财务变量在商业环境中如何相互作用并彼此影响。
</p>

<h2>Sheets中的高级函数与应用</h2>
<p>
    随着你的学习进展，课程将介绍 Google 表格的更多高级功能，重点讲解构建复杂模型所必需的引用和函数技能。 您将学习如何利用这些功能来提高模型的准确性和效率。 在本课程结束时，您不仅将全面理解商业和财务建模的理论方面，还将掌握使用 Google 表格将这些概念应用于现实场景的实用技能。 这种实践经验将在您的职业和个人财务规划中都极具价值。
</p>

Intermediate Google Sheets

使用Google表格学习商业建模基础，专注于现金流、投资、年金、贷款摊销和退休储蓄。

Google Sheets 金融建模

使用 Google Sheets 学习基础商业建模，包括现金流、投资、年金、贷款摊销等。

金融基础知识 在 Google 表格中

Find volatility

Google Sheets 金融建模

练习说明

动手互动练习