I need an Hershey ratio analysis done, can you please complete in excel format.

Thank you.

Comparative Balance Sheet With Horizontal Analysis 2011 2010 Particulars Increase (or Decrease ) Amount Percentage -21.59% 2.42% 693,686 399,499 648,953 136,861 167,559 2,046,558 1,559,717 516,745 111,913 38,544 138,722 4,412,199 884,642 390,061 533,622 55,760 141,132 2,005,217 1,437,702 524,134 123,080 21,387 161,212 4,272,732 - 190,956 9,438 115,331 26,427 26,427 41,341 122,015 -7,389 -11,167 17,157 -22,490 139,467 21.61% 18.73% 18.73% 2.06% 8.49% -1.41% -9.07% 80.22% -13.95% 3.26% 9,362 2.28% Current Assets: cash and cash equivalent Accounts Receivable trade Inventories Deferred Income taxes Prepaid Expenses and other Total Current Assets Property, pl plant, and equipment, net Goodwill Other intangibles Deferred income taxes Other assets Total assets Liabilities al and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries 3.18% 420,017 612,186 1,899 42,080 97,593 1,173,775 1,748,500 617,275 3,539,551 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,335,131 18,878 -7,503 17,992 -163,799 -125,070 206,675 122,815 204,420 -79.80% 74.69% -62.66% -9.63% 13.40% 24.84% 6.13% 74 0.02% -74 -0.12% 12.87% 7.43% 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23 626 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35285 55,952 324,879 -206,861 -227,264 -53,294 5.11% 105.67% -5.91% -11 659 .33 64% 420,017 612,186 1,899 2.28% 3.18% -79.80% 42,080 97,593 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,335,131 9,362 18,878 -7,503 17,992 -163,799 -125,070 206,675 122,815 204,420 1,173,775 1,748,500 617,275 3,539,551 74.69% -62.66% -9.63% 13.40% 24.84% 6.13% Liabilities al and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries Total stockholders' equity Total liability and stockholders' equity 74 0.02% -74 -0.12% 12.87% 7.43% 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23,626 872,648 4,412,199 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35,285 937,601 4,272,732 5.11% 105.67% 55,952 324,879 -206,861 -227,264 -53,294 -11,659 -64,953 139,467 -5.91% -33.04% -6.93% 3.26% Comparative Balan Vertical Analysis 2011 Particulars 2010 Amount Percent Amount Percent 16 9 15 3 4 46 693,686 399,499 648,953 136,861 167,559 2,046,558 1,559,717 516,745 111,913 38,544 138,722 4,412,199 884,642 390,061 533,622 55,760 141,132 2,005,217 1,437,702 524,134 123,080 21,387 161,212 4,272,732 20.70% 9.13% 12.49% 1.31% 3.30% 46.93% 33.65% 12.27% 2.88% 0.50% 3.77% 100.00% 35 12 3 1 3 100 Current Assets: cash and cash equivalent Accounts Receivable trade Inventories Deferred Income taxes Prepaid Expenses and other Total Current Assets Property, plant, and equipment, net Goodwill Other intangibles Deferred income taxes Other assets Total assets Liabilities and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss 10 14 0 1 420,017 612,186 1,899 4,080 97,593 1,173,775 1,748,500 617,276 3,539,551 2 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,355,131 10.00% 14.00% 0.00% 1.00% 6.00% 30.00% 36.00% 12.00% 78.00% 27 40 14 80 7 1 11 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 7.00% 1.00% 10.00% 102.00% -95.00% -5.00% 107 -97 -10 10 14 0 1 420,017 612,186 1,899 4,080 97,593 1,173,775 1,748,500 617,276 3,539,551 2 27 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,355,131 10.00% 14.00% 0.00% 1.00% 6.00% 30.00% 36.00% 12.00% 78.00% 40 14 80 Liabilities and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries Total stockholders' equity Total liability and stockholders' equity 7 1 11 107 -97 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23,626 872,648 4,412,199 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35,285 937,601 4,272,732 7.00% 1.00% 10.00% 102.00% -95.00% -5.00% 21.00% 1.00% 22.00% 100.00% -10 19 1 20 100 Comparative Balance Sheet With Horizontal Analysis 2011 2010 Particulars Increase (or Decrease ) Amount Percentage -21.59% 2.42% 693,686 399,499 648,953 136,861 167,559 2,046,558 1,559,717 516,745 111,913 38,544 138,722 4,412,199 884,642 390,061 533,622 55,760 141,132 2,005,217 1,437,702 524,134 123,080 21,387 161,212 4,272,732 - 190,956 9,438 115,331 26,427 26,427 41,341 122,015 -7,389 -11,167 17,157 -22,490 139,467 21.61% 18.73% 18.73% 2.06% 8.49% -1.41% -9.07% 80.22% -13.95% 3.26% 9,362 2.28% Current Assets: cash and cash equivalent Accounts Receivable trade Inventories Deferred Income taxes Prepaid Expenses and other Total Current Assets Property, pl plant, and equipment, net Goodwill Other intangibles Deferred income taxes Other assets Total assets Liabilities al and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries 3.18% 420,017 612,186 1,899 42,080 97,593 1,173,775 1,748,500 617,275 3,539,551 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,335,131 18,878 -7,503 17,992 -163,799 -125,070 206,675 122,815 204,420 -79.80% 74.69% -62.66% -9.63% 13.40% 24.84% 6.13% 74 0.02% -74 -0.12% 12.87% 7.43% 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23 626 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35285 55,952 324,879 -206,861 -227,264 -53,294 5.11% 105.67% -5.91% -11 659 .33 64% 420,017 612,186 1,899 2.28% 3.18% -79.80% 42,080 97,593 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,335,131 9,362 18,878 -7,503 17,992 -163,799 -125,070 206,675 122,815 204,420 1,173,775 1,748,500 617,275 3,539,551 74.69% -62.66% -9.63% 13.40% 24.84% 6.13% Liabilities al and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries Total stockholders' equity Total liability and stockholders' equity 74 0.02% -74 -0.12% 12.87% 7.43% 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23,626 872,648 4,412,199 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35,285 937,601 4,272,732 5.11% 105.67% 55,952 324,879 -206,861 -227,264 -53,294 -11,659 -64,953 139,467 -5.91% -33.04% -6.93% 3.26% Comparative Balan Vertical Analysis 2011 Particulars 2010 Amount Percent Amount Percent 16 9 15 3 4 46 693,686 399,499 648,953 136,861 167,559 2,046,558 1,559,717 516,745 111,913 38,544 138,722 4,412,199 884,642 390,061 533,622 55,760 141,132 2,005,217 1,437,702 524,134 123,080 21,387 161,212 4,272,732 20.70% 9.13% 12.49% 1.31% 3.30% 46.93% 33.65% 12.27% 2.88% 0.50% 3.77% 100.00% 35 12 3 1 3 100 Current Assets: cash and cash equivalent Accounts Receivable trade Inventories Deferred Income taxes Prepaid Expenses and other Total Current Assets Property, plant, and equipment, net Goodwill Other intangibles Deferred income taxes Other assets Total assets Liabilities and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury-common stock shares, at cost: Accumulated other comprehensive loss 10 14 0 1 420,017 612,186 1,899 4,080 97,593 1,173,775 1,748,500 617,276 3,539,551 2 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,355,131 10.00% 14.00% 0.00% 1.00% 6.00% 30.00% 36.00% 12.00% 78.00% 27 40 14 80 7 1 11 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 7.00% 1.00% 10.00% 102.00% -95.00% -5.00% 107 -97 -10 10 14 0 1 420,017 612,186 1,899 4,080 97,593 1,173,775 1,748,500 617,276 3,539,551 2 27 410,655 593,308 9,402 24,088 261,392 1,298,845 1,541,825 494,461 3,355,131 10.00% 14.00% 0.00% 1.00% 6.00% 30.00% 36.00% 12.00% 78.00% 40 14 80 Liabilities and Stockholders equity Current Liabilities Accounts Payable Accrued Liabilities Accrued income taxes Short Term Debts Current Portion of Long-term debts Total current liabilities Long term debt Other long-term liabilities Total Liabilities Stockholders' Equity: Common Stock share issued Class B common stocks, share issued Additional paid in capital Retained earnings Treasury common stock shares, at cost: Accumulated other comprehensive loss The Hershey Company's stockholders' equity Non-controlling interest in subsidiaries Total stockholders' equity Total liability and stockholders' equity 7 1 11 107 -97 299,269 60,632 490,817 4,699,597 -4,258,962 -442,331 849,022 23,626 872,648 4,412,199 299,195 60,706 434,865 4,374,718 -4,052,101 -215,067 902,316 35,285 937,601 4,272,732 7.00% 1.00% 10.00% 102.00% -95.00% -5.00% 21.00% 1.00% 22.00% 100.00% -10 19 1 20 100