60.1K

Verified Solution

Link Copied!

Ratio calculation (cash flow):

in excel, use formulas to calculate the following financial indicators for each year of data (2016, 2015, 2014).

See attachments

Ratios to be calculated for each year (2016, 2015, 2014):

Current ratio:

Debt/equity ratio:

Free cash flow:

Earnings per-share:

Price/earning ratio:

Return on equity:

Net profit margin:

As Reported Annual Cash Flow Report Date 10/01/2016 USD Not Qualified 09/27/2014 10/03/2015 USD Not Qualified Audit Status Not Qualified ) Consolidated Scale Net income (loss) Depreciation & amortization Thousands 9790000 2527000 Thousands 8852000 2354000 91000 Thousands 8004000 2288000 299000 Losses (gains) on sales of investments, dispositions & acquisitions 26000 1214000 926000 799000 -101000 393000 445000 393000 186000 137000 40000 598000 13213000 4773000 45000 -850000 180000 5758000 920000 6065000 2205000 2313000 Losses (gains) on sales of investments & dispositions -102000 -814000 752000 922000 410000 341000 211000 1000 34000 49000 354000 10909000 -4265000 166000 517000 854000 718000 964000 408000 234000 -480000 81000 151000 536000 96000 9780000 3311000 395000 402000 27000 -3345000 50000 2231000 -1648000 Deferred income taxes 7 Equity in the loss (income) of investees Cash distributions received from equity investees Net change in film & television costs & advances Equity-based compensation Other adjustments 2 Receivables 3 Inventories 4 Other assets 5t Accounts payable& other accrued liabilities 6 Income taxes 7 Net cash flows from operating activities Investments in parks, resorts & other property 9 Sales of investments or proceeds from dispositions 0 Acquisitions 1 Other investing activities 2 Net cash flows from investing activities 3 Commercial paper borrowings (repayments), net 4 Borrowings 5 Reduction of borrowings 6 Dividends 146000 4245000 2376000 2550000 2221000 -3063000 2016 Balance Sheet 2016 Income Statement 2016 Cash Flow Stock Prices 6 As Reported Annual Cash Flow Report Date 10/01/2016 USD Not Qualified 09/27/2014 10/03/2015 USD Not Qualified Audit Status Not Qualified ) Consolidated Scale Net income (loss) Depreciation & amortization Thousands 9790000 2527000 Thousands 8852000 2354000 91000 Thousands 8004000 2288000 299000 Losses (gains) on sales of investments, dispositions & acquisitions 26000 1214000 926000 799000 -101000 393000 445000 393000 186000 137000 40000 598000 13213000 4773000 45000 -850000 180000 5758000 920000 6065000 2205000 2313000 Losses (gains) on sales of investments & dispositions -102000 -814000 752000 922000 410000 341000 211000 1000 34000 49000 354000 10909000 -4265000 166000 517000 854000 718000 964000 408000 234000 -480000 81000 151000 536000 96000 9780000 3311000 395000 402000 27000 -3345000 50000 2231000 -1648000 Deferred income taxes 7 Equity in the loss (income) of investees Cash distributions received from equity investees Net change in film & television costs & advances Equity-based compensation Other adjustments 2 Receivables 3 Inventories 4 Other assets 5t Accounts payable& other accrued liabilities 6 Income taxes 7 Net cash flows from operating activities Investments in parks, resorts & other property 9 Sales of investments or proceeds from dispositions 0 Acquisitions 1 Other investing activities 2 Net cash flows from investing activities 3 Commercial paper borrowings (repayments), net 4 Borrowings 5 Reduction of borrowings 6 Dividends 146000 4245000 2376000 2550000 2221000 -3063000 2016 Balance Sheet 2016 Income Statement 2016 Cash Flow Stock Prices 6

Answer & Explanation Solved by verified expert

See Answer