Question
I am having a hard time with this problem. Analyzing Duke Energy's acquisition of Progress Energy In 2012DukeEnergy, a large utility company with its headquarters
I am having a hard time with this problem.
Analyzing Duke Energy's acquisition of Progress Energy
In 2012DukeEnergy, a large utility company with its headquarters in North Carolina, completed its $32 billion acquisition ofProgress Energy. To get an idea of the size of this deal, in 2011 Duke Energy reported revenues of $14.5 billion. In 2012, with the additional revenue from Progress Energy, its revenues were $19.6 billion. To complete the requirements below you will need to obtainDuke 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.
2011 10-k consolidated balance sheet starts on page 78 http://www.annualreports.com/HostedData/AnnualReportArchive/d/NYSE_DUK_2011.pdf
2014 10-k Consolidated balance sheet start on page 66
https://www.duke-energy.com/_/media/pdfs/our-company/investors/de-annual-reports/2014/annual-report-2014.pdf?la=en
Questions
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
ROI
Return on equity
Current ratio
Debt to asset ratio
b.Based on the ratios computed in Requirementa, comment on the apparent effects of Duke Energy's acquisition of Progressive Energy. Assume any significant change in these ratios was the result 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?
![image text in transcribed](https://s3.amazonaws.com/si.experts.images/answers/2024/06/667defc682be8_414667defc66bdf8.jpg)
Step by Step Solution
There are 3 Steps involved in it
Step: 1
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-text-image.webp)
Get Instant Access with AI-Powered Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Step: 3
![blur-text-image](https://dsd5zvtm8ll6.cloudfront.net/includes/images/document_product_info/blur-subtext-image.webp)
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started