introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v...
TRANSCRIPT
![Page 1: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/1.jpg)
![Page 2: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/2.jpg)
Agenda
1 2 3
4 5 6
Introductions Context for survey Survey results
Best practices for Cash Forecasting
Q&AConclusion
![Page 3: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/3.jpg)
Introduction
![Page 4: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/4.jpg)
Introduction
![Page 5: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/5.jpg)
Context for Survey
![Page 6: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/6.jpg)
Limitations of Cash Forecasting – Myth or Reality?
Time consuming
• Processing - Data collection/Data entering
• No time left for actual process (too many spreadsheets?)
Prone to human error
• One typo can make your whole forecast wrong
• Lack of proper review/No proper version control
Exposed to continuity & key man risk
• Having multiple people building your forecast, the risk of unrealistic forecasts will grow
• Numbers can get lost
![Page 7: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/7.jpg)
Corporate Debt now 9.8Trn or 40% of net worth. Too high?
Too Much Debt – When forecasting becomes important
![Page 8: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/8.jpg)
• Manufacturing (28%)• Retail (12%)• Technology (11%)• Transportation & Distribution (10%)• Energy 7%• …
• CFO (35%)• Controller (16%)• Treasurer (12%)• Treasury Director (5%)• Treasury Manager (3%)• …
10+ Job titles
14+ Industries
From $50 million tomore than $6 billion
• < = $50 million (35%)• $50 - 250 million (24%)• > $6 billion (11%)• $1 - 2 billion (8%)• $250 - 500 million (8%)• …
225 Respondents
Context for Survey
![Page 9: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/9.jpg)
Cash Forecasting remains a challenge - Example
RedEnvelope lose more than a quarter of their value
Due to a budgeting error that resulted in an overestimation of gross margins.
![Page 10: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/10.jpg)
Cash Forecasting remains a challenge - Example
Companies Are Finding More Accounting Flubs
“An uptick in financial restatements from public companies through the first half of the year could derail a decadelong streak of improvements”
– Sept 20, 2018
![Page 11: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/11.jpg)
Cash Forecasting remains a challenge - Example
University of Toledo Loses $2.4 Million in Projected Revenue
Lessons learned: Future-looking financial statements should have extra scrutiny and review. User training would also help prevent these formula-based errors.
![Page 12: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/12.jpg)
Cash Forecasting remains a challenge - Example
Westpac jumps the Gun on Profit
Profit were embedded in a template of last year's results and were accessible with minor
manipulation of the spreadsheet.
![Page 13: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/13.jpg)
Cash Forecasting remains a challenge - Example
Fannie Mae Discovers $1.3 Billion "Honest" Mistake
Lesson learned: When billions are at stake, it's best to have a financial peer review the documentation.
![Page 14: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/14.jpg)
Survey Results
![Page 15: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/15.jpg)
1. Cash forecasting remains the top issue
2. Time is money
3. Processing against the clock
4. A TMS is not made for Cash Forecasting
5. No proper reward structure based on cash flow
Top 5 findings
![Page 16: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/16.jpg)
What is the most important issue for your company over the next year?
Cash forecasting remains the top issue
![Page 17: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/17.jpg)
Ma
jor
go
als
Cash Forecasting Process
Working Capital Management process
• Analyzing operational
cash flow (+ / - )
• Funding subsidiary needs
• Meeting targets
• Freeing up working capital
• Determining requirements for
external financing
• Providing targets for working
capital improvements
![Page 18: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/18.jpg)
Do you use Excel Spreadsheets for the following tasks?Preparation
How are your forecasts prepared?
![Page 19: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/19.jpg)
Do you use Excel Spreadsheets for the following tasks?
Optimizing cash streams in a complex environment
![Page 20: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/20.jpg)
What are the limitations of using spreadsheets to perform?
Optimizing cash streams in a complex environment
![Page 21: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/21.jpg)
What financial systems are used when performing the following functions?
A TMS is not made for Cash Forecasting
![Page 22: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/22.jpg)
Staff
How many FTE are involved in the activities below (average)?
What percentage of staff resources above are spent on the following financial activities?
![Page 23: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/23.jpg)
What percentage of staff resources are spent on creating/updating cash forecasts?
Processing against the clock
![Page 24: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/24.jpg)
Which metrics below does your company use and which ones are used to reward its business units?
No proper reward structure based on cash flow
![Page 25: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/25.jpg)
Best Practicesfor Forecasting
![Page 26: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/26.jpg)
ERP
¥$€
£
Multi - Entity
Multi - Bank
Complex ERP
Multi - Currency$
ERP
ERP
Cash Management in global & complex businesses is challenging
![Page 27: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/27.jpg)
01 02 03 04 05 06
Understand your working capital drivers
Understand your cash flow drivers Define your Cash
forecasting horizons
Define your Cash forecasting sources per time horizon
Integrate and consolidate the data
Define your cash forecast logic / assumptions /Metrics
Effective cash flow forecasting in 6 steps
![Page 28: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/28.jpg)
Effective cash flow forecasting in 6 steps
![Page 29: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/29.jpg)
Integration with different bank statement formats
Short-term forecast:Purchase orders,Purchase invoices, Vendor master data
Other sources
Input & Mgmt of Non-ERP data
Cash projections, purchase budgets
Treasury flows
Payment runs, historicals …
Projects, Capex, Payroll, Taxes, Direct Debits (Rent, Leasings…)
Banks
Throughour available
ERP connectors(plug & play)
Our platform
Data sources
Analysis & Simulations
Refresh• daily of ad-hoc• incremental or full
ERP
(With audit trail in case of manual input)
(from TMS or managed through Cashforce)
• short vs. long term• forecast vs. actuals• forecast vs. forecast• what-if scenarios
Bank Balances (CODA & manual updates payment layer)
Smart forecasting logicSmart algorithms that make your cash
forecast really accurate.
(Excel, Business Warehouses,...)
05Define clear system relationships to consolidate the process
![Page 30: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/30.jpg)
Conclusion
![Page 31: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/31.jpg)
1. Cash forecasting remains the top issue
2. Best practice requires an integrated approach to forecasting
3. Look beyond classic TMS for Cash Forecasting
4. Form strategic partnerships : CFO/FP&A/Treasury => single version of truth
5. Create a reward structure based on cash flow
Conclusion
![Page 32: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/32.jpg)
Q&A
![Page 33: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/33.jpg)
Q&A?
Want to learn more?
Schedule a demo at
www.cashforce.com
or reach out to us at
![Page 34: Introduction · do you use excel spreadsheets for the following tasks? &uhdwh uhfrq floh frq v rolg dwhg fdv k srv lwlrq &roohfw fuhdwh fdv k iruhfdv w p dnh frp sdulv rq v wr dfwx](https://reader036.vdocuments.us/reader036/viewer/2022081606/5e9e4c3bea94041525688d0a/html5/thumbnails/34.jpg)
Stay connected
/Cashforce
@Cashforce
Bruce Lynn
Nicolas Christiaen
@Nicolas_Chri
Mark O'Toole
@MarkDOToole
www.cashforce.comhttp://www.thefecg.com/