Answered step by step
Verified Expert Solution
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?
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€
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%
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
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 ...Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started