Stage 4 (2023) “Phone Bill Analysis”

This is an actual case study that was presented to the participants of the Financial Modeling World Cup 2023, Stage 4 (June 9-12).

Case description:

Finovo, a sales business operating in multiple countries, is reviewing its corporate mobile phone contract and wants to model the expected cost of different proposals. Historical call data from 2022 is provided, and the objective is to determine the costs for each proposal based on call types, roaming charges, and vendor pricing options. The analysis will help Finovo’s procurement team make an informed decision regarding the contract.

The downloadable file consists of the following:
–Task: PDF file with Case Materials; PDF file with Questions; Excel file with Assumptions
–Solution: Excel file with full Solution Model; PDF file with correct Answers in Bold