compute period ending for Nov 29,2019.
1) (20 pts) Use the given information about Adobe to compute for the period ending Dec. 29, 2019 the following ratios: a) Average Collection Period d) Return on Assets b) Asset Turnover e) Debt to Equity c) Current Ratio (In thousands, except par value) November 19, 2019 November 30, 2015 ASSETS Current assets: Cash and cash equivalents Short-term investments Trade receivables, net of allowances for doubtful accounts of $9,650 and of $14,981, respectively Prepaid expenses and other current assets Total current assets Property and equipment, net Goodwill Other intangibles, net Other assets Total assets 2,650,221 5 1,526,755 1.534,809 783,140 6,494.925 1.293,015 10,691,199 1.720,565 562,696 20.762.400 S 1,642,775 1,586,187 1,315,578 312,499 4,857,039 1,075,072 10,581,048 2,069,001 186,522 18.768.682 ps-konica-me204-10-20201006172434 $ 186,258 1.163,185 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Trade payables Accrued expenses Debt Deferred revenue Income taxes payable Total current liabilities Long-term liabilities: Debt Deferred revenue Income taxes payable Deferred income taxes Other liabilities Total liabilities 209,499 $ 1,398,548 3,149,343 3,377,986 35,562 8,190,938 2,915,974 35,709 4,301,126 988,924 122,727 616,102 140,498 173.056 10.232.245 4.124.800 137,630 644.101 46,702 152.209 9,406,568 Commitments and contingencies Stockholders' equity: Preferred stock, 50.0001 par value; 2,000 shares authorized: none issued Common stock. 50.0001 par value; 900,000 shares authorized; 600,834 shares issued; 482,339 and 487,663 shares outstanding, respectively Additional paid-in-capital Retained earnings Accumulated other comprehensive income (loss) Treasury stock, at cost (118,495 and 113,171 shares, respectively), net of re-issuances Total stockholders' equity Total liabilities and stockholders' equity See accompanying Notes to Consolidated Financial Statements 61 6,504,800 14,828,562 (188,034) (10,615,234 10.530,155 20,762 400 5 61 5,685,337 11,815,597 (148,130) (7.990,751) 9,362,114 18.768.682 CONSOLIDATED STATEMENTS OF INCOME (In thousands, except per share data) November 29, Years Ended November 30, 2018 2019 December 1, 2017 Revenue: Subscription Product Services and support Total revenue $ 9,994,463 $ 7,922,152 S 6,133,869 647,788 622,153 706,767 529,046 485,703 460,869 11,171,297 9,030,008 7,301,505 1,222,520 39,625 410,575 1,672,720 807,221 46,009 341,769 1,194,999 623,048 57,082 330,361 1,010,491 9,498,577 7,835,009 6,291,014 Cost of revenue: Subscription Product Services and support Total cost of revenue Gross profit Operating expenses: Rescarch and development Sales and marketing General and administrative Amortization of intangibles Total operating expenses Operating income Non-operating income (expense): Interest and other income (expense), net Interest expense Investment gains (losses), net Total non-operating income (expense), net Income before income taxes Provision for income taxes Net income Basic net income per share Shares used to compute basic net income per share Diluted net income per share Shares used to compute diluted net income per share 1,930,228 3,244,347 880,637 175.244 6,230,456 1,537,812 2,620,829 744,898 91,101 4,994,640 1.224,059 2,197,592 624,706 76,562 4.122.919 3,268,121 2.840,369 2,168,095 42,255 39,536 36,395 (157,214) (89,242) (74,402) 51,579 3.213 7,553 (63,380) (46,493) (30,454) 3,204,741 2,793,876 2,137,641 253,283 203,102 443,687 $ 2.951,458 S 2.590,774 $ 1,693,954 $ 6.07 $ 5.28 5 3.43 486,291 490,564 493,632 6.00 $ 5.20 $ 3.38 491,572 497,843 501,123 1) (20 pts) Use the given information about Adobe to compute for the period ending Dec. 29, 2019 the following ratios: a) Average Collection Period d) Return on Assets b) Asset Turnover e) Debt to Equity c) Current Ratio (In thousands, except par value) November 19, 2019 November 30, 2015 ASSETS Current assets: Cash and cash equivalents Short-term investments Trade receivables, net of allowances for doubtful accounts of $9,650 and of $14,981, respectively Prepaid expenses and other current assets Total current assets Property and equipment, net Goodwill Other intangibles, net Other assets Total assets 2,650,221 5 1,526,755 1.534,809 783,140 6,494.925 1.293,015 10,691,199 1.720,565 562,696 20.762.400 S 1,642,775 1,586,187 1,315,578 312,499 4,857,039 1,075,072 10,581,048 2,069,001 186,522 18.768.682 ps-konica-me204-10-20201006172434 $ 186,258 1.163,185 LIABILITIES AND STOCKHOLDERS' EQUITY Current liabilities: Trade payables Accrued expenses Debt Deferred revenue Income taxes payable Total current liabilities Long-term liabilities: Debt Deferred revenue Income taxes payable Deferred income taxes Other liabilities Total liabilities 209,499 $ 1,398,548 3,149,343 3,377,986 35,562 8,190,938 2,915,974 35,709 4,301,126 988,924 122,727 616,102 140,498 173.056 10.232.245 4.124.800 137,630 644.101 46,702 152.209 9,406,568 Commitments and contingencies Stockholders' equity: Preferred stock, 50.0001 par value; 2,000 shares authorized: none issued Common stock. 50.0001 par value; 900,000 shares authorized; 600,834 shares issued; 482,339 and 487,663 shares outstanding, respectively Additional paid-in-capital Retained earnings Accumulated other comprehensive income (loss) Treasury stock, at cost (118,495 and 113,171 shares, respectively), net of re-issuances Total stockholders' equity Total liabilities and stockholders' equity See accompanying Notes to Consolidated Financial Statements 61 6,504,800 14,828,562 (188,034) (10,615,234 10.530,155 20,762 400 5 61 5,685,337 11,815,597 (148,130) (7.990,751) 9,362,114 18.768.682 CONSOLIDATED STATEMENTS OF INCOME (In thousands, except per share data) November 29, Years Ended November 30, 2018 2019 December 1, 2017 Revenue: Subscription Product Services and support Total revenue $ 9,994,463 $ 7,922,152 S 6,133,869 647,788 622,153 706,767 529,046 485,703 460,869 11,171,297 9,030,008 7,301,505 1,222,520 39,625 410,575 1,672,720 807,221 46,009 341,769 1,194,999 623,048 57,082 330,361 1,010,491 9,498,577 7,835,009 6,291,014 Cost of revenue: Subscription Product Services and support Total cost of revenue Gross profit Operating expenses: Rescarch and development Sales and marketing General and administrative Amortization of intangibles Total operating expenses Operating income Non-operating income (expense): Interest and other income (expense), net Interest expense Investment gains (losses), net Total non-operating income (expense), net Income before income taxes Provision for income taxes Net income Basic net income per share Shares used to compute basic net income per share Diluted net income per share Shares used to compute diluted net income per share 1,930,228 3,244,347 880,637 175.244 6,230,456 1,537,812 2,620,829 744,898 91,101 4,994,640 1.224,059 2,197,592 624,706 76,562 4.122.919 3,268,121 2.840,369 2,168,095 42,255 39,536 36,395 (157,214) (89,242) (74,402) 51,579 3.213 7,553 (63,380) (46,493) (30,454) 3,204,741 2,793,876 2,137,641 253,283 203,102 443,687 $ 2.951,458 S 2.590,774 $ 1,693,954 $ 6.07 $ 5.28 5 3.43 486,291 490,564 493,632 6.00 $ 5.20 $ 3.38 491,572 497,843 501,123