visa assignment for finance
nuexiepan
visa_spreadsheets.xlsxT.1 Sponsorships
| Payments Due By Period, From Current Year (All Millions) | |||||
| 2013 Pg. 91 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $116 | $178 | $108 | $178 | $580 |
| 2012 Pg. 98 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $120 | $237 | $115 | $231 | $703 |
| 2011 Pg. 58 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $119 | $214 | $94 | $86 | $513 |
| 2010 Pg. 57 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $110 | $202 | $168 | $105 | $585 |
| 2009 Pg. 50 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $150 | $239 | $162 | $7 | $558 |
| 2008 Pg. 85 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Marketing & Sponsorships | $107 | $152 | $97 | $25 | $381 |
| 2007 Pg. 91 | Less than 1 Year | 1-3 Years | 3-5 Years | More than 5 Years | Total |
| Sponsorships | $18 | $24 | $3 | — | $45 |
| Source: Visa Accounts |
T.2 Revenues
| Year to | |||||
| All Millions | 09/30/2013 | 09/30/2012 | 09/30/2011 | 09/30/2010 | 09/30/2009 |
| Service revenues | $ 5,352 | $ 4,872 | $ 4,261 | $ 3,497 | $ 3,174 |
| Data processing revenues | $ 4,642 | $ 3,975 | $ 3,478 | $ 3,125 | $ 2,430 |
| International transaction fees | $ 3,389 | $ 3,025 | $ 2,674 | $ 2,290 | $ 1,916 |
| Other revenues | $ 716 | $ 704 | $ 655 | $ 713 | $ 625 |
| Incentives | $ (2,321) | $ (2,155) | $ (1,880) | $ (1,560) | $ (1,234) |
| Total operating revenues | $ 11,778 | $ 10,421 | $ 9,188 | $ 8,065 | $ 6,911 |
T.3 Expenses
| Year to | |||||
| All Millions | 09/30/2013 | 09/30/2012 | 09/30/2011 | 09/30/2010 | 09/30/2009 |
| Personnel expenses | $1,932 | $1,726 | $1,459 | $1,222 | $1,143 |
| Network & processing1 | $468 | $414 | $357 | $425 | $393 |
| Marketing2 | $876 | $873 | $870 | $964 | $918 |
| Professional fees3 | $412 | $385 | $337 | $286 | $353 |
| Depreciation & amortization | $397 | $333 | $288 | $265 | $226 |
| General & administrative expenses4 | $451 | $451 | $414 | $359 | $338 |
| Litigation provision (benefit) | $3 | $4,100 | $7 | -$45 | $2 |
| Total operating expenses | $4,539 | $8,282 | $3,732 | $3,476 | $3,373 |
| Total Operating Revenues | $11,778 | $10,421 | $9,188 | $8,065 | $6,911 |
| Operating Income | $7,239 | $2,139 | $5,456 | $4,589 | $3,538 |
| Non-Operating Income (Net) | 18 | 68 | 200 | 49 | 462 |
| Income Before taxes | $7,257 | $2,207 | $5,656 | $4,638 | $4,000 |
| Income Tax Provision | $2,277 | $65 | $2,010 | $1,674 | $1,648 |
| Adjustment For Non-Controlling Interest | $0 | $2 | $4 | $2 | $1 |
| Net income attributable to Visa Inc. | $4,980 | $2,144 | $3,650 | $2,966 | $2,353 |
| Notes | |||||
| 1 Called Network, electronic data processing (EDP) & communications expenses prior to 2012 | |||||
| 2 Called Advertising, marketing & promotion expenses prior to 2012 | |||||
| 3 Called Professional & consulting fees prior to 2012 | |||||
| 4 Called Administrative & other operating expenses prior to 2012 | |||||
T.4 Market Cap
| Market Value As At End of Sept (Thousands) | |
| 2013 | $89,754,613 |
| 2012 | $67,642,513 |
| 2011 | $45,809,735 |
| 2010 | $34,260,090 |
| 2009 | $32,715,030 |
| 2008 | $33,984,908 |
T.5 Ret Earn
| All Millions | 09/30/2013 | 09/30/2012 | 09/30/2011 | 09/30/2010 | 09/30/2009 | 09/30/2008 |
| Previous retained earnings (accumulated deficit) | $7,809 | $6,706 | $4,368 | $2,219 | $186 | -$501 |
| Net Income | $4,980 | $2,144 | $3,650 | $2,966 | $2,353 | $804 |
| Cash dividends declared & paid | -$864 | -$595 | -$423 | -$368 | -$318 | -$85 |
| Repurchase of class A common stock | -$3,951 | -$446 | -$889 | -$449 | $0 | $0 |
| Other Adjustments | $0 | $0 | $0 | $0 | -$2 | -$32 |
| Change in Year | $165 | $1,103 | $2,338 | $2,149 | $2,033 | $687 |
| Accumulated Earnings at Year End | $7,974 | $7,809 | $6,706 | $4,368 | $2,219 | $186 |
| Accumulated Other Comprehensive Income (loss), net | $21 | -$171 | -$176 | -$151 | -$188 | -$70 |
| Temporary Equity | $0 | $0 | $0 | $0 | $0 | $1,136 |
| Non-Controlling Interest | $0 | $0 | $0 | $3 | $4 | 0 |
| Paid in Capital | 18,875 | 19,992 | 19,907 | 20,794 | 21,160 | 21,060 |
| Class C Treasury stock | 0 | 0 | 0 | 0 | -2 | -35 |
| Equity at End of year | $26,870 | $27,630 | $26,437 | $25,014 | $23,193 | $22,277 |
T.6 Assets & Liabilities
| All Millions | 09/30/2013 | 09/30/2012 | 09/30/2011 | 09/30/2010 | 09/30/2009 | 09/30/2008 | 10/01/2007 |
| Total current assets | $7,822 | $11,786 | $9,190 | $8,734 | $9,241 | $11,174 | $4,701 |
| Investments & Client Incentives | $2,849 | $3,341 | $796 | $195 | $620 | $997 | $815 |
| Property, equipment & technology, net | $1,732 | $1,634 | $1,541 | $1,357 | $1,204 | $1,080 | $906 |
| Total other assets | $521 | $151 | $129 | $197 | $125 | $634 | $625 |
| Intangible assets | $11,351 | $11,420 | $11,436 | $11,478 | $10,883 | $10,883 | $10,883 |
| Goodwill | $11,681 | $11,681 | $11,668 | $11,447 | $10,208 | $10,213 | $9,139 |
| Total assets | $35,956 | $40,013 | $34,760 | $33,408 | $32,281 | $34,981 | $27,069 |
| Total current liabilities | $4,335 | $7,954 | $3,451 | $3,498 | $4,442 | $7,165 | $4,786 |
| Deferred tax liabilities | $4,149 | $4,058 | $4,205 | $4,181 | $3,807 | $3,811 | $3,758 |
| Total other liabilities | $602 | $371 | $667 | $715 | $839 | $1,728 | $2,240 |
| Total liabilities | $9,086 | $12,383 | $8,323 | $8,394 | $9,088 | $12,704 | $10,784 |
| Total Equity | $26,870 | $27,630 | $26,437 | $25,014 | $23,193 | $22,277 | ERROR:#REF! |
T.7 Intangibles
| Intangible Asset | $ millions |
| Tradename | $2,564 |
| Customer relationships | $6,799 |
| Visa Europe franchise right | $1,520 |
| $10,883 | |
T.8 Brand Values
| $ Millions | 2013 | 2012 | 2011 | 2010 | 2009 | 2008 |
| Interbrand | $5,465 | $4,944 | $4,478 | $3,998 | $3,170 | $3,385 |
| Brand Finance | $9,058 | $7,555 | $7,087 | $6,555 | $5,037 | $2,875 |
| BrandZ | $56,060 | $38,284 | $28,553 | $24,883 | $16,353 | NA |
T.9 Ratios
| Year to | ||||||
| 09/30/2013 | 09/30/2012 | 09/30/2011 | 09/30/2010 | 09/30/2009 | 09/30/2008 | |
| Operating Revenues | $11,778 | $10,421 | $9,188 | $8,065 | $6,911 | |
| Operating Expenses | $4,539 | $8,282 | $3,732 | $3,476 | $3,373 | |
| Adjustment Capitalizing Marketing Spend | ||||||
| Operating Expenses | $4,539 | $8,282 | $3,732 | $3,476 | $3,373 | |
| Operating Income | $7,239 | $2,139 | $5,456 | $4,589 | $3,538 | |
| Non-Operating Income | 18 | 68 | 200 | 49 | 462 | |
| Tax | 2277 | 65 | 2010 | 1674 | 1648 | |
| Adjustment for Non-controlling interest | 0 | 2 | 4 | 2 | 1 | |
| Net income After Tax | $4,980 | $2,144 | $3,650 | $2,966 | $2,353 | |
| Reconciliation | $4,980 | $2,144 | $3,650 | $2,966 | $2,353 | |
| Total Assets | $35,956 | $40,013 | $34,760 | $33,408 | $32,281 | |
| Marketing Assets | $0 | $0 | $0 | $0 | $0 | |
| Total + Marketing Assets | $35,956 | $40,013 | $34,760 | $33,408 | $32,281 | |
| Total Liabilities | $9,086 | $12,383 | $8,323 | $8,394 | $9,088 | |
| Total Equity | $26,870 | $27,630 | $26,437 | $25,014 | $23,193 | |
| Accumulated Earning Beginning of Year | $7,809 | $6,706 | $4,368 | $2,219 | 186 | -$501 |
| Net income After Tax | $4,980 | $2,144 | $3,650 | $2,966 | $2,353 | $804 |
| Adjustment for Increase in Brand Value | ||||||
| Dividends and Share Buy Back | -$4,815 | -$1,041 | -$1,312 | -$817 | -$320 | -$117 |
| Accumulated Earnings End of Year | $7,974 | $7,809 | $6,706 | $4,368 | $2,219 | $186 |
| Paid Up Capital | 18,875 | 19,992 | 19,907 | 20,794 | 21,160 | 21,060 |
| Adjustments | 21 | -171 | -176 | -148 | -186 | 1,031 |
| Total Equity | $26,870 | $27,630 | $26,437 | $25,014 | $23,193 | $22,277 |
| Ratios | ||||||
| ROIC | 26.4% | 10.7% | 18.3% | 14.3% | 11.1% | |
| ROE | 18.5% | 7.8% | 13.8% | 11.9% | 10.1% | |
| Total Asset Turnover | 32.8% | 26.0% | 26.4% | 24.1% | 21.4% | |
| ROA | 13.9% | 5.4% | 10.5% | 8.9% | 7.3% | |
| Notes: Return equals Net Income After Tax | ||||||
| Current practice is to ignore most marketing assets, count as 0 | ||||||
| ROIC is Return on Invested Capital = Return/Paid Up Capital | ||||||
| ROE is Return on Equity = Return/Total Equity | ||||||
| Total Asset Turnover = Operating Revenues/Total Assets | ||||||
| ROA is Return on Assets = Return/Total Assets | ||||||
