Excel Practice Sheet

Question 1 Input: Input your age: 25.0 Input your younger sibling's age: 17.0 Question Answer Can you vote for president? For how many years have you been eligible to vote? Are both me and my younger sibling eligible to vote? Question 2 Input: Input expected company revenue: 300.0 Input actual company revenue: 400.0 Input expected company EBITDA: 50.0 Input actual company EBITDA: 60.0 Question Answer Did the company exceed revenue expectations? Did the company exceed both revenue and EBITDA expectations?

1 Forecasts 2016 2016 2016 1,578.0 1,625.3 1,674.1 583.8 601.4 619.4 994.1 1,023.9 1,054.7 172.0 177.2 182.5 822.1 846.8 872.2 3.00% 3.00% 3.00% 37.00% 37.00% 37.00% 10.90% 10.90% 10.90%

2014 2015 2016 Net earnings $1,500.0 $1,850.0 $2,130.0 Shares outstanding 0.0 50.0 75.0 Earnings per share (EPS)

Combine IF and AND functions to answer this question: Criteria: If on the job 5 years or more AND received an 8 or higher for a performance rating, output a salary reflecting a 5% raise, otherwise, output "No raise" Employee Age Salary Years at Company Performance Rating New salary A 25.0 $53,140.0 0.0 10.0 No raise B 48.0 $110,662.0 11.0 2.0 No raise C 48.0 $117,294.0 17.0 8.0 $123,158.7 D 34.0 $114,373.0 19.0 10.0 $120,091.7 Combine IF and OR functions to answer this question: Criteria: If on the job 5 years or more OR received an 8 or higher for a performance rating, output a salary reflecting a 5% raise, otherwise, output "No raise" Employee Age Salary Years at Company Performance Rating New salary A 25.0 $53,140.0 0.0 10.0 $55,797.0 B 48.0 $110,662.0 11.0 2.0 $116,195.1 C 48.0 $117,294.0 17.0 8.0 $123,158.7 D 34.0 $114,373.0 19.0 10.0 $120,091.7

Input Company Name: Lemonade Co. Tax rate 35.0% Income Statement for Lemonade Co. 12/31/14 12/31/15 12/31/16 12/31/17 Revenues 800.0 1,000.0 1,500.0 2,500.0 Cost of Goods Sold 300.0 500.0 1,200.0 3,400.0 Gross Profit 500.0 500.0 300.0 (900.0) Operating costs 35.0 45.0 55.0 65.0 Pretax Profit 465.0 455.0 245.0 (965.0) Taxes 0.0 0.0 0.0 0.0 Net Profit 465.0 455.0 245.0 (965.0) Basic Shares Outstanding 100.0 110.0 115.0 120.0 Basic EPS $4.65 $4.14 $2.13 ($8.04) Exit year 12/31/2016 Select a metric: Gross Profit Solution: Combining formulas to make more durable formulas without ha Accomplish using: Combination formulas: HLOOKUP w/ MATCH VLOOKUP w/MATCH OFFSET w/ MATCH INDEX w/ MATCH CHOOSE w/ MATCH

2014 2015 2016 2017 2018 Output: Err:504 <---- =MATCH(AE23,AC21:AG21,0)

ual to the lookup value, as long as data is in ascending order the lookup value as long as data is in descending order value that is less than lookup_value is returned. will return #N/A

2014 2015 2016 2017 2018 Output: Err:504 <---- =MATCH(AE23,AC21:AG21,0)

Input Company Name: Lemonade Co. Income Statement for Lemonade Co. Actuals Projections 12/31/2012 12/31/2013 12/31/2014 12/31/2015 12/31/2016 Revenues 1,500.0 3,500.0 4,500.0 4,500.0 4,500.0 Cost of Goods Sold 1,200.0 3,400.0 4,000.0 0.0 0.0 Gross Profit 300.0 100.0 500.0 4,500.0 4,500.0 Operating costs 55.0 65.0 78.0 78.0 78.0 Non-operating costs 15.0 15.0 15.0 15.0 15.0 Pretax Profit 230.0 20.0 407.0 4,407.0 4,407.0 Taxes 80.0 5.0 141.6 1,542.5 1,542.5 Tax rate 34.8% 25.0% 34.8% 35.0% 35.0% Net Profit 150.0 15.0 265.4 2,864.6 2,864.6 Shares Outstanding 115.0 120.0 125.0 125.0 125.0 EPS $1.30 $0.13 $2.12 $22.92 $22.92 Select a case: <-insert a dropdown menu with the options Best case Revenue growth (%) COGS margin (%) Revenue Best case 24.0% 26.0% Base case 20.0% 22.0% Weak case 16.0% 18.0% COGS Best case 35.0% 40.0% Base case 40.0% 45.0% Weak case 45.0% 50.0% $22.92 Revenue growth rate assumptions: 16.0% 18.0% 20.0% <-Build a data table that ou 22.0% 24.0% Revenue growth rate assumptions 16.0% 18.0% 20.0% $22.92 Build a data table where the output is 2015 EPS , sensitized using BOTH the following inputs:

Revenue growth rate assumptions 16.0% 18.0% Cost of Goods Sold margin assumptions 35.0% 37.0% $22.92 16.0% 18.0% 20.0% 39.0% 38.0% 37.0% 36.0% 35.0% 34.0%

12/31/2017 4,500.0 0.0 4,500.0 78.0 15.0 4,407.0 1,542.5 35.0% 2,864.6 125.0 $22.92 e, Base case, Weak case <-Using OFFSET & MATCH, output revenue growth based on the scenario selected in the dropdow <-Using OFFSET & MATCH, output COGS % margin based on the scenario selected in the dropdown 28.0% 24.0% 20.0% 45.0% 50.0% 55.0% utputs 2015 EPS at the revenue sensitivities above 22.0% 24.0% <-Build a data table that outputs 2015 EPS at the revenue sensitivities above

20.0% 22.0% 24.0% 39.0% 41.0% 43.0% 45.0% 22.0% 24.0%

wn n

Input Company Name: Lemonade Co. Income Statement for Lemonade Co. Actuals Projections 12/31/2012 12/31/2013 12/31/2014 12/31/2015 12/31/2016 Revenues 1,500.0 3,500.0 4,500.0 5,220.0 6,159.6 Cost of Goods Sold 1,200.0 3,400.0 4,000.0 2,088.0 2,771.8 Gross Profit 300.0 100.0 500.0 3,132.0 3,387.8 Operating costs 55.0 65.0 78.0 78.0 78.0 Non-operating costs 15.0 15.0 15.0 15.0 15.0 Pretax Profit 230.0 20.0 407.0 3,039.0 3,294.8 Taxes 80.0 5.0 141.6 1,063.7 1,153.2 Tax rate 34.8% 25.0% 34.8% 35.0% 35.0% Net Profit 150.0 15.0 265.4 1,975.4 2,141.6 Shares Outstanding 115.0 120.0 125.0 125.0 125.0 EPS $1.30 $0.13 $2.12 $15.80 $17.13 Select a case: Base case <-insert a dropdown menu with the options Best case Revenue growth (%) 16.0% 18.0% COGS margin (%) 40.0% 45.0% Revenue Best case 24.0% 26.0% Base case 16.0% 18.0% Weak case 16.0% 18.0% COGS Best case 35.0% 40.0% Base case 40.0% 45.0% Weak case 45.0% 50.0% $15.80 Revenue growth rate assumptions: 16.0% $15.80 18.0% $16.08 20.0% $16.36 <-Build a data table that ou 22.0% $16.65 24.0% $16.93 Revenue growth rate assumptions 16.0% 18.0% 20.0% $15.80 $15.80 $16.08 $16.36 Build a data table where the output is 2015 EPS , sensitized using BOTH the following inputs:

Revenue growth rate assumptions 16.0% 18.0% Cost of Goods Sold margin assumptions 35.0% 37.0% $15.80 16.0% 18.0% 20.0% 39.0% $16.07 $16.36 $16.65 38.0% $16.35 $16.64 $16.93 37.0% $16.62 $16.91 $17.21 36.0% $16.89 $17.19 $17.49 35.0% $17.16 $17.46 $17.77 34.0% $17.43 $17.74 $18.05

12/31/2017 7,391.5 3,695.8 3,695.8 78.0 15.0 3,602.8 1,261.0 35.0% 2,341.8 125.0 $18.73 e, Base case, Weak case 20.0% <-Using OFFSET & MATCH, output revenue growth based on the scenario selected in the dropdown 50.0% <-Using OFFSET & MATCH, output COGS % margin based on the scenario selected in the dropdown 28.0% 20.0% 20.0% 45.0% 50.0% 55.0% utputs 2015 EPS at the revenue sensitivities above 22.0% 24.0% $16.65 $16.93 <-Build a data table that outputs 2015 EPS at the revenue sensitivities above

20.0% 22.0% 24.0% 39.0% 41.0% 43.0% 45.0% 22.0% 24.0% $16.93 $17.22 $17.22 $17.51 $17.50 $17.80 $17.79 $18.09 $18.07 $18.38 $18.36 $18.67

2015 Revenue growth assumptions $15.80 16.0% 18.0% 20.0% 22.0% 2015 44.0% Err:522 Err:522 Err:522 Err:522 COGS 42.0% Err:522 Err:522 Err:522 Err:522 margin 40.0% $15.80 Err:522 Err:522 Err:522 assumptions 38.0% Err:522 Err:522 Err:522 Err:522

Absolute Value Input a number: (4.0) Return absolute value 4.0 =ABS(C3) Ceiling Input EPS ($xx.xx): $4.23 Round input up to nearest $0.05 $4.30 =CEILING(C8,0.1) Floor Input EPS ($xx.xx): $4.23 Round input down to nearest $0.05 $4.20 =FLOOR(C13,0.05) Combinations Input useful life (n years) of a fixed asset: 15 Return sum of years' digits n(n+1)/2 120 =COMBIN(C18+1,2) Round Net profits $1,807.0 Shares outstanding 123.0 EPS $14.69 =ROUND(C23/C24,2) Round Up Net profits $1,807.0 Shares outstanding 123.0 EPS $14.70 =ROUNDUP(C23/C24,2) Round Down Net profits $1,807.0 Shares outstanding 123.0 EPS $14.69 =ROUNDDOWN(C23/C24,2) Max 2014 2015 2016 2017 Cash available to paydown / (needed from ad (200.0) 900.0 750.0 1,040.0 Short-term debt - Beginning of period $800.0 $0.0 $0.0 $0.0 Short-term debt - End of period (using MAX) Min Borrowing capacity will be calculated as 5x (the lesser of last year's EBITDA or the average EBITDA over the last three years) 2014 2015 2016 Average EBITDA 350.0 367.5 385.9 367.8 Borrowing capacity Count Property Price (000's) Hillside $348.0 Riviera 263.0 Agora Sold Lexington 309.0 Tremont 123.0 Weymouth Sold York 131.0 Deville 238.0 Cobble Hill 385.0 Number of Properties Available for Sale =COUNT(C54:C62) Number of Properties Available for Sale or Sold =COUNTA(C54:C62) Number of Properties > $250,000 =COUNTIF(C54:C62,">250") Product 2011 Free Cash Flow $1,500.0 Weighted Average Cost of Capital (WACC) 8.0% Discount Factor 0.8573 Midyear Adjustment Factor 1.0392 Present Value Cash Flow (2009) PV and FV PV FV Annual interest rate 12.0% 12.0% Payment amount per month ($500.0) ($500.0) Life of loan 5 years 5 years Payment made at the beginning of each peri 1 1 Rate per month 1.0% 1.0% Number of payments 60 60 NPV NPV Annual discount rate 12.0% Cash outflow on 12/31/14 ($1,000.0) Cash inflow on 12/31/15 $250.0 Cash inflow on 12/31/16 $400.0 Cash inflow on 12/31/17 $500.0 Cash inflow on 12/31/18 $480.0 Cash inflow on 12/31/19 $700.0 NPV vs XNPV XNPV Hacking NPV to calculate off BOP XNPV NPV XNPV NPV Annual discount rate 12.0% rate: 10.0% rate: 10.0% rate: 10.0% 4/12/2014 ($1,000.0) 12/31/14 1,000.0 1,000.0 1,000.0 1/31/2015 $250.0 12/31/15 1,000.0 1,000.0 1,000.0 9/30/2015 $400.0 12/31/16 1,000.0 1,000.0 1,000.0 6/30/2016 $500.0 12/31/17 1,000.0 1,000.0 1,000.0 4/30/2018 $480.0 3,169.9 3,486.4 3,486.9 5/31/2018 $700.0 =NPV(G99,G100:G103) =XNPV(I99,I100:I103,F100:F103) IRR IRR vs XIRR Initial investment expenditure ($1,000.0) Cash inflow after period 1 $100.0 IRR XIRR Cash inflow after period 2 $200.0 4/12/2014 (1,000.0) (1,000.0) Cash inflow after period 3 $300.0 1/31/2015 400.0 400.0 Cash inflow after period 4 $400.0 9/30/2015 300.0 300.0 Cash inflow after period 5 $500.0 6/30/2016 800.0 800.0 Internal Rate of Return 20.3% 27.9% =IRR(G111:G114) =XIRR(I111:I114,F111:F114) XIRR Dates of Cash Flows Cash Flows 4/12/2014 ($1,000.0) 1/31/2015 $100.0 9/30/2015 $200.0 6/30/2016 $300.0 4/30/2018 $400.0 5/31/2018 $500.0 Internal Rate of Return Goal Seek Car Loan Amount $15,000 Term in Months 36.0 Monthly Interest Rate 2.0% Monthly Payment ($588)

Absolute Value Input a number: (4.0) Return absolute value 4.0 =ABS(C3) Ceiling Input EPS ($xx.xx): $4.23 Round input up to nearest $0.05 $4.30 =CEILING(C8,0.1) Floor Input EPS ($xx.xx): $4.23 Round input down to nearest $0.05 $4.20 =FLOOR(C13,0.05) Combinations Input useful life (n years) of a fixed asset: 15 Return sum of years' digits n(n+1)/2 120 =COMBIN(C18+1,2) Round Net profits $1,807.0 Shares outstanding 123.0 EPS $14.69 =ROUND(C23/C24,2) Round Up Net profits $1,807.0 Shares outstanding 123.0 EPS $14.70 =ROUNDUP(C23/C24,2) Round Down Net profits $1,807.0 Shares outstanding 123.0 EPS $14.69 =ROUNDDOWN(C23/C24,2) Max 2014 2015 2016 2017 Cash available to paydown / (needed from additional) short-term debt (200.0) 900.0 750.0 1,040.0 Short-term debt - Beginning of period $800.0 $1,000.0 $100.0 $0.0 Short-term debt - End of period (using MAX) $1,000.0 $100.0 $0.0 $0.0 =MAX(0,C42-C41) Min Borrowing capacity will be calculated as 5 x (the lesser of last year's EBITDA or the average EBITDA over the last three years) 2014 2015 2016 Average EBITDA 350.0 367.5 385.9 367.8 Borrowing capacity 1,839.0 =5*MIN(F49,E49) Count Property Price (000's) Hillside $348.0 Riviera 263.0 Agora Sold Lexington 309.0 Tremont 123.0 Weymouth Sold York 131.0 Deville 238.0 Cobble Hill 385.0 Number of Properties Available for Sale 7 =COUNT(C54:C62) Number of Properties Available for Sale or Sold 9 =COUNTA(C54:C62) Number of Properties > $250,000 4 =COUNTIF(C54:C62,">250") Product 2011 Free Cash Flow $1,500.0 Weighted Average Cost of Capital (WACC) 8.0% Discount Factor 0.8573 Midyear Adjustment Factor 1.0392 Present Value Cash Flow (2009) $1,336.5 =PRODUCT(C81,C83,C84) PV and FV PV FV Annual interest rate 12.0% 12.0% Payment amount per month ($500.0) ($500.0) Life of loan 5 years 5 years Payment made at the beginning of each period 1 1 Rate per month 1.0% 1.0% Number of payments 60 60 $22,702.3 $41,243.2 NPV NPV Annual discount rate 12.0% Cash outflow on 12/31/14 ($1,000.0) Cash inflow on 12/31/15 $250.0 Cash inflow on 12/31/16 $400.0 Cash inflow on 12/31/17 $500.0 Cash inflow on 12/31/18 $480.0 Cash inflow on 12/31/19 $700.0 $535.92 NPV vs XNPV XNPV Hacking NPV to calculate off BOP XNPV NPV XNPV NPV Annual discount rate 12.0% rate: 10.0% rate: 10.0% rate: 10.0% 4/12/2014 ($1,000.0) 12/31/14 1,000.0 1,000.0 1,000.0 1/31/2015 $250.0 12/31/15 1,000.0 1,000.0 1,000.0 9/30/2015 $400.0 12/31/16 1,000.0 1,000.0 1,000.0 6/30/2016 $500.0 12/31/17 1,000.0 1,000.0 1,000.0 4/30/2018 $480.0 3,169.9 3,486.4 3,486.9 5/31/2018 $700.0 =NPV(G99,G100:G103) =XNPV(I99,I100:I103,F100:F103) $696.9 IRR IRR vs XIRR Initial investment expenditure ($1,000.0) Cash inflow after period 1 $100.0 IRR XIRR Cash inflow after period 2 $200.0 4/12/2014 (1,000.0) (1,000.0) Cash inflow after period 3 $300.0 1/31/2015 400.0 400.0 Cash inflow after period 4 $400.0 9/30/2015 300.0 300.0 Cash inflow after period 5 $500.0 6/30/2016 800.0 800.0 Internal Rate of Return 12.0% 20.3% 27.9% =IRR(G111:G114) =XIRR(I111:I114,F111:F114) XIRR Dates of Cash Flows Cash Flows 4/12/2014 ($1,000.0) 1/31/2015 $100.0 9/30/2015 $200.0 6/30/2016 $300.0 4/30/2018 $400.0 5/31/2018 $500.0 Internal Rate of Return 14.2% Goal Seek Car Loan Amount $15,000 Term in Months 36.0 Monthly Interest Rate 2.0% Monthly Payment ($588)

Car Sales by Manufacturer, Region, and Date

Car Sales by Manufacturer, Region, and Date

COUNTIF Criteria The criteria in count is mostly used to test weather the array is <> or = to a specific criteria or another range (doesn't have to be the same length). For example, given the critera and range, countif will tell us How many #s in range equal the number in the criteria (23): How many # greater than 23: How many # less than 23: How many # less than or equal to 23: Crtiera can be both numbers or text. The criteria in count doesn’t have to be one data point - it can be an array. For example, in this example, the countif function is storing how many times the criteria range contained the same numbers as in the range: But note that it doesn't sum the array. For that you need to wrap a SUMPRODUCT function around it (and you cant use SUM: This works because SUMPRODCT instructs excel to sum all the arguments in the array. If there's a second array (i.e. the traditional use of sumproduct) then it multiplies the first arguments of each array before summing. But if there isnt a second array, it just sums everything up, like SUM. But unlike SUM, you can feed an array to sumproduct

Range 1 Criteria 23 23 23 14 2 <-=COUNTIF(D4:D6,E4) is the "long form" syntax for equal 0 1 3 Range 1 Crtiera range 23 2 12 7 14 23 1 12 0 This formula, while outputting 0 - actually stores the array {0;0;1;0;1} 2

List of countries Olympic event Gold Silver Andorra Event 1 United Kingdom Germany United Arab Emirates Event 2 China Colombia Afghanistan Event 3 Cuba Ukraine Antigua and Barbuda Event 4 Colombia Colombia Anguilla Event 5 Portugal United States Albania Event 6 United States China Argentina Event 7 Indonesia Vietnam American Samoa Event 8 Philippines Tunisia Austria Event 9 United States China Australia Event 10 Russia United States Aruba Event 11 Poland China Azerbaijan Event 12 United States South Korea Bosnia and Herzegovina Event 13 Russia Colombia Barbados Event 14 Indonesia China Bangladesh Event 15 Portugal Philippines Belgium Event 16 Israel Ethiopia Burkina Faso Event 17 Indonesia Kazakhstan Bulgaria Event 18 China Georgia Bahrain Event 19 Brazil Bulgaria Burundi Event 20 Indonesia Morocco Benin Event 21 China Ukraine Bermuda Event 22 China China Brunei Event 23 United States China Bolivia Event 24 Indonesia China Brazil Event 25 Armenia France Bahamas Event 26 Ukraine Peru Bhutan Event 27 Sweden Sweden Bouvet Island Event 28 Czech Republic Argentina Botswana Event 29 Russia China Belarus Event 30 Sweden Portugal Belize Event 31 Panama China Canada Event 32 United States Czech Republic Cocos [Keeling] Islands Event 33 Russia Colombia Congo [DRC] Event 34 Portugal China Central African Republic Event 35 Russia Macedonia Congo [Republic] Event 36 Philippines Ireland Switzerland Event 37 Brazil China Côte d'Ivoire Event 38 Czech Republic Japan

Cook Islands Event 39 Indonesia Serbia Chile Event 40 Sweden Poland Cameroon Event 41 China China China Event 42 Philippines Peru Colombia Event 43 Poland Indonesia Costa Rica Event 44 Brazil Thailand Cuba Event 45 Hungary Kyrgyzstan Cape Verde Event 46 China Pakistan Christmas Island Event 47 Russia Somalia Cyprus Event 48 Japan Colombia Czech Republic Event 49 Japan France Germany Event 50 Iraq Saudi Arabia Djibouti Event 51 Azerbaijan Norway Denmark Event 52 Norway South Africa Dominica Event 53 Indonesia China Dominican Republic Event 54 China Japan Algeria Event 55 Cambodia Armenia Ecuador Event 56 China Nepal Estonia Event 57 Ukraine Monaco Egypt Event 58 Indonesia China Western Sahara Event 59 Ukraine Portugal Eritrea Event 60 Venezuela Brazil Spain Event 61 China Macedonia Ethiopia Event 62 Malawi Guatemala Finland Event 63 Kazakhstan Syria Fiji Event 64 Colombia Belarus Falkland Islands [Islas Malvinas] Event 65 China Indonesia Micronesia Event 66 Pakistan Colombia Faroe Islands Event 67 Brazil Armenia France Event 68 China Indonesia Gabon Event 69 Ukraine Japan United Kingdom Event 70 Brazil Brazil Grenada Event 71 Indonesia Uganda Georgia Event 72 Australia China French Guiana Event 73 Russia Armenia Guernsey Event 74 South Africa China Ghana Event 75 Egypt Portugal Gibraltar Event 76 Ukraine Croatia Greenland Event 77 China Israel Gambia Event 78 Russia China Guinea Event 79 Belarus Vietnam Guadeloupe Event 80 Russia Kazakhstan

Equatorial Guinea Event 81 China China Greece Event 82 Dominican RepublicChina South Georgia and the South Sandwich Islands Event 83 Mexico China Guatemala Event 84 Greece China Guam Event 85 Brazil Mexico Guinea-Bissau Event 86 Croatia Brazil Guyana Event 87 China South Korea Gaza Strip Event 88 Indonesia Mexico Hong Kong Event 89 Uzbekistan Poland Heard Island and McDonald Islands Event 90 China Cambodia Honduras Event 91 Indonesia Ukraine Croatia Event 92 China Albania Haiti Event 93 France United States Hungary Event 94 Sweden Philippines Indonesia Event 95 Ukraine China Ireland Event 96 China China Israel Isle of Man India British Indian Ocean Territory Iraq Iran Iceland Italy Jersey Jamaica Jordan Japan Kenya Kyrgyzstan Cambodia Kiribati Comoros Saint Kitts and Nevis North Korea South Korea Kuwait Cayman Islands Kazakhstan Laos Lebanon Saint Lucia

Liechtenstein Sri Lanka Liberia Lesotho Lithuania Luxembourg Latvia Libya Morocco Monaco Moldova Montenegro Madagascar Marshall Islands Macedonia [FYROM] Mali Myanmar [Burma] Mongolia Macau Northern Mariana Islands Martinique Mauritania Montserrat Malta Mauritius Maldives Malawi Mexico Malaysia Mozambique Namibia New Caledonia Niger Norfolk Island Nigeria Nicaragua Netherlands Norway Nepal Nauru Niue New Zealand Oman Panama

Peru French Polynesia Papua New Guinea Philippines Pakistan Poland Saint Pierre and Miquelon Pitcairn Islands Puerto Rico Palestinian Territories Portugal Palau Paraguay Qatar Réunion Romania Serbia Russia Rwanda Saudi Arabia Solomon Islands Seychelles Sudan Sweden Singapore Saint Helena Slovenia Svalbard and Jan Mayen Slovakia Sierra Leone San Marino Senegal Somalia Suriname São Tomé and Príncipe El Salvador Syria Swaziland Turks and Caicos Islands Chad French Southern Territories Togo Thailand Tajikistan Tokelau

Timor-Leste Turkmenistan Tunisia Tonga Turkey Trinidad and Tobago Tuvalu Taiwan Tanzania Ukraine Uganda U.S. Minor Outlying Islands United States Uruguay Uzbekistan Vatican City Saint Vincent and the Grenadines Venezuela British Virgin Islands U.S. Virgin Islands Vietnam Vanuatu Wallis and Futuna Samoa Kosovo Yemen Mayotte South Africa Zambia Zimbabwe

Critera Q1 Criteria Q2 United States United States Germany Bronze Q1 Q2 Q3 France France 0 1 2 China 0 0 0 Question 1: In how many eve Poland 0 0 0 Question 2: In how many eve Russia 0 0 0 Question 3: How many total m Indonesia 1 1 1 Peru 1 1 1 Bonus: Using wildcards Croatia 0 0 0 How many countries contain the w Indonesia 0 0 0 How many countries start with the Comoros 1 1 1 Poland 1 1 1 Philippines 0 0 0 Brazil 1 1 1 Germany 0 1 1 Venezuela 0 0 0 Indonesia 0 0 0 Libya 0 0 0 Peru 0 0 0 El Salvador 0 0 0 United Kingdom 0 0 0 China 0 0 0 China 0 0 0 China 0 0 0 China 1 1 1 China 0 0 0 Colombia 0 1 1 Honduras 0 0 0 Philippines 0 0 0 Ukraine 0 0 0 Malaysia 0 0 0 China 0 0 0 Indonesia 0 0 0 Sierra Leone 1 1 1 Tanzania 0 0 0 Serbia 0 0 0 Russia 0 0 0 China 0 0 0 Poland 0 0 0 Peru 0 0 0

Russia 0 0 0 Czech Republic 0 0 0 Chile 0 0 0 Canada 0 0 0 Poland 0 0 0 Canada 0 0 0 China 0 0 0 Norway 0 0 0 Indonesia 0 0 0 Poland 0 0 0 France 0 1 2 Poland 0 0 0 Philippines 0 0 0 Jamaica 0 0 0 Mexico 0 0 0 Macedonia 0 0 0 Poland 0 0 0 Germany 0 1 1 Egypt 0 0 0 Kyrgyzstan 0 0 0 Nicaragua 0 0 0 China 0 0 0 Indonesia 0 0 0 China 0 0 0 Indonesia 0 0 0 Brazil 0 0 0 Japan 0 0 0 Russia 0 0 0 Guatemala 0 0 0 United States 1 1 1 Thailand 0 0 0 Syria 0 0 0 China 0 0 0 Guatemala 0 0 0 China 0 0 0 Honduras 0 0 0 Indonesia 0 0 0 China 0 0 0 Thailand 0 0 0 Israel 0 0 0 Ukraine 0 0 0 Slovenia 0 0 0

China 0 0 0 China 0 0 0 Tanzania 0 0 0 Philippines 0 0 0 China 0 0 0 Israel 0 0 0 Nigeria 0 0 0 United States 1 1 1 China 0 0 0 Pakistan 0 0 0 Iran 0 0 0 China 0 0 0 Sweden 1 1 2 Indonesia 0 0 0 Sweden 0 0 0 China 0 0 0

Criteria Q3 United States Germany France ents did the United States earn a medal? 10 ents did either the US, Germany or France win a medal? 15 medals were won by US, Germany and France? 18 word "united" in their name ? 3 letter "A"? 11

Function LEN 6 123456 LEFT hel hello 3 RIGHT llo hello 3 MID ell hello 2 3 PROPER Hello There hello there UPPER HELLO hello LOWER hello HELLO TRUNC 1234.25 1234.256 SEARCH 1 hello he FIND 2 hello ello <-The main difference between FIND and SEARCH is that FIND is case sensitive while SEARCH is not. Search also allows the use of wildcards when searching. SUBSTITUTE g12 m12 <-substitutes a portion of a string with another string. If there are multiple instances of the string portion, you can identify which instances should be substituted. REPLACE ahi!34567 am123456 <-replaces a portion of a string with another string/number, where the portion to be replaced is identified by finding the starting point and the length of the string Exercise: Using the functions we discussed build a formula that outputs: "Happy Halloween" by manipulating the following string Happy Belated Halloween Using SUBSTITUTE: Using REPLACE: Exercise 2: Output "Happy Halloween" regardless of the word in between "Happy" and "Halloween" Using LEFT AND RIGHT: Other approaches that may come in handy 6 SEARCH for first space starting in the first position 14 SEARCH for second space 8 Number of characters between the 2 spaces Using multiple steps or formulas: 6 SEARCH for first space starting in the first position 14 SEARCH for second space Happy LEFT (Happy has a space after it) Halloween RIGHT w LEN Combine

Function LEN 6 123456 LEFT hel hello 3 RIGHT llo hello 3 MID ell hello 2 3 PROPER Hello There hello there UPPER HELLO hello LOWER hello HELLO TRUNC 1234.25 1234.2564 SEARCH 1 hello he FIND 2 hello ello <-The main difference between FIND and SEARCH is that FIND is case sensitive while SEARCH is not. Search also allows the use of wildcards when searching. SUBSTITUTE g12 m12 <-substitutes a portion of a string with another string. If there are multiple instances of the string portion, you can identify which instances should be substituted. REPLACE ahi!34567 am1234567 <-replaces a portion of a string with another string/number, where the portion to be replaced is identified by finding the starting point and the length of the string Exercise: Using the functions we discussed build a formula that outputs: "Happy Halloween" by manipulating the following string Happy Belated Halloween Using SUBSTITUTE: Happy Halloween Using REPLACE: Happy Halloween Exercise 2: Output "Happy Halloween" regardless of the word in between "Happy" and "Halloween" Using LEFT AND RIGHT: Happy Halloween Other approaches that may come in handy 6 SEARCH for first space starting in the first position 14 SEARCH for second space 8 Number of characters between the 2 spaces Happy Halloween Using multiple steps or formulas: 6 SEARCH for first space starting in the first position 14 SEARCH for second space Happy LEFT (Happy has a space after it) Halloween RIGHT w LEN Happy Halloween Combine

EBITDA 2014 125.0 2015 132.5 2016 141.8 2017 150.3 2018 160.8 2019 170.4 2020 180.7 2021 191.5 2022 203.0 2023 215.2 Pick a start year: Pick an end year: Cumulative EBITDA from to :

EBITDA 2014 125.0 2015 132.5 2016 141.8 2017 150.3 2018 160.8 2019 170.4 2020 180.7 2021 191.5 2022 203.0 2023 215.2 Pick a start year: 2016 Pick an end year: 2021 Cumulative EBITDA from 2016 to 2021: 995.5

Sort the following table by industry, and then by market cap, in descendin Industry Company Ticker Share price Shares out. Energy Exxon Mobil wmt 94.0 4,320,000,000.0 Tech Apple xom 536.1 891,990,000.0 Consumer Procter & Gamble tw 79.0 2,710,000,000.0 Tech Google pg 1,200.0 336,050,000.0 Telecom Cisco kmb 21.6 5,150,000,000.0 Consumer Colgate csco 63.3 918,940,000.0 Consumer Kimberly Clark kmb 109.1 379,400,000.0 Industrials Alcoa aa 12.2 1,080,000,000.0 Retail Safeway goog 38.7 227,870,000.0 Tech Yahoo cl 37.6 1,010,000,000.0 Consulting Juniper msft 114.2 70,530,000.0 Real Estate BRE Properties yhoo 61.6 77,300,000.0 Tech Zynga znga 5.7 876,880,000.0 Telecom Logmein logm 44.2 24,190,000.0 Banking Goldman Sachs gs 169.9 467,360,000.0 Industry Company Ticker Share price Shares out. Banking Goldman Sachs gs 169.9 467,360,000.0 Banking Total Consulting Juniper msft 114.2 70,530,000.0 Consulting Total Consumer Procter & Gamble tw 79.0 2,710,000,000.0 Consumer Colgate csco 63.3 918,940,000.0 Consumer Kimberly Clark kmb 109.1 379,400,000.0 Consumer Total Energy Exxon Mobil wmt 94.0 4,320,000,000.0 Energy Total Industrials Alcoa aa 12.2 1,080,000,000.0 Industrials Total Real Estate BRE Properties yhoo 61.6 77,300,000.0 Real Estate Total Retail Safeway goog 38.7 227,870,000.0 Retail Total Tech Total Telecom Cisco kmb 21.6 5,150,000,000.0 Telecom Logmein logm 44.2 24,190,000.0 Telecom Total Grand Total

ng order LTM Revenue LTM EBITDA Market cap. 393,720,000,000.0 60,950,000,000.0 406,123,200,000.0 173,990,000,000.0 56,560,000,000.0 478,186,919,100.0 84,740,000,000.0 19,370,000,000.0 213,954,500,000.0 59,820,000,000.0 18,030,000,000.0 403,256,639,500.0 47,870,000,000.0 12,980,000,000.0 111,291,500,000.0 17,420,000,000.0 4,560,000,000.0 58,159,712,600.0 21,150,000,000.0 4,270,000,000.0 41,373,570,000.0 23,030,000,000.0 2,560,000,000.0 13,165,200,000.0 36,140,000,000.0 1,590,000,000.0 8,807,175,500.0 4,680,000,000.0 1,030,000,000.0 37,935,600,000.0 3,590,000,000.0 653,890,000.0 8,055,936,600.0 404,650,000.0 257,310,000.0 4,758,974,500.0 873,270,000.0 73,630,000.0 4,954,372,000.0 166,260,000.0 7,470,000.0 1,069,439,900.0 34,210,000,000.0 0.0 79,399,790,400.0 LTM Revenue LTM EBITDA Market cap. 34,210,000,000.0 0.0 79,399,790,400.0 79,399,790,400.0 3,590,000,000.0 653,890,000.0 8,055,936,600.0 8,055,936,600.0 84,740,000,000.0 19,370,000,000.0 213,954,500,000.0 17,420,000,000.0 4,560,000,000.0 58,159,712,600.0 21,150,000,000.0 4,270,000,000.0 41,373,570,000.0 313,487,782,600.0 393,720,000,000.0 60,950,000,000.0 406,123,200,000.0 406,123,200,000.0 23,030,000,000.0 2,560,000,000.0 13,165,200,000.0 13,165,200,000.0 404,650,000.0 257,310,000.0 4,758,974,500.0 4,758,974,500.0 36,140,000,000.0 1,590,000,000.0 8,807,175,500.0 8,807,175,500.0 924,333,530,600.0 47,870,000,000.0 12,980,000,000.0 111,291,500,000.0 166,260,000.0 7,470,000.0 1,069,439,900.0 112,360,939,900.0 1,870,492,530,100.0

REIT Property Type Region Sq. Ft. BRE Properties Residential East 5,800 $1,391 Capital Properties Retail West 2,000 $845 Equity Residential Office North 6,558 $1,391 Equity Residential Leisure South 8,683 $1,823 Capital Properties Residential South 769 $280 BRE Properties Retail East 3,900 $1,174 BRE Properties Office North 980 $680 Capital Properties Retail North 4,000 $1,887 Capital Properties Office North 3,850 $1,724 Equity Residential Retail South 450 $346 BRE Properties Office East 6,000 $1,355 Capital Properties Leisure West 826 $869 Equity Residential Retail West 5,401 $1,644 Equity Residential Office East 4,392 $1,904 Capital Properties Office North 2,974 $1,267 BRE Properties Leisure South 1,429 $1,563 BRE Properties Leisure South 2,590 $1,005 Capital Properties Residential North 1,511 $959 BRE Properties Leisure West 2,234 $1,246 Equity Residential Residential East 1,928 $1,223 Capital Properties Residential South 4,898 $1,667 BRE Properties Leisure North 4,200 $1,250 Equity Residential Residential North 1,785 $1,034 Capital Properties Residential South 1,100 $642 Capital Properties Retail West 3,214 $1,200 BRE Properties Office East 2,931 $1,827 Equity Residential Office South 4,875 $1,752 Equity Residential Leisure North 3,165 $1,271 Capital Properties Residential North 726 $418 Capital Properties Retail West 644 $633 Equity Residential Retail North 2,502 $934 BRE Properties Office South 930 $777 BRE Properties Residential East 4,169 $1,990 Equity Residential Leisure North 388 $854 BRE Properties Residential South 829 $535 Equity Residential Leisure West 774 $472 Capital Properties Residential East 1,264 $697 Equity Residential Retail East 7,809 $2,685 BRE Properties Office East 2,469 $1,548 Capital Properties Retail North 2,315 $1,409 Equity Residential Leisure West 1,050 $613 BRE Properties Residential East 5,143 $1,642 Capital Properties Office South 965 $823 Property Value ($ in 000's)

Capital Properties Retail South 4,490 $1,610 BRE Properties Office East 5,021 $1,731 Equity Residential Retail West 429 $647 Equity Residential Office North 1,533 $976 Equity Residential Leisure South 7,901 $3,127 Capital Properties Residential East 1,459 $980 Equity Residential Retail West 2,402 $1,240 BRE Properties Office North 675 $291 BRE Properties Leisure North 4,024 $1,595 Capital Properties Residential South 1,196 $927 Capital Properties Retail East 4,069 $1,965

Build a pivot table to answer the following questions 1. Which region shows the most overall property sales, by square footage? 2. Which region shows the most Leisure sales, by square footage? 3. Which region(s) have zero Leisure property sales? 4. In which region does BRE appear to have properties valued significantly above its peers? 6. Which REIT has the highest value real estate, in dollars? 8. What was the total value of Office real estate that Equity Residential sold in the South? 9. Which property type is the most popular (by number of properties) in the South? 10. What is the % of Equity Residential properties (by number of properties) as a % total properties in the Sout By looking at the Pivot Table that is not broken down by region, which property type appears to be Capital Prop Which REIT has the lowest number of retail properties?

Answers th? perties’s weakest in terms of value?

REIT Property Type Region Sq. Ft. BRE Properties Residential East 5,800 $1,391 Capital Properties Retail West 2,000 $845 Equity Residential Office North 6,558 $1,391 Equity Residential Leisure South 8,683 $1,823 Capital Properties Residential South 769 $280 BRE Properties Retail East 3,900 $1,174 BRE Properties Office North 980 $680 Capital Properties Retail North 4,000 $1,887 Capital Properties Office North 3,850 $1,724 Equity Residential Retail South 450 $346 BRE Properties Office East 6,000 $1,355 Capital Properties Leisure West 826 $869 Equity Residential Retail West 5,401 $1,644 Equity Residential Office East 4,392 $1,904 Capital Properties Office North 2,974 $1,267 BRE Properties Leisure South 1,429 $1,563 BRE Properties Leisure South 2,590 $1,005 Capital Properties Residential North 1,511 $959 BRE Properties Leisure West 2,234 $1,246 Equity Residential Residential East 1,928 $1,223 Capital Properties Residential South 4,898 $1,667 BRE Properties Leisure North 4,200 $1,250 Equity Residential Residential North 1,785 $1,034 Capital Properties Residential South 1,100 $642 Capital Properties Retail West 3,214 $1,200 BRE Properties Office East 2,931 $1,827 Equity Residential Office South 4,875 $1,752 Equity Residential Leisure North 3,165 $1,271 Capital Properties Residential North 726 $418 Capital Properties Retail West 644 $633 Equity Residential Retail North 2,502 $934 BRE Properties Office South 930 $777 BRE Properties Residential East 4,169 $1,990 Equity Residential Leisure North 388 $854 BRE Properties Residential South 829 $535 Equity Residential Leisure West 774 $472 Capital Properties Residential East 1,264 $697 Equity Residential Retail East 7,809 $2,685 BRE Properties Office East 2,469 $1,548 Capital Properties Retail North 2,315 $1,409 Equity Residential Leisure West 1,050 $613 BRE Properties Residential East 5,143 $1,642 Capital Properties Office South 965 $823 Property Value ($ in 000's)

Capital Properties Retail South 4,490 $1,610 BRE Properties Office East 5,021 $1,731 Equity Residential Retail West 429 $647 Equity Residential Office North 1,533 $976 Equity Residential Leisure South 7,901 $3,127 Capital Properties Residential East 1,459 $980 Equity Residential Retail West 2,402 $1,240 BRE Properties Office North 675 $291 BRE Properties Leisure North 4,024 $1,595 Capital Properties Residential South 1,196 $927 Capital Properties Retail East 4,069 $1,965

Build a pivot table to answer the following questions Answers 1. Which region shows the most overall property sales, by square footage? East 2. Which region shows the most Leisure sales, by square footage? South 3. Which region(s) have zero Leisure property sales? East 4. In which region does BRE appear to have properties valued significantly above its peers? East Leisure 6. Which REIT has the highest value real estate, in dollars? Equity Res BRE Prope 8. What was the total value of Office real estate that Equity Residential sold in the South? 1752 9. Which property type is the most popular (by number of properties) in the South? Residentia 10. What is the % of Equity Residential properties (by number of properties) as a % total properties in 28.57% Count of Property Value Region REIT East North South West Total Result BRE Properties 57.14% 25.00% 28.57% 10.00% 31.48% Capital Properties 21.43% 37.50% 42.86% 40.00% 35.19% Equity Residential 21.43% 37.50% 28.57% 50.00% 33.33% Total Result 100.00% 100.00% 100.00% 100.00% 100.00% By looking at the Pivot Table that is not broken down by region, which property type appears to be Ca Which REIT has the lowest number of retail properties?

sidential erties al

Conditional formatting (alt O D) Exercise 1: Sales Results Exercise 2: Historical vs Projected R 1. Highlight sales in the top 10% Given current year, color all rows in 2. Highlight entire row where sales were above: 30,000.0 Current year: Date Salesrep Sales Region Year 12/20/07 Amanda 29,688.0 Canada 2007 2014 2015 2/18/08 Barry 37,812.0 Canada 2008 Revenues 100.0 110.0 4/7/07 Sara 6,804.0 Latin America 2007 Expenses 55.0 60.5 3/1/08 John 14,867.0 USA 2008 9/5/06 Barry 29,406.0 Canada 2006 3/9/06 John 35,784.0 Latin America 2006 Exercise 3: Stock screen 4/9/07 Barry 30,005.0 USA 2007 Beta less than: 12/2/07 John 37,033.0 Mexico 2007 ROE greater than: 3/29/06 John 23,106.0 USA 2006 Highlight rows that meet criteria 10/18/07 John 9,910.0 Latin America 2007 2/17/06 Barry 11,012.0 Canada 2006 Stock Beta ROE 6/3/07 Sara 8,032.0 Canada 2007 1 -1 15% 3/21/07 Sara 10,112.0 Canada 2007 2 -2 0% 7/6/07 John 24,643.0 Canada 2007 3 -2 10% 12/18/07 Amanda 25,876.0 Mexico 2007 4 1 3% 11/8/07 John 25,627.0 Latin America 2007 5 -1 9% 12/19/07 John 13,656.0 Latin America 2007 6 3 31% 4/14/08 Barry 16,159.0 Canada 2008 7 1 23% 1/26/07 John 22,918.0 USA 2007 8 -2 7% 10/27/07 Amanda 18,825.0 USA 2007 9 -2 22% 9/26/06 Amanda 17,893.0 Mexico 2006 10 3 35% 4/2/08 Barry 35,667.0 Mexico 2008 11 -2 27% 4/28/07 Sara 8,538.0 Mexico 2007 12 4 9% 6/6/08 Amanda 38,989.0 USA 2008 13 4 15% 5/4/08 Barry 19,745.0 Latin America 2008 14 -2 10% 3/20/06 Sara 9,050.0 Canada 2006 15 2 19% 3/26/08 Sara 17,277.0 Mexico 2008 16 -1 21% 10/26/06 Amanda 39,030.0 Latin America 2006 17 -2 8% 7/1/06 John 37,998.0 Mexico 2006 18 -2 34% 1/26/06 Sara 29,229.0 Latin America 2006 19 1 5% 2/16/06 John 23,414.0 Latin America 2006 20 2 0% 12/25/07 Amanda 10,250.0 Canada 2007 21 4 21% 7/16/07 John 31,581.0 Canada 2007 22 -2 19% 10/18/06 Amanda 8,389.0 USA 2006 23 0 16% 3/16/08 Barry 22,551.0 Mexico 2008 24 1 6% 7/22/06 John 17,083.0 Latin America 2006 25 4 28% 3/14/07 Sara 22,556.0 Canada 2007 26 4 20%

5/8/07 Barry 21,328.0 Latin America 2007 27 4 28% 3/28/07 Sara 23,187.0 Latin America 2007 28 -1 8% 11/27/06 Sara 39,424.0 Canada 2006 29 4 10% 10/14/06 Sara 21,797.0 Canada 2006 30 4 6% 12/30/06 John 14,781.0 Mexico 2006 31 -1 7% 8/6/07 John 29,357.0 USA 2007 32 2 22% 6/6/06 Sara 18,499.0 Canada 2006 33 0 28% 3/3/08 Barry 36,672.0 Canada 2008 34 4 29% 4/20/08 Barry 28,048.0 Mexico 2008 35 3 24% 3/20/06 Sara 34,340.0 Canada 2006 36 4 33% 4/17/06 Sara 38,993.0 Mexico 2006 37 -2 35% 6/4/08 Amanda 5,219.0 Latin America 2008 38 3 27% 6/26/07 Sara 20,108.0 USA 2007 39 4 4% 10/9/07 John 34,661.0 Latin America 2007 40 -1 30% 3/20/06 Amanda 16,143.0 Latin America 2006 41 -2 13% 12/30/07 John 25,809.0 Latin America 2007 42 2 4% 3/29/07 Barry 36,392.0 Mexico 2007 43 0 12% 3/14/08 Barry 8,198.0 Mexico 2008 44 -2 34% 5/6/07 Amanda 7,333.0 USA 2007 45 1 22% 5/4/07 John 19,211.0 Canada 2007 46 2 2% 3/23/08 Sara 19,078.0 Canada 2008 47 4 18% 12/24/06 John 27,820.0 Canada 2006 48 -2 34% 10/14/07 Barry 32,391.0 USA 2007 49 2 34% 3/14/07 John 29,641.0 Mexico 2007 50 0 12% 2/22/07 Barry 10,953.0 Latin America 2007 3/11/07 Sara 17,379.0 Mexico 2007 12/2/06 John 18,451.0 Canada 2006 9/29/06 Sara 13,605.0 Latin America 2006 5/13/08 John 30,500.0 USA 2008 5/26/08 Barry 21,955.0 Canada 2008 4/7/08 Sara 37,154.0 Canada 2008 9/13/06 Barry 27,567.0 Latin America 2006 2/4/07 John 30,918.0 Canada 2007 4/11/06 Amanda 17,335.0 Mexico 2006 7/13/07 Amanda 35,432.0 Canada 2007 3/3/06 Barry 35,341.0 Canada 2006 11/24/06 Barry 15,071.0 Latin America 2006 9/6/07 Barry 29,598.0 Latin America 2007 7/6/07 Amanda 6,850.0 Canada 2007 2/19/06 John 33,946.0 Latin America 2006 6/24/07 John 30,562.0 Canada 2007 6/15/06 Amanda 6,100.0 Mexico 2006 6/8/07 John 15,446.0 Mexico 2007 2/5/07 Sara 26,538.0 USA 2007 12/14/07 John 7,455.0 Latin America 2007

8/30/06 John 37,299.0 Canada 2006 5/26/08 Barry 35,338.0 Latin America 2008 12/29/07 Barry 27,093.0 Latin America 2007 2/8/08 Sara 34,728.0 USA 2008 4/1/06 John 31,941.0 Canada 2006 1/5/08 Sara 30,310.0 Latin America 2008 4/20/06 Barry 35,609.0 Mexico 2006 6/12/07 Barry 20,381.0 Latin America 2007 3/30/07 Barry 26,213.0 Mexico 2007 5/3/08 Barry 14,904.0 Canada 2008 10/8/07 Barry 11,985.0 USA 2007 4/5/08 Amanda 24,065.0 USA 2008 1/1/08 Amanda 18,694.0 Mexico 2008 10/7/06 Barry 29,026.0 USA 2006 11/24/07 Barry 12,006.0 Latin America 2007 2/28/06 John 35,731.0 USA 2006 11/21/06 Sara 19,326.0 USA 2006 12/15/06 Barry 37,983.0 Canada 2006 2/21/06 Sara 24,360.0 USA 2006 4/5/06 Barry 39,054.0 Canada 2006 4/17/08 Amanda 14,801.0 Canada 2008 3/18/07 Barry 5,112.0 Mexico 2007 8/30/07 Barry 14,785.0 Latin America 2007 12/16/06 Sara 11,239.0 Mexico 2006 8/23/07 Amanda 33,686.0 Latin America 2007 5/17/06 Barry 28,016.0 USA 2006 8/24/07 Barry 17,054.0 Latin America 2007 8/6/06 Barry 27,199.0 USA 2006 5/25/08 Sara 7,173.0 Latin America 2008 2/22/06 John 37,867.0 Canada 2006 8/9/07 Barry 12,739.0 Latin America 2007 1/29/08 Amanda 14,958.0 Canada 2008 6/29/06 Barry 31,630.0 Latin America 2006 11/28/06 Amanda 21,276.0 USA 2006 7/30/06 Amanda 37,180.0 Latin America 2006 2/7/08 Barry 10,985.0 Mexico 2008 6/19/06 John 12,358.0 USA 2006 10/24/07 John 27,371.0 Mexico 2007 3/5/06 Sara 28,076.0 Canada 2006 10/30/07 Sara 21,065.0 Latin America 2007 5/22/08 Sara 27,466.0 Latin America 2008 9/2/07 Sara 23,876.0 Canada 2007 4/16/08 Sara 28,929.0 USA 2008 10/22/06 Amanda 17,596.0 USA 2006 9/11/07 Barry 23,904.0 USA 2007

3/29/08 Sara 19,949.0 Latin America 2008 7/10/06 Sara 35,745.0 Mexico 2006 3/22/07 Amanda 20,071.0 USA 2007 3/11/07 John 9,705.0 Mexico 2007 7/23/07 Amanda 32,888.0 Latin America 2007 12/21/07 John 30,039.0 USA 2007 6/24/06 Sara 25,631.0 Canada 2006 2/27/07 Barry 15,416.0 Latin America 2007 12/22/06 Amanda 29,354.0 Canada 2006 6/26/06 Barry 21,811.0 Mexico 2006 11/2/07 John 22,862.0 Canada 2007 7/13/06 John 22,050.0 Latin America 2006 4/4/07 Sara 32,437.0 Canada 2007 3/12/06 Amanda 25,298.0 USA 2006 3/6/06 Amanda 38,701.0 USA 2006 2/21/06 Sara 10,113.0 Canada 2006 12/19/06 Sara 12,999.0 Mexico 2006 9/23/07 John 26,222.0 USA 2007 3/26/07 Barry 35,661.0 Canada 2007 11/16/06 Sara 35,002.0 USA 2006 11/1/07 Barry 17,237.0 Latin America 2007 8/6/06 Barry 16,097.0 Canada 2006 7/29/06 Amanda 18,720.0 Canada 2006 11/22/07 John 9,159.0 USA 2007 7/22/06 Amanda 8,361.0 USA 2006 2/19/07 Barry 33,346.0 Latin America 2007 2/7/08 Barry 38,569.0 Latin America 2008 3/25/06 Barry 5,348.0 Canada 2006 4/18/07 John 13,257.0 Mexico 2007 3/23/07 Barry 5,942.0 Mexico 2007 11/29/06 Barry 13,305.0 USA 2006 5/1/08 Amanda 24,796.0 Latin America 2008 11/9/07 John 35,707.0 Latin America 2007 12/6/06 Barry 28,302.0 USA 2006 6/8/08 Barry 20,406.0 USA 2008 2/6/08 Sara 17,204.0 Mexico 2008 3/13/06 Amanda 39,381.0 USA 2006 1/13/08 John 5,610.0 Mexico 2008 9/6/06 Barry 8,021.0 Latin America 2006 5/23/07 Amanda 8,808.0 USA 2007 8/27/06 John 36,172.0 Mexico 2006 5/25/06 Barry 25,061.0 Mexico 2006 5/31/06 John 34,496.0 Mexico 2006 7/17/06 Barry 8,685.0 Latin America 2006 7/18/06 John 27,432.0 USA 2006

6/14/07 Amanda 26,531.0 USA 2007 7/15/07 Barry 8,330.0 Canada 2007 12/30/06 Barry 26,194.0 Latin America 2006 10/16/07 Amanda 36,140.0 Canada 2007 1/8/07 Sara 30,306.0 USA 2007 12/16/07 Sara 30,059.0 USA 2007 2/20/08 John 14,673.0 Mexico 2008 12/2/06 John 14,709.0 Canada 2006 9/19/06 Sara 6,853.0 Canada 2006 4/19/06 Sara 28,214.0 USA 2006 3/22/06 Amanda 6,693.0 USA 2006 5/16/08 Sara 6,646.0 Canada 2008 11/28/07 Sara 10,742.0 Mexico 2007 9/30/07 Amanda 14,218.0 USA 2007 1/2/06 Amanda 9,593.0 Canada 2006 4/14/07 Amanda 10,862.0 Latin America 2007 3/31/07 John 6,669.0 Latin America 2007 5/23/08 Barry 8,595.0 Latin America 2008 12/11/07 Amanda 15,990.0 Latin America 2007 2/23/06 John 38,653.0 Canada 2006 9/13/06 Barry 36,391.0 Latin America 2006 2/15/07 Barry 38,682.0 USA 2007 11/7/07 John 26,495.0 Mexico 2007 9/21/06 John 36,791.0 USA 2006 12/5/06 Amanda 33,999.0 Canada 2006 2/11/06 John 7,739.0 Mexico 2006 4/23/08 Sara 6,412.0 Canada 2008 7/5/07 Barry 32,893.0 Mexico 2007 7/4/07 John 5,755.0 Latin America 2007 11/12/07 Barry 39,019.0 Latin America 2007 4/9/06 John 28,987.0 Canada 2006 4/28/08 Amanda 33,089.0 Latin America 2008 8/10/07 Amanda 35,314.0 Canada 2007 5/31/08 Sara 35,800.0 USA 2008 4/27/06 John 28,396.0 Canada 2006 9/30/06 Barry 6,076.0 USA 2006 6/29/06 Amanda 10,305.0 Mexico 2006 4/6/07 John 14,988.0 Canada 2007 11/4/07 Amanda 25,010.0 USA 2007 10/27/06 Barry 31,233.0 Mexico 2006 2/15/08 Amanda 21,995.0 Latin America 2008 6/16/08 Barry 19,542.0 Latin America 2008 3/2/08 Barry 39,369.0 USA 2008 7/14/06 Barry 37,326.0 Mexico 2006 10/22/07 John 26,164.0 Mexico 2007

6/30/07 Sara 10,156.0 Canada 2007 1/27/06 Amanda 32,023.0 Canada 2006 7/7/07 Barry 28,877.0 Mexico 2007 5/15/06 Sara 20,439.0 Mexico 2006 1/7/06 Amanda 17,651.0 USA 2006 5/11/06 John 29,136.0 Canada 2006 2/17/07 John 19,689.0 USA 2007 5/4/07 John 15,232.0 USA 2007 1/31/07 Barry 30,662.0 Canada 2007 11/18/06 Sara 19,993.0 Latin America 2006 11/19/07 Amanda 31,460.0 Canada 2007 6/4/07 Amanda 31,942.0 Canada 2007 2/22/07 Barry 8,560.0 Mexico 2007 4/4/07 John 21,962.0 Mexico 2007 3/23/08 Sara 24,365.0 Mexico 2008 8/10/07 Sara 6,825.0 Mexico 2007 11/1/07 Sara 13,496.0 USA 2007 2/19/06 Amanda 5,767.0 Canada 2006 9/11/06 Amanda 15,765.0 Mexico 2006 6/18/06 Sara 27,920.0 USA 2006 11/27/07 Barry 36,930.0 Canada 2007 5/25/07 Sara 35,814.0 Canada 2007 10/10/07 John 32,260.0 Latin America 2007 6/13/07 Amanda 37,109.0 USA 2007 12/5/07 Sara 22,221.0 Latin America 2007 3/2/06 Barry 16,218.0 Mexico 2006 3/16/08 John 34,659.0 Mexico 2008 2/22/08 Amanda 14,376.0 Latin America 2008 10/31/06 Amanda 25,771.0 USA 2006 10/18/07 Sara 14,191.0 Canada 2007 11/25/06 John 18,922.0 USA 2006 4/29/06 Amanda 21,436.0 Canada 2006 9/16/07 Amanda 32,513.0 Mexico 2007 10/4/06 John 12,769.0 Canada 2006 1/21/06 Sara 17,120.0 USA 2006 10/22/06 Sara 31,575.0 Latin America 2006 9/4/06 Sara 36,599.0 Mexico 2006 12/14/06 Sara 27,619.0 USA 2006 5/27/07 Barry 19,987.0 USA 2007 2/2/08 Sara 20,176.0 USA 2008 3/11/06 John 12,813.0 Latin America 2006 1/14/06 Amanda 12,699.0 Mexico 2006 4/29/08 John 11,181.0 Latin America 2008 3/25/08 Barry 30,246.0 USA 2008 7/31/06 John 12,097.0 Latin America 2006

2/16/07 Amanda 33,542.0 USA 2007 3/4/08 Amanda 13,620.0 USA 2008 3/25/06 Amanda 5,603.0 Mexico 2006 3/21/07 Sara 39,437.0 Canada 2007 6/10/07 Amanda 29,543.0 Canada 2007 5/21/08 Amanda 38,396.0 Latin America 2008 4/7/08 Amanda 30,365.0 USA 2008 10/5/07 John 9,990.0 USA 2007 5/20/07 Amanda 5,143.0 Latin America 2007 9/20/07 Barry 39,950.0 Mexico 2007 10/4/06 John 19,300.0 Canada 2006 8/26/06 Barry 24,848.0 Canada 2006 5/3/06 Sara 24,535.0 Canada 2006 12/2/06 Sara 15,488.0 USA 2006 9/15/07 John 7,504.0 Latin America 2007 10/15/06 Amanda 16,231.0 Latin America 2006 1/5/08 John 35,079.0 USA 2008 4/20/06 John 16,210.0 Canada 2006 3/20/07 Sara 29,904.0 Latin America 2007 10/13/07 Amanda 13,924.0 Latin America 2007 3/2/07 Sara 15,133.0 USA 2007 5/11/08 Amanda 32,553.0 Latin America 2008 3/4/06 Sara 12,182.0 Latin America 2006 4/1/08 Sara 39,843.0 USA 2008 1/13/08 John 19,515.0 Mexico 2008 9/2/07 Sara 32,431.0 Latin America 2007 9/14/07 John 31,011.0 Latin America 2007 3/3/06 Barry 16,357.0 USA 2006 6/2/07 Amanda 12,629.0 USA 2007 3/24/07 Amanda 6,463.0 USA 2007 3/6/07 John 12,394.0 Canada 2007 7/5/06 Sara 11,162.0 Mexico 2006 2/20/07 John 33,370.0 Latin America 2007 9/30/06 Sara 39,220.0 Latin America 2006 8/1/07 John 17,524.0 USA 2007 9/14/07 Sara 31,471.0 USA 2007 3/7/06 Sara 37,833.0 Latin America 2006 11/1/06 Barry 12,077.0 Canada 2006 6/19/07 Sara 29,772.0 USA 2007 4/8/06 Barry 7,834.0 Mexico 2006 9/24/07 Amanda 18,394.0 Latin America 2007 9/23/07 John 6,918.0 Canada 2007 3/8/08 John 13,975.0 USA 2008 9/3/07 Sara 5,295.0 Latin America 2007 2/26/07 Barry 29,955.0 Latin America 2007

5/18/06 Amanda 28,927.0 Mexico 2006 4/30/07 Sara 11,454.0 Mexico 2007 2/7/08 John 35,275.0 Canada 2008 5/14/07 Sara 29,301.0 Mexico 2007 2/20/06 Amanda 36,817.0 USA 2006 6/13/06 Amanda 39,987.0 Canada 2006 5/17/07 Amanda 39,574.0 USA 2007 2/24/06 Amanda 25,220.0 USA 2006 8/6/06 John 25,788.0 Mexico 2006 4/15/07 Amanda 28,599.0 USA 2007 11/25/07 Sara 9,997.0 Canada 2007 1/15/07 John 17,683.0 Latin America 2007 5/12/08 Amanda 20,872.0 Canada 2008 6/16/07 Barry 28,089.0 USA 2007 5/14/07 John 39,641.0 USA 2007 10/8/06 Barry 27,542.0 Mexico 2006 4/12/07 Amanda 38,816.0 Latin America 2007 7/7/07 Sara 31,474.0 Canada 2007 7/6/07 Sara 31,791.0 Canada 2007 1/16/07 Amanda 36,342.0 Mexico 2007 12/24/06 John 27,500.0 Latin America 2006 6/8/06 Sara 35,427.0 Mexico 2006 6/19/06 Sara 7,221.0 Latin America 2006 7/11/06 Barry 37,793.0 Latin America 2006 2/13/07 Sara 14,617.0 Canada 2007 10/27/06 Sara 28,239.0 Canada 2006 5/21/08 Barry 9,170.0 USA 2008 12/25/07 Amanda 11,027.0 Canada 2007 4/18/06 John 22,966.0 Canada 2006 12/17/06 Sara 34,075.0 Latin America 2006 2/4/08 Barry 5,971.0 USA 2008 3/17/07 Barry 32,354.0 Mexico 2007 4/28/07 Sara 25,207.0 Latin America 2007 6/26/06 Barry 39,409.0 Latin America 2006 3/2/07 Amanda 34,257.0 Latin America 2007 7/7/06 Amanda 33,369.0 USA 2006 10/13/07 Barry 9,613.0 Canada 2007 4/2/08 Barry 37,940.0 USA 2008 7/22/07 Amanda 15,906.0 Latin America 2007 4/30/07 John 25,842.0 Canada 2007 4/18/08 Barry 30,271.0 USA 2008 4/27/08 Amanda 31,955.0 Canada 2008 12/19/07 Amanda 10,407.0 Canada 2007 2/17/08 Sara 17,527.0 Canada 2008 6/14/07 Sara 33,604.0 Latin America 2007

6/8/06 John 28,250.0 Mexico 2006 3/14/08 Barry 35,464.0 Mexico 2008 2/6/07 Sara 22,897.0 Latin America 2007 1/4/08 Amanda 28,107.0 Mexico 2008 6/18/08 Barry 9,609.0 Mexico 2008 1/25/07 Amanda 11,195.0 Latin America 2007 11/26/06 Barry 22,885.0 Mexico 2006 11/23/07 John 5,481.0 Latin America 2007 4/12/07 Sara 12,996.0 Canada 2007 9/13/07 Amanda 34,409.0 Canada 2007 4/27/07 Barry 22,871.0 Latin America 2007 12/15/07 John 38,174.0 Canada 2007 12/16/06 Barry 24,668.0 Canada 2006 3/23/08 Amanda 27,215.0 Latin America 2008 7/21/06 Amanda 32,720.0 Mexico 2006 10/25/06 Barry 33,669.0 USA 2006 5/19/06 John 25,720.0 USA 2006 6/9/08 Amanda 29,008.0 Mexico 2008 8/8/07 John 9,218.0 Canada 2007 3/19/08 John 39,565.0 Latin America 2008 11/17/07 Amanda 8,310.0 Mexico 2007 5/17/07 Barry 39,168.0 Mexico 2007 11/24/07 Barry 26,135.0 Canada 2007 5/17/06 Barry 31,565.0 Mexico 2006 10/23/06 John 24,397.0 USA 2006 9/15/06 Sara 14,690.0 Canada 2006 5/30/07 Sara 26,689.0 Canada 2007 1/17/08 John 8,523.0 Mexico 2008 8/19/06 John 39,652.0 Latin America 2006 7/16/06 Amanda 9,059.0 Canada 2006 3/28/07 Amanda 32,931.0 Latin America 2007 11/22/07 Sara 28,328.0 Canada 2007 5/10/08 Amanda 20,207.0 Latin America 2008 9/28/07 John 39,189.0 USA 2007 6/21/07 Sara 13,127.0 Mexico 2007 3/22/06 Amanda 26,691.0 Mexico 2006 11/17/07 John 11,110.0 Latin America 2007 8/20/06 Amanda 20,306.0 Latin America 2006 11/20/07 Sara 14,307.0 USA 2007 1/30/07 Sara 19,361.0 Latin America 2007 5/20/08 Amanda 26,905.0 USA 2008 5/5/06 Sara 14,769.0 Mexico 2006 11/3/06 John 9,754.0 Canada 2006 12/1/06 John 30,257.0 USA 2006 4/6/08 Sara 16,068.0 Canada 2008

3/10/08 Amanda 35,768.0 Mexico 2008 5/23/08 John 38,117.0 Canada 2008 10/4/07 Amanda 12,838.0 USA 2007 4/7/06 Amanda 16,253.0 USA 2006 11/1/07 John 33,351.0 Latin America 2007 2/7/07 Amanda 5,418.0 Latin America 2007 7/19/07 Amanda 21,464.0 Mexico 2007 12/18/07 Amanda 18,495.0 Canada 2007 6/1/06 John 16,255.0 Latin America 2006 4/15/07 Sara 7,018.0 USA 2007 3/10/06 Sara 8,435.0 USA 2006 4/27/08 John 35,284.0 Canada 2008 3/20/06 Barry 14,096.0 USA 2006 10/11/06 John 20,320.0 Mexico 2006 12/29/06 Sara 6,554.0 Canada 2006 5/31/08 Barry 34,398.0 Canada 2008 2/18/07 Barry 27,803.0 Latin America 2007 3/27/08 John 19,387.0 Mexico 2008 8/25/06 Sara 15,961.0 Latin America 2006 7/2/07 Barry 28,097.0 USA 2007 9/25/07 Amanda 33,232.0 Latin America 2007 5/15/06 Amanda 37,903.0 Canada 2006 4/27/06 Barry 21,020.0 Latin America 2006 2/28/06 John 11,958.0 Latin America 2006 6/9/07 Amanda 36,909.0 Canada 2007 4/9/08 Amanda 12,981.0 Canada 2008 1/18/08 Barry 16,556.0 Canada 2008 9/9/06 Sara 33,297.0 USA 2006 3/16/06 John 29,283.0 Mexico 2006 7/27/06 Amanda 26,584.0 Mexico 2006 12/18/06 Barry 31,841.0 USA 2006 9/25/06 John 13,232.0 Latin America 2006 7/28/06 Sara 16,065.0 Latin America 2006 5/15/07 John 35,299.0 Mexico 2007 9/21/07 John 13,661.0 Canada 2007 11/4/06 Sara 15,719.0 Mexico 2006 6/14/08 Amanda 11,957.0 Mexico 2008 5/27/06 John 9,765.0 USA 2006 1/26/08 Barry 12,153.0 Latin America 2008 10/4/07 Amanda 15,808.0 Canada 2007 5/25/07 Sara 21,257.0 Latin America 2007 11/23/06 Sara 31,487.0 USA 2006 1/8/06 Amanda 34,430.0 Mexico 2006 8/19/06 Sara 22,228.0 Canada 2006 3/19/07 Sara 39,175.0 Latin America 2007

10/2/07 Barry 7,641.0 Mexico 2007 7/1/06 Amanda 17,918.0 USA 2006 9/4/06 Amanda 14,060.0 Latin America 2006 10/23/06 Barry 24,304.0 USA 2006 3/16/07 Sara 32,012.0 Latin America 2007 1/1/08 Barry 22,995.0 Canada 2008 7/13/06 Barry 32,098.0 Canada 2006 7/6/06 Barry 23,888.0 Canada 2006 4/4/07 Sara 31,118.0 Mexico 2007 9/28/06 John 11,418.0 Canada 2006 2/27/07 Barry 10,006.0 Mexico 2007 5/14/07 Amanda 35,320.0 Latin America 2007 8/12/06 John 22,282.0 Mexico 2006 10/15/07 John 33,933.0 Canada 2007 12/13/06 Sara 12,905.0 Mexico 2006 10/13/07 Barry 5,816.0 Latin America 2007 1/2/07 Amanda 7,796.0 USA 2007 9/15/06 John 5,569.0 Canada 2006 8/21/06 Barry 31,819.0 Mexico 2006 7/26/06 John 31,268.0 Canada 2006 9/25/07 Sara 36,527.0 Mexico 2007 5/14/06 Sara 33,790.0 Mexico 2006 6/29/06 Barry 28,406.0 USA 2006 7/6/06 Barry 15,760.0 USA 2006 4/15/08 Barry 11,188.0 Latin America 2008 2/15/08 John 13,313.0 Canada 2008 5/23/06 Sara 29,785.0 Latin America 2006 4/28/06 Sara 5,832.0 Canada 2006 7/7/06 John 17,185.0 Mexico 2006 12/7/06 Barry 35,194.0 Canada 2006 5/1/07 John 36,571.0 Latin America 2007 11/13/06 Sara 25,928.0 USA 2006 1/23/06 Barry 31,914.0 Latin America 2006 2/28/06 Sara 16,415.0 Latin America 2006 3/22/08 Amanda 29,864.0 Mexico 2008 6/23/06 Barry 11,227.0 Mexico 2006 4/4/08 Barry 9,090.0 Mexico 2008 1/31/08 Sara 9,021.0 Mexico 2008 4/23/08 Sara 22,615.0 Latin America 2008 11/24/06 Amanda 14,747.0 Mexico 2006 3/28/07 Sara 38,685.0 Mexico 2007 1/10/08 John 29,614.0 Latin America 2008 4/16/08 Barry 19,224.0 Canada 2008 2/15/07 Barry 20,715.0 Latin America 2007 1/4/06 John 15,784.0 USA 2006

5/25/06 Sara 7,133.0 Canada 2006 11/29/06 Sara 35,990.0 Canada 2006 6/30/06 Sara 11,183.0 Latin America 2006 12/30/07 Sara 33,064.0 USA 2007 3/31/07 Sara 36,044.0 Mexico 2007 3/29/07 Amanda 28,358.0 Canada 2007 7/3/06 Barry 37,400.0 Latin America 2006 5/3/08 Amanda 24,455.0 Canada 2008 6/24/07 Amanda 14,584.0 USA 2007 8/21/07 Barry 31,595.0 Mexico 2007 8/2/07 John 38,126.0 Canada 2007 3/15/08 John 14,855.0 Mexico 2008 12/19/06 Sara 32,868.0 Mexico 2006 3/17/08 Barry 10,564.0 Canada 2008 7/1/07 Sara 18,800.0 Mexico 2007 5/14/07 Sara 30,754.0 Mexico 2007 1/21/06 Sara 34,257.0 USA 2006 9/19/06 John 34,814.0 Canada 2006 3/4/07 Barry 33,691.0 Mexico 2007 1/31/08 John 13,552.0 Canada 2008 7/26/06 Barry 8,890.0 USA 2006 11/21/06 Sara 39,352.0 Mexico 2006 3/8/06 John 19,305.0 USA 2006 3/20/07 Sara 26,514.0 Canada 2007 9/6/06 Amanda 13,477.0 Mexico 2006 4/21/07 Sara 10,713.0 Canada 2007 5/1/07 Barry 39,719.0 Canada 2007 12/27/06 John 22,170.0 Latin America 2006 8/7/07 Barry 13,296.0 Canada 2007 10/7/06 Sara 31,670.0 Latin America 2006 1/6/08 John 18,724.0 Latin America 2008 9/3/07 Amanda 31,180.0 Canada 2007 3/25/06 Barry 26,747.0 USA 2006 4/21/08 John 27,845.0 Canada 2008 1/12/08 Sara 31,816.0 Latin America 2008 2/28/07 John 5,407.0 Latin America 2007 1/30/06 Amanda 8,396.0 Canada 2006 2/24/07 John 30,518.0 USA 2007 3/16/06 John 24,284.0 Canada 2006 6/4/08 Barry 23,533.0 Mexico 2008 5/13/06 Amanda 30,363.0 Canada 2006 6/26/07 Barry 31,824.0 Latin America 2007 3/12/08 John 37,747.0 Mexico 2008 11/5/06 Barry 27,243.0 Latin America 2006 9/22/07 Amanda 35,196.0 Mexico 2007

3/6/08 Sara 34,236.0 Latin America 2008 9/29/07 Barry 23,137.0 USA 2007 12/14/06 John 12,216.0 Latin America 2006 9/21/07 Sara 35,164.0 USA 2007 3/21/08 Barry 10,755.0 USA 2008 2/15/08 John 23,325.0 USA 2008 2/27/08 Amanda 27,298.0 USA 2008 3/2/06 Amanda 11,035.0 Canada 2006 2/16/07 Barry 33,945.0 Latin America 2007 8/19/06 John 33,878.0 Mexico 2006 1/6/08 Barry 33,932.0 USA 2008 9/3/07 Amanda 18,435.0 Mexico 2007 9/19/07 Sara 20,963.0 USA 2007 4/18/07 Barry 26,573.0 USA 2007 7/1/06 Barry 7,430.0 USA 2006 9/29/07 Barry 12,885.0 USA 2007 12/26/06 John 33,115.0 Mexico 2006 5/16/08 Amanda 17,129.0 Latin America 2008 8/28/07 Amanda 21,344.0 Mexico 2007 12/16/07 John 14,446.0 USA 2007 6/28/06 Amanda 29,589.0 USA 2006 1/19/07 John 11,123.0 Canada 2007 1/2/07 Sara 7,978.0 Canada 2007 7/31/06 Amanda 12,094.0 Latin America 2006 3/16/08 John 6,186.0 Latin America 2008 11/5/07 Sara 15,928.0 Canada 2007 1/24/07 John 23,790.0 USA 2007 9/3/07 Sara 37,839.0 Mexico 2007 9/15/06 Barry 13,659.0 Mexico 2006 5/7/06 Amanda 15,695.0 USA 2006 8/8/06 Barry 12,019.0 Canada 2006 12/31/06 Amanda 38,691.0 Mexico 2006 8/19/06 Barry 34,839.0 Latin America 2006 2/10/06 Barry 25,124.0 USA 2006 9/30/06 John 39,844.0 Latin America 2006 2/25/08 Sara 14,139.0 USA 2008 9/11/07 Sara 38,718.0 USA 2007 7/30/07 John 23,597.0 Mexico 2007 3/22/07 Sara 12,037.0 USA 2007 6/11/08 John 30,430.0 Latin America 2008 4/21/08 Amanda 6,263.0 Latin America 2008 9/9/07 Amanda 12,836.0 Latin America 2007 3/9/08 Amanda 10,283.0 Latin America 2008 8/27/06 John 39,911.0 Latin America 2006 3/7/06 John 37,432.0 Mexico 2006

10/4/06 Barry 27,023.0 Canada 2006 5/30/06 Barry 22,624.0 Canada 2006 7/10/07 Sara 38,180.0 Latin America 2007 5/2/07 Sara 29,787.0 USA 2007 8/11/06 Sara 28,692.0 USA 2006 10/17/07 Amanda 22,913.0 Mexico 2007 3/24/07 Sara 12,061.0 USA 2007 12/25/07 Sara 19,881.0 Latin America 2007 3/26/06 Sara 15,886.0 Canada 2006 11/15/06 Barry 25,774.0 Mexico 2006 3/18/06 Barry 16,600.0 USA 2006 7/14/06 John 14,056.0 USA 2006 9/21/07 Sara 25,167.0 Latin America 2007 6/4/06 Sara 26,244.0 Canada 2006 12/3/06 Amanda 16,804.0 Latin America 2006 9/23/07 Sara 6,634.0 Canada 2007 2/10/07 Sara 25,627.0 Mexico 2007 9/7/07 Amanda 37,695.0 Latin America 2007 2/28/08 Barry 36,880.0 USA 2008 9/22/06 Barry 30,352.0 Canada 2006 12/11/07 John 7,261.0 Latin America 2007 7/3/07 Barry 39,549.0 USA 2007 3/8/07 Amanda 18,449.0 Mexico 2007 3/19/08 Barry 30,592.0 Mexico 2008 6/7/07 Amanda 31,194.0 Canada 2007 4/20/07 Sara 12,031.0 Canada 2007 11/14/06 Sara 13,742.0 USA 2006 4/22/07 Amanda 14,904.0 Latin America 2007 1/5/06 John 10,402.0 USA 2006 2/5/07 Sara 37,538.0 Latin America 2007 4/27/06 John 17,342.0 Mexico 2006 3/16/08 Barry 22,894.0 Latin America 2008 3/27/08 John 10,518.0 Canada 2008 1/28/07 Amanda 23,736.0 Mexico 2007 3/27/07 John 12,849.0 USA 2007 6/6/07 Barry 7,041.0 Canada 2007 4/28/07 Barry 13,631.0 USA 2007 3/1/08 Amanda 11,432.0 Mexico 2008 12/3/06 Amanda 9,405.0 USA 2006 2/5/06 John 35,888.0 Canada 2006 3/13/08 Amanda 37,895.0 USA 2008 12/16/07 Barry 10,990.0 Canada 2007 2/22/07 Barry 28,368.0 USA 2007 5/16/06 John 16,259.0 Latin America 2006 12/1/07 Amanda 28,853.0 Latin America 2007

1/8/08 Barry 21,672.0 Mexico 2008 9/11/07 Barry 20,906.0 Latin America 2007 3/6/06 Amanda 20,809.0 Latin America 2006 10/17/06 Amanda 27,409.0 USA 2006 12/8/06 Amanda 33,811.0 USA 2006 2/2/08 Amanda 19,790.0 Canada 2008 11/10/07 John 27,686.0 Latin America 2007 1/18/06 John 18,826.0 Canada 2006 2/14/06 Barry 16,853.0 Canada 2006 6/6/07 Barry 27,701.0 Latin America 2007 11/30/07 Sara 37,142.0 USA 2007 4/26/06 Barry 37,837.0 Canada 2006 5/4/07 Sara 35,982.0 Mexico 2007 5/5/07 Amanda 18,884.0 Latin America 2007 4/30/06 Sara 27,193.0 Canada 2006 3/23/08 Barry 6,412.0 Latin America 2008 3/14/07 Barry 36,040.0 Latin America 2007 10/1/06 Sara 5,997.0 Canada 2006 7/13/06 Barry 21,221.0 USA 2006 5/9/08 John 25,026.0 USA 2008 1/20/06 John 19,551.0 Canada 2006 1/31/06 Sara 27,893.0 Latin America 2006 8/28/06 Sara 23,715.0 Latin America 2006 12/7/07 Sara 31,411.0 USA 2007 2/7/08 Barry 12,639.0 USA 2008 8/3/06 Amanda 38,227.0 USA 2006 7/29/07 John 19,695.0 USA 2007 3/4/06 Sara 13,560.0 USA 2006 9/4/06 Sara 8,602.0 Mexico 2006 2/5/08 Sara 16,739.0 Latin America 2008 7/19/07 Barry 35,061.0 Canada 2007 1/10/08 John 21,478.0 Mexico 2008 11/17/07 Amanda 8,256.0 USA 2007 2/8/07 John 39,725.0 Mexico 2007 4/22/06 Amanda 20,724.0 USA 2006 12/29/07 Amanda 34,786.0 Canada 2007 5/16/08 Amanda 21,440.0 Canada 2008 4/25/07 Amanda 37,249.0 USA 2007 1/7/06 John 33,145.0 Mexico 2006 7/27/07 Barry 27,857.0 Latin America 2007 10/1/07 Barry 29,253.0 Mexico 2007 11/17/07 Barry 15,216.0 USA 2007 4/20/08 Barry 18,310.0 USA 2008 3/31/08 Barry 30,616.0 Latin America 2008 5/3/08 Sara 32,886.0 Canada 2008