Annual Report Analysis

profileAlexisperr
JWI530_Assignment1DataandAnalyticsTemplate_1198.xlsx
Home>Business & Finance homework help>Operations Management homework help>Annual Report Analysis

Sheet1

Assignment 1 Student Name:
Data and Analytics Submission Template
Due: Sunday Midnight Week 5
Disney Netflix
UNITS (eg Billions, Millions, Thousands - Please input) Millions Millions
FY 2018 FY 2017 FY 2016 FY 2015 Comments FY 2018 FY 2017 FY 2016 FY 2015 Comments
Total Revenue (or Sales) 59434 55137 55632 52465 15794 11693 8831 6780
Cost of Goods Sold/Cost of Sales 32414 33098 32520 30718 9968 8033 6257 4591 Cost of Revenue
Total Selling, General & Administrative (SG&A) 8860 8176 8754 8523 2193 2193 2193
Microsoft Office User: Microsoft Office User: Acctg Restatement in 2016, will also accept 2,420 		1882 Mktg,Tech,G&A
Total Interest Expense 574 385 260 117 420 238 150 133
Gross Profit (Gross Income) 27020 22039 23112 21747 5826 3660 2574 2189
Gross Margin 45% 40% 42% 41% GP/Rev 37% 31% 29% 32% GP/Rev
Net Profit (Net Income) 13066 9366 9391 8382 1211 559 187 123
Net Margin 22% 17% 17% 16% NP/Rev 8% 5% 2% 2% NP/Rev
SG&A as % of Sales 15% 15% 16% 16% SG&A/Rev 14% 19% 25% 28% SG&A/Rev
Interest Expense as % of Sales 1% 1% 0% 0% Int Exp/Rev 3% 2% 2% 2% Int Exp/Rev
Return on Sales (ROS) 22% 17% 17% 16% NP/Rev 8% 5% 2% 2% NP/Rev
Return on Total Assets (ROA) 13% 10% 10% 10% NP/Total Assets 5% 3% 1% 1% NP/Total Assets
Return on Equity (ROE) 25% 21% 20% 17% NP/Total Equity 23% 16% 7% 6% NP/Total Equity
Cash 4150 4017 4610 4269 3794 2823 1468 1809
Accounts Receivable 9334 8633 9065 8019 0 0 0 0
Inventory 1392 1373 1390 1571 0 0 0 0
Total Current Assets 16825 15889 16996 16758 9694 7670 5720 5431
Total Assets 98598 95789 92033 88182 25974 19013 13587 10203
Total Current Liabilities 17860 19595 16842 16334 6487 5466 4587 3530
Long Term Debt (excluding CPOLTD) 27868 27868 27868 23193 Borrow+DefTax+Other LT 10360 6499 3364 2371
Total Debt 45728 47463 44710 39527 20736 15431 10907 7979
Retained Earnings 82679 72606 66088 59028 2942 1731 1129 941
Total Equity 52832 45004 47323 48655 5239 3582 2680 2223
Current Ratio 0.94 0.81 1.01 1.03 CA/CL 1.49 1.40 1.25 1.54 CA/CL
Long Term Debt to Equity 0.53 0.62 0.59 0.48 LTD/Total Equity 1.98 1.81 1.26 1.07 LTD/Total Equity
Total Debt to Equity 0.87 1.05 0.94 0.81 Tot Debt/Tot Equity 3.96 4.31 4.07 3.59 Tot Debt/Tot Equity
AR Turnover (times per year) 6.6 6.2 6.5 Revenue/Avg AR N/A N/A N/A Revenue/Avg AR
Days Sales Outstanding (in days) 55 59 56 365/AR Turnover N/A N/A N/A 365/AR Turnover
Cash Flow From Operations 14295 12343 13136 10909 Source/(Use) -2680 -1786 -1474 -749 Source/(Use)
Cash Flow from Investing -5336 -4111 -5758 -4245 -339 34 50 -179
Cash Flow from Financing -8843 -8959 -7220 -5514 4049 3077 1092 1640
Capital Expenditures -4465 -3623 -4773 -4265 -173 -173 -108 -91
Change in Long Term Debt (Proceeds - Payments) 2940 2705 Comml Paper + Borrow+Reduction 1000 1500 Proceeds from Issuance
Dividends -2515 -2445 -2313 -3063 0 0 0 0
Cash used in Acquisitions -1581 -417 -850 0 -39 -54 -77 -78
Free Cash Flow 9830 8720 8363 6644 CFFO - CapEx -2853 -1959 -1582 -840 CFFO - CapEx
Free Cash Flow as % of Net Income 75% 93% 89% 79% FCF/NI -236% -350% -846% -683% FCF/NI
Indicates Financial Ratio (calculations required)