From the course: Excel: Learning Cash Flow Forecasting
Join today to access over 24,600 courses taught by industry experts.
Identifying sources of historical financial data
From the course: Excel: Learning Cash Flow Forecasting
Identifying sources of historical financial data
- [Lecturer] Let's begin the cash flow forecasting process. One of the first steps we need to take is to explore historical financial information. This is my go-to information request and the rationale I have for asking what I do. Historical income statements, balance sheets, and cash flows. These provide a historical view of revenue, expenses, and profitability, balances that I'll likely want to forecast, and cash movements. It helps me understand financial performance and anomalies or irregularities that I might need to question. It allows me to see trends from the past that can inform future cash flow projections. General ledgers and trial balances. These contain detailed transaction records that can clarify revenue patterns, expense fluctuations, and cash disbursements. I may not be able to see this from the top level financial statements. Audited financial statements. If they're available, audited financials ensure reliability as they've been independently verified by third…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.