Build a cash flow model

Financial Modeling in Google Sheets

Erin Buchanan

Professor

Parts of a cash flow statement

• Operating: Day-to-day expenses, inventory, products
• Investing: Buying and selling property/equipment, securities, investing
• Financing: Paying and borrowing money

Forecast next year

= 2018 cell * (1 + Forecast Cell)

Create your first cash flow!

Financial Modeling in Google Sheets