Cash Flow Forecast and KPI Dashboard: Full Walkthrough (Excel and Google Sheets)
SheetSmartTemplateCo
0:00 / 0:00
Cash Flow Forecast and KPI Dashboard: Full Walkthrough (Excel and Google Sheets)
4 просмотра · 2 дн. назад
SheetSmartTemplateCo
4 подписчика
4 просмотра · 2 дн. назад
A full, tab-by-tab walkthrough of the Cash Flow Forecast and KPI Dashboard spreadsheet from SheetSmart Template Co. See exactly what you get and how to use every tab before you buy.
🛒 Get it on Etsy: https://www.etsy.com/listing/4601521189
📂 All templates: https://www.etsy.com/shop/SheetSmartT...
✅ Works in Microsoft Excel and Google Sheets
✅ Sample-data version + blank ready-to-use version
✅ Yellow cells = you type, everything else calculates
✅ Instant digital download
Chapters
0:00 Intro
0:30 Guide & FAQ
0:40 Setup
1:11 Cash Flow Forecast
1:38 Receivables
2:04 Payables
2:27 13-Week Cash Flow
2:54 Actuals
3:07 Actual vs Forecast
3:25 AR & AP Aging
3:52 KPI Data
4:19 KPI Scorecard
4:35 Dashboard
5:17 Scenarios
5:46 Runway Calculator
6:09 Quarterly Summary
6:34 Where to get it