2025 SOA Valuation Actuary Meeting: Session 9F: Spreadsheet Spread Thin? Time For Open Source-08.20.26 Recording

A deep dive into utilizing open-source tools for cash flow projection or valuation tasks when Excel and vendor software may not be the right fit. Speakers will cover common concerns about open-source tooling, a real-world example of Excel at its limits, a walkthrough of building a valuation engine in Python, performance comparisons of multiple languages and implementation approaches, and perspectives on using open-source tooling in the real world. Attendees will learn the pros and cons of open-source tools, when incorporating these tools might make sense, ways to get started, and gain exposure to advanced topics like profiling and optimization, concurrency, and adding a graphical user interface.