Question

Banks are financing acquisition projects, i.e. for Venture Capital funds. An exemplary project shows the following...

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 €
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

Homework Answers

Answer #1

Assumption: Inflation - 0%

EBIT = Revenues - Costs operational

Taxes = 30%*(EBIT-Interest operational)

PBT = EBIT - Interest operational - Taxes

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
The following Statement of Cash Receipts and Disbursements was prepared by the bookkeeper of The Anchorage...
The following Statement of Cash Receipts and Disbursements was prepared by the bookkeeper of The Anchorage Arboretum Authority. The Arboretum Authority is a component unit of the City of Anchorage and must be included in the City's financial statements. It began operations on January 1, 2020 with no outstanding liabilities or commitments and only 2 assets: (1) $15,000 cash and (2) land that it had paid $23,000 to acquire. Cash Basis 12 months Cash Receipts: Admission fees 400,000 Borrowing from...
1. Summit Energy is an alternative energy producer. Your hedge fund is interested in investing into...
1. Summit Energy is an alternative energy producer. Your hedge fund is interested in investing into the company. As an analyst, you need to estimate firm value and its price per share using the NPV method and report it to the energy portfolio manager. So far you’ve successfully forecasted its earnings for 2020-2022 (numbers are in millions). Actual earnings Forecasted earnings 2018 2019 2020 2021 2022 Revenues 25,650 24,368 25,220 26,481 26,746 Cost of goods sold 17,894 19,750 21,230 20,381...
Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion...
Use the following information on Company Y and perform pro-forma financial modeling using a planned expansion method to answers question (1) and (2). To do this assume that the percentage values with respect to sales of the (i) costs except depreciation, (ii) cash and equivalents, (iii) accounts receivable, (iv) inventories, and (v) accounts payable will stay fixed at the values corresponding for 2016. Assume also that income tax will remain at 35% of the Pretax Income. Consider Company Y. This...
Project Details The Acme Gadget Company designs and manufactures consumer gadgets. Last year, Acme began development...
Project Details The Acme Gadget Company designs and manufactures consumer gadgets. Last year, Acme began development of three prototype gadgets with the intention of bringing all three to market. However, a recent downturn in the economy has forced Acme to reconsider due to decreased consumer demand that is projected to remain low for 2-3 years. As such, Acme will bring only one of the prototypes to market. They’ve hired a consulting firm to advise which prototype to bring to market....
ACCOUNTING Compute the following transactions, for year XO. After computing them, present the Income Statement, Balance...
ACCOUNTING Compute the following transactions, for year XO. After computing them, present the Income Statement, Balance Sheet and Cash Flow Statement as of December 31 st , X0, and answer to the following questions: a) Which is the shareholders’ equity value at the end of year X0? b) What’s the financial position of the firm at the end of year X0? (Compare SHE and Liabilities) c) What’s the asset composition of the firm at the end of the year? d)...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers,...
  The following balance sheet and income statement should be used for questions #1 through #6: Kuipers, Inc. 2001 Income Statement (OMR in millions) Net sales 9,625 Less: Cost of goods sold 5,225 Less: Depreciation 1,890 Earnings before interest and taxes 2,510 Less: Interest paid 850 Taxable income 1,660 Less: Taxes 581 Net income 1,079 Addition to retained earnings 679 Dividends paid 400 Kuipers, Inc. 12/31/00 and 12/31/01 Balance Sheet (in OMR, in millions) 2000 2001 2000 2001 Cash 1,455 260...
1. It is time for Jung So Min Corp. to begin its annual budget preparation for...
1. It is time for Jung So Min Corp. to begin its annual budget preparation for its upcoming fiscal year, which ends on December 31, 2021. They are in need of temporary assistance in their accounting office, and have hired you to carry out the task of preparing the budgets. Jung So Min prepares quarterly budgets, and then from this information prepares an annual budget. To assist you in this task, Jung So Min has gathered the following information: 1)...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary...
Please answer the following Case analysis questions 1-How is New Balance performing compared to its primary rivals? How will the acquisition of Reebok by Adidas impact the structure of the athletic shoe industry? Is this likely to be favorable or unfavorable for New Balance? 2- What issues does New Balance management need to address? 3-What recommendations would you make to New Balance Management? What does New Balance need to do to continue to be successful? Should management continue to invest...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how...
Delta airlines case study Global strategy. Describe the current global strategy and provide evidence about how the firms resources incompetencies support the given pressures regarding costs and local responsiveness. Describe entry modes have they usually used, and whether they are appropriate for the given strategy. Any key issues in their global strategy? casestudy: Atlanta, June 17, 2014. Sea of Delta employees and their families swarmed between food trucks, amusement park booths, and entertainment venues that were scattered throughout what would...
Please read the article and answear about questions. Determining the Value of the Business After you...
Please read the article and answear about questions. Determining the Value of the Business After you have completed a thorough and exacting investigation, you need to analyze all the infor- mation you have gathered. This is the time to consult with your business, financial, and legal advis- ers to arrive at an estimate of the value of the business. Outside advisers are impartial and are more likely to see the bad things about the business than are you. You should...