Complete a horizontal and vertical analysis of the Balance Sheets (below) for th

Question

Complete a horizontal and vertical analysis of the Balance Sheets (below) for the past three years (with all yearly balances set as a percentage of total assets for that year), in spreadsheet format.

All numbers in thousands

All numbers in thousands

Period Ending Sep 26, 2015 Sep 27, 2014 Sep 28, 2013 Assets Current Assets Cash And Cash Equivalents 21,120,000   13,844,000   14,259,000   Short Term Investments 20,481,000   11,233,000   26,287,000   Net Receivables 35,889,000   31,537,000   24,094,000   Inventory 2,349,000   2,111,000   1,764,000   Other Current Assets 9,539,000   9,806,000   6,882,000   Total Current Assets 89,378,000   68,531,000   73,286,000   Long Term Investments 164,065,000   130,162,000   106,215,000   Property Plant and Equipment 22,471,000   20,624,000   16,597,000   Goodwill 5,116,000   4,616,000   1,577,000   Intangible Assets 3,893,000   4,142,000   4,179,000   Accumulated Amortization - - - Other Assets 5,556,000   3,764,000   5,146,000   Deferred Long Term Asset Charges - - - Total Assets 290,479,000   231,839,000   207,000,000   Liabilities Current Liabilities Accounts Payable 60,671,000   48,649,000   36,223,000   Short/Current Long Term Debt 10,999,000   6,308,000   - Other Current Liabilities 8,940,000   8,491,000   7,435,000   Total Current Liabilities 80,610,000   63,448,000   43,658,000   Long Term Debt 53,463,000   28,987,000   16,960,000   Other Liabilities 33,427,000   24,826,000   20,208,000   Deferred Long Term Liability Charges 3,624,000   3,031,000   2,625,000   Minority Interest - - - Negative Goodwill - - - Total Liabilities 171,124,000   120,292,000   83,451,000   Stockholders' Equity Misc Stocks Options Warrants - - - Redeemable Preferred Stock - - - Preferred Stock - - - Common Stock 27,416,000   23,313,000   19,764,000   Retained Earnings 92,284,000   87,152,000   104,256,000   Treasury Stock - - - Capital Surplus - - - Other Stockholder Equity (345,000) 1,082,000   (471,000) Total Stockholder Equity 119,355,000   111,547,000   123,549,000   Net Tangible Assets 110,346,000   102,789,000   117,793,000  

Explanation / Answer

Horizontal Veritcal Period Ending Sep 26, 2015 Sep 27, 2014 Sep 28, 2013 variance Assets Current Assets Cash And Cash Equivalents 21120000 1,38,44,000 1,42,59,000 -4,15,000 72,76,000 7% 6% 7% Short Term Investments 20481000 1,12,33,000 2,62,87,000 -1,50,54,000 92,48,000 7% 5% 13% Net Receivables 35889000 3,15,37,000 2,40,94,000 74,43,000 43,52,000 12% 14% 12% Inventory 2349000 21,11,000 17,64,000 3,47,000 2,38,000 1% 1% 1% Other Current Assets 9539000 98,06,000 68,82,000 29,24,000 -2,67,000 3% 4% 3% Total Current Assets 89378000 6,85,31,000 7,32,86,000 -47,55,000 2,08,47,000 31% 30% 35% Long Term Investments 164065000 13,01,62,000 10,62,15,000 2,39,47,000 3,39,03,000 56% 56% 51% Property Plant and Equipment 22471000 2,06,24,000 1,65,97,000 40,27,000 18,47,000 8% 9% 8% Goodwill 5116000 46,16,000 15,77,000 30,39,000 5,00,000 2% 2% 1% Intangible Assets 3893000 41,42,000 41,79,000 -37,000 -2,49,000 1% 2% 2% Other Assets 55,56,000 37,64,000 51,46,000 -13,82,000 17,92,000 2% 2% 2% Total Assets 29,04,79,000 23,18,39,000 20,70,00,000 2,48,39,000 5,86,40,000 100% 100% 100% Accounts Payable 6,06,71,000 4,86,49,000 3,62,23,000 1,24,26,000 1,20,22,000 21% 21% 17% Short/Current Long Term Debt 1,09,99,000 63,08,000 - #VALUE! 46,91,000 4% 3% #VALUE! Other Current Liabilities 89,40,000 84,91,000 74,35,000 10,56,000 4,49,000 3% 4% 4% Total Current Liabilities 8,06,10,000 6,34,48,000 4,36,58,000 1,97,90,000 1,71,62,000 28% 27% 21% Long Term Debt 5,34,63,000 2,89,87,000 1,69,60,000 1,20,27,000 2,44,76,000 18% 13% 8% Other Liabilities 3,34,27,000 2,48,26,000 2,02,08,000 46,18,000 86,01,000 12% 11% 10% Deferred Long Term Liability Charges 36,24,000 30,31,000 26,25,000 4,06,000 5,93,000 1% 1% 1% Total Liabilities 17,11,24,000 12,02,92,000 8,34,51,000 3,68,41,000 5,08,32,000 59% 52% 40% Common Stock 2,74,16,000 2,33,13,000 1,97,64,000 35,49,000 41,03,000 9% 10% 10% Retained Earnings 9,22,84,000 8,71,52,000 10,42,56,000 -1,71,04,000 51,32,000 32% 38% 50% Other Stockholder Equity -345000 10,82,000 -471000 15,53,000 -14,27,000 0% 0% 0% Total Stockholder Equity 11,93,55,000 11,15,47,000 12,35,49,000 -1,20,02,000 78,08,000 41% 48% 60% Net Tangible Assets 11,03,46,000 10,27,89,000 11,77,93,000 -1,50,04,000 75,57,000 38% 44% 57%

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.