Question
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 the 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 rate of 10% p.a., collateralized by the shares of 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 $-5.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 the a reasonable assumption for your subsequent calculation. Please calculate the planned annual profitability of the VC funds 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 $ |
Dept capital | 180$ |
Term debt | 4 years bullit repayment |
Annual debt accrual | 45.0 $ |
Interest rate | 10.0% |
Tax rate | 30 % |
Target company | 2020 | 2021 | 2022 | 2023 | 2024 | 2025 |
Revenues | 150.0 | |||||
Costs operational | -110.0 | |||||
EBIT | 40.0 | |||||
Interest operational | -6.0 | |||||
Taxes | -10.2 | |||||
PBT | 23.8 |
Step by Step Solution
There are 3 Steps involved in it
Step: 1
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