Проект по LBO оценке бизнеса

Вся работа в экселе, есть шаблон, он в прикрепленных файлах. Текст задания: A Private Equity Firm is considering an LBO acquisition of a German business. The ultimate goal of this acquisition for the PE Firm is to improve operational performance, paydown the debt and then exit at a higher equity valuation. Acting as a Financial Analyst of the PE Firm, you have prepared a complex LBO financial model of the business covering actual financials and forecasting its business development with reasonable assumptions for the next 5 years. Assignment 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