Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Read the scenario below and follow the instructions at the end. You'll use Excel to create your answers and will upload an Excel spreadsheet.

image text in transcribedimage text in transcribed

Read the scenario below and follow the instructions at the end. You'll use Excel to create your answers and will upload an Excel spreadsheet. In 2012, Marty was very unhappy with her bank - the United Bank of San Jose- and in January switched her banking relationship to the San Francisco Community Bank (SFCB). SFCB's marketing department estimates it costs $1,075 on average in advertising to make a prospect aware of the bank and "convert" them to a customer. When Marty moved her accounts (including her checking, savings and car loan) to SFCB, it cost $485 for bank personnel to open her accounts, set her up on the system and transfer her deposit accounts and car loan from her previous bank. Each year, it costs SFCB $18 per month to send Marty statements, process her checks and post her loan payments. It also costs SFCB $150 per year because they pay Marty interest on her savings account. In addition, SFCB spends $65 per year to create and mail her tax filing documents. (All banks are required to provide this information to customers so customers can file their income taxes.) Marty pays $30 per month in fees for her checking account and $565 per month in interest on her car loan. Marty occasionally sends wire transfers and does foreign currency transactions that the bank charges her fees for, which average $45 per year. Marty has been very happy with SFCB and has referred 3 other people to the bank. The bank estimates each referral is worth $1,025 in profit to the bank. (The bank doesn't pay Marty for her referrals.) Use Excel to complete answer the questions following.

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Accounting Business Reporting For Decision Making

Authors: Jacqueline Birt, Keryn Chalmers, Albie Brooks, Suzanne Byrne, Judy Oliver

4th Edition

978-0730302414, 0730302415

More Books

Students also viewed these Accounting questions