Please consider the following company financials: Amounts in min dollars Balance sheet Goodwill Tangible fixed assets...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Please consider the following company financials: Amounts in min dollars Balance sheet Goodwill Tangible fixed assets Inventories Accounts Receivable Other operating short term assets Cash Total Equity Interest bearing debt Operating provisions Accounts Payable Other operating short term liabilities Total Profit & Loss Account Revenues -Cost of goods sold Gross margin - Personnel cost -Other operating cost EBITDA -Depreciation EBITA -Amortization EBIT -Interest PBT - Taxes Net profit Equity Investment: 1194 O Enterprise value: 984.3 Equity Investment: 592.8 O Enterprise value: 987.3 31-12-18 31-12-19 31-12-20 31-12-21 31-12-22 31-12-23 31-12-24 actuals forecast forecast forecast forecast forecast forecast Equity Investment: 391.3 208 ************ 234 90 172 23 42 769 234 312 26 158 39 769 88988* 780 452 328 117 62 149 31 118 0 118 16 102 26 76 208 246 95 180 25 42 796 246 312 31 166 41 796 819 475 344 123 66 155 33 122 0 122 16 106 27 79 200 263 102 193 26 37 829 259 312 36 178 44 829 876 508 368 131 70 167 34 133 0 133 16 117 29 88 208 276 107 202 28 37 858 272 312 41 187 46 858 920 534 386 138 74 174 36 138 0 138 16 122 31 91 208 290 112 213 29 36 888 286 312 46 196 48 888 966 560 406 145 77 184 37 147 0 147 16 131 33 98 ****** 888585******** 208 301 117 221 30 41 918 301 312 51 204 50 918 1,005 422 151 80 191 39 152 0 152 16 136 34 102 208 310 120 228 31 50 947 317 312 56 210 52 947 1,035 600 435 155 83 197 41 156 A private equity firm considers acquiring the company per 31/12/2018 and uses multiples valuation. It will use 4x the 2018 EBITDA of debt to finance the acquisition at the entry date. The private equity firm targets to exit the company after 5 years at the end of 2023 and expects to realise an exit EBITDA-multiple of 7.5x. Because all intermediate cash flows the firm will generate are used to repay the debt, you may assume that the expected net debt level at the end of 2023 will be 40% of the initial debt level at entry. Calculate the maximum enterprise value and equity investment the PE is willing to invest at the entry date when the private equity-house targets an IRR of 25%. O Enterprise value: 982.6 Equity Investment: 402.6 O Enterprise value: 1433 0 156 16 140 35 105 Please consider the following company financials: Amounts in min dollars Balance sheet Goodwill Tangible fixed assets Inventories Accounts Receivable Other operating short term assets Cash Total Equity Interest bearing debt Operating provisions Accounts Payable Other operating short term liabilities Total Profit & Loss Account Revenues -Cost of goods sold Gross margin - Personnel cost -Other operating cost EBITDA -Depreciation EBITA -Amortization EBIT -Interest PBT - Taxes Net profit Equity Investment: 1194 O Enterprise value: 984.3 Equity Investment: 592.8 O Enterprise value: 987.3 31-12-18 31-12-19 31-12-20 31-12-21 31-12-22 31-12-23 31-12-24 actuals forecast forecast forecast forecast forecast forecast Equity Investment: 391.3 208 ************ 234 90 172 23 42 769 234 312 26 158 39 769 88988* 780 452 328 117 62 149 31 118 0 118 16 102 26 76 208 246 95 180 25 42 796 246 312 31 166 41 796 819 475 344 123 66 155 33 122 0 122 16 106 27 79 200 263 102 193 26 37 829 259 312 36 178 44 829 876 508 368 131 70 167 34 133 0 133 16 117 29 88 208 276 107 202 28 37 858 272 312 41 187 46 858 920 534 386 138 74 174 36 138 0 138 16 122 31 91 208 290 112 213 29 36 888 286 312 46 196 48 888 966 560 406 145 77 184 37 147 0 147 16 131 33 98 ****** 888585******** 208 301 117 221 30 41 918 301 312 51 204 50 918 1,005 422 151 80 191 39 152 0 152 16 136 34 102 208 310 120 228 31 50 947 317 312 56 210 52 947 1,035 600 435 155 83 197 41 156 A private equity firm considers acquiring the company per 31/12/2018 and uses multiples valuation. It will use 4x the 2018 EBITDA of debt to finance the acquisition at the entry date. The private equity firm targets to exit the company after 5 years at the end of 2023 and expects to realise an exit EBITDA-multiple of 7.5x. Because all intermediate cash flows the firm will generate are used to repay the debt, you may assume that the expected net debt level at the end of 2023 will be 40% of the initial debt level at entry. Calculate the maximum enterprise value and equity investment the PE is willing to invest at the entry date when the private equity-house targets an IRR of 25%. O Enterprise value: 982.6 Equity Investment: 402.6 O Enterprise value: 1433 0 156 16 140 35 105
Expert Answer:
Answer rating: 100% (QA)
The detailed answer for the above question is provided be... View the full answer
Related Book For
Understanding Financial Accounting
ISBN: 978-1118849385
1st Canadian Edition
Authors: Christopher Burnley, Robert Hoskin, Maureen Fizzell, Donald
Posted Date:
Students also viewed these general management questions
-
The Robinson Company had a cost of goods sold of $1,000,000 in 2014 and $1,200,000 in 2015. a. Calculate the inventory turnover for each year. Comment on your findings. b. What would have been the...
-
The actual variable cost of goods sold for a product was $ 70 per unit, while the planned variable cost of goods sold was $68 per unit. The volume increased by 1,200 units to 7,000 actual total...
-
The Cole Corporation had cost of goods sold of $ 685,000 during 2010. Based on the beginning and ending balances of the Inventory and Accounts Payable Merchandise accounts, how much cash did Cole...
-
A process is controlled with a fraction nonconforming control chart with three-sigma limits, n = 100, UCL = 0.161, center line = 0.080, and LCL = 0. (a) Find the equivalent control chart for the...
-
You are scheduled to receive annual payments of $5,100 for each of the next 7 years. The discount rate is 10 percent. What is the difference in the present value if you receive these payments at the...
-
Find the nth term a n of each geometric sequence.When given, r is the common ratio. 7, 14, 28, 56, . . .
-
Key success factors. Dalworth Construction Company provides construction services for major projects. Managers at the company believe that construction is a people-management business, and they list...
-
Sunrise Solar Inc. (SSI) is a medium-sized company that is developing solar energy systems for private residences and small businesses. It is privately owned, with the majority of the shares held by...
-
Required: 2. After all of the transactions for the year ended December 31, 2015, had been posted [including the transactions recorded in part (1) and all adjusting entries], the data that follows...
-
Table 5.7 shows a small set of predictive model validation results for a classification model, with both actual values and propensities. a. Calculate error rates, sensitivity, and specificity using...
-
A construction company has contracted with a major university to build a new sports complex. The contract calls for two sports arenas to be built in the next three years. The company will receive...
-
Change the BinarySearchTree.print method of Section 17.3.4 to print the tree as a tree shape. You can print the tree sideways. Extra credit if you instead display the tree with the root node centered...
-
Modify Exercise P16.14 to use quadratic probing. The ith index in the probing sequence is computed as (h + i2) % L. Data from exercise 16.14 Implement a hash table with open addressing. When...
-
Why does only one of the two while loops at the end of the merge method in Section 14.4 do any work?
-
Locate nodes with no children, one child, and two children in the tree of Exercise R17.13 . For each of them, show the tree of size 10 that is obtained after removing the node. Da ta from exercise...
-
Repeat Exercise P18.1 but require that the array elements implement the Comparable interface. Data from exe rcise P 18.1 Write a static generic method PairUtil.minmax that computes the minimum and...
-
Carrie borrows $525 from Sue on February 14, 2019 for 13 months at 8.5% simple interest. Then, 5 months before maturity, Sue sells the note to B. Harmless who discounts it based on a bank discount...
-
Gordon and Lisa estimate that they will need $1,875,000 in 40 years for their retirement years. If they can earn 8 percent annually on their funds, how much do they need to save annually?
-
Catalina Holdings Ltd. (CHL), a Calgary-based property management company, is owned by Leslie Smeal. Leslie is trying to prepare a bank reconciliation for CHLs bank account for October 31, 2016. A...
-
Slick Snowboards Company reported sales of $700,000 in the first quarter of 2016. The company has never implemented an inventory system so the controller does not know how much inventory is actually...
-
The following amounts were reported by Liquid Company in its most recent statement of financial position: Cash ................... $ 40,000 Accounts receivable ............... 130,000 Short-term...
-
A \(20 \mathrm{MeV}\) alpha particle is fired toward a \({ }^{238} \mathrm{U}\) nucleus. It follows the path shown in Figure P29.53. What is the alpha particle's speed when it is closest to the...
-
The first three energy levels \(E(\mathrm{eV})\) of the fictitious element \(\mathrm{X}\) are \(\ldots . . \ldots\) shown in Figure P29.56. a. What wavelengths are observed in the absorption spectrum...
-
A sodium atom in the \(3 p\) state emits a photon, decreasing the energy of the atom by \(2.10 \mathrm{eV}\). By how much does the orbital angular momentum of the atom change? Does it increase or...
Study smarter with the SolutionInn App