Identifying where cash was being spent in real time was a key priority at Sprint Nextel, especially as its accounts payable began trending above forecast.  

While the $34 billion voice and data services provider could identify spend via its regression-based forecasting process, it could not isolate where projected overspending was occurring. "It wasn't 'show me the money' so much as show me where the money is being spent," says Jennifer Dale, assistant treasurer and director of treasury services at Sprint. "We wanted real-time visibility into where spend was occurring and how this was trending compared to the budget, rather than an analysis at month-end when the books are closed."

Dale was tasked with developing a model with a higher degree of accuracy. The goal was to take the cash forecast AP line and expand it to the business-unit level to track cash spend against the budget and forecast. Dale identified the top 10 business units by spend category, accounting for roughly 80% of total spend. Treasury then created a database utilizing a waterfall hierarchy of identification points to track expenditures in the units.

Continue Reading for Free

Register and gain access to:

  • Thought leadership on regulatory changes, economic trends, corporate success stories, and tactical solutions for treasurers, CFOs, risk managers, controllers, and other finance professionals
  • Informative weekly newsletter featuring news, analysis, real-world cas studies, and other critical content
  • Educational webcasts, white papers, and ebooks from industry thought leaders
  • Critical coverage of the employee benefits and financial advisory markets on our other ALM sites, PropertyCasualty360 and ThinkAdvisor
NOT FOR REPRINT

© 2024 ALM Global, LLC, All Rights Reserved. Request academic re-use from www.copyright.com. All other uses, submit a request to [email protected]. For more information visit Asset & Logo Licensing.