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 Sheets 建立穩健的商業與財務模型。 Google Sheets 以其多功能性著稱，是建立詳細商業模型的絕佳工具。 它讓您能夠為各種財務目標建立明確的架構，例如追蹤投資成長，並可利用即時數據隨時更新這個架構。 本課程的導言將為您說明課程內容與學習目標，讓您清楚了解在本課程中可以學到什麼知識並達成哪些成就。
</p>

<h2>核心建模技術</h2>
<p>
    本課程深入探討商業建模的基礎，特別強調現金流、投資、年金、貸款攤還以及退休規劃等關鍵面向。 您將學習支撐這些金融概念的基本原則，為建立與解讀模型打下堅實的基礎。 本課程旨在協助您掌握必要的知識，了解在商業情境中，不同財務變數如何相互影響與作用。
</p>

<h2>Sheets 進階函數與應用</h2>
<p>
    隨著課程進行，您將學習 Google Sheets 更進階的功能，重點介紹在建立複雜模型時不可或缺的引用與函數技巧。 您將學習如何運用這些功能，以提升模型的準確性與效率。 在本課程結束時，您不僅將徹底了解商業與財務建模的理論基礎，還能掌握運用 Google Sheets 將這些概念應用於實際情境的實作技能。 這項實作經驗將對您的職業與個人財務規劃都帶來無價的幫助。
</p>

Intermediate Google Sheets

使用Google試算表學習商業建模基礎，專注現金流、投資、年金、貸款攤銷及退休儲蓄。

在 Google Sheets 進行財務建模

掌握基本商業建模：現金流、投資、年金、貸款攤還等，並運用 Google Sheets 實作。

財務基礎 在 Google Sheets 中

Complete loan model

在 Google Sheets 進行財務建模

練習說明

動手互動練習