Financial Analysis Assignment 1: Urgent

profilegarinh
SiriusXMFINANCIALANALYSISASSIGNMENT2.xlsx

Sheet1

SIRIUS XM HOLDINGS, INC.
FINANCIAL ANALYSIS 2012-2016
Numbers in Thousands, except where indicated
2012 2013 2014 2015 2016
INCOME STATEMENT
Total Revenue $3,402,040.00 $3,799,095.00 $4,181,095.00 $4,570,058.00 $5,017,220.00
Total Revenue (in millions)
Total Revenue (in billions)
Revenue CAGR 2012-2016
Revenue 1 Year Growth Rate ---
Operating Income $872,025.00 $1,044,553.00 $1,119,670.00 $1,178,688.00 $1,432,129.00
Operating Margin
Net Income $3,472,702.00 $377,215.00 $493,241.00 $509,724.00 $745,933.00
Net Income 1 Year Growth Rate ---
Return on Sales (ROS)
Return on Assets (ROA)
Return on Equity (ROE)
Earnings per Share (EPS) - Diluted
2012 2013 2014 2015 2016
BALANCE SHEET
Current Assets $1,828,182.00 $1,419,013.00 $1,549,746.00 $561,889.00 $642,649.00
Inventories $25,337.00 $13,863.00 $19,397.00 $22,295.00 $20,363.00
Current Ratio
Quick Ratio
Total Debt (Liabilities) $5,015,278.00 $6,099,038.00 $7,065,672.00 $8,213,153.00 $8,795,610.00
Total Long-Term Debt $2,222,080.00 $3,093,821.00 $4,493,863.00 $5,443,614.00 $5,842,764.00
Debt to Asset Ratio (D/A)
Long Term Debt to Asset (LTD/A)
Property & Equipment, Net $1,571,922.00 $1,594,574.00 $1,510,112.00 $1,415,401.00 $1,398,693.00
Total Asset Turnover (TAT)
Fixed Asset Turnover (FAT)