2015 Round 2: The Price Is Right
  • 2015 Round 2: The Price Is Right - Page 1
  • 2015 Round 2: The Price Is Right - Page 2
Originally published: 18/07/2018 13:07
Publication number: ELQ-39776-1
View all versions & Certificate
certified

2015 Round 2: The Price Is Right

Excel training/competition model from the 2015 Financial Modeling World Championships

Description
This workbook is taken from the 2nd round of the 2015 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:

You have been hired by a consortium to assist with their financial modelling for an upcoming tender. The tender is a government contract to operate and maintain for 15 years an existing asset, a major water treatment facility. If successful the consortium plans to set up a new company called “OpCo” (short for Operating Company) which will carry out the contract. As part of the tender submission the consortium is required to bid the amount of revenue it would like OpCo to receive in order to operate and maintain the asset.

Your task is to:

 Model the year 1 expenses in accordance with the data below.

 Model the growth profile of the expenses over the contract life.

 Model the additional Lifecycle Costs (non-recurring one-off expenditure relating to major maintenance work).

 Back solve the necessary bid values for the revenue stream, in order to meet the consortium’s internal revenue sizing conditions.

You will probably need to build a simple Cash Flow statement of OpCo in order to complete this task. Information is provided in the attached PDF regarding the assumed expenses of OpCo, the escalation assumptions for both revenues and expenses, as well as general model assumptions. Use your model to answer the case study questions.

Allotted time: 40 minutes

Once finished, feel free to upload your model to your own dedicated author channel!

This Best Practice includes
1 PDF File

ModelOff offers you this Best Practice for free!

read for free

Add to bookmarks

Discuss

Reviews

  • Rate this PDF File Format

    Write a review

  • Vavrinec Kryzanek(last updated: 18/09/2019 12:40)

keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ModelOff

See all
keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all

Discussion feed for 2015 Round 2: The Price Is Right

The user community and author are here to help. Go ahead!

  • Guste Placardo
    Could you please send the excel version of the solved problem?
    arrow_drop_uparrow_drop_downReply reply


    5.0 / 5 (1 votes)

    please wait...