Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Uses data on post-LBO forecasts of the balance sheet, and on the post-LBO valuation of company Y Cash flows Balance Sheet 2021 Dec 2022 Dec
Uses data on post-LBO forecasts of the balance sheet, and on the post-LBO valuation of company Y | |||||||||||
Cash flows | Balance Sheet | ||||||||||
2021 Dec | 2022 Dec | 2023 Dec | 2024 Dec | Dec-20 | Dec-21 | Dec-22 | Dec-23 | Dec-24 | |||
EBITDA | 2866 | 2981 | 3100 | 3224 | Cash and ST Investments | 895 | 1405 | 1880 | 2684 | 3706 | |
Capital expenditures | -1090 | -1220 | -989 | -875 | Receivables and Inventory | 3256 | 3309 | 3364 | 3422 | 3481 | |
Change in NWC | -53 | -55 | -57 | -60 | Current Assets | 4151 | 4714 | 5244 | 6106 | 7187 | |
Taxes | -373 | -370 | -443 | -493 | Net Property, Plant and Equipment | 7356 | 7666 | 8075 | 8220 | 8218 | |
Cash flows | 1350 | 1336 | 1610 | 1796 | Non-current Assets | 7356 | 7666 | 8075 | 8220 | 8218 | |
Discounted cash flow | 1224.121 | 1098.1 | 1200.1 | 1213.514 | Total Assets | 11507 | 12380 | 13319 | 14326 | 15405 | |
Terminal value | 22073 | ||||||||||
2020 Dec | |||||||||||
Firm (enterprise) value | 19649 | ||||||||||
Total debt | 18675 | ||||||||||
Cash | 895 | ||||||||||
Equity value | 1869 | ||||||||||
WACC | 10.3% | 0.103 | |||||||||
Long-term growth | 2.0% | ||||||||||
The private equity fund is planning to invest 2000 in cash in this deal in December 2020. | |||||||||||
a) What is the NPV of the deal for the private equity fund in Dec 2020? | |||||||||||
b) What is the IRR of the deal, if the PE fund exits in 2024? Assume no cash payouts between 2020 and 2024. |
Step by Step Solution
★★★★★
3.43 Rating (156 Votes )
There are 3 Steps involved in it
Step: 1
ANSWER To solve this problem we need to calculate the Net Present Value NPV and Internal Rate of Return IRR of the deal for the private equity fund Given information The private equity fund is plannin...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