2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
  • 2017 Finals: Funding Fun
Originally published: 05/07/2018 12:28
Publication number: ELQ-52260-1
View all versions & Certificate
certified

2017 Finals: Funding Fun

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

Description
This workbook is taken from the Finals of the 2017 Modeloff financial modeling world chamionships.

Follow the instructions in order to complete the model:

You are an analyst helping your company prepare its purchase bid for the 30-year concession of a Stateowned infrastructure asset that has been put up for sale. You have been provided the outline of a
financing model which includes 10 scenarios of Inputs, and 10 scenarios of Operating Cash Flow taken from a colleague’s forecast operations model.

For each of the Input scenarios, most assumption values have been provided, but one or two from each
scenario will need to be solved for to find the optimal value, subject to the other values provided.

The values that may need to be solved for are:
• First Debt Repayment Date
• Sculpted DSCR
• Debt Drawdown amount
• Equity Investment amount
• Required Rate of Return (also known as the Equity IRR)

Your task will be to build the necessary additions to the model so that it can identify the Optimal missing
values for the selected scenario.

Questions 1 to 20 are based on the provided input scenarios.
Questions 21 to 23 may require you to change some of the existing user-variable input values from certain
scenarios in order to answer.

Allotted time: 80 minutes

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

This Best Practice includes
1 excel workbook & 1 pdf

ModelOff offers you this Best Practice for free!

download for free

Add to bookmarks

Discuss

Reviews


keyboard_arrow_leftkeyboard_arrow_right

More Best Practices from ModelOff

See all
keyboard_arrow_leftkeyboard_arrow_right

Related categories


See all

Discussion feed for 2017 Finals: Funding Fun

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

  • Yuchao (Alex) Chen
    Q2 I got only 66,692 instead of 66,949. Any suggestion what's missing?
    arrow_drop_uparrow_drop_downReply reply
    • Yuchao (Alex) Chen
      After including the interest on cash balance into the CFADS, it improves to 66,899 but still short of 50 to the answer...
      arrow_drop_uparrow_drop_downReply reply


    5.0 / 5 (3 votes)

    please wait...