ATC 9-3 research assignment: Analyzing Duke Energy;s acquisition of progress energy Question a-c.

0 the ratios presented in this chapter, you rnight also find it useruy the filM course accounting, thc margin pcrccntage (Gross margin + Sales). b. Select a section. thc explain the rationale for gmups selection. The explanation should include a set of ratios that support the group's conclusion. ATC 9-3 Analyzing Duke Energy's acquisition of Research Assignment Progress Energy In 2012 Duke Energy, a large utility company with its headquarters in North Carolina, completed its S32 billion acquisition of Progress Energy. To get an idea of the size of this deal, in 2011 Duke En- ergy reported revenues of $ 14.5 billion. In 2012, with the additional revenue frorn Progress Energy, its revenues were $19.6 billion. To complete the requirements below you will need to obtain Duke Energy Holding Company's Form 10-K for 2011, the year before the acquisition, and for 2014, two years after the deal was closed. The Form 10-Ks can be accessed through the "Investors" link on the company's website, www.duke-energy.com, or through the EDGAR system. Be aware that the Form 10-Ks include separate financial statements for each of Duke Energy's subsidiary companies, so be sure to use the statements for the consolidated company, Duke Energy Corporation. Required a. Compute the following ratios for 2011 and 2014. To make the computations simpler, use end-of- year amounts for total assets and total equity rather than averages. Show your calculations. Net margin Return on investment Return on equity Current ratio Debt to assets ratio be Based on the ratios computed in Requirement a, comment on the apparent effects of Duke Ener- gy's acquisition of Progressive Energy. Assume any significant change in these ratios was the re- sult of the acquisition. c. Based on this limited analysis, does it appear that the effects of the merger were good or bad for Duke Energy?