hi could you help me on this disney 10-k analysis i couldnt figure out some of the ratios and what to put fpr the foot notes

Retained Earnings from the RE Info 42,494 32,679 Check figure - Total Assets from above 193,984 98,598 Are the Balance Sheets in balance? Yes Yes Common Shares Yearend Information: # of Shares actual or in thousands or in millions Shares authorized 4,600 4,600 Shares issued 1,800 2,900 Less: Treasury shares 19 1,400 Total Common Shares Outstanding 1,781 1,500 Statements of Cash Flows (SoCF): 9/28/2019 9/29/2018 9/30/2017 Cash provided /(used) by operating activities $ 5,984 S 14,295 S 12,343 Cash provided /(used) by investing activities (15,096) (5,336) (4,111 Cash provided /(used) by financing activities (464) (8,843) (8,959) Cash provided by discontinued operations (2019) and exchange 10,876 (25) 31 Increase/ (decrease) in cash and cash equivalents 1,300 $ 91 $ (696) Cash and cash equivalents, beginning of year 4,155 4,064 Enter here> > 4,760 Cash and cash equivalents, ending of year $ 5,455 S 4,155 S ,064 Less: restricted cash elsewhere on balance sheet 37 5 Calculated cash and equivalents from the balance sheet 5,418 $ 4,150 Actual Cash and equivalents from the balance sheet 5,418 1,150 Do the most recent two years cash agree to the B/S? Yes Yes Other extracted information (enter as positive): 9/28/2019 9/29/2018 Net interest expense (not applicable, if revenue) + 1,142 S 631 Depreciation, amortization, depletion expense (SoCF) + 4,160 3,011 New Capital Expenditures/New PP&E/Fixed Assets: Capital Expenditures from the Stmt of Cash Flows 4,876 4,465 Capital Expenditures from non-cash (loans) Total Capital Expenditures / new PP&E $ 4,876 $ 4,465 Property, Plant, and Equipment: 9/28/2019 9/29/2018 Attractions, buildings and improvments 29,509 50.4% 28,995 52.5% 0.0% 0.0% Furniture, fixtures, and equipment 21,265 36.3% 19,400 35.1% Land improvments 6,649 11.3% 5,911 10.7% Lease hold improvments 1,166 2.0%% 932 1.7% Total cost S 58,589 100.0% $ 55,238 100.0% Less accumulated depreciation (32,415) 55.3% (30,764) 55.7% Property, plant and equipment, net $ 26,174 44.7% $ 24,474 44.3% PP&E, net from the Balance Sheet S 26,174 $ 24,474 Detail Fixed Asset/ PP&E Information found in: From note 14, excluding land and projects in progress.The Walt Disney Company Remember Gold: Leave alone - programmed Horizontal Analysis Ch02 Consolidated Statements of Income With Vertical Analysis %'s based on Revenues / Sales Increase / % Increase / millions Newest Yr End Middle Yr End Oldest Yr End (Decrease) Change For the Years Ended (change as needed): (Decrease) Change 9/28/2019 9/29/2018 9/30/2017 Bet. Newest/Middle Yr. Bet. Middle/Oldest Yr. Services Revenue 31.9% 84.7% $ 84.8% $ 19.0% $ 4,026 8.6% Cost of services $6,450 0.29 54.1% 25,320 54.1% B.922 32.4% 2,208 Gross profit on revenue #1 24,092 39.8% $ 45.9% $ 3.2% $ 1,818 8.4% Products Revenue 12.2% 8,565 6 S 3,294 15.0% $ 163 5.4% $ 271 3.3% Cost of Products 5,568 61.7% 5,198 60.7% 4,986 60.1% 370 7.1% 212 Gross profit on revenue #2 3,460 8.3% $ ,367 9.3% $ 3,308 2.8% Other income, net 4,357 5.9% $ 601 1.0% $ 78 0.1% 3,756 625.0% S 6/0.5% Total revenue (operating #1 - #3) 73,927 100.0% $ 100.0% $ 55,215 23.1% $ 4,820 8.7% Blended Gross Profit for both revenue #1 & #2 27,552 26,708 24,831 1,877 7.6%% Operating expenses: Selling, General, Administrative and other expense 11,541 15.6% $ 14.8% $ 8,176 14.8% $ 2,681 0.0% Depreciation and Amortization 4,160 5.6% 3,011 5.0% 2,782 5.0% 1,149 38.2% 229 8.2%% Total operating expenses S 15,701 21.2% $ 11,871 19.8% $ 10,958 19.8% S 3,830 32.3% S 913 Net Operating Income 16,208 21.9% $ 15,438 8.3% 25.7% $ 770 1,487 10.7%% Non-operating revenues or (expenses): Interest expense, ne (978 -1.3% 574) 1.0% 385) -0.7% (189) 49.1% Restructuring and Impairment charges 1,183) 1.6% 0.1% (98) -0.2% 1,150) 3484.8% 65 -66.3%% Equity in the income(loss) of investees, net (103) -0.1% (102) -0.2% 320 0.6% 1.0% (422) -131.9% Income before income taxes $ 13,944 18.9% $ 24.5% $ 25.0% S (785) -5.3% $ 941 6.8%% Income tax from countinuing operations 3,031 4.1% 1,663 2.8% 4,422 8.0% 82.3% (2,759) -62.4% Net income before minority/discontinued S 10,913 14.8% $ 21.8% $ 9,366 17.0% $ 0.0% S 0.0% (530) -0.7% (468) (386) -0.7% 13.2% 82) 21.23 671 0.9% 0.0% 0.0% Net income and profitability percentage S 11,054 15.0% $ 12,598 21.0% S 8,980 16.3% S 1,544) -12.3% $ 3,618 Net income (loss) on the 10-K 1,054 ,980 > > $ 2,494 32,679 72,606 > =E88/E105 174 Quick ratio = Quick assets/Current liabilities Ch10 0.7 times 0.8 show> > -E80+E82/E109 175 176 Working capital = Current assets - Current liabilities $ (3,217) $ (1,035) show> =E87-E109 178 Days' [operating] cash on hand: Ch07 179 (Cash + short-term invesments) / 156.0 days 185.4 show> > =(E80+E82/(E37/365) 180 ((Operating expenses - depreciation/amortization expense) / 365) 182 Current cash debt coverage ratio: 183 Cash provided by operations/Ending current liabilities 19.0% 80.0% show> > 104 =E136/E109 185 Inventory turnover ratio: Ch06 186 Cost of goods sold/ Ending inventory 3.4 times 1.2 show> > =E31/E84 188 Days in inventory: Ch06 189 365 days/Inventory turnover ratio 107.3 days 304.2 show> > =365/E186 190 191 Receivables turnover ratio: Ch08 192 Net sales/Ending net receivables 1.8 times 2.9 show> > =E29+E32/E82 194 Average collection period: Cho8 195 365 days/Receivables turnover ratio 202.8 days 125.9 show> > =365/E192 196 197 Financial Ratios - Solvency 9/28/2019 9/29/2018 199 Debt to total assets ratio: 200 Total liabilities/ Total assets 51.6% 46.4% show> > =E114/E96 202 Ratio of Fixed Assets to Long-term Liabilities: Ch14 203 Fixed assets - net / Long-term liabilities 40.0% 92.0% show> > =E90+E91/E114-E109 205 Cash debt coverage ratio: 206 Cash provided by operations/Ending total liabilities 5.9% 31.2% show> > =E132-E114 208 Ratio of Total Liabilities to Total Stockholders' Equity: 209 Total liabilities / Total stockholders' equity Choi 113.0% 93.8% show> > =E114/E112 211 Times interest earned ratio: [show only if there is net interest expense] 12 (Net income + net Interest expense+ Income tax) :13 Net Interest expense Ch11 0.8 1.1 show> > =E34+C46+C51/E46 215 Free cash flow: 16 Cash provided by operations - Ch13 217 Capital [PP&E] expenditures - cash dividend S show> > =E139196 197 Financial Ratios - Solvency 9/28/2019 9/29/2018 193 Debt to total assets ratio: 200 Total liabilitiesr Total assets 51.6% 46.4% show> > = E114/E96 202 Ratio of Fixed Assets to Long-term Ch14 203 Fixed assets - net / Long-term liabilities 40.0% 92.0% show> > = E90+891/E114-E109 205 Cash debt coverage ratio: 206 Cash provided by operations/Ending total liabilities 5.9% 31.2% show> > = E132-E114 206 Ratio of Total Liabilities to Total Stockholders' Equity: 203 Total liabilities / Totalstockholders' equity Cho1 113.0% 93.8% show> > = E114/E 112 210 211 Times interest earned ratio: [show only if there is net interest expense ] 212 (Net income + net Interest expense+ Income tax) 213 Net Interest expense Ch11 0.8 1.1 show> > = E34+C46+C51/E46 215 Free cash flow: 216 Cash provided by operations - Ch13 217 $ 210 Bapital [PP&E] expenditures - cash dividend show> > = E139 219 Financial Ratios - Profitability 9/28/2019 9/29/2018 221 Earnings per share: [You may have to adjust by 1,000 or 1,000,000 as appropriate. 222 (Net income - preferredstock dividendr, if any ) Ch12 223 Ending common baricshares outstanding 6.21 $ 8.40 show> > 22! EPS basic from above income statement $ 6.64 $ 3.40 Price-earnings ratio: Ch14 7/19/2020 84 > =B228/E225 230 Gross profit and profitability ratios: 231 See percentages in the common sized Income Statement above 233 Return on assets ratio: Ch05 234 Net incomerEnding total assets 5.7% 12.8% show> > = E55/E96 236 Fixed asset turnover ratio: Cho9 237 Net Sales / Book value of fixed assets [PP&E] show> > 239 Asset turnover ratio: Ch14 240 Net sales 241 En ding total assets [exclude L-T Investments) 0.0 0.0 show> > 243 Dividends per Share: [You may have to adjust by 1,000 or 1,000,000 as appropriate.] 244 Dividends on common stock? Ch14 245 Shares of common stock outstanding 25.50 56.81 show> > = E69/E133 247 Dividends per share from financials 1.76 1.68 249 Dividend payout ratio: Not covered in text. 250 Cash dividends declared on common stockr 251 Net income 0.0% 0.0% show> > 253 Dividend yield: Ch14 254 Dividends per share of common stock 255 Market price per share of common stock 0.0% 0.0% show> > 257 Return on common stockholders' : Ch14 258 Net income - preferred stock dividends 253 Ending common stockholders' equity 1.0% 0.0% show> > 261 262 Footnotes [fn] to the Financial An. Disney 263 264 In 1. row *: size as required. 265 266 in 2. row x: size as required. 267 268 fri 3. row x: size as required 263 270 fri 4, row x: size as required 271 272 fri S. row > size as required 273 274 fo 6, row x: size as required 275 276 in 7, row *: size as required. 277