Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

I need help with the formulas to add to the green sections B2 X V fx Financial Analysis 2012-2016 A B D E F Numbers

image text in transcribed

I need help with the formulas to add to the green sections

image text in transcribed
B2 X V fx Financial Analysis 2012-2016 A B D E F Numbers in Thousands, except where indicated 2012 2013 2014 2015 2016 INCOME STATEMENT Total Revenue ($ actual) $1,394,205,000 0 Total Revenue (in thousands) $1,394,205 Total Revenue (in millions) $1,394 Total Revenue (in billions) $1.39 Revenue 1 Year Growth Rate .4 Total Revenue CAGR 2014-2018 Gross Profit $627,235.00 $673,214.00 $481,920.00 $384,530.00 $361,434.00 Gross Margin 0 Operating Income $187,035 $54,748 -$372,969 -$163,460 -$93,962 Operating Margin N 3 Net Income (NI) $128,088 $36,1: $419,003 $182,873 -$109,034 4 NI 1 Year Growth Rate 5 6 Return on Sales (ROS) 8 Return on Assets (ROA) 9 0 Return on Equity (ROE) 1 2 EPS - Diluted ($ per share) $0.92 2014 2015 2016 2017 2018 BALANCE SHEET Current Assets $823,043 $833,243 $587,813 $573,681 $474,073 Inventories $153,026 $188, $167,192 $150,551 $116,4 Current Liabilities $258,769 $295,177 $430,739 $370,531 $299,499 4 Current Ratio Quick Ratio 17 8 Total Debt (Liabilities) $276,487 $330,943 $475,695 $551,541 $486,2 9 Total Assets $917,691 $1,102,976 $922,640 $850,246 $698,359 0 Total Shareholder Equity $641,204 $772,033 $446,945 $298,705 $212,1 Debt to Asset Ratio (D/A) Debt to Equity Ratio (D/E) 6 Total Revenues $1,394,205 $1,619,971 $1,185,481 $1,179,741 $1,148,337 Total Assets $917,691 $1,102,976 $922,640 $850,246 $698,359 Fixed Assets (PP&E, Net) $41,556 $70,050 $76,509 $68,587 $46,567 Total Asset Turnover (TAT) Fixed Asset Turnover (FAT) 3

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Financial Management Principles and Applications

Authors: Sheridan Titman, Arthur J. Keown, John H. Martin

13th edition

134417216, 978-0134417509, 013441750X, 978-0134417219

More Books

Students also viewed these Finance questions