Originally published: 18/07/2018 14:42
Publication number: ELQ-77878-1
View all versions & Certificate
Publication number: ELQ-77878-1
View all versions & Certificate
2014 Round 2: Time is Money
Excel training/competition model from the 2014 Financial Modeling World Championships
by Full Stack ModellerTo help finance professionals transform their Excel, financial modelling, data visualisation & analytics skillsFollow 75
financial modelingm&aacquisitionsfinancial statementsexcel skillsexcel trainingfinancial modeling trainingfinancial modeling competition
Description
This workbook is taken from the 2nd round of the 2014 Modeloff financial modeling world chamionships.
Follow the instructions in order to complete the model:
INTRODUCTION
You work in the business development team of ETech, a technology company that primarily operates out of Europe and prepares its financial statements in Euros.
ETech has a comprehensive corporate model that you use to analyse the impact of any potential acquisitions. The corporate model is prepared in Euros on a nominal basis therefore any acquisition analysis needs to be converted to nominal Euros to correctly interface with the corporate model. ETech has been approached by JL Goodward, a well-known investment banking firm on behalf of their client GEE, a conglomerate. GEE is looking to divest its technology division and has put a sale process in place. Your mangers and board of directors are excited by the prospect of acquiring GEE’s technology division and have requested entry into the sales process. With all the legal formalities out of the way, JL Goodward sends you an Information Memorandum (‘IM’) to assist you with preparing your Indicative Bid. In the IM you have been provided with management’s forecast performance of the business. The forecast includes sales, opex and capex in real US$ and the opening balance of the two classes of tax assets in US$.
You are instructed to ignore all other assets and liabilities for the purpose of preparing your Indicative Bid. Furthermore you are instructed to make the following assumptions:
• GEE’s effective tax rate is 40%. Tax is calculated on the last day of the year and paid immediately. Corporate tax will continue to be payable within the US.
• That all cash flows (Sales, Opex, Capex etc) happen on the last day of the year.
• Depreciation for Tax and Accounting is done using:
o For Class A assets, the double declining balance method over 5 years.
o For Class B assets, the straight line method over 4 years. Assume the opening balance has not yet been depreciated and will be depreciated over 4 years starting in 2015.
In order to prepare your bid, you have talked to your tax advisors, investment committee and ETech’s management. Based on these discussions, you have settled on the following assumptions relevant to your valuation:
• There are no cross border implications from the acquisition;
• You will discount pre financing, post-tax nominal US$ cash flows using a 10% rate in order to value the assets as at 31 December 2014;
• The spot exchange rate as at the valuation date will be 1.31 US$ per 1 Euro;
• You are provided with a real US$:Euro exchange rate and told that it has been calculated as a notional exchange rate that can be used to convert directly between real US$ and real Euro.
Hint: Do not use these rates to directly convert between nominal US$ and nominal Euro.
• You have formed a view on inflation for both the US$ and Euro, included in the provided workbook.
Allotted time: 35 minutes
Once finished, feel free to upload your model to your own dedicated author channel!
This workbook is taken from the 2nd round of the 2014 Modeloff financial modeling world chamionships.
Follow the instructions in order to complete the model:
INTRODUCTION
You work in the business development team of ETech, a technology company that primarily operates out of Europe and prepares its financial statements in Euros.
ETech has a comprehensive corporate model that you use to analyse the impact of any potential acquisitions. The corporate model is prepared in Euros on a nominal basis therefore any acquisition analysis needs to be converted to nominal Euros to correctly interface with the corporate model. ETech has been approached by JL Goodward, a well-known investment banking firm on behalf of their client GEE, a conglomerate. GEE is looking to divest its technology division and has put a sale process in place. Your mangers and board of directors are excited by the prospect of acquiring GEE’s technology division and have requested entry into the sales process. With all the legal formalities out of the way, JL Goodward sends you an Information Memorandum (‘IM’) to assist you with preparing your Indicative Bid. In the IM you have been provided with management’s forecast performance of the business. The forecast includes sales, opex and capex in real US$ and the opening balance of the two classes of tax assets in US$.
You are instructed to ignore all other assets and liabilities for the purpose of preparing your Indicative Bid. Furthermore you are instructed to make the following assumptions:
• GEE’s effective tax rate is 40%. Tax is calculated on the last day of the year and paid immediately. Corporate tax will continue to be payable within the US.
• That all cash flows (Sales, Opex, Capex etc) happen on the last day of the year.
• Depreciation for Tax and Accounting is done using:
o For Class A assets, the double declining balance method over 5 years.
o For Class B assets, the straight line method over 4 years. Assume the opening balance has not yet been depreciated and will be depreciated over 4 years starting in 2015.
In order to prepare your bid, you have talked to your tax advisors, investment committee and ETech’s management. Based on these discussions, you have settled on the following assumptions relevant to your valuation:
• There are no cross border implications from the acquisition;
• You will discount pre financing, post-tax nominal US$ cash flows using a 10% rate in order to value the assets as at 31 December 2014;
• The spot exchange rate as at the valuation date will be 1.31 US$ per 1 Euro;
• You are provided with a real US$:Euro exchange rate and told that it has been calculated as a notional exchange rate that can be used to convert directly between real US$ and real Euro.
Hint: Do not use these rates to directly convert between nominal US$ and nominal Euro.
• You have formed a view on inflation for both the US$ and Euro, included in the provided workbook.
Allotted time: 35 minutes
Once finished, feel free to upload your model to your own dedicated author channel!
This Best Practice includes
1 Excel Workbook, 1 PDF
