Do a vertical and horizontal analysis (do in excel format please), you will see the spots to fill in. If possible also explain where you see fraud and why

SHENANIGANS CONSOLIDATED STATEMENTS OF INCOME As of December 31, 2009 Dollars in Thousands (except per share data) 2009 2008 2007 2006 2005 Net Sales Jummy Bear Beer Little Jolly Juice Beer A Pop Gift Shop Sales Merchandise TOTAL NET SALES Cost of Goods Sold (Gift Shop) Cost of Goods Sold (Beer Ingredients) Gross Profit $ $ $ $ $ $ $ s 742.00 $ 778.00 $ 843.00 $ 285.00 S 2,648.00 $ (184,00) 1226.00) 2,238.00 S 739.00 $ 768.00 $ 838.00 $ 286.00 $ 2,631.00 S (181.00) 1223.00) 2,227.00 S 725.00 $ 719.00 $ 745.00 $ 735.00 $ 826.00 $ 814.00 $ 286.50 S 287.00 S 2,582.50 $ 2,555.00 $ (176.00) 5 (173.00) $ 1219.00) S (215.00) S 2,187.50 $ 2,167.00 $ 713.00 719.00 812.00 292.00 2,536.00 (168.00) 1212.00) 2,156,00 27.00 16.00 $ $ s $ 32.00 31.00 S 12.00 S 75.00 28.00 $ 26.00 $ 10.00 S 64.00 S 27.00 $ 24.00 S 11.00 S 62.00 $ 26.00 S 19.00 S 9.00 5 54.00 S 11.00 54.00 Financial Services Income Interest Income Income from securitizations Other Income Financial Services Income Financial Services Expenses Interest Expense Operating Expenses Financial Services Expenses Operating Income from Financial Services $ $ S 112.00 $ 98.00 210.00 $ 119.00 $ 99.00 S 218.00 S 121.00 $ 101.00 S 222.00 S 197.00 $ 140.00 S 337.00 $ 198.00 139.00 337.00 $ (135.00) (154.00) S (160,00) (283.00) S (283.00) Selling, Administrative, and Engineering Expenses Income Before Taxes Income Taxes Net Income S $ $ s 42.00 S 2,061.00 $ 926.80S 1.134.20 43.00 S 2,030.00 $ 920.90 $ 1.109.10 45.00 S 1,982.50 S 903.90 S 1.078.60 S 63.00 S 1,821.00 5 894.30 S 926.70 S 65.00 1,808.00 887.60 920.40 Shares Outstanding (thousands) Dividends Paid Earnings Per Share 37 272 $23.330 38 270 $22.678 38 268 $21.908 56 266 $17.857 58 256 $17.957 Horizontal Analysis 2009 2008 2007 Vertical Analysis 2009 2008 2006 2005 2007 2006 2005 63.79% 105.86% 129.92% 65.52% 65.52% 105.47% 104.69% 126.29% 122.00% 96.55% 103.91% 99.44% 100.00% 100.00% 100.00% 1.40% 10.23% 0.88% 2009 2008 2007 2006 2005 1,593.0 1,292.0 1,024.7 869.0 720.0 586.0 391.0 370.0 290.0 378.0 300.0 250.0 3,231.0 2,682,0 2,150.7 8874 420.0 250.0 190.0 1.747.4 769 320 220 168 1477 5 5 ASSETS: Current Assets: Cash Marketable Securities Accounts Receivable. Net Inventories Total Current Assets Property, Plant and Equipment Buildings and Related Improvements Machinery and Equipment Total Property, plant and Equipment Less Accumulated Depreciation Net Property, Plant and Equipment Other Assets Finance Receivables, Net Goodwill, Net Other Assets Total 9 1047 1056 2103 253 1850 1012 1015 2027 251 1776 978 1012 1990 249 1741 945 935 1880 247 1633 766 825 1591 245 1346 10 11 12 13 1120.1 612.1 1732.2 992 313.9 1305.9 750 220 970 625 178 803 482 100 582 18 15 6813.2 5763.9 4861.7 4183.4 3405 12 18 10 98 83 926.8 1107.8 157 61 823 101 85 920.9 1106,9 160 120 90 903.9 1113.9 190 58 171 1532.9 212 185 894.3 1291.3 260 55 233 1839.3 242 188 887.6 1317.6 275 53 250 TOTAL ASSETS 16 LIABILITIES AND STOCKHOLDERS' EQUITY: Current Liabilies: Accounts Payable Current Portion of Long-Term Debt 20 Income Taxes Total Current Liabilities Long-Term Debt Postretirement Healthcare Benefits Other Long-Term Liabilities Total Liabilies STOCKHOLDERS' EQUITY: Common Stock Additional Paid-In Capital Retained Earnings 20 Total Stockholders' Equity 29 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY: Beginning Retained Earnings Net Income 33 Dividends Paid Ending Retained Earnings 59 84.1 1408.1 1410 1895.6 27 142 23 $240.1 5405.1 135 26 4192.9 4353.9 129 27 3172.8 3328.8 115 43 2186.2 2344.2 112 45 1352.4 1509.4 30 6813.2 5763.9 4861.7 4183.4 3405 31 32 41929 13182 271 $240.1 31728 1290.2 270 4192.9 2186.2 1254.6 268 3172.8 1352.4 1099.8 266 21862 520 1088.4 256 1352.4 34 Invoice Date 1/5/96 1/8/96 2/4/96 3/2/96 3/29/96 4/25/96 5/22/96 6/18/96 7/15/96 18/11/96 9/7/96 10/4/96 13 10/31/96 11 11/27/96 12/24/96 1/20/97 2/16/97 13/15/97 4/11/97 S/8/97 1 6/4/97 17/1/97 27/28/97 8/24/97 2 9/20/97 22 10/17/97 2 11/13/97 12/10/97 1/6/98 2/2/98 20 3/1/98 2 3/28/98 24/24/98 5/21/98 20 6/17/98 30 7/14/98 18/10/98 9/6/98 33 10/3/98 10/30/98 34 11/26/08 12/23/98 1/9/99 Item Description Pint Glasses Beer Steins T-Shirts Beer Mugs Golf Shirts Sweatshirts Jackets Divot Tool Golf Towels Home Brew Kits Beer Posters Neon Beer Signs Beer Openers Beer Taps Christmas Omaments Beer Ingredients Packets Golf Shirts T-Shirts Golf Shirts Pint Glasses Beer Mugs T-Shirts Divot Tool Sweatshirts Golf Towels Beer Steins Sweatshirts Christmas Ornaments T-Shirts Beer Mugs Golf Shirts Pint Glasses Divot Tool Golf Shirts T-Shirts Golf Towels Beer Mugs Sweatshirts Pint Glasses Home Brew Kits T-Shirts Sweatshirts Beer Steins Number Bought SO 75 100 30 25 32 55 15 25 10 SO 15 20 100 100 25 25 80 25 50 30 50 15 32 25 75 32 100 30 30 25 50 15 25 30 25 30 32 50 -10 30 32 75 Price Invoice Amount Vendor Name 537.36 S 1,867.82 Bar Glass Co. $66.95 $ 5,021.36 German Stein Co. S50.21 S 5,021 36 T-Shirts 399.25 5 2,977.35 Mug Designs $8.00 $ 200.00 Golf Shirt Inc 56219 $ 1.990.00 Sweatshirt $112.73 6,200.00 Jackets $661335 9,920.00 Golf Accessories S15.40 S 385.00 Golf Accessories $60.02 $ 600.16 Home Brew Supplies 586.39 $ 431948 Poster Company $23.44 5 351.54 Neon Sing Co. $481.84 9,636.88 Restaurant Supply Co. $40.00 $ 4,000.00 American Beer Taps S1.12 5 112.00 North Pole Store SI5.48 S 387.12 Hops & Barley $340.00 S 8,500.00 Golf Shirt Inc $62.77 $ 5,021.36 T-Shirts $394,54 S 9,863.55 Golf Shirt Inc. $7.62 S 380.94 Bar Glass Co. $33.33 5 1,000.00 Mug Designs $100.43S 5,021.36 T-Shirts $127.83 5 1.917.50 Golf Accessories $12.03 $ 385.00 Sweatshirt $88.45 S 2.211.29 Golf Accessories $66.95 S 5,021.36 German Stein Co. $69.38 $ 2,220.00 Sweatshirt $49.25 $ 4,925 32 North Pole Store $167.38 S 5,021.36 T-Shirts $28.07 5 842.11 Mug Designs $74.71 S 1,867.82 Golf Shirt Inc. $37.36 S 1,867.82 Bar Glass Co. $273.92 S 4.108.76 Golf Accessories $14.59 S 364.67 Golf Shirt Inc. $167.385 3,021.36 T-Shirts $74.71 S 1,867.82 Golf Accessories $17.58 S $27.50 Mug Designs $27.29 $ 873.30 Sweatshirt $4.00 5 200.00 Bar Glass Co. $48.13 S 481.29 Home Brow Supplies $16738 5 5,021.36 T-Shirts $89.50 S 2,863.86 Sweatshirt 566055 5,021 36 German Stein Co Vendor Address 25 Pint Way 102 Stein View 657-T Street 46 Mug Blvd 2034 Fairway Drive 4465 Sweat Lane 602 Appearal Circle 1055 Sand Trap Way 1056 Sand Trap Way 245 Brew Lang 999 Billboard Way 123 Neon Drive 65 Main Street 44 American Blvd 689 Snow Hill Road 177 Hops Terrace 2034 Fairway Drive 657-T Street 2034 Fairway Drive 25 Pint Way 46 Mug Blvd. 657 T Street 1055 Sand Trap Way 4465 Sweat Lane 1056 Sand Trap Way 102 Stein View 4465 Sweat Lane 689 Snow Hill Road 657-T Street 46 Mug Blvd. 2034 Fairway Drive 25 Pint Way 1055 Sand Trap Way 2034 Fairway Drive 657-T Street 1056 Sand Trap Way 46 Mug Blvd. 4465 Sweat Lane 25 Pint Way 245 Brew Lane 657-T Street 4465 Sweat Lane 102 Stein View VA 1/9/99 2/15/99 3/14/99 4/10/99 5/7/99 6/3/99 6/30/99 7/27/99 823/99 9/19/99 10/16/99 11/12/99 12/9/99 1/5/00 2/1/00 2/28/00 3/26/00 3/26/00 4/22/00 5/19/00 6/15/00 7/12/00 8/8/00 9/4/00 10/1/00 10/28/00 11/24/00 1221/00 1/17/01 2/13/01 3/12/01 4/8/01 S/5/01 6/1/01 628/01 7/25/01 8/21/01 9/17/01 10/14/01 10 11/10/01 12/7/01 1/3/02 1/30/02 3 2/26/02 34 3/25/02 4/21/02 5/18/02 Beer Steins Golf Shirts Neon Beer Signs Divot Tool Golf Shirts PintGlasses Golf Shirts Beer Mugs Sweatshirts Beer Steins Beer Posters Beer Openers Beer Taps T-Shirts Pint Glasses Beer Mugs T-Shirts Golf Shirts Golf Shirts Divot Tool Golf Towels Home Brew Kits Beer Steins Sweatshirts Pint Glasses Neon Beer Signs Christmas Omaments T-Shirts Divot Tool Golf Shirts Beer Mugs Golr Shirts Golf Towels Sweatshirts T-Shirts Beer Ingredients Packets Christmas Omaments Home Brew Kits Pint Glasses Beer Steins Divot Tool Beer Mugs Beer Taps Golf Shirts Beer Openers T-Shirts Golf Shirts 75 25 15 15 25 50 25 30 32 75 50 20 100 30 SO 10 30 25 25 15 25 10 75 32 SO 15 100 30 15 25 30 25 25 32 30 25 100 10 50 75 15 30 100 25 20 30 25 566.95 S $12.72 S $33.86 S $52.00 S $35.60 S $180.00 $ $21.98 $ $67.92 S 59336 5 $66.95 S 56.99 S 524.06 5 $43.19 5 5167385 $189.28 5 $1284 S $167.385 S130 574.71 5 $24.33 S $390.00 SIS 90 $ $66.95 $ $40.58 S $30.68 5 S266.67 S $1.40 $ S167.38 S $21.43 S SI5.24 s $18.70 $ $72.00 S $74.71 S SX0.06 5 $167.38 s 59711 S $49.50 $ $80.25 S $36.55 S 66.95 s $132.37 S 562.50 S $3.30 s $24.89 S $39.84 S $1673% S 53430 $ 5,021.36 German Stein Co. 318.00 Golr Shirt Inc 50795 Neon Sing Co 780.00 Golf Accessories 890.00 Golf Shirt Inc. 9,000.00 Bar Glass Co. 549.38 Golf Shirt Ine 1.91750. Mug Designs 2.98731 Sweatshirt 5,021 36 German Stein Co. 349,46 Poster Company 48129 Restaurant Supply Co. 4.319.45 American Beer Tops 5,021 36 T Shirts 9,464.00 Bar Glass Co. 385.25 Mug Designs 5,021 36 T Shirts 826.91 Golf Shirt Inc. 1,86782 Golf Shirt Ine 364.97 Golf Accessories 9.750.00 Golf Accessories 159.00 Home Brew Supplies 5,021.36 German Stein Co. 1.298,63 Sweatshirt 1,533.96 Bar Glass Co. 4,000.00 Neon Sing Co. 140,16 North Pole Store 3,021 36 T Shirts 321.51 Golf Accessories 380.94 Golr Shirt Ino 561.14 Mug Designs 1.800.00 Golf Shirt Ine 1.867.82 Golf Accessories 2.562.00 Sweatshirt 5,021 36 T-Shirts 2,427.70 Hops & Barley 4,950.00 North Pole Store 802.50 Home Brew Supplies 1.827.38 Bar Glass Co. 5,021.36 German Stein Co. 1.985.60 Golf Accessories 1,874.97 Mug Designs 330.00 American Beer Tips 622,20 Golf Shirt Inc 796,74 Restaurant Supply Co. 5,021 36 T Shirts 857.49 Golf Shirt Inc 102 Stein View 2034 Fairway Drive 123 Neon Drive 1055 Sand Trap Way 2034 Fairway Drive 25 Pint Way 2034 Fairway Drive 46 Mug Blvd 4465 Sweat Lane 102 Stein View 999 Billboard Way 65 Main Street 44 American Blvd. 657-T Street 25 Pint Way 46 Mug Blvd 657 T Street 2034 Fairway Drive 2034 Fairway Drive 1055 Sand Trap Way 1056 Sand Trap Way 245 Brew Land 102 Stein View 4465 Sweat Lane 25 Pint Way 123 Neon Drive 689 Snow Hill Road 657-T Street 1055 Sand Trap Way 2034 Fairway Drive 46 Mug Blvd 2034 Fairway Drive 1056 Sand Trap Way 4465 Sweat Lane 657-T Street 177 Hops Terraco 689 Snow Hill Road 245 Brew Lane 25 Pint Way 102 Stein View 1055 Sand Trap Way 46 Mug Blvd 44 American Blvd. 2034 Fairway Drive 65 Main Street 657-T Street 2034 Fairway Drive - OCT