Fund Name Fund Type Net Asset Value ($) 5 Year Average Return (%) Expense Ratio (%) Morningstar Rank (Stars) Amer Cent Inc & Growth Inv DE 28.88 12.39 0.67 2 American Century Intl. Disc IE 14.37 30.53 1.41 3 American Century Tax-Free Bond FI 10.73 3.34 0.49 4 American Century Ultra DE 24.94 10.88 0.99 3 Ariel DE 46.39 11.32 1.03 2 Artisan Intl Val IE 25.52 24.95 1.23 3 Artisan Small Cap DE 16.92 15.67 1.18 3 Baron Asset DE 50.67 16.77 1.31 5 Brandywine DE 36.58 18.14 1.08 4 Brown Cap Small DE 35.73 15.85 1.20 4 Buffalo Mid Cap DE 15.29 17.25 1.02 3 Delafield DE 24.32 17.77 1.32 4 DFA U.S. Micro Cap DE 13.47 17.23 0.53 3 Dodge & Cox Income FI 12.51 4.31 0.44 4 Fairholme DE 31.86 18.23 1.00 5 Fidelity Contrafund DE 73.11 17.99 0.89 5 Fidelity Municipal Income FI 12.58 4.41 0.45 5 Fidelity Overseas IE 48.39 23.46 0.90 4 Fidelity Sel Electronics DE 45.60 13.50 0.89 3 Fidelity Sh-Term Bond FI 8.60 2.76 0.45 3 Fidelity DE 39.85 14.40 0.56 4 FPA New Income FI 10.95 4.63 0.62 3 Gabelli Asset AAA DE 49.81 16.70 1.36 4 Greenspring DE 23.59 12.46 1.07 3 Janus DE 32.26 12.81 0.90 3 Janus Worldwide IE 54.83 12.31 0.86 2 Kalmar Gr Val Sm Cp DE 15.30 15.31 1.32 3 Managers Freemont Bond FI 10.56 5.14 0.60 5 Marsico 21st Century DE 17.44 15.16 1.31 5 Mathews Pacific Tiger IE 27.86 32.70 1.16 3 Meridan Value DE 31.92 15.33 1.08 4 Oakmark I DE 40.37 9.51 1.05 2 PIMCO Emerg Mkts Bd D FI 10.68 13.57 1.25 3 RS Value A DE 26.27 23.68 1.36 4 T. Rowe Price Latin Am. IE 53.89 51.10 1.24 4 T. Rowe Price Mid Val DE 22.46 16.91 0.80 4 Templeton Growth A IE 24.07 15.91 1.01 3 Thornburg Value A DE 37.53 15.46 1.27 4 USAA Income FI 12.10 4.31 0.62 3 Vanguard Equity-Inc DE 24.42 13.41 0.29 4 Vanguard Global Equity IE 23.71 21.77 0.64 5 Vanguard GNMA FI 10.37 4.25 0.21 5 Vanguard Sht-Tm TE FI 15.68 2.37 0.16 3 Vanguard Sm Cp Idx DE 32.58 17.01 0.23 3 Wasatch Sm Cp Growth DE 35.41 13.98 1.19 4 The file FDICBankFailures contains data on failures of federally insured banks between 2000 and 2012. Create a PivotTable in Excel to answer the following questions. The PivotTable should group the closing dates of the banks into yearly bins and display the counts of bank closures each year in columns of Excel. Row labels should include the bank locations and allow for grouping the locations into states or viewing by city. You should also sort the PivotTable so that the states with the greatest number of total bank failures between 2000 and 2012 appear at the top of the PivotTable. Which state had the greatest number of federally insured bank closings between 2000 and 2012? How many bank closings occurred in the state of Nevada (NV) in 2010? In what cities did these bank closings occur? Use the PivotTables filter capability to view only bank closings in California (CA), Florida (FL), Texas (TX), and New York (NY) for the years 2009 through 2012. What is the total number of bank closings in these states between 2009 and 2012? Using the filtered PivotTable from part c, what city in Florida had the greatest number of bank closings between 2009 and 2012? How many bank closings occurred in this city? Create a PivotChart to display a column chart that shows the total number of bank closings in each year from 2000 through 2012 in the state of Florida. Adjust the formatting of this column chart so that it best conveys the data. What does this column chart suggest about bank closings between 2000 and 2012 in Florida? Discuss. (Hint: You may have to switch the row and column labels in the PivotChart to get the best presentation for your PivotChart.)