2013 Round 1: Acquisition Financing
  • 2013 Round 1: Acquisition Financing - Page 1
  • 2013 Round 1: Acquisition Financing - Page 2
Originally published: 23/07/2018 12:49
Publication number: ELQ-80571-1
View all versions & Certificate
certified

2013 Round 1: Acquisition Financing

Excel training/competition modeling challenge from the 2013 Financial Modeling World Championships

Description
This modeling task is taken from the first round of the 2013 Modeloff financial modeling world championships.

Follow the instructions in order to complete the model and questions:

INTRODUCTION

You’ve been asked to prepare a model to forecast the performance of a multiple tranche debt facility that will be drawn by an investment fund to purchase assets. The facility is only drawn when it is needed to finance the purchasing of an asset in to the fund, and each asset purchased will map to its own tranche in the facility.

TRANCHE DETAILS

The facility is forecast to have 4 tranches. Details of each tranche are given in the attached PDF.

INTEREST BASIS AND TIMING ASSUMPTIONS

Assume that all interest is calculated on a 30/360 basis on the opening daily balance. All interest rates given are simple annual rates (not effective-annual compounding rates). All cash flows, payment dates and interest accrual dates occur on calendar quarter end dates.

Use this guide to construct a financial model to forecast the performance of the debt facility. This will allow you to then answer the questions that can be found in the attached PDF file.

Allotted time: 40 minutes

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

This Best Practice includes
1 PDF

ModelOff offers you this Best Practice for free!

read 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

Any questions on 2013 Round 1: Acquisition Financing?

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


5.0 / 5 (1 votes)

please wait...