Building an In house Solution to Cash-Flow-at-Risk

While some companies will spend tens of thousands of dollars on a vendor solution to compute Cash-Flow-at-Risk, JTI (Japan Tobacco International) has implemented a low-cost, in-house solution using Excel. Vincent Delort, Risk and Reporting Manager at the company, shares the inside track on the project – including the precise Excel formulae used.

Key Points

  • VaR vs CFaR: at a glance
  • Honing the methodology
  • Useful formulae
  • Monte Carlo method
  • Translating formulae into Excel

Written by

Vincent Delort


Risk Management Series (30 articles)


Add to cart

Every case study in this series is also included in our Unlimited Case Studies collection. Get the full story with access to all case studies on TMI Academy for just


Add to cart