Financial Statement Analysis

profilelivingkaya
Statementanalysistdl.xlsx
Home>Business & Finance homework help>Financial markets homework help>Financial Statement Analysis

Sheet1

Principles of Business I: Paul Melton
Financial Statement Analysis
NOTE: You'll need to add rows to show additional calculations for analysis, but you shouldn't need to add any other formatting.
2017 (Current) 2016 2015 2014 2013
Profitability and Valuation
Revenues (US$m) 805.38 961.49 938.05 853.68
Revenue Growth -16% 2% 10%
Gross Profit (US$m) 632.53 742.71 774.75 738.78
Gross Margin 78.54% 77.25% 82.59% 86.54%
Net Income 74.11 43.73 117.80 130.01
Net Income Growth 69% -63% -9%
Net Profit Margin 9.20% 4.55% 12.56% 15.23%
Book Value (US$m)
Paul Melton: Paul Melton: Use Total Equity from the annual balance sheets.		 505.42 806.43 877.70 1,139.32
Return on Equity (ROE) 14.66% 5.42% 13.42% 11.41%
Market Capitalization (US$m)
Paul Melton: Paul Melton: Year-end for all years except 2014 . Use the most current number you can find for 2014.		 2,660.00 2,175.00 1,752.00 3,006.00 3,678.00
Financial Position
Current Assets (US$m) 1,268.85 2,109.74 2,039.52 1,972.27
Long-term Assets (US$m)
Paul Melton: Paul Melton: Use Total Assets - Current Assets.		 1,235.58 1,153.57 1,095.30 921.28
Total Assets (US$m) 2,504.43 3,263.31 3,134.82 2,893.55
Current Liabilities (US$m) 742.98 1,196.57 1,429.21 1,142.49
Long-term Liabilities (US$m)
Paul Melton: Paul Melton: Use Total liabilites - Current liabilities.		 1,256.03 1,260.32 827.91 611.74
Total Liabilities (US$m) 1,999.01 2,456.89 2,257.12 1,754.23
Total Debt (US$m) 1,170.57 1,152.75 963.73 518.78
Current Ratio 1.71 1.76 1.43 1.73
Debt-to-Equity (D/E) Ratio
Paul Melton: Paul Melton: Using "Total Debt" from balance sheet.		 2.32 1.43 1.10 0.46
Debt-to-Equity (D/E) Ratio (2)
Paul Melton: Paul Melton: Using total iabilities from balance sheet.
Paul Melton: Paul Melton: Use Total Equity from the annual balance sheets.
Paul Melton: Paul Melton: Year-end for all years except 2014 . Use the most current number you can find for 2014.		 3.96 3.05 2.57 1.54
Analysis: Type your analysis and interpretation of the data here.