Financial Modeling in Google Sheets

Start Free Preview

Buying via our links supports this free directory · Affiliate disclosure.
Course facts
  • Payment: Free Preview (Paid Upgrade)
  • Learning style: Self-paced, start anytime
  • Format: Text & Interactive
  • Video access: Streaming Only
  • Before you start: Intermediate Google Sheets
DataCamp details
  • Chapters: 4
Created byDataCamp
Available onDataCamp

Course Details
Learning Style

Start Anytime

Level

Intermediate

Study Mode

100% Online

Duration

Short (< 10 Hours)

Languages
Audio Language

English

Outcomes
Certificate

Certificate of Completion

Price & Terms
Pricing Model

Free Preview (Paid Upgrade)

Technical
Content Medium

Text & Interactive

Video Access

Streaming Only

Specification
Access

Subscription

SKU: financial-modeling-google-sheets Category: Tags: , , Brand:

Build cash flow, loan amortization, retirement and stock price models in Google Sheets with its FV, PV, PMT and NPER financial functions.

At a glance
Duration4 hrs
LevelIntermediate
CertificateCertificate of Completion
LanguageEnglish
Taught byErin Buchanan
AccessSubscription
Add your review
Add to wishlistAdded to wishlistRemoved from wishlist 0
Add to compare

Financial modeling in Google Sheets turns everyday money questions into spreadsheets that answer them. Those questions include how a business’s cash will move over the coming years, what a loan really costs, how much to set aside for retirement, and how far a stock price might swing. You format income statements and balance sheets, apply the time value of money with the spreadsheet’s financial functions, and simulate stock prices to see the spread of likely results.

What You Will Achieve

  • Lay out a business’s income statement and balance sheet and project its cash flow for each year ahead.
  • Work out savings goals, college costs and debt payoff with built-in financial functions and an amortization table.
  • Estimate the nest egg needed for retirement and see how withdrawals and fixed income change it over the years.
  • Gauge how much a stock’s price moves each day and chart a simulated range of where it could end up.


Program Overview

Financial Statements and Cash Flow Models

Income statements and balance sheets are formatted and totaled for each year, then linked into a cash flow model that is updated and projected forward.

  • Income statements and yearly totals
  • Balance sheets and common size statements
  • Cash flow models and forecasts

Time Value of Money and Retirement Planning

Financial functions answer savings, tuition and debt questions, and the same math drives retirement plans in real and nominal dollars.

  • FV, PV, PMT and NPER functions
  • Effective interest rates and loan amortization
  • Retirement savings and withdrawal plans
  • Fixed income estimates and stock balances

Probabilistic Stock Price Models

Past stock prices give daily returns and volatility, which feed a simple simulation of where a price could land and how likely each result is.

  • Relative price, daily return and volatility
  • Expected return and random values
  • Stock price probability tables and distribution charts

Certificate Awarded (Paid)


Job Outlook

Spreadsheet financial models like these are used in business planning, personal finance and investment analysis, wherever cash flows, loans, retirement savings or stock returns need to be projected and compared.


Our take

Good for: Google Sheets users who want to build working models for business cash flow, loans, college costs, retirement savings and stock prices.

Keep in mind: Personal finance takes up much of the course: college costs, debt payoff and two retirement plans, while business financial statements fill only the opening chapter.

Bottom line: Each chapter builds a working model in Sheets, and the last one carries the math into simulated stock prices and their probabilities.

Frequently Asked Questions

Is the course taught in Excel or Google Sheets?

Every model is built in Google Sheets with its own financial functions and referencing techniques, so the exercises are set up for Sheets rather than Excel.

How does the course model stock prices?

The final chapter turns past prices into relative prices and daily returns and finds the average return and volatility. It then uses expected return and random values to step out minimum and maximum prices, fill a probability table and graph the distribution.

Which planning scenarios do the exercises use?

The savings exercises cover doubling an investment, adding starter money, out-of-state tuition, paying for a child's college and a study year abroad. A debt reduction and loan payoff model follows, then two retirement plans built in real and in nominal dollars.

User Reviews

0.0 out of 5
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0
★★★★★
0

No reviews yet. Be the first to review this course.

There are no reviews yet.

Write your review

Reviews can only be posted by registered learners. Log in, then you will return here to post.

×

    Report this page
    Financial Modeling in Google Sheets
    Financial Modeling in Google Sheets
    LiveTalent
    Logo
    Compare items
    • Total (0)
    Compare
    0