Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Banks are financing acquisition projects, i.e. for Venture Capital funds. An exemplary project shows the following data: A VC fund purchased the target company on

Banks are financing acquisition projects, i.e. for Venture Capital funds. An exemplary project shows the following data:
A VC fund purchased the target company on 1.1.2020 for a price of €300k at a Price/EBIT-multiple of 7.5x. 40% of the purchase price is funded by equity of the VC, remaining amount by bank loan at an interest of 10% p.a., collateralized by the shares of the target company. The loan will be repaid on 31.12.2023, accrual for loan repayment is planned pro rata annually. All cash flows related to the purchase will be pushed down into the target company’s P&L. The target company runs operationally at annual revenues of €150k in 2020, growing each upcoming year at 4%, while operational costs in 2020 are at €-110k at a future growth rate of 2% year-on-year. In 2020, EBIT is €40k. Operational interest is at €-6.0k (and will be stable for the upcoming years). Tax rate is 30%. There are no other operational P/L impacts.The VC plans to sell the company on 31.12.2025 (= after 6 years) at a Price/EBIT-multiple of 7.5x which was the same at purchase.
Please complete the financial model of the transaction based on the xls-table below. In case of lack of data, please take a reasonable assumption for your subsequent calculation. Please calculate the planned annual profitability of the VC fund and the overall internal rate of return. As the financing bank, what is your recommendation in respect to the transaction and its risks and benefits?

Transaction data
Purchase price................................ 300€
Equity............................................... 120€
Debt capital..................................... 180€

Term dept. 4 years bullet repayment
Annual debt accrual....................... 45.0€
Interest rate.................................... 10.0%
Tax rate............................................ 30%

Target company 2020, 2021, 2022, 2023, 2024, 2025
Revenues........................................ 150,0
Cost operational........................... -110,0
EBIT.................................................. 40,0
Interest operational........................ -6.0
Taxes................................................ -10,2
PBT..................................................... 23,8

Step by Step Solution

3.40 Rating (153 Votes )

There are 3 Steps involved in it

Step: 1

Assumption Inflation is taken as 0 Filling the table It is given in the question that the revenue is ... blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Global Investments

Authors: Bruno Solnik, Dennis McLeavey

6th edition

321527704, 978-0321527707

More Books

Students also viewed these Accounting questions

Question

What is your greatest strength?

Answered: 1 week ago

Question

How has technology aided inventory management?

Answered: 1 week ago

Question

Who needs to be involved in inventory decisions?

Answered: 1 week ago