I need help in completing the Excel template for comparable companies for final paper. Attached are instructions.

Davenport University

Finance 738: Mergers and Acquisitions

Final Project Guidelines

200 points

Select a public company in which you would be interested in analyzing, investing in or if money was not object buying.

Review PowerPoint instructions for completing template.

Complete Comparable Companies Template (Your target company and two comparables)

Input data only in cells noted in the instructions

oDo not worry if the terminology is not exactly the same as the company you selected.Part of the analysis is making assumptions.

oAssume the EPS stated is the diluted EPS

oEnsure the ITEMS in Bold are correct and tie to the 10K (i.e. net income, ebit, EBITDA etc.)

Upon completion of the Data Entry

oComplete your analysis of the target company as compared to the two comparable's.

Final Paper

oProvide a brief description of your target company.

oProvide an in depth rationale as to why you selected the company as a target.Be sure to include numbers in your rationale.

oProvide an in depth rationale as to why you selected each comparable company.Be sure to include numbers in your rationale.

oSummarize the benchmarking analysis (Page 1 and Page 2 excel spreadsheet) of the target and two comparable's.

oSummarize the companies analysis (Output tab of the excel spreadsheet)

oBased on your analysis, provide your recommendation to your investors or board members.Be sure to justify your recommendation with numbers from your analysis.

Final Presentation (50 Points)

oSummarize your final paper in a presentation using power point slides.

oUse the note section with the information that supports your slides.