ç

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

JTI

Risk Management Series (30 articles)

£55

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

£139

Add to cart