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

The term paper is due on May 21, 2024, at 11:59 PM. Your assignment is to find some news articles within the last year and use them to discuss how the

The term paper is due on May 21, 2024, at 11:59 PM. Your assignment is to find some news articles within the last year and use them to discuss how the economy is doing in two pages or less. Remember to talk about inflation, unemployment, and economic growth and any

Overview Scenario 1 Lori is walking to her car in a shopping mall parking lot at night when Brian suddenly jumps in front of her and points a knife in her

Overview Scenario 1 Lori is walking to her car in a shopping mall parking lot at night when Brian suddenly jumps in front of her and points a knife in her face. Brian strikes Lori. Fortunately, Lori took a self-defense class and hits Brian with her knee and fists and

Instructions Preparation View the Technology in Corrections BriefingLinks to an external site. video that introduces you to the types of challenges to

Instructions Preparation View the Technology in Corrections BriefingLinks to an external site. video that introduces you to the types of challenges to corrections operations and challenges you to find solutions. Download the Week 10 Assignment Template Download Week 10 Assignment Template and use it to complete this assignment. Review Electronic Monitoring of Offenders: An Ethical

You will write a public policy analysis about a national, state, or local issue that interests you. It should be coming from your perspective, not

You will write a public policy analysis about a national, state, or local issue that interests you. It should be coming from your perspective, not the legislators’. Be sure to focus on a policy that is part of current public discourse; if it already is in place, this means that policymakers are considering

Choose one scenario from the list below: Campus Safety—The parents of local high school students are concerned about student safety on campus. At the

Choose one scenario from the list below: Campus Safety—The parents of local high school students are concerned about student safety on campus. At the recent school board meeting, they proposed installing metal detectors at the entrance to each high school. Smoking and Vaping—Local health officials warn there has been a sharp rise

What is the ASCA National Model and why is it important to the field of school counseling? What role do you think this national model might play in your

What is the ASCA National Model and why is it important to the field of school counseling? What role do you think this national model might play in your day-to-day work as a school counselor? Does the ASCA National Model allow for compassion, justice, and concern for the common good?

I need your assistance…. 500 words. 2 current academic references (w/in 5 years). Describe dermatitis, diagnostic criteria, and treatment

I need your assistance…. 500 words. 2 current academic references (w/in 5 years). Describe dermatitis, diagnostic criteria, and treatment modalities Describe the drug therapy for Conjunctivitis and Otitis Media Discuss Herpes Virus infections, patient presentation, and treatment Describe the most common primary bacterial skin infections and the treatment of choice.

Can you assist with an advanced writing assignment? Analyze and evaluate a middle range theory. You will select a middle range theory and identify

Can you assist with an advanced writing assignment? Analyze and evaluate a middle range theory. You will select a middle range theory and identify application of nursing theories into clinical practice. 1. APA 2. 3 references published within last five years ,scholarly journal articles or primary legal sources (statutes, court opinions.) 3.

In this unit, most of the discussion has been centered around program design and measuring the effectiveness of training and development programs. You have

In this unit, most of the discussion has been centered around program design and measuring the effectiveness of training and development programs. You have the opportunity to design a training program for your organization. Describe the training program and how the training program will be delivered. Who will be trained,

Contract Scenario Calvin had been an avid coin collector for many years, and the most valuable coin in his collection was an uncirculated, mint condition,

Contract Scenario Calvin had been an avid coin collector for many years, and the most valuable coin in his collection was an uncirculated, mint condition, 1943 Lincoln penny made of copper (most pennies made during World War II were made of zinc because copper was needed in the war effort).

Instructions Please complete the following steps for your first discussion post and response. Conduct research and find two studies related to the

Instructions Please complete the following steps for your first discussion post and response. Conduct research and find two studies related to the variables used in your field of study. Your articles should focus on the relationship between the same two variables. Be sure the studies include either correlation or regression,

CASE #2 Nancy Jefferson is the superintendent of a medium-sized public school district. Nancy is passionate about finding ways to better prepare her

CASE #2 Nancy Jefferson is the superintendent of a medium-sized public school district. Nancy is passionate about finding ways to better prepare her district’s students for life after high school graduation. While the district’s current teaching methods are in accordance with the state-mandated curriculum and her district’s students are testing

2 assignments 2 Written assignment: 1. Mobility in computing is becoming a primary driving factor for businesses, especially following

2 assignments 2 Written assignment: 1. Mobility in computing is becoming a primary driving factor for businesses, especially following the Covid-19 pandemic. When the pandemic hit, many businesses were not ready to send their workers home and did not have the networking infrastructure in place to support secure remote access

1 Cultural Humility in Practice Student Name Department of Social and Behavioral Sciences, Capella University PSY 7710: Ethics for

1 Cultural Humility in Practice Student Name Department of Social and Behavioral Sciences, Capella University PSY 7710: Ethics for Behavior Analysts Instructor Name Assignment Due Date Culture in Behavior Analysis Please note, all italicized writing in this template is for instructional purposes. You will not be using italics. Remove all

1) How can existing and emerging technologies (IoT, Artificial Intelligence, Cloud Computing, Machine Learning, Collaboration Technologies, etc,) inform

1) How can existing and emerging technologies (IoT, Artificial Intelligence, Cloud Computing, Machine Learning, Collaboration Technologies, etc,) inform and enhance the administration and delivery of Public Sector services, i.e., 2) What is possible? 3) How to maximize?

Central-line-associated Bloodstream Infections – Outcome

Medicaid is partially federally funded and partially state-funded. As we all know, not every State is equal in per capita income, and the number of

Medicaid is partially federally funded and partially state-funded. As we all know, not every State is equal in per capita income, and the number of poor and disabled is equally unbalanced. Under the Affordable Care Act (ACA), Medicaid funding was expanded, yet some states opted out of accepting 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