Our Services

Get 15% Discount on your First Order

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

May 1, 2024

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

Patient 4: 8-year-old Asian female with a diagnosis of severe depressive disorder presents to the office with a report of worsening symptoms. She has never

Patient 4: 8-year-old Asian female with a diagnosis of severe depressive disorder presents to the office with a report of worsening symptoms. She has never taken psychotropic medication before. Medica

Course Description We will study and explore the physical, intellectual, emotional, social, and behavioral development of humans from puberty

Course Description We will study and explore the physical, intellectual, emotional, social, and behavioral development of humans from puberty to maturity. In addition, an examination of the challenges experienced by adolescents and parents will be covered. Syllabus is subject to change! Course Objectives. 1) To gain a fundamental understanding of

Korn Ferry | Organizational Consulting The Shift from the Experience Economy to the Transforma… (thehappyprizecompany.com) From the fluidity of the

Korn Ferry | Organizational Consulting The Shift from the Experience Economy to the Transforma… (thehappyprizecompany.com) From the fluidity of the experience economy to transformative experiences as a catalyst for positive change: the future of experiential travel | Emerald Insight Background Information The experience economy is the current trend in hospitality,

Yulia Gutsul T00434432 Module 5 Pre-observation interview

Yulia Gutsul T00434432 Module 5 Pre-observation interview The subject of this lesson is “Alphabet”. · At the end of the class, most students may: · Recognize words that are relevant to the letters of the specific alphabet. · Read the various letters of the alphabet. · Determine has given objects

Please Read Name: _________________________ Social identity wheel Fill in your identity for each of the categories listed. In the inner circle,

Please Read Name: _________________________ Social identity wheel Fill in your identity for each of the categories listed. In the inner circle, record the identities that are the most important or salient to you. In the outer circle, record the identities that are less important or salient to you. Questions 1.

INSTRUCTIONS ATTACHED Persuasive Essay (Without Sources) Purpose · Argue for community issues from a personal perspective · Think critically about

INSTRUCTIONS ATTACHED Persuasive Essay (Without Sources) Purpose · Argue for community issues from a personal perspective · Think critically about community issues; draft and revise a 5-paragraph Persuasive Essay in a Word doc. using MLA formatting; identify and correct writing errors; and reflect on the writing process · Organize ideas

Module 03 Written Assignment – Agencies for Quality Top of Form Bottom of Form Module 03 Content 1. Top of Form Explore one of the agencies for

Module 03 Written Assignment – Agencies for Quality Top of Form Bottom of Form Module 03 Content 1. Top of Form Explore one of the agencies for quality improvement listed in this module’s lecture. Write a one-page summary of what the agency does, who it affects, and how it is utilized.

Instructions: Draw a logical data model (ERD) for the Picnics R US case [Refer to ‘Assignment#1’ and ‘Assiignment#2’ on Canvas under ‘Assignments’] Guidelines:

Instructions: Draw a logical data model (ERD) for the Picnics R US case [Refer to ‘Assignment#1’ and ‘Assiignment#2’ on Canvas under ‘Assignments’] Guidelines: A data model describes the data that flo

i need a paper done, one file is the rubric while the other is the topic that needs to be written upon; due 3/31 11:59 pm U.S central standard time please

i need a paper done, one file is the rubric while the other is the topic that needs to be written upon; due 3/31 11:59 pm U.S central standard time please ask questions if needed!

what are your thoughts about the opportunities and challenges related to achieving the 2021 National Patient Safety Goal of, reducing the risk of health

what are your thoughts about the opportunities and challenges related to achieving the 2021 National Patient Safety Goal of, reducing the risk of health care associated infections, in your work environment?

write a speech about this topic for civilization’s class WRITE IT AS FAST AS YOU CAN AND USE THE ARTICLE I HAVE UPLOADED The Cold War. (1945-1991) The Cold

write a speech about this topic for civilization’s class WRITE IT AS FAST AS YOU CAN AND USE THE ARTICLE I HAVE UPLOADED The Cold War. (1945-1991) The Cold War was reflected in culture through musicwrite a speech about this topic for civilization’s class WRITE IT AS FAST AS

Case BUS530 Managerial Economics Module 1 Case Equilibrium, Supply and Demand Assignment Overview Supply and Demand in the Real WorldA commodity is the

Case BUS530 Managerial Economics Module 1 Case Equilibrium, Supply and Demand Assignment Overview Supply and Demand in the Real WorldA commodity is the focus of this case which uses real data for price fluctuations over 6 months. You will research reasons for the changes and develop a multifaceted economic analysis.

Describe experiences (such as work, volunteer, church, social, academic) you have had that resulted in learning. Be as specific as possible with your

Describe experiences (such as work, volunteer, church, social, academic) you have had that resulted in learning. Be as specific as possible with your examples.Discuss the reflective concept in the cou

Review Mindsets, M 1 – M 7 of the ASCA School Counselor Professional Standards and Competencies. Select one of the listed beliefs of school counselors and

Review Mindsets, M 1 – M 7 of the ASCA School Counselor Professional Standards and Competencies. Select one of the listed beliefs of school counselors and discuss how you have either personally experienced a school counselor exhibit this belief or how you as a school counseling professional might go about

Think of a social norm that you have seen violated in a film, television show, literary novel, or other form of media. It should be a situation where everyone

Think of a social norm that you have seen violated in a film, television show, literary novel, or other form of media. It should be a situation where everyone knows what the appropriate behavior would

DISCUSSION RESPONSE MEASURES USED IN EPIDEMIOLOGY DUE MARCH 28 MEASURES USED IN EPIDEMIOLOGY Respond to

DISCUSSION RESPONSE MEASURES USED IN EPIDEMIOLOGY DUE MARCH 28 MEASURES USED IN EPIDEMIOLOGY Respond to two colleagues in one or more of the following ways: · Ask a probing question, substantiated with additional background information, evidence or research. · Share an insight from having read your colleagues’ postings, synthesizing the information to

Our Services

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

Share This Post

Related Questions

Use Our 6 Free Tools