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

Please respond to the following questions in ONE posting and NUMBER your responses: Debate 1:

Please respond to the following questions in ONE posting and NUMBER your responses: Debate 1: Banning TikTok – FOR or AGAINST? · Make an initial posting FOR “Banning TikTok” AND AGAINST “Banning TikTok.” · Reply to 1+ students’ postings after you have read a number of students’ arguments in the

1500 words MINIMUM (not including cover/reference pages or questions) Requirement is at least five scholarly articles, ONE

1500 words MINIMUM (not including cover/reference pages or questions) Requirement is at least five scholarly articles, ONE maybe the course textbook BELOW Textbook(s) Thomas, C. R., & Maurice, S. C. (2020). Managerial economics: Foundations of business analysis and strategy (13th ed.). McGraw-Hill/Irwin. UNIT 1 Complete 1. At the beginning of

Section A Input Data

Section A Input Data EduCredit is the education loan division of a bank. It is considering a batch of applications for student loans repayable in one year. EduCredit charges each loan applicants an annual interest rate that depends on the band of their credit scores (A is the highest) Loan

Unit 7 Use Berkshire Hathaway Phase IV Part II: Credit Policies and Profitability Analysis Overview: This unit requires you to analyze the impact of

Unit 7 Use Berkshire Hathaway Phase IV Part II: Credit Policies and Profitability Analysis Overview: This unit requires you to analyze the impact of various credit policies on your chosen company’s profitability. Consider different credit terms and policies that the company might adopt and evaluate how these would influence cash

2/19/24, 7:02 PM SLP – HRM401 Staffing Organizations (2024JAN08FT-1) 1/5 Module 4 – SLP EMPLOYEE RETENTION For this SLP assignment, review the

2/19/24, 7:02 PM SLP – HRM401 Staffing Organizations (2024JAN08FT-1) 1/5 Module 4 – SLP EMPLOYEE RETENTION For this SLP assignment, review the following: Arthur, D. (2019). Chapter 17: Online employee orientation. In Recruiting, interviewing, selecting, & orienting new employees (6th ed.). Harper Collins [Books 24/7]. Available in the Trident Online

Concept Map Template Primary Diagnosis: Parkinson’s 1. Describe the pathophysiology of the primary diagnosis in your own words. What are the

Concept Map Template Primary Diagnosis: Parkinson’s 1. Describe the pathophysiology of the primary diagnosis in your own words. What are the patient’s risk factors for this diagnosis? Pathophysiology of Primary Diagnosis Causes Risk Factors (genetic/ethnic/physical) 2. What are the patient’s signs and symptoms for this diagnosis? How does the diagnosis

Lesson ELEMENTARY AND SECONDARY COMPONENT 3 PreK/Kindergarten: Activity 3: Lesson Video Description and Reflection Questions Page 1 of 11

Lesson ELEMENTARY AND SECONDARY COMPONENT 3 PreK/Kindergarten: Activity 3: Lesson Video Description and Reflection Questions Page 1 of 11 © 2022 University of Florida Lastinger Center for Learning Your Name: Maria Alejandra Paz Date: 2/29/2024 Grade(s) You Teach: VPK Activity 3: Lesson Video Description and Guiding Questions Instructions: Watch a

Description You are encouraged to use the library as a resource for this assignment. Note: This assignment will have 2 parts. Part 1 As a security manager,

Description You are encouraged to use the library as a resource for this assignment. Note: This assignment will have 2 parts. Part 1 As a security manager, address a memo to key stakeholders in indust

Review this week’s Learning Resources and consider the following: Ethical issues faced by forensic psychology professionals who work with the

Review this week’s Learning Resources and consider the following: Ethical issues faced by forensic psychology professionals who work with the military (either as active-duty military personnel or as civilians) Roles and responsibilities forensic psychology professionals may have in relation to Veterans Treatment Court Benefits and limitations of Veterans Treatment

Case Study- Joe is a 14 yo Hispanic male currently participating in competitive skateboarding. He wears the regulation helmet while competing, but often

Case Study- Joe is a 14 yo Hispanic male currently participating in competitive skateboarding. He wears the regulation helmet while competing, but often chooses a half helmet while practicing because it’s lighter. 3 days ago he hit his head when he fell from the top of the half pipe while practicing a new

Unit 1 Discussion CLO 1, 3, 5-6 1) Pick ONE of the four questions below to answer using both the information learned in Unit 1 and online resources. 2) Answer

Unit 1 Discussion CLO 1, 3, 5-6 1) Pick ONE of the four questions below to answer using both the information learned in Unit 1 and online resources. 2) Answer the question in complete sentences in no more than a TWO paragraph. (50% of the grade) 3) Cite at least

PSYC 620 Case Study Paper Assignment Instructions Overview Through this paper, you will demonstrate your conceptual

PSYC 620 Case Study Paper Assignment Instructions Overview Through this paper, you will demonstrate your conceptual comprehension and clinical intervention skills by identifying and describing diagnostic criteria based on the disorders studied in this course. You will create a hypothetical case of a patient who is presenting with 2 psychological

A strong mentorship program provides an opportunity for experienced health care workers to share their knowledge and offer guidance to colleagues. As

A strong mentorship program provides an opportunity for experienced health care workers to share their knowledge and offer guidance to colleagues. As a manager at a health care organization, you have been asked to develop a personal leadership philosophy as an example for a mentorship program’s participants that your leadership team has instituted for developing new

In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff

In the fast-paced business world, maintaining a competitive edge often hinges on accessing the right talent at the right time. This is where staff augmentation shines as a strategic solution. To explore how staff augmentation can elevate your business operations, visit Sombrainc: and discover tailored solutions designed to drive

view attachment PEER REVIEW DISCUSSION The class will be divided into four learning communities at the beginning of the course (group A, B, C, and

view attachment PEER REVIEW DISCUSSION The class will be divided into four learning communities at the beginning of the course (group A, B, C, and D). Each of the four learning communities will have a different strand assigned to individually select a topic to present to the group. (Note: this

Instructions – Apply the strategy below to the Internation Venture Idea (1 page)

Instructions – Apply the strategy below to the Internation Venture Idea (1 page) Strategy – Target the right strategy group strategy International Venture Idea – An education platform that can be accessed online by all students around the world implementing diverse languages and curriculum.

BJ 6218 assessment 3 Remove or Replace: Header Is Not Doc Title NURS-FPX6218 Guiding Questions for

BJ 6218 assessment 3 Remove or Replace: Header Is Not Doc Title NURS-FPX6218 Guiding Questions for Assessment 3 Planning for Community and Organizational Change This document is designed to give you questions to consider and additional guidance to help you successfully complete the Planning for Community and Organizational Change assignment.

Please write a reflection summary of what you have learned these past 16 weeks in the course “Physical Security” Also, tell me what things I did as an in

Please write a reflection summary of what you have learned these past 16 weeks in the course “Physical Security” Also, tell me what things I did as an instructor that were the most helpful to you, as well as any suggestions you have for further improving this course. Thank you, and I

24/7 — Client Support