Financial modeling
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
- PCN 605 Topic 2 DQ 2
- MGT 500 WEEK 1 DISCUSSION
- PAD 505 WEEK 10 DISCUSSION (FOUR DIFFERENT VERSION ANSWER POSTED)
- PAY HERE
- P10-8A P10-2 E12-18 E12-20
- DUE: 4/1/2016 at 10 am est. 1 page for $5 …THXS!
- for AllRoundBest Tutor
- Explain your proposed approach for conducting research necessary to develop quality deliverables and explain how the information gleaned will support...
- paragraph
- WITHIN 24HOURS ***