I need help with part,can you help me finish it?thank u

FINA 415-15S Exam PART 1 Excel # 1 2 3 4 5 6 Worksheet Name Solver Look Up Function Matrix Pivot table Data Table Offset Function Description Calculating portfolio weights (11 Marks) Look up function, Match and Index (10 marks) Matrix Multiplication in excel (4 Marks) Pivot table analysis (6 marks) Two-Way future value data table (4 Marks) Nested Offset function (5 marks) This is part 1 of the Exam. Please enter your answers in the Yellow Area Save your work frequently, there will be no time extension for work lost due to not backing up your workbook. At the end of the test submit file via the Myweb submission facility (go to Assessment - click on Web Submit) Any solutions reaching our mailbox more than 5 minutes late will lose marks. Thus, it is important that you keep a copy of the screen that confirms that you have submitted your file on time. Name Student ID Below you will find the data on the returns, E(rA) and E(rB), and standard deviations, A and B , of stocks A and B. The number is the correlation coefficient of the return of A and B. For a portfolio composed of proportion xA of stock A and xB of stock B, the portfolio expected return and standard deviation is given by: a. User Solver to compute the proportion of xA and xB for portfolio that has the minimum standard deviation. b. User Solver and a constraint to compute the proportion of xA and xB for portfolio that has the minimum standard deviation and a return of at least 18%. Calculate answers for (a) here (5 Marks) Stock A Expected return, E(rA) 12% Return standard deviation, sA 15% Calculate answers for (b) here (6 Marks) Stock A Expected return, E(rA) 12% Return standard deviation, sA 15% Stock B Expected return, E(rB) Return standard deviation, sB 22% 25% Stock B Expected return, E(rB) Return standard deviation, sB 22% 25% Correlation of A and B returns, r 0.50 Correlation of A and B returns, r 0.50 Portfolio Proportion of A, xA Proportion of B, xB Portfolio Proportion of A, xA Proportion of B, xB Portfolio expected return, E(rP) Portfolio standard deviation, sP Portfolio expected return, E(rP) Portfolio standard deviation, sP Lookup Function and Match & Index Common information for problems Assume you are the treasurer of Utopia, a small island country somewhere in the Pacific Ocean.You are currently reviewing your income taxation structure. The average income tax rate for various levels of income are shown below. Tax payers data is available on "Tax Payer Data" worksheet. You need to dynamically link your formula with that worksheet.(You are not supposed to copy the tax payers data in this sheet). Income ($ p.a.) From To $ 0.00 $ 999.99 $ 1,000.00 $ 1,999.99 $ 2,000.00 $ 2,999.99 $ 3,000.00 $ 3,999.99 $ 4,000.00 $ 4,999.99 $ 5,000.00 $ 5,999.99 $ 6,000.00 $ 6,999.99 $ 7,000.00 $ 7,999.99 $ 8,000.00 $ 8,999.99 $ 9,000.00 $ 9,999.99 $ 10,000.00 10,9999.99 or more Tax rate (%) 5.0% 6.0% 7.5% 9.5% 12.0% 15.0% 18.5% 22.5% 27.0% 32.0% 37.5% (i) What is the total amount of tax revenue that can be expected from Utopia's tax payers shown in sheet "tax payer data". (1 marks) Answer: ($): tax revenue (ii) There is a proposal to lower the tax rates for everyone by 2%, i.e. someone earning $5,600 p.a., for example, would pay a rate of 13% instead of 15%. By how much would the income tax revenue of Utopia be reduced? (1 marks) Answer: ($): tax revenue reduction (iii) Utopia's most affluent resident, Mr. Peter Rich (Tax Payer Id 1), has decided to shift to an overseas tax haven. The government wants to maintain the tax revenue and proposes a fixed rate increase equal for each income class. By what amount would they have to raise the tax rate across all income classes to make up for the loss in tax revenue from Mr. Rich? Take original tax rates as the base (i.e. before revision of problem (ii). (2 marks) Answer: (%): fixed increase tax rate across all income classes Match & Index Functions The following table is providing the the sales figure of Sales Reps for different month. You are required to use data validation for SALES REP Name and Month, then dynamically link the user selections with (i) to (iii). SALES REP Name January February March April May June July August September October November December Total SALE REP Name Month Lin Yu 3,627 4,672 4,913 4,979 3,638 4,843 4,260 4,368 3,850 2,299 4,103 3,034 48,586 4,776 3,845 4,527 4,512 4,987 3,087 3,439 3,383 4,093 2,699 3,942 3,949 47,239 Ximeng Jiaru 4,651 3,389 4,670 3,554 4,440 2,071 2,590 4,956 3,587 2,751 4,221 3,288 2,058 4,369 2,052 3,284 4,243 4,209 4,469 2,366 4,808 3,005 2,565 3,010 44,354 40,252 (1 Mark) (1 Mark) (i) Use the Match Function to find out the correct Column Number for SALES REP Name. (1 marks) (ii) Use the Match Function to find out the correct Row Number for Month. (1 marks) (iii) Use the Index Function to find out the Sales. (2 marks) Tax payer data This sheet contains data on tax payers which you need to answer problems A1 - A3 You may use this sheet to to find your answer. The final answer must however be shown in sheet problems A1 -A3 Tax Payer Id 1 5,134,558 7,521,355 5,775,849 2,212,694 9,009,297 2,604,328 9,572,925 1,654,075 1,141,915 8,745,264 4,142,026 9,255,090 9,309,678 4,086,183 8,401,912 8,088,025 4,900,741 2,085,225 5,541,613 6,556,423 4,961,068 3,384,691 2,209,701 7,499,064 9,654,983 5,846,629 3,126,356 1,825,702 1,888,801 1,546,989 8,602,346 8,003,736 6,568,587 6,868,105 Name Address Rich, Peter Wealthy St, Utopia Beverley Hills Bell Allan A & N 31 Resthill Cre Utopia City Bell Allen & P 59 Snell Dve Utopia City Bell A L M & S M Snell Drive Utopia on the Sea Bell Allan M Horsham Downs Rd Utopia City Bell A M & L P 135 a Knighton Rd Utopia City Bell A R & Y M 49 Insoll Ave Utopia City Bell, Peter 8 A Ashley St Utopia City Bell B A 734 River Rd Utopia City Bell B 112 a Lake Rd Utopia City Bell, Bernie 12 Golden Pl Utopia City Bell Barbara 194 Ohaupo Rd Utopia City Bell, Josua Gordonton Rd R D 1 Utopia City Bell B C & M L Gordonton Rd R D 1 Utopia City Bell B Frederic 12 Sacha Pl Utopia City Bell Bea J 16 Bernard St Utopia City Bell Bonnie 17 Sandes St Utopia City Bell-Campbell T L 97 Heath St St Andrews Utopia City Bell C & Crocombe J 3/10 Te Aroha St Utopia City Bell C E & Atherton R J 41 MacFarlane St Utopia City Bell C J & R J 5 a Kotuku St Frankton Utopia City Bell-Jason, Peter 21 River Oaks Pl Utopia City Bell-Miller, Ron 11856 Tennessee Pl, Central Utopia Bell-Holmberg, Jenny Pacific Palisades, Upper Utopia Bell, Anna Longbeach Avenue, Upper Utopia Neville, Olga Princess Wharf, Utopia on the Sea Bell, Allan 6041 California Ave, Hinter Utopia Bell, Theo 135 N 105th St, Central Utopia Bell Andrea 2231 46th Ave SW, West Utopia Bell, Keith 601 Belmont Ave E, Upper Utopia Bell Anthony 9810 Marine View Dr, Utopia Port Bell, Melrose 320 Melrose Ave E, West Utopia Bell, Brett 1202 E Pike St, West Utopia Bell, Gail 2236 Northpark Ave N, Utopia Central Bell, Bruce 2234 Westpark Ave N, North Utopia Income per year $ 48,910 $ 8,374 $ 4,967 $ 715 $ 8,924 $ 4,037 $ 1,292 $ 1,151 $ 6,336 $ 1,335 $ 6,377 $ 924 $ 5,933 $ 4,983 $ 1,929 $ 4,879 $ 4,747 $ 6,283 $ 1,781 $ 7,954 $ 3,812 $ 2,999 $ 6,570 $ 2,543 $ 2,083 $ 336 $ 4,179 $ 4,081 $ 1,448 $ 5,626 $ 7,816 $ 1,000 $ 9,831 $ 1,426 $ 12,999 $ 198,580 Solve the equation AX=Y, where = [8(13&8&3@8&10&1@3&1&11)] , =[8(20@5@0)] , = [8( _1@ _2@ _3 )] Use matrix function of excel to solve for x1, x2, x3. (4 marks) Pivot Table Analysis on Bank data (Use \"Pivot Table Data\") (i) What are the ten largest banks in the sample in terms of total assets? Note that total assets are given in local currencies only. (2 Marks) (ii) Show the percentage contribution (using the pie chart) of each county's banks to this sample (i.e. number of banks as % of all banks). (2 Marks) (iii) What is the average Return on Assets (ROA), Return on Equity (ROE) and Net Profit Margin by country? Visualise your results using a Pivot Chart. (3 Marks) Issuer Aargauische Kantonalbank Abbey National PLC ABN AMRO Bank N.V. ABN AMRO Bouwfonds Nederlandse Gemeenten N.V. ABN AMRO North America Inc. ABSA Bank Ltd. Abu Dhabi Commercial Bank Achmea Hypotheekbank N.V. Adelaide Bank Ltd. ADVANTA Corp. Allfirst Financial Inc. Allgemeine Hypothekenbank Rheinboden AG Alliance & Leicester PLC Allied Banking Corp. Allied Irish Banks PLC American Express Credit Corp. American General Finance Inc. American Savings Bank, FSB, Honolulu HI AmeriCredit Corp. ANZ Banking Group (New Zealand) Ltd. Arab Banking Corp. B.S.C. Artesia Banking Corp. S.A. ASB Bank Ltd. Associated Banc Corp. Australia and New Zealand Banking Group Ltd. Banca Agricola Mantovana SpA Banca Agrileasing SpA Banca Carige SpA Banca CRT SpA Banca di Bologna Banca Lombarda SpA Banca Monte dei Paschi di Siena SpA Banca Nazionale del Lavoro SpA Banca OPI SpA Banca Popolare Commercio e Industria SCRL Banca Popolare dell'Emilia Romagna SCRL Banca Popolare di Bergamo-Credito Varesino Banca Popolare di Intra SCRL Banca Popolare di Milano SCRL Banca Popolare di Verona - Banco S. Geminiano e S. Prospero SCRL Banca Popolare di Vicenza SCRL Banca Toscana SpA bancApulia SpA Banco Atlantico S.A. Banco Bilbao Vizcaya Argentaria S.A. Banco Comercial Portugues S.A. Banco de Credito Local de Espana S.A. Banco di Napoli SpA Banco di Sicilia SpA Banco Espanol de Credito S.A. Banco Espirito Santo S.A. Banco Pastor, S.A. Banco Popular Espanol, S.A. Banco Sabadell S.A. Banco Santander Central Hispano S.A. Banco Totta & Acores, S.A. BancorpSouth Inc. BancWest Corp. Bangkok Bank Public Co. Ltd. Bank Bali Tbk (P.T.) Bank Brussels Lambert S.A. Bank Central Asia (P.T.) Bank for Foreign Trade of Vietnam Bank for Investment and Development of Vietnam Bank Nederlandse Gemeenten (BNG) Bank Negara Indonesia (Persero) Tbk (P.T) Bank of America Corp. Bank of Asia Public Co., Ltd. Bank of Ayudhya Public Co. Ltd. Bank of Baroda Bank of Hawaii Corporation Bank of India Bank of Ireland Bank of Montreal Bank of New Zealand Ltd. Bank of Nova Scotia Country Switzerland United Kingdom Netherlands Netherlands United States South Africa U.A.E. Netherlands Australia United States United States Germany United Kingdom Philippines Ireland United States United States United States United States New Zealand Bahrain Belgium New Zealand United States Australia Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Italy Spain Spain Portugal Spain Italy Italy Spain Portugal Spain Spain Spain Spain Portugal United States United States Thailand Indonesia Belgium Indonesia Vietnam Vietnam Netherlands Indonesia United States Thailand Thailand India United States India Ireland Canada New Zealand Canada Total Assets (in Local Currency billion) Total Equity USD billion Operating Revenues USD billion Net Income USD billion Currency 12226.25 520.5472972973 176.3243243243 32.8243243243 CHF 183065 18276.9230769231 7006.1538461539 2053.8461538462 GBP 597363 17724 18834 2615 EUR 21138 966 347 108 EUR 94696 9361 3311 582 USD 212277 1444.0952380952 1359.1428571429 239.8095238095 ZAR 26593 1035.9673024523 264.3051771117 167.5749318801 AED 11154 307 63 11 EUR 6569 186.8421052632 97.3684210526 17.8947368421 AUD 3263 466 307 -70.53 USD 18088 2052 560 -13 USD 93750 565 263 97 EUR 39244 2715.3846153846 1963.0769230769 441.5384615385 GBP 108815 313.0426356589 78.1589147287 16.0658914729 PHP 85833 6364 3790 557 EUR 26542 2200 2842 277 USD 13532 1355 1999 228.26 USD 5925 485 227 54 USD 11615 1060 818 222.85 USD 27184 688.1818181818 522.2727272727 180.4545454545 NZD 25743 6005.2631578947 1876.3157894737 428.9473684211 BHD 70891 2887 1086 225 EUR 20122 372.7272727273 293.1818181818 83.1818181818 NZD 13542 1070 604 180 USD 180582 6153.1578947369 3392.1052631579 985.2631578947 AUD 10591 854 532 71 EUR 2690 183 62 7 EUR 12386 1298 571 81 EUR 16608 1299 1013 236 EUR 415 51 23 6 EUR 27832 1916 1295 202 EUR 112654 6546 4661 650 EUR 95400 4187 3238 482 EUR 13699 374 79 72 EUR 19881 1615 474 27 EUR 31999 2104 936 155 EUR 38517 2491 1315 230 EUR 3533 255 145 29 EUR 34784 2365 1251 228 EUR 28769 1961 1287 232 EUR 9199 1559 413 78 EUR 14390 1120 692 67 EUR 833 56 37 2 EUR 8740 542 297 56 EUR 292375 21818 11221 2914 EUR 62057 4268 2434 679 EUR 11437 330 92 48 EUR 32019 1381 1196 92 EUR 28403 1372 860 66 EUR 42810 2445 1372 390 EUR 37253 2242 1168 283 EUR 10091 632 321 81 EUR 35987 2676 1785 528 EUR 24427 2908 779 209 EUR 333641 26965 13206 3059 EUR 24755 1704 690 130 EUR 9371 805 460 98 USD 19468 2252 33 8 USD 1252505 1031.6904761905 860.0714285714 154.3571428571 THB 6427 -417.7802944507 -38.2785956965 -229.2185730464 IDR bil 135236 3794 2931 766 EUR 96450 579.8414496036 -420.6115515289 72.5934314836 IDR bil 65630 133.9163349214 63.8256216146 13.8354108203 VND bil 48561 422.8284278536 71.8527703452 13.9659335639 VND bil 67755 2380 294 249 EUR 97718 -110.7587768969 -536.013590034 -1521.4043035108 IDR bil 609458 54261 35100 6792 USD 159011 227.380952381 119.5 -90.880952381 THB 443566 364.3333333333 187.5714285714 -63 THB 633220 690.7388351513 544.1654661453 56.5342663099 INR 10597 1347 752 119 USD 595666 552.8915414694 517.7402757769 51.8213624203 INR 81399 4373 2806 920 EUR 238093 7910.9677419355 5626.4516129032 976.1290322581 CAD 37828 814.0909090909 564.0909090909 200 NZD 283691 10125.1612903226 6567.0967741936 1489.0322580645 CAD Currency Area Switzerland United Kingdom EUROLAND EUROLAND United States South Africa U.A.E. EUROLAND Australia United States United States EUROLAND United Kingdom Philippines EUROLAND United States United States United States United States New Zealand Bahrain EUROLAND New Zealand United States Australia EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND United States United States Thailand Indonesia EUROLAND Indonesia Vietnam Vietnam EUROLAND Indonesia United States Thailand Thailand India United States India EUROLAND Canada New Zealand Canada Exchange rate (LC/USD) 1.48 0.65 1 1 1 10.5 3.67 1 1.9 1 1 1 0.65 51.6 1 1 1 1 1 2.2 0.38 1 2.2 1 1.9 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 1 42 8.83 1 8.83 15.323 15.323 1 8.83 1 42 42 48.59 1 48.59 1 1.55 2.2 1.55 Bank of Queensland Ltd. Bank of the Philippine Islands Bank of Western Australia Ltd. Bank One Corp. Bank Tabungan Negara (Persero) (P.T.) Bankinter S.A. Banknorth Group Inc. Banque Audi sal Banque Cantonale Vaudoise Banque Covefi Banque de Financement et de Tresorerie Banque de la Mediterranee sal Banque de Neuflize Schlumberger Mallet Demachy Banque D'Orsay Banque Federale des Banques Populaires Banque Federative du Credit Mutuel Banque Finama Banque Hervet Banque Martin Maurel Banque OBC-Odier, Bungener, Courvoisier Banque Petrofigaz Banque PSA Finance Barclays Bank PLC Basellandschaftliche Kantonalbank Basler Kantonalbank Bay View Capital Corp. Bayerische Hypo- und Vereinsbank AG Bayerische Landesbank Girozentrale Bendigo Bank Ltd. Berlin-Hannoversche Hypothekenbank AG BHF-Bank AG Bipop-Carire SpA Blom Bank sal BNP PARIBAS BNP Paribas Lease Group BOE Bank Ltd. Boeing Capital Corp. BOK Financial Corp. Bombardier Capital Inc. BPI-SGPS, S.A. Bradford & Bingley PLC BRED - Banque Populaire Bristol & West PLC Britannia Building Society Bulbank A.D. Bumiputra-Commerce Bank Berhad Caisse Centrale de Reescompte Caisse centrale Desjardins du Quebec Caisse Centrale du Credit Immobilier de France Caisse Centrale du Credit Mutuel Caisse Nationale de Credit Agricole Caisse Nationale des Caisses d'Epargne et de Prevoyance Caixa Geral de Depositos S.A. Caja de Ahorros y Monte de Piedad de Gipuzkoa y San Sebastian (kutxa) Caja de Ahorros y Monte de Piedad de Madrid Caja de Ahorros y Monte de Piedad de Zaragoza, Aragon y Rioja (IBERCAJA) Caja de Ahorros y Pensiones de Barcelona Canadian Imperial Bank of Commerce Canara Bank Capital One Financial Corp. Cardine Banca SpA Cariverona Banca SpA Cassa Centrale delle Casse Rurali Trentine Cassa Centrale Raiffeisen dell'Alto Adige S.p.A. Cassa di Risparmio di Cento SpA Cassa di Risparmio di Padova e Rovigo SpA Cassa di Risparmio in Bologna SpA Caterpillar Financial Services Corp. CDC IXIS Central Bank of India Ceska Sporitelna a.s. Ceskoslovenska Obchodni Banka A.S. Cetelem Charter One Financial Inc. Chevy Chase Bank, FSB China Banking Corp. Chittenden Trust Co. Australia Philippines Australia United States Indonesia Spain United States Lebanon Switzerland France France Lebanon France France France France France France France France France France United Kingdom Switzerland Switzerland United States Germany Germany Australia Germany Germany Italy Lebanon France France South Africa United States United States United States Portugal United Kingdom France United Kingdom United Kingdom Bulgaria Malaysia France Canada France France France France Portugal Spain Spain Spain Spain Canada India United States Italy Italy Italy Italy Italy Italy Italy United States France India Czech Republic Czech Republic France United States United States Philippines United States 4222 381681 20070 267187 9039 22387 20629 5774136 37962 407 6314 5850505 8323 2334 175842 175580 2297 5554 884 1453 706 15976 344382 13779 21302 3894 721003 305042 6906 43286 52912 26620 8733369 792918 16856 65727 11023 11057 8007 23642 23465 24486 14534 17360 2794 63638 4351 75940 23536 126829 481724 262982 63639 8687 63608 14135 84602 286846 664390 28184 38929 18365 913 892 1047 10123 9763 16110 127363 472603 470941 553202 16335 37865 11359 66014 4120 110.5263157895 957.1705426357 501.5789473684 23541 -1322.7633069083 1082 1883 247.75 1593.9189189189 41 107 440.6514550265 380 90 9115 7737 227 251 58 56 54 1327 30301.5384615385 611.4864864865 1029.0540540541 426 25221 5876 222.6315789474 665 2105 1660 327.6884920635 29022 1644 696.2857142857 1371 828 755 1462 2123.0769230769 638 1340 1606.1538461539 212.1212121212 959.2105263158 210 3359.3548387097 2378 10316 30586 11236 3061 1310 4839 1170 9888 7838.064516129 579.2344103725 3422 3480 1677 112 71 106 623 555 1539 6082 523.0088495575 766.15625 1128.96875 1850 2929 669 228.7596899225 367 85.7894736842 377.3449612403 302.1052631579 15788 -153.2276330691 497 928 114.7566137566 660.1351351351 47 69 106.7956349206 360 69 5610 4836 63 188 58 82 18 743 17409.2307692308 257.4324324324 429.7297297297 261 8658 2174 126.3157894737 73 1219 1265 162.5277777778 16580 556 340.6666666667 663 589 627 720 1093.8461538462 547 447.6923076923 404.6153846154 76.2626262626 233.6842105263 31 2434.8387096774 426 4110 15838 5628 1770 293 1935 436 2794 7201.2903225807 576.4149001852 6083 1710 1136 26 21 50 577 448 1620 1806 394.8549084174 753.8125 566.1875 1189 1466 428 70.3100775194 230 12.6315789474 AUD 58.7209302326 PHP 71.5789473684 AUD 2682 USD -383.805209513 IDR bil 99 EUR 243 USD 34.1832010582 LBP 112.1621621622 CHF 4 EUR 19 EUR 31.419973545 LBP 29 EUR 29 EUR 883 EUR 663 EUR 13 EUR 14 EUR 8 EUR 17 EUR 8 EUR 150 EUR 3996.9230769231 GBP 59.4594594595 CHF 63.5135135135 CHF -101 USD 1184 EUR 550 EUR 17.3684210526 AUD -562 EUR 380 EUR 343 EUR 78.2665343915 LBP 4552 EUR 243 EUR 92.380952381 ZAR 151.7 USD 116 USD -29.47 USD 175 EUR 250.7692307692 GBP 77 EUR 138.4615384615 GBP 198.4615384615 GBP 80.8080808081 BGN 42.8947368421 MYR 15 EUR 330.9677419355 CAD 123 EUR 671 EUR 2800 EUR 751 EUR 547 EUR 146 EUR 485 EUR 142 EUR 1033 EUR 1125.1612903226 CAD 58.6746244083 INR 642 USD 310 EUR 322 EUR 4 EUR 3 EUR 8 EUR 132 EUR 71 EUR 212 USD 608 EUR 9.5698703437 INR 0.78125 CZK 149.03125 CZK 336 EUR 501 USD 52 USD 12.7131782946 PHP 59 USD Australia Philippines Australia United States Indonesia EUROLAND United States Lebanon Switzerland EUROLAND EUROLAND Lebanon EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND United Kingdom Switzerland Switzerland United States EUROLAND EUROLAND Australia EUROLAND EUROLAND EUROLAND Lebanon EUROLAND EUROLAND South Africa United States United States United States EUROLAND United Kingdom EUROLAND United Kingdom United Kingdom Bulgaria Malaysia EUROLAND Canada EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND Canada India United States EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND United States EUROLAND India Czech Republic Czech Republic EUROLAND United States United States Philippines United States 1.9 51.6 1.9 1 8.83 1 1 1512 1.48 1 1 1512 1 1 1 1 1 1 1 1 1 1 0.65 1.48 1.48 1 1 1 1.9 1 1 1 1512 1 1 10.5 1 1 1 1 0.65 1 0.65 0.65 1.98 3.8 1 1.55 1 1 1 1 1 1 1 1 1 1.55 48.59 1 1 1 1 1 1 1 1 1 1 48.59 32 32 1 1 1 51.6 1 CIT Group, Inc. Citigroup Inc. Citizens Banking Corp. City National Corp. Coastal Bancorp Inc. Houston, TX Cofidis Cofiri SpA Colonial BancGroup Inc. Commerce Bancorp, Inc Commerce Bancshares Inc. Commercial Federal Corporation Commerzbank AG Commonwealth Bank of Australia Compass Bancshares, Inc. Corporation Bank CPR S.A. Credit Agricole Indosuez S.A. Credit Commercial de France Credit du Nord S.A. Credit Foncier de France Credit Foncier et Communal d'Alsace et de Lorraine Banque Credit Industriel et Commercial Credit Lyonnais Credit Municipal de Paris Credit Suisse Group Credito Bergamasco Cullen/Frost Bankers, Inc. Dana Credit Corp. Danske Bank A/S Den norske Bank DePfa Deutsche Pfandbrief AG Deutsche Bank AG Deutsche Genossenschafts-Hypothekenbank AG Deutsche Hypothekenbank Hannover Berlin AG Development Bank of Singapore Ltd. Dexia Bank Nederland N.V. Dexia Banque Belgique Dexia Crediop SpA Dexia Credit Local Dexia Hypothekenbank Berlin AG Discover Bank Doral Financial Corp. Downey Financial Corp. Dresdner Bank AG DVI Inc. DZ Bank Deutsche Zentral-Genossenschaftsbank AG Edison Funding Co. Emirates Bank International PJSC Entenial Equitable - PCI Bank Inc. Eurohypo AG-Europaische Hypothekenbank der Deutschen Bank Factofrance Heller S.A. Findomestic Banca SpA First BanCorp First Citizens BancShares, Inc. First Investment Bank First National of Nebraska Inc. First Republic Bank, San Francisco First Virginia Banks Inc. FirstMerit Corp. FirstRand Bank Ltd. FleetBoston Financial Corp. Ford Motor Credit Co. Fortis Bank Franfinance Fulton Financial Corp. GATX Financial Corp. General Electric Capital Corp. General Motors Acceptance Corp. Greater Bay Bancorp Gulf International Bank B.S.C. Hamburgische Landesbank HBOS PLC Hibernia Corp. Hong Leong Bank Berhad Household Finance Corp. Household International Inc. United States United States United States United States United States France Italy United States United States United States United States Germany Australia United States India France France France France France France France France France Switzerland Italy United States United States Denmark Norway Germany Germany Germany Germany Singapore Netherlands Belgium Italy France Germany United States United States United States Germany United States Germany United States U.A.E. France Philippines Germany France Italy United States United States Bulgaria United States United States United States United States South Africa United States United States Belgium France United States United States United States United States United States Bahrain Germany United Kingdom United States Malaysia United States United States 60830 993920 7598 9999 2576 3004 4299 13083 11339 12907 12710 495022 188346 22799 197032 8570 167640 71761 23194 38005 550 136794 207317 452 856549 9103 8306 2308 1537772 360797 173476 941995 70570 22950 110934 7290 147814 18058 141615 28303 22491 6685 11102 534121 2434 341721 3852 23525 11464 263303 71166 2850 3738 8190 11753 443 9585 4176 10423 10053 184877 198563 231845 373246 4232 7697 6388 422392 192721 7856 15019 85634 273424 16387 24539 90667 110364 10858 89425 697 891 186 318 399 935 694 1278 780 13456 10446.3157894737 1845 277.3615970364 505 5013 3849 975 1078 65 5100 9583 85 8987.1621621622 653 694 198 6930.4 3711.2881806109 2478 40372 623 251 4738.2857142857 551 4926 761 4868 221 2744 762 854 24894 222 8102 904 1211.1716621253 449 891.9379844961 1446 259 239 603 1135 24.7474747475 819 280 1152 932 1227.1428571429 20412 11984 11743 259 819 1416 31563 16134 682 3144.7368421053 2098 25430.7692307692 1560 462.6315789474 7702 9634 4548 79682 422 567 98 395 77 521 598 758 435 7704 4893.6842105263 1197 179.7489195308 215 3609 2507 1128 291 19 3263 6660 26 26455.4054054054 392 516 296 3941.0666666667 1722.0451527225 860 29576 280 101 1647.4285714286 453 2670 177 1199 65 4086 275 370 12415 179 2985 212 251.7711171662 219 268.4108527132 402 149 258 290 560 14.1414141414 947 152 551 577 1134.6666666667 12451 25451 7893 220 391 1471 48545 25476 353 781.5789473684 599 10481.5384615385 952 216.8421052632 10328 13916 333.8 USD 14371 USD 105 USD 146 USD 24 USD 80 EUR 10 EUR 129 USD 103 USD 183 USD 98 USD 1411 EUR 1269.4736842105 AUD 270 USD 53.8793990533 INR 45 EUR 443 EUR 451 EUR 167 EUR 83 EUR 4 EUR 370 EUR 777 EUR 3 EUR 1225.6756756757 CHF 75 EUR 86 USD 30.6 USD 1161.7333333333 DKK 533.598937583 NOK 187 EUR 5026 EUR 46 EUR 32 EUR 761.1428571429 SGD 118 EUR 703 EUR 89 EUR 578 EUR 18 EUR 700 USD 138 USD 120 USD 1742 EUR 18.44 USD 521 EUR 101.96 USD 151.4986376022 AED 28 EUR 14.0697674419 PHP 138 EUR 45 EUR 31 EUR 87 USD 87 USD 4.5454545455 BGN 81 USD 25 USD 164 USD 123 USD 277.9047619048 ZAR 931 USD 838.5 USD 1628 EUR 41 EUR 114 USD 220.7 USD 5902 USD 1785.9 USD 80 USD 310.5263157895 BHD 59 EUR 2869.2307692308 GBP 218 USD 30.7894736842 MYR 1447.6 USD 1923.5 USD United States United States United States United States United States EUROLAND EUROLAND United States United States United States United States EUROLAND Australia United States India EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND Switzerland EUROLAND United States United States Denmark Norway EUROLAND EUROLAND EUROLAND EUROLAND Singapore EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND United States United States United States EUROLAND United States EUROLAND United States U.A.E. EUROLAND Philippines EUROLAND EUROLAND EUROLAND United States United States Bulgaria United States United States United States United States South Africa United States United States EUROLAND EUROLAND United States United States United States United States United States Bahrain EUROLAND United Kingdom United States Malaysia United States United States 1 1 1 1 1 1 1 1 1 1 1 1 1.9 1 48.59 1 1 1 1 1 1 1 1 1 1.48 1 1 1 7.5 7.53 1 1 1 1 1.75 1 1 1 1 1 1 1 1 1 1 1 1 3.67 1 51.6 1 1 1 1 1 1.98 1 1 1 1 10.5 1 1 1 1 1 1 1 1 1 0.38 1 0.65 1 3.8 1 1 Housing Development Finance Corp. HSBC Bank Canada HSBC Bank PLC Hudson United Bancorp HVB Real Estate Bank AG Hypothekenbank in Essen AG Iccrea Banca SpA ICICI Ltd. Indian Overseas Bank Industrial and Commercial Bank of Vietnam Industrial Development Bank of India ING Bank N.V. IntesaBci SpA Irish Life & Permanent PLC iStar Financial Inc. J.P. Morgan Chase & Co. John Deere Capital Corp. KBC Bank N.V. KeyCorp Komercni Banka A.S. Krung Thai Bank Public Co. Ltd. Landesbank Baden-Wuerttemberg Landesbank Hessen-Thringen Landesbank Rheinland-Pfalz Landesbank Sachsen Girozentrale Landesbank Schleswig-Holstein Landshypotek AB Laurentian Bank of Canada LGT Bank in Liechtenstein AG Lippo Bank Tbk (P.T.) Lloyds TSB Bank PLC LNR Property Corp. Locat SpA Locindus S.A. M & T Bank Corp. Malayan Banking Berhad Marshall & Ilsley Corp. MashreqBank MBNA Corp. Mediocredito Centrale SpA Mercantile Bankshares Corp. Merita Bank PLC Metris Cos. Inc. Metropolitan Bank & Trust Co. Migrosbank AG Multi-Purpose Bank Berhad Municipal Bank A.D. Natexis Banques Populaires National Australia Bank Ltd. National Bank of Abu Dhabi National Bank of Canada National Bank of Dubai National Bank of New Zealand Ltd. (The) National City Corp. National Commerce Financial Corp. National Consumer Cooperative Bank Nationwide Building society Nedcor Ltd. Nederlandse Waterschapsbank N.V. NetBank Inc. NIB Capital Bank N.V. Norddeutsche Landesbank Girozentrale Nordea Bank Danmark A/S Nordea Bank Norway (part of pan-Nordic Nordea group) Nordea Bank Sweden AB Nordea Hypotek AB North Fork Bancorp Northern Rock PLC Nykredit A/S OCWEN Financial Corp. OKO Bank (OKO Osuuspankkien Keskuspankki Oyj) Old National Bancorp Oriental Bank of Commerce ORIX Financial Services Inc. Oversea-Chinese Banking Corp. Ltd. Overseas Union Bank Ltd. Paccar Financial Corp. India Canada United Kingdom United States Germany Germany Italy India India Vietnam India Netherlands Italy Ireland United States United States United States Belgium United States Czech Republic Thailand Germany Germany Germany Germany Germany Sweden Canada Switzerland Indonesia United Kingdom United States Italy France United States Malaysia United States U.A.E. United States Italy United States Finland United States Philippines Switzerland Malaysia Bulgaria France Australia U.A.E. Canada U.A.E. New Zealand United States United States United States United Kingdom South Africa Netherlands United States Netherlands Germany Denmark Norway Sweden Sweden United States United Kingdom Denmark United States Finland United States India United States Singapore Singapore United States 191145 33260 190480 6925 78913 65381 6108 734137 302945 48704 717834 443356 338492 16581 4375 684030 14369 196982 79806 401525 976741 292534 130900 63871 55609 128069 35679 17634 14056 23779 187561 2837 7206 929 30179 127322 26681 22700 42866 9918 9817 61061 4134 433413 20831 9330 249 96804 337182 32252 75458 32660 36364 104649 18081 1159 73045 171308 22634 2853 17500 186331 559362 236923 611159 179961 16805 26383 579512 1704 12449 8996 270724 3122 59710 46603 3563 488.1457089936 1188.3870967742 28493.8461538462 509 1327 554 244 1712.8421485903 191.9736571311 114.6642302421 1885.5320024697 17692 16612 1960 1784 46233 1907 10090 7443 713.84375 1511.5952380952 6173 3190 984 907 2158 435.1063829787 530.9677419355 793.9189189189 261.9479048698 23704.6153846154 1119 256 170 3258 2796.3157894737 2709 797.2752043597 8377 650 1230 3186 1142 1010.523255814 791.8918918919 165.5263157895 11.6161616162 4607 13329.4736842105 880.1089918256 2969.6774193548 1166.485013624 989.5454545455 7620 2704 162 6438.4615384615 1295.3333333333 921 255 1407 3235 2325.3333333333 2379.1500664011 3911.3829787234 929.6808510638 1681 2636.9230769231 4376.4 440 621 689 318.7281333608 401 4698.2857142857 3028.5714285714 523 142.5601975715 756.7741935484 11124.6153846154 392 412 168 135 661.4529738629 243.5068944227 62.1288259479 459.5595801605 11071 12045 424 485 29004 1216 4485 4550 779.34375 607.9047619048 2218 826 524 334 931 42.9787234043 400 385.1351351351 -103.8505096263 13295.3846153846 478 149 32 1630 1242.6315789474 1800 310.3542234332 8331 206 562 1822 1685 387.6356589147 297.2972972973 103.1578947368 6.5656565657 1846 6961.052631579 275.204359673 2094.8387096774 209.8092643052 520.4545454545 6028 981 56 1806.1538461539 859.4285714286 127 79 373 1286 1442.1333333333 942.2310756972 2646.914893617 200.7446808511 788 761.5384615385 656.2666666667 150 308 404 217.8225972422 303 986.8571428571 760 336 97.4891953077 INR 148.3870967742 CAD 2675.3846153846 GBP 94 USD 160 EUR 66 EUR 9 EUR 110.5783082939 INR 23.8526445771 INR 8.6797624486 VND bil 142.2103313439 INR 1693 EUR 1690 EUR 50 EUR 229.91 USD 1771 USD 157.8 USD 1669 EUR 157 USD -6.90625 CZK -105.1428571429 THB 460 EUR 95 EUR 96 EUR 41 EUR 84 EUR 23.829787234 SEK 60 CAD 139.1891891892 CHF -185.7304643262 IDR bil 3967.6923076923 GBP 135.11 USD 40 EUR 24 EUR 404 USD 361.3157894737 MYR 338 USD 112.5340599455 AED 1694 USD 44 EUR 181 USD 629 EUR 260 USD 30.1744186047 PHP 41.8918918919 CHF 20.7894736842 MYR 0.5050505051 BGN 320 EUR 1421.5789473684 AUD 165.6675749319 AED 381.2903225806 CAD 122.8882833787 AED 189.0909090909 NZD 1388 USD 225 USD 13 USD 358.4615384615 GBP -98.8571428571 ZAR 117 EUR 7 USD 188 EUR 136 EUR 275.7333333333 DKK 320.1859229748 NOK 1520.1063829787 SEK 143.5106382979 SEK 331 USD 316.9230769231 GBP 243.6 DKK -127 USD 119 EUR 93 USD 41.7575632846 INR -39.67 USD 484.5714285714 SGD 320.5714285714 SGD 15.6 USD India Canada United Kingdom United States EUROLAND EUROLAND EUROLAND India India Vietnam India EUROLAND EUROLAND EUROLAND United States United States United States EUROLAND United States Czech Republic Thailand EUROLAND EUROLAND EUROLAND EUROLAND EUROLAND Sweden Canada Switzerland Indonesia United Kingdom United States EUROLAND EUROLAND United States Malaysia United States U.A.E. United States EUROLAND United States EUROLAND United States Philippines Switzerland Malaysia Bulgaria EUROLAND Australia U.A.E. Canada U.A.E. New Zealand United States United States United States United Kingdom South Africa EUROLAND United States EUROLAND EUROLAND Denmark Norway Sweden Sweden United States United Kingdom Denmark United States EUROLAND United States India United States Singapore Singapore United States 48.59 1.55 0.65 1 1 1 1 48.59 48.59 15.323 48.59 1 1 1 1 1 1 1 1 32 42 1 1 1 1 1 9.4 1.55 1.48 8.83 0.65 1 1 1 1 3.8 1 3.67 1 1 1 1 1 51.6 1.48 3.8 1.98 1 1.9 3.67 1.55 3.67 2.2 1 1 1 0.65 10.5 1 1 1 1 7.5 7.53 9.4 9.4 1 0.65 7.5 1 1 1 48.59 1 1.75 1.75 1 Panin Bank (P.T.) People's Bank Perwira Affin Bank Berhad PHH Corp. Philippine National Bank Pitney Bowes Credit Corp. PNC Financial Services Group Provident Bankshares Corp. Provident Financial Group, Inc Providian Financial Corp. Public Bank Berhad Punjab National Bank Rabobank Nederland RBC Centura Banks Inc. Regions Financial Corp. Renault Credit International S.A. Banque RHB Bank Berhad Rheinische Hypothekenbank AG Riggs National Corp. Rizal Commercial Banking Corp. Rolo Banca 1473 SpA Roslyn Bancorp Inc. Royal Bank of Canada Royal Bank of Scotland Group PLC S&T Bancorp Inc. Sampo Bank PLC Sanpaolo IMI SpA Santander BanCorp SBAB (The Swedish National Housing Finance Corp.) Schwyzer Kantonalbank SEB Hypothekenbank AG Security Bank Corp. Selectibail Siam City Bank Public Co. Ltd. Siam Commercial Bank Public Co. Ltd. Skandinaviska Enskilda Banken AB Sky Financial Group Inc. SNS bank Nederland N.V. Societe Generale Socram Sofinco South Financial Group Inc. (The) Southern Bank Berhad Spintab AB (Swedmortgage) St.George Bank Ltd. Stadshypotek AB Standard Bank of South Africa Ltd. Standard Life Bank Ltd. State Bank of India Suncorp-Metway Ltd. SunTrust Banks Inc. Susquehanna Bancshares Inc. Svenska Handelsbanken Swedbank (ForeningsSparbanken AB) Synovus Financial Corp. TCF Financial Corp. Textron Financial Corp. Thai Farmers Bank Public Co. Ltd. Thai Military Bank Public Co. Ltd. Toronto-Dominion Bank (The) Transamerica Finance Corp. Trustmark Corp U.S. Bancorp UBS AG UniCredito Italiano SpA Union Bank of India Union Bank of Norway (part of Gjensidige NOR group) Union Bank of the Philippines Union Planters Corp. UnionBanCal Corp. United Bulgarian Bank A.D. United California Bank United National Bancorp United Overseas Bank Ltd. Valley National Bancorp Veneto Banca SCRL Via Banque Indonesia United States Malaysia United States Philippines United States United States United States United States United States Malaysia India Netherlands United States United States France Malaysia Germany United States Philippines Italy United States Canada United Kingdom United States Finland Italy United States Sweden Switzerland Germany Philippines France Thailand Thailand Sweden United States Netherlands France France France United States Malaysia Sweden Australia Sweden South Africa United Kingdom India Australia United States United States Sweden Sweden United States United States United States Thailand Thailand Canada United States United States United States Switzerland Italy India Norway Philippines United States United States Bulgaria United States United States Singapore United States Italy France 11335 11775 15012 13028 192430 5721 67395 4891 15694 19938 43238 635051 363619 12470 44515 18387 50611 77254 6088 152557 46941 8736 356912 342908 2331 25425 172584 7641 146725 8148 14751 74843 692 297838 723081 1086548 9160 32416 466947 1758 8493 5939 17600 348011 49395 358823 230972 6202 3156442 26494 104282 4999 1147505 910013 16628 11312 8796 774599 366670 283064 12848 7117 164279 1211720 204291 389777 231599 49686 32270 35992 1309 10524 1958 66324 8575 3312 1157 325.3680634202 935 379.4736842105 1777 396.7248062016 1476 6841 356 1343 2012 1298.6842105263 549.3311380943 18565 2374 4186 1238 1180.5263157895 1000 711 312.4612403101 2865 569 12699.3548387097 51129.2307692308 293 3444 9269 592 550 385.8108108108 156 167.9651162791 177 443.1904761905 1497.0714285714 6494.4680851064 757 1500 19606 161 586 495 522.3684210526 2318.4042553192 1908.4210526316 2232.7659574468 1690.9523809524 364.6153846154 2770.4260135831 1430 10010 494 5478.2978723404 6345.5319148936 1794 917 1037 653.3333333333 324.2619047619 9468.3870967742 1344 685 19287 17986.4864864865 12254 380.4898127187 2141.3014608234 233.5852713178 3423 3910 130.303030303 1084 203 3986.8571428572 878 335 246 74.8584371461 577 126.0526315789 2861 170.523255814 588 5016 226 694 4760 512.1052631579 579.7283391644 8434 364 2468 913 333.4210526316 361 275 122.9069767442 2041 252 9452.9032258065 20973.8461538462 121 672 5845 309 112.5531914894 112.1621621622 46 57.7713178295 19 48.1666666667 585.6666666667 3115.9574468085 461 575 13830 28 638 229 146.3157894737 409.1489361702 1007.3684210526 497.1276595745 1376.7619047619 113.8461538462 2524.3054126364 635.2631578947 5408 257 2278.7234042553 2458.5106382979 1559 855 709 613.1904761905 193.7142857143 6992.2580645161 1728 380 11630 24508.1081081081 9321 315.003087055 966.5338645418 57.9263565891 1907 2265 48.4848484848 605 97 1160 403 146 22 3.9637599094 IDR bil -11 USD 24.7368421053 MYR 227 USD -115.7751937985 PHP 160.14 USD 477 USD 43 USD 23 USD 141 USD 207.1052631579 MYR 95.4105783083 INR 1483 EUR 40 USD 509 USD 141 EUR 102.8947368421 MYR 114 EUR -4 USD 9.0310077519 PHP 528 EUR 116 USD 1640 CAD 4212.3076923077 GBP 49 USD 140 EUR 1402 EUR 56 USD 41.3829787234 SEK 20.9459459459 CHF 22 EUR 8.1782945736 PHP 25 EUR -170.3333333333 THB 12.0714285714 THB 542.0212765957 SEK 131 USD 98 EUR 2877 EUR 6 EUR 103 EUR 45 USD 24.7368421053 MYR 267.1276595745 SEK 213.6842105263 AUD 346.170212766 SEK 305.7142857143 ZAR -18.4615384615 GBP 330.1502366742 INR 207.8947368421 AUD 1369 USD 56 USD 884.2553191489 SEK 620.1063829787 SEK 331 USD 207 USD 120.57 USD 24.2380952381 THB 15.5952380952 THB 921.2903225806 CAD 104.68 USD 111 USD 1707 USD 5323.6486486487 CHF 1858 EUR 32.002469644 INR 356.9721115538 NOK 16.0852713178 PHP 460 USD 506 USD 13.1313131313 BGN 113 USD 25 USD 521.7142857143 SGD 135 USD 31 EUR 9 EUR Indonesia United States Malaysia United States Philippines United States United States United States United States United States Malaysia India EUROLAND United States United States EUROLAND Malaysia EUROLAND United States Philippines EUROLAND United States Canada United Kingdom United States EUROLAND EUROLAND United States Sweden Switzerland EUROLAND Philippines EUROLAND Thailand Thailand Sweden United States EUROLAND EUROLAND EUROLAND EUROLAND United States Malaysia Sweden Australia Sweden South Africa United Kingdom India Australia United States United States Sweden Sweden United States United States United States Thailand Thailand Canada United States United States United States Switzerland EUROLAND India Norway Philippines United States United States Bulgaria United States United States Singapore United States EUROLAND EUROLAND 8.83 1 3.8 1 51.6 1 1 1 1 1 3.8 48.59 1 1 1 1 3.8 1 1 51.6 1 1 1.55 0.65 1 1 1 1 9.4 1.48 1 51.6 1 42 42 9.4 1 1 1 1 1 1 3.8 9.4 1.9 9.4 10.5 0.65 48.59 1.9 1 1 9.4 9.4 1 1 1 42 42 1.55 1 1 1 1.48 1 48.59 7.53 51.6 1 1 1.98 1 1 1.75 1 1 1 Vietnam Bank for Agriculture and Rural Development Wachovia Corporation Washington Mutual Finance Corp. Webster Financial Corp. Wells Fargo & Co. Wells Fargo Financial Inc. Westcorp, Irvine, CA Westdeutsche Landesbank Girozentrale Westfaelische Hypothekenbank AG WestfaelischeBodenkreditbank AG Westpac Banking Corp. Whitney Holding Co. (The) Woolwich PLC Wuerttembergische Hypothekenbank AG Wuestenrot Hypothekenbank AG Yorkshire Building Society Zions Bancorp. Zurcher Kantonalbank Vietnam United States United States United States United States United States United States Germany Germany Germany Australia United States United Kingdom Germany Germany United Kingdom United States Switzerland 39489 317680 4073 11537 296843 15849 10072 399945 41659 12956 180730 7142 39237 32626 10040 12468 23331 77487 179.7950792926 28455 560 1166 29649 2111 619 9176 333 202 5107.8947368421 718 2615.3846153846 379 107 1046.1538461539 2516 2877.7027027027 93.7153298962 14046 626 526 20070 2622 550 4519 128 44 3467.3684210526 363 1587.6923076923 123 18 238.4615384615 1346 1112.8378378378 12.5954447562 VND bil 1619 USD 61.13 USD 137 USD 3423 USD 264.82 USD 66 USD 497 EUR 25 EUR 8 EUR 1004.2105263158 AUD 76 USD 361.5384615385 GBP 38 EUR -2 EUR 72.3076923077 GBP 282 USD 152.7027027027 CHF Vietnam United States United States United States United States United States United States EUROLAND EUROLAND EUROLAND Australia United States United Kingdom EUROLAND EUROLAND United Kingdom United States Switzerland 15.323 1 1 1 1 1 1 1 1 1 1.9 1 0.65 1 1 0.65 1 1.48 total asset in USD 8260.9797297297 281638.461538461 597363 21138 94696 20216.8571428571 7246.0490463215 11154 3457.3684210526 3263 18088 93750 60375.3846153846 2108.8178294574 85833 26542 13532 5925 11615 12356.3636363636 67744.7368421053 70891 9146.3636363636 13542 95043.1578947369 10591 2690 12386 16608 415 27832 112654 95400 13699 19881 31999 38517 3533 34784 28769 9199 14390 833 8740 292375 62057 11437 32019 28403 42810 37253 10091 35987 24427 333641 24755 9371 19468 29821.5476190476 727.8595696489 135236 10922.9898074745 4283.1038308425 3169.1574756901 67755 11066.5911664779 609458 3785.9761904762 10561.0952380952 13031.8995678123 10597 12259.0244906359 81399 153608.387096774 17194.5454545455 183026.451612903 2222.1052631579 7396.9186046512 10563.1578947368 267187 1023.6693091733 22387 20629 3818.873015873 25650 407 6314 3869.3816137566 8323 2334 175842 175580 2297 5554 884 1453 706 15976 529818.461538462 9310.1351351351 14393.2432432432 3894 721003 305042 3634.7368421053 43286 52912 26620 5776.0376984127 792918 16856 6259.7142857143 11023 11057 8007 23642 36100 24486 22360 26707.6923076923 1411.1111111111 16746.8421052632 4351 48993.5483870968 23536 126829 481724 262982 63639 8687 63608 14135 84602 185061.935483871 13673.3895863346 28184 38929 18365 913 892 1047 10123 9763 16110 127363 9726.3428689031 14716.90625 17287.5625 16335 37865 11359 1279.3410852713 4120 60830 993920 7598 9999 2576 3004 4299 13083 11339 12907 12710 495022 99129.4736842105 22799 4054.9907388352 8570 167640 71761 23194 38005 550 136794 207317 452 578749.324324324 9103 8306 2308 205036.266666667 47914.6082337317 173476 941995 70570 22950 63390.8571428572 7290 147814 18058 141615 28303 22491 6685 11102 534121 2434 341721 3852 6410.0817438692 11464 5102.7713178295 71166 2850 3738 8190 11753 223.7373737374 9585 4176 10423 10053 17607.3333333333 198563 231845 373246 4232 7697 6388 422392 192721 7856 39523.6842105263 85634 420652.307692308 16387 6457.6315789474 90667 110364 3933.8341222474 21458.064516129 293046.153846154 6925 78913 65381 6108 15108.8083967895 6234.7190779996 3178.4898518567 14773.286684503 443356 338492 16581 4375 684030 14369 196982 79806 12547.65625 23255.7380952381 292534 130900 63871 55609 128069 3795.6382978723 11376.7741935484 9497.2972972973 2692.9784824462 288555.384615385 2837 7206 929 30179 33505.7894736842 26681 6185.2861035422 42866 9918 9817 61061 4134 8399.4767441861 14075 2455.2631578947 125.7575757576 96804 177464.210526316 8788.0108991826 48682.5806451613 8899.1825613079 16529.0909090909 104649 18081 1159 112376.923076923 16315.0476190476 22634 2853 17500 186331 74581.6 31463.8778220452 65016.914893617 19144.7872340426 16805 40589.2307692308 77268.2666666667 1704 12449 8996 5571.5990944639 3122 34120 26630.2857142857 3563 1283.6919592299 11775 3950.5263157895 13028 3729.2635658915 5721 67395 4891 15694 19938 11378.4210526316 13069.5822185635 363619 12470 44515 18387 13318.6842105263 77254 6088 2956.5310077519 46941 8736 230265.806451613 527550.769230769 2331 25425 172584 7641 15609.0425531915 5505.4054054054 14751 1450.4457364341 692 7091.380952381 17216.2142857143 115590.212765957 9160 32416 466947 1758 8493 5939 4631.5789473684 37022.4468085106 25997.3684210526 38172.6595744681 21997.3333333333 9541.5384615385 64960.7326610414 13944.2105263158 104282 4999 122075 96809.8936170213 16628 11312 8796 18442.8333333333 8730.2380952381 182621.935483871 12848 7117 164279 818729.72972973 204291 8021.7534472114 30756.8393094289 962.9069767442 32270 35992 661.1111111111 10524 1958 37899.4285714286 8575 3312 1157 2577.1063107747 317680 4073 11537 296843 15849 10072 399945 41659 12956 95121.052631579 7142 60364.6153846154 32626 10040 19181.5384615385 23331 52356.0810810811 Data Table Assume that you deposit $10,000.00 today into an account paying 6% annual interest and leave it for exactly 8 years. How much will be in the account at the end of 8 years if interest is compounded monthly? (i) What is the Future Value (FV)? (1 marks) (ii) Format Data Table. (3 marks) 2% $ $ $ $ $ $ $ $ 5,000.00 10,000.00 15,000.00 20,000.00 25,000.00 30,000.00 35,000.00 40,000.00 3% 4% 5% 6% 7% OFFSET function The following is the data of XYZ ltd's unit rejects from production department. You are required to setup an OFFSET function so that the user can keep adding data to the table and simultaneously calculate the average of the latest week. (5 Marks) Date % Reject 1/1/2015 0.17% 1/2/2015 0.18% 1/3/2015 0.06% 1/4/2015 0.14% 1/5/2015 0.08% 1/6/2015 0.13% 1/7/2015 0.05% 1/8/2015 0.16% 1/9/2015 0.05% 1/10/2015 0.09% 1/11/2015 0.16% 1/12/2015 0.17% 1/13/2015 0.19% 1/14/2015 0.15% 1/15/2015 0.06% 1/16/2015 0.13% 1/17/2015 0.05% 1/18/2015 0.18% Calculate Average of Latest 7 days