Модель оценки LBO

You are asked to prepare an LBO valuation of the business based on available information about future projections. In part A, you would calculate Internal Rate of Return (IRR) and Multiple on Invested Capital (Cash on Cash), given different scenarios of exit multiple (EV/EBITDA) and leverage (Senior Debt / EBITDA). You will be able to compute them after finalizing the financial model on the LBO spreadsheet. In part B, you would indicate the required return for this kind of transaction. You should refer to the concepts of Leverage Buyout investment. Please, suggest the number or a range and provide short explanations. In part C, you would provide your investment recommendation based on the provided answers in the previous parts. You should specify whether the German business is a good LBO target and whether the Private Equity Firm should proceed with the transaction. In addition, as a part of your investment recommendation you could provide your suggestions on the terms of the deal (could be entry valuation, leverage, exit valuation, other assumptions).