United Savings Bank (USB) is a large bank with branches spanning the United States. They are already collecting information on their customers in the following systems. Core Banking SystemOnline Banki

United Savings Bank (USB) is a large bank with branches spanning the United States. They are already collecting information on their customers in the following systems.

Core Banking System
Online Banking
Lending System (Auto/Personal Loans)
Credit Card System
Mortgage Lending System
Insurance Policy System
Financial Investment System

They are interested in understanding how they can leverage this data, in addition to data gathered from other potential sources, to provide a competitive advantage in their market. You are to analyze some of the data to see if you can provide a recommendation for USB to achieve a strategic advantage.

The following is the necessary information to complete this lab assignment.

Add a worksheet and rename it Step 1.
Create a table that includes customer first and last name, total balance of deposit and investment accounts, and whether the customer has a life insurance policy with the bank or not.
Format the data to look professional.
Sort the data by the total deposit and investment balance in descending order.
Filter those customers without an insurance policy with the bank. It should look like the following.
Copy the primary sheet (Sheet 1) and move it to the end. Rename it to Step 2.
Filter the data to show those customers with a car loan balance that do not have any car insurance policy with the bank.
Sort the filtered data by the car loan balance in descending order. The worksheet should look like the following.Create a new worksheet at the end and name it Step 3.
In cell A1, enter “Number of customers without any mortgages” and calculate the number of customers without any mortgage accounts in cell B1. Hint: you will want to utilize the count command in cell B1.
Calculate the percentage of in C1 based on the 50 customers.
In cell A2, enter “Number of customers without any car loans” and calculate the number of customers without any mortgage accounts in cell B2. Hint: you will want to utilize the count command in cell B2.
Calculate the percentage of in C2 based on the 50 customers.
In cell A3, enter “Number of customers without any investment accounts” and calculate the number of customers without any mortgage accounts in cell B3. Hint: you will want to utilize the count command in cell B3.
Calculate the percentage of in C3 based on the 50 customers.
In rows 4 through 6, repeat the previous two items (item 6 and 7) to determine the number of customers without direct deposit, number of customers with a deposit balance greater than $200,000, and number of customers with a deposit balance less than $10,000.
Make sure that you utilize formulas to calculate each number.
Save your work.
Create a new worksheet at the end and name it Step 4.
Write a 100- to 200-word analysis of what you could recommend to the board regarding possible opportunities to maximize the banks performance in all financial areas based on Steps 1 to 3.
Below the analysis from item 2, please indicate at least three other analyses that could be performed to determine how this data might be used to generate a competitive advantage for the bank.

Share This Post

Order a Similar Paper and get 15% Discount on your First Order

Related Questions

Develop an Organizational Development Report for Management During this unit, you will submit your final project. You will use the organization chosen in Unit I (The United States Army) to finalize an

Develop an Organizational Development Report for Management During this unit, you will submit your final project. You will use the organization chosen in Unit I (The United States Army) to finalize and complete the organizational development (OD) for your management team. During Unit VI, you prepared an outline of your

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured. It should reflect the results of your independent research of

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured within the army. It should reflect the results of your independent research of The United States Army. Within the essay, be sure to include the following elements: ·

PowerPoint Presentation Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For thi

PowerPoint Presentation Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentation, you will choose one of these companies to research. For your research, you will discover what data collection methods

Module 2 – SLPVirtue Ethics and Critical ThinkingAssignment OverviewDiversity, Inclusion, and Virtue Ethics Diversity and Inclusion (D&I) refers to organizational strategies that promote represent

Module 2 – SLPVirtue Ethics and Critical ThinkingAssignment OverviewDiversity, Inclusion, and Virtue Ethics Diversity and Inclusion (D&I) refers to organizational strategies that promote representation and participation of various groups, backgrounds, and perspectives. D&I emphasizes recognizing and valuing differences, ensuring environments where all individuals feel valued, respected, and have equal opportunities.

During this unit, we focused on the costs and benefits of human resource development (HRD) programs. These programs are often designed to help the entire organization reach its goals, but HR leaders a

During this unit, we focused on the costs and benefits of human resource development (HRD) programs. These programs are often designed to help the entire organization reach its goals, but HR leaders also create these programs to help their department to reach its goals and metrics. For this unit’s assignment,

The topic of this paper will address the issue of human resource (HR) alignment with The United States Army’s strategic plan. It should reflect the results of your independent research (US Army). In y

The topic of this paper will address the issue of human resource (HR) alignment with The United States Army’s strategic plan. It should reflect the results of your independent research (US Army). In your paper, be sure to include the elements listed below. – Explain the payoff from enhanced selection

The topic of this essay will address the issue of variability of performance across human operators and how that variability is measured within the army. It should reflect the results of your independ

Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentatio

Restructuring Case Analysis Marriot, Tata Motors, and Sony are three major companies that have gone through a complete restructuring in some area of their organization. For this PowerPoint presentation, you will choose one of these companies to research. For your research, you will discover what data collection methods were used

Organizational Analysis and Feedback This assignment will be used as a precursor to the final project. You will continue to use the organization chosen in Unit I- US Army. To begin this assignment, yo

Organizational Analysis and Feedback This assignment will be used as a precursor to the final project. You will continue to use the organization chosen in Unit I- US Army. To begin this assignment, you will collect the necessary data in order to find out more information about the organization’s problem,

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As generations change, businesses must adapt to d

Module 2 – CaseVirtue Ethics and Critical ThinkingAssignment OverviewGenerational Ethics in Business Generational ethics influence workplace dynamics. As generations change, businesses must adapt to diverse ethical priorities, and foster cross-generational collaboration for sustainable success. Complete SLP 2 before Case 2 Case 2 ResourcesText: 5.2 Business Ethics over Time (2023) Text: 11.1 Business Ethics

1. Your article report study will include a current business article of your choice. “Current” means not older than one year from the beginning date of the class. This report will be a summary of an a

1. Your article report study will include a current business article of your choice. “Current” means not older than one year from the beginning date of the class. This report will be a summary of an article you have selected from a current national news magazine, newspaper, or website. 2.

BA 504 Module Four Excel Workbook Guidelines and RubricOverview Bivariate regression analysis is an excellent tool to help you answer questions about a business. When you use bivariate analysis, you c

BA 504 Module Four Excel Workbook Guidelines and RubricOverview Bivariate regression analysis is an excellent tool to help you answer questions about a business. When you use bivariate analysis, you can discover whether there is a strong correlation between a dependent and an independent variable. In this scenario, you will

Assignment Planning for Effective Communication and Feedback Analysis You will continue to use the organization chosen in Unit I- US Army. This unit’s assignment focuses on the plan for the assessment

Assignment Planning for Effective Communication and Feedback Analysis You will continue to use the organization chosen in Unit I- US Army. This unit’s assignment focuses on the plan for the assessment and the reasons for engaging the employees during the assessment. To begin this assignment, you will describe an issue

Reflection Paper #3 : What is more important to you – a high paying career or a motivating career? Single-spaced, Between 550-600 words (no longer than 600 words and no shorter than 550 words). Essa

Reflection Paper #3 : What is more important to you – a high paying career or a motivating career? Single-spaced, Between 550-600 words (no longer than 600 words and no shorter than 550 words). Essay format- ie., not point form. However, you don’t need a thesis statement nor introduction nor conclusion. i,e. your

Prepare a full sentence outline for research paper about customer service. The outline should include a cover page and list of references. The outline should be a minimum of two double-spaced pages (n

Prepare a full sentence outline for research paper about customer service. The outline should include a cover page and list of references. The outline should be a minimum of two double-spaced pages (not counting cover and references). The purpose of the outline is to help you establish the organization of your final

Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, cust

Stakeholders are individuals or groups that have an active interest in an organization. Stakeholders and stakeholder groups typically include employees, vendors, communities, government agencies, customers, investors, and lenders. Different stakeholders have different interests, attitudes, and priorities. Effective communication ensures that they receive relevant information and develop a positive attitude to

For the marketing plan assignment you are going to develop Part C of the strategic marketing plan. Be sure you include detailed research, information, and analysis to present the assignment’s require

For the marketing plan assignment you are going to develop Part C of the strategic marketing plan. Be sure you include detailed research, information, and analysis to present the assignment’s requirements. The strategic marketing plan should clearly state the chosen market and target audiences. Note: Information within tables can be single-spaced. The rest

Managing and optimizing brand equity is one of the long-term goals of any organization and thus it is a joint responsibility of all the functional departments. Brand equity is the set of assets linked

Managing and optimizing brand equity is one of the long-term goals of any organization and thus it is a joint responsibility of all the functional departments. Brand equity is the set of assets linked to the brand. These assets include brand awareness, brand loyalty, and brand associations. Appropriate alignment of