Comprehensive financial statements forecast model
During a budget cycle at Kabam Games, the parent company mandated a five-year financial forecast, expanding the usual income statement focus to include balance sheet and cash flow statements. Attempts to meet this requirement within the existing financial planning system proved unsuccessful, and the FP&A team faced a tight one-month deadline to deliver a solution. Sven was tasked with developing a comprehensive set of financial models to meet these new demands while ensuring accuracy and alignment with Kabam’s strategy.
To address this challenge, Sven conducted a detailed analysis of Kabam’s financial statements to understand account characteristics and interdependencies. He designed and developed an integrated set of financial models, which included product-level sales forecasts feeding into P&Ls, schedules for capital investments, leases, and IFRS 15 revenue deferrals, and derived balance sheet and cash flow projections. These models were built from the ground up, ensuring consistency and precision across all financial components.
The final five-year forecast package was successfully delivered within the one-month deadline and presented to the Board of Directors. Beyond meeting the immediate mandate, these models established a foundation for enhancing Kabam’s financial planning system. This initiative demonstrated how Finance BI elevates FP&A by combining deep financial analysis, business analysis, complex modeling, and strategic foresight to resolve a business problem.
EXPERTISE
Management accounting
Financial modeling
CONTACT to learn more about this case and discuss yours.
