Assume you work as an entry level analyst for Bank of America after you graduated from school. There are four other banks of comparable size to your bank in the community: First Union, Sun Trust, Georgia Bank, and BB&T. As the annual report season is approaching, your division manager, Ms. Dawn Mitters, has asked you to prepare a graphic representation of the growth in income of all five banks for the past seven years (2011 to 2017). In addition, the manager wants you to prepare a chart showing the percentage of combined net income attributable to each of the five banks for 2017. Based on your managers requirements, perform the following tasks:

1. Prepare a line, column, and stacked-bar column of the data for the seven years. Be sure to use proper titles and legends. Enter appropriate titles for the x- and y-axes. Name each chart for ease of reference later. Print the three charts into one page and in good format.

2. Prepare a pie chart showing the distribution of the net income among the banks for the most recent year (year 2017). Be use to use a suitable title and label for the pie chart. Also, explode the Bank of America wedge. Print the pie chart in one page and in good format.

3. As a part of your presentation on your banks performance, prepare a short letter to Ms. Mitters, your manager, to discuss your banks performance for the past seven years. Please be specific in your analysis, and provide evidence such as percentage changes and ratios in your paragraphs.

Please Use Excel Format