Financial modeling

profilessqg31021

this assignment is for a financial modeling class, the requirement: "As part of a group, you are required to submit written analysis of one case including financial analysis. Submission should include a 4-5 page write-up and a financial model including all necessary quantitative analysis." The case is "Palamon Capital Partners/TeamSystem S.p.A." You can find the case on Google. My professor wants me to include the following information in the write up and the financial model: "Private equity deal: whether to proceed this deal Decision driver: IRR~~20% typical hurdle rate Use the assumption in the case, do the irr analysis Negative CF at the beginning, how much i am spending on this deal? Deal value: (debt&equity component), not what i am paying ,but debt i am using to finance the deal. Equity: how much equity i am putting in the deal Generate CF, not outflow, if i buy the company, the company does not pay the cash flow to me ( not actually paid out) Our assumption: no dividend paid Use as much debt as possible, if i use less equity, little outflow, irr goes up We want to minimize equity Pay down debt to create equity value Multiple: which multiple to use when buying? Use entry multiple as a guide, what the exit multiple will be? Following EBITDA (EXIT VALUE) Make some assumptions about the dividend. Deal value=equity and debt Risks? What IRR do i need to accept that deal? 2007 ebitda multiple to calculate the value( exit multiple/value?) Set up balance sheet as functional model, excess cash sould be included in the calculation of EV, also the equity value Finanly make a decision? " This is a Financial Modeling class, the most important thing is the excel model, please do the model as well as you can, and for the write-up, you don't need to talk about the case and the background, just explain your thought on your model, for example: how did you get the WACC? what beta you used and why?

    • 9 years ago
    • 100
    Answer(0)
    Bids(0)