Financial Modeling in Google Sheets
Build cash flow, loan amortization, retirement and stock price models in Google Sheets with its FV, PV, PMT and NPER financial functions.
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.
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.


There are no reviews yet.