Complete a horizontal and vertical analysis of the Income Statements (below) for

Question

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

All numbers in thousands Period Ending Sep 26, 2015 Sep 27, 2014 Sep 28, 2013 Total Revenue 233,715,000   182,795,000   170,910,000   Cost of Revenue 140,089,000   112,258,000   106,606,000   Gross Profit 93,626,000   70,537,000   64,304,000   Operating Expenses Research Development 8,067,000   6,041,000   4,475,000   Selling General and Administrative 14,329,000   11,993,000   10,830,000   Non Recurring - - - Others - - - Total Operating Expenses - - - Operating Income or Loss 71,230,000   52,503,000   48,999,000   Income from Continuing Operations Total Other Income/Expenses Net 1,285,000   980,000   1,156,000   Earnings Before Interest And Taxes 72,515,000   53,483,000   50,155,000   Interest Expense - - - Income Before Tax 72,515,000   53,483,000   50,155,000   Income Tax Expense 19,121,000   13,973,000   13,118,000   Minority Interest - - - Net Income From Continuing Ops 53,394,000   39,510,000   37,037,000   Non-recurring Events Discontinued Operations - - - Extraordinary Items - - - Effect Of Accounting Changes - - - Other Items - - - Net Income 53,394,000   39,510,000   37,037,000   Preferred Stock And Other Adjustments - - - Net Income Applicable To Common Shares 53,394,000   39,510,000   37,037,000  

Explanation / Answer

Period Ending 26-Sep-15 Vertical analysis - % 2015 27-Sep-14 Vertical analysis - % 2015 28-Sep-13 Vertical analysis - % 2015 Horizontal analysis 2013-14 Horizontal analysis 2015-14 Total Revenue 233715000 100.00% 182795000 78.21% 170910000 73.13% $11,885,000 6.95% $50,920,000 358.98% Cost of Revenue 140089000 59.94% 112258000 48.03% 106606000 45.61% $5,652,000 5.30% $27,831,000 403.36% Gross Profit 93626000 40.06% 70537000 30.18% 64304000 27.51% $6,233,000 9.69% $23,089,000 305.50% Operating Expenses Research Development 8067000 3.45% 6041000 2.58% 4475000 1.91% $1,566,000 34.99% $2,026,000 298.17% Selling General and Administrative 14329000 6.13% 11993000 5.13% 10830000 4.63% $1,163,000 10.74% $2,336,000 513.40% Non Recurring Others Total Operating Expenses Operating Income or Loss 71230000 30.48% 52503000 22.46% 48999000 20.97% $3,504,000 7.15% $18,727,000 280.36% Income from Continuing Operations Total Other Income/Expenses Net 1285000 0.55% 980000 0.42% 1156000 0.49% ($176,000) -15.22% $305,000 321.31% Earnings Before Interest And Taxes 72515000 31.03% 53483000 22.88% 50155000 21.46% $3,328,000 6.64% $19,032,000 281.02% Interest Expense Income Before Tax 72515000 31.03% 53483000 22.88% 50155000 21.46% $3,328,000 6.64% $19,032,000 281.02% Income Tax Expense 19121000 8.18% 13973000 5.98% 13118000 5.61% $855,000 6.52% $5,148,000 271.43% Minority Interest Net Income From Continuing Ops 53394000 22.85% 39510000 16.91% 37037000 15.85% $2,473,000 6.68% $13,884,000 284.57% Non-recurring Events Discontinued Operations Extraordinary Items Effect Of Accounting Changes Other Items Net Income 53394000 22.85% 39510000 16.91% 37037000 15.85% $2,473,000 6.68% $13,884,000 284.57%

Related Questions

Navigate

• Browse (All)
• Browse C
• Subjects

---

---

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