powerpoint slides for financial analysis

profileBrishna
FinancialAnalysisofWalmartandJCPenny.xlsx
Home>Business & Finance homework help>Management homework help>powerpoint slides for financial analysis

Sheet1

Assignment 1 Student Name:
Data and Analytics Submission Template
Due: Sunday Midnight Week 5
Walmart JCPenney
UNITS (eg Billions, Millions, Thousands - Please input) Millions Millions
FY 2019 FY 2018 FY 2017 FY 2016 Comments FY 2018 FY 2017 FY 2016 FY 2015 Comments NOTE: Both WMT and JCP have fiscal years ending on 1/31. For the period ending 1/31/19, Walmart labels it as FY 2019, whereas JCP labels it FY 2018
Total Revenue (or Sales) 514405 500343 485873 482130 12019 12873 12547 12625
Cost of Goods Sold/Cost of Sales 385301 373396 361256 360984 7870 8208 8071 8074
Total Selling, General & Administrative (SG&A) 107147 106510 101853 97041 3596 3845 3538 3775
Total Interest Expense 2129 2178 2267 2467 Interest, net 313 325 363 405
Gross Profit (Gross Income) 129104 126947 124617 121146 Rev - COS 4149 4665 4476 4551
Gross Margin 25% 25% 26% 25% GP/Rev 34% 36% 36% 36% GP/Rev
Net Profit (Net Income) 6670 9862 13643 14694 223 5 1 -513
Net Margin 1% 2% 3% 3% NP/Rev 2% 0% 0% 2% NP/Rev
SG&A as % of Sales 21% 21% 21% 20% SG&A/Rev 30% 30% 28% 30% SG&A/Rev
Interest Expense as % of Sales 0% 0% 0% 1% Int Exp/Rev 3% 3% 3% 3% Int Exp/Rev
Return on Sales (ROS) 1% 2% 3% 3% NP/Rev 2% 0% 0% -4% NP/Rev
Return on Total Assets (ROA) 3% 5% 7% 7% NP/Total Assets 3% 0% 0% -5% NP/Total Assets
Return on Equity (ROE) 8% 12% 17% 18% NP/Total Equity 19% 0% 0% -39% NP/Total Equity
Cash 7722 6756 6867 8705 333 458 887 900
Accounts Receivable 6283 5614 5835 5624 0 0 0 0
Inventory 44269 43783 43046 44469 2437 2803 2854 2721
Total Current Assets 61897 59664 57689 60239 2959 3451 4097 4018
Total Assets 219295 204522 198825 199581 7721 8454 9314 9442
Total Current Liabilities 77477 78521 66928 64619 1942 2369 2419 2412
Long Term Debt (including LT Cap Lease) 50203 36825 42018 44030 3920 3992 4558 4678
Total Debt 139661 123700 118290 115970 6551 7071 7960 8133 Tot Liability
Retained Earnings 80785 85107 89354 90021 3373 3118 -3006 -3007
Total Equity 79634 80822 80535 83611 1170 1383 1354 1309
Current Ratio 0.80 0.76 0.86 0.93 CA/CL 1.52 1.46 1.69 1.67 CA/CL
Long Term Debt to Equity 0.63 0.46 0.52 0.53 LTD/Total Equity 3.35 2.87 3.37 3.57 LTD/Total Equity
Total Debt to Equity 1.75 1.53 1.47 1.39 Tot Debt/Tot Equity 5.60 5.11 5.88 6.21 Tot Debt/Tot Equity
Inventory Turnover (time per year) 8.70 8.52 8.26 COS/avg Inv 3.23 1.37 2.90 COS/avg Inv
Inventory Days on Hand (in days) 41.95 42.84 44.21 365/Inv Turns 113.00 266.42 126.06 365/Inv Turns
AR Turnover (times per year) 81.9 89.1 84.8 Revenue/Avg AR N/A N/A N/A Revenue/Avg AR
Days Sales Outstanding (in days) 4 4 4 365/AR Turnover N/A N/A N/A 365/AR Turnover
Cash Flow From Operations 27753 28337 31530 27389 Source/(Use) 359 454 334 440 Source/(Use)
Cash Flow from Investing -24036 -9060 -13987 -10675 -244 -229 -316 -296
Cash Flow from Financing -2537 -19875 -18929 -16122 240 654 31 -562
Capital Expenditures -10344 -10051 -10619 -11477 Payments for P&E -392 -395 -427 -320
Change in Long Term Debt (Proceeds - Payments) 12088 -5585 -1918 -4393 Proceeds - payments of LTD -207 N/A -23 -557 Sum of all Payment/Proceed (ex st=hort term borring)
Dividends -6102 -6124 -6216 -6294 0 0 0 0
Purchase of Tresaury Stock -7410 -8296 -8298 -4112 Purch of Company Stk 3 5 0 0
Cash used in Acquisitions -14656 -375 -2463 0 0 0 0 0
Free Cash Flow 17409 18286 20911 15912 CFFO - CapEx -133 -59 -93 120 CFFO - CapEx
Free Cash Flow as % of Net Income 261% 185% 153% 108% FCF/NI -59% -1180% -9300% -23% FCF/NI
Indicates Financial Ratio (calculations required)