Our Services

Get 15% Discount on your First Order

I WILL ADD THE TEMPLATE SO ITS JUST TO PUT IT TOGETHER United Savings Bank (USB) is a large bank with branches spanning the United States. They are

May 1, 2024

I WILL ADD THE TEMPLATE SO ITS JUST TO PUT IT TOGETHER

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.

Business & Finance

Share This Post

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

Related Questions

Comparison of Inflammatory Diseases Rheumatoid Arthritis Systemic Lupus Erythematosus Ulcerative

Comparison of Inflammatory Diseases Rheumatoid Arthritis Systemic Lupus Erythematosus Ulcerative Colitis Pathophysiology Etiology Clinical Manifestations Common Laboratory Tests Treatment 11/23/2021 image1.png

1 2 Klyesium Name Institution Course Date Klyesium: A Culinary Odyssey To begin with, planning a dream

1 2 Klyesium Name Institution Course Date Klyesium: A Culinary Odyssey To begin with, planning a dream restaurant is the most inspiring journey referring to building a name that both expresses an innovative concept and draws customers in (Ehrman, 2021). According to Sally’s instructions and after careful thought, the appropriated one-word

After reviewing the TEDTalk Video: I Love Being a Police Officer, but We Need Reform by Melvin Russell, respond to the following: There doesn’t seem to

After reviewing the TEDTalk Video: I Love Being a Police Officer, but We Need Reform by Melvin Russell, respond to the following: There doesn’t seem to be a question that law enforcement is in crisis today. What steps can be taken to transform the relationship between police and the communities they are

INTRO TO HUMAN RESOURCE MANAGEMENT; HRM’S ROLE; STRATEGIC HRM It is important for HRM professionals to keep up on the HRM

INTRO TO HUMAN RESOURCE MANAGEMENT; HRM’S ROLE; STRATEGIC HRM It is important for HRM professionals to keep up on the HRM field. In the SLP assignment in this class, you will be investigating an HRM practitioner publication, HR Magazine (found in ProQuest from the Trident Online Library). It is the main

Option 1 Your team has been assigned to design and launch of a new product or service. This could be an external product for sale or an internal

Option 1 Your team has been assigned to design and launch of a new product or service. This could be an external product for sale or an internal service to support other departments. As you prepare for your first team meeting, you know that identifying and classifying costs will

1 paragraph needed 2 Discussion Student’s Name Institutional Affiliation Professor’s Name Course Name Due Date READ

1 paragraph needed 2 Discussion Student’s Name Institutional Affiliation Professor’s Name Course Name Due Date READ BELOW Assessment questions and appropriate interventions related to the Neighborhood and Built Environment category focus on individual and community health outcomes. As a nurse practitioner (NP), we can work toward influencing patient’s daily behaviors,

There are five general methodological approaches for conducting qualitative research acceptable Ethnography. Case study. Phenomenology. Grounded

There are five general methodological approaches for conducting qualitative research acceptable Ethnography. Case study. Phenomenology. Grounded theory. Generic qualitative inquiry. Select two methodological approaches from the five introduced this week. Demonstrate your understanding of this methodological approach by describing each, comparing and contrasting key features, and explaining when

This is the rubric for my Project. ( Major Project 2: Research essay Research Essay (12 points, required to pass the course, Brightspace) Research an

This is the rubric for my Project. ( Major Project 2: Research essay Research Essay (12 points, required to pass the course, Brightspace) Research an issue important to children, either historical or contemporary. How you define childhood and what stage of childhood (infancy, youth culture, emerging adulthood, etc.) is up to

So many diseases can be prevented if you assess your risk factors and consult your medical professional early on.

Please see attachment · In a section titled “Theories” identify between 1 and 3 moral theories you will use to build your compass

Please see attachment · In a section titled “Theories” identify between 1 and 3 moral theories you will use to build your compass (deontological, utilitarian, common good, virtue, etc.) along with a short, documented definition for each theory. The definition should be in your own words. As citations are

Please help with assignment Revise the information for a rough draft Good start! See comments – don’t panic. We

Please help with assignment Revise the information for a rough draft Good start! See comments – don’t panic. We can talk if you’d like. Biggest thing is that you need better organization. Your studies are all over the place. Sometimes you connect things or say a researcher did a similar

Health care leaders may face many challenging scenarios, such as conflicts between coworkers and departments. During the first 2 months

Health care leaders may face many challenging scenarios, such as conflicts between coworkers and departments. During the first 2 months as the administrator of a new management team for a long-term care facility, you have noticed an increase in conflicts between your coworkers and other departments, such as pharmacy and nursing staff. This

Which factor do you feel has the most impact on family members?, What are some of the reasons it is important to include the support persons in the

Which factor do you feel has the most impact on family members?, What are some of the reasons it is important to include the support persons in the plan of care?

Comment about this post: A school’s organization has a great impact on the cognitive development of a child. The organization also is a direct reflection of

Comment about this post: A school’s organization has a great impact on the cognitive development of a child. The organization also is a direct reflection of the needs of the community. Thats why for example in Orlando, Fl Boone High School is located in a rich neighborhood and has mostly

Attached is Marshal Review the Marshall et. al. (2017) Reading Excerpt linked above. What challenges to completion do you anticipate you will

Attached is Marshal Review the Marshall et. al. (2017) Reading Excerpt linked above. What challenges to completion do you anticipate you will encounter in your doctoral program? What strategies for successful completion do you anticipate will be the most useful for you, and how will you work toward implementing these

1-1 Discussion: Research Methods Address the prompt below. This discussion will focus on the following research methods used in personality

1-1 Discussion: Research Methods Address the prompt below. This discussion will focus on the following research methods used in personality psychology: ● Correlational Studies ● Experimental Studies ● Case Methods Imagine your team is applying for a grant to conduct a major study in personality psychology. Before getting into the

Our Services

I WILL ADD THE TEMPLATE SO ITS JUST TO PUT IT TOGETHER United Savings Bank (USB) is a large bank with branches spanning the United States. They are

Share This Post

Related Questions

Use Our 6 Free Tools