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

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

チャプターを開始

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.

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

チャプターを開始

Probabilistic 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

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

チャプターを開始

Google Sheetsで学ぶファイナンシャル・モデリング

コース完了

修了証明書を取得

この修了書をLinkedInや履歴書、CVに追加しましょう
ソーシャルメディアや人事評価で共有しましょう今すぐ登録

Google Sheetsで学ぶファイナンシャル・モデリング

チームのトレーニングを担当していますか？

コース説明

前提条件

What are Models?

Time Value Money Models

Planning and Investing Models

Probabilistic Models

修了証明書を取得

19百万人を超える学習者と共にGoogle Sheetsで学ぶファイナンシャル・モデリングを始めましょう！

DataCamp for Mobileでデータスキルを磨きましょう

コース説明

修了証明書を取得

.css-nklxlk{color:var(--wf-brand--main, #03EF62);}19百万人を超える学習者と共にGoogle Sheetsで学ぶファイナンシャル・モデリングを始めましょう！

無料アカウントを作成

DataCamp for Mobileでデータスキルを磨きましょう

19百万人を超える学習者と共にGoogle Sheetsで学ぶファイナンシャル・モデリングを始めましょう！