Read the scenario below and follow the instructions at the end. You'll use Excel to create...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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. | 3. Bonus Question: Because interest paid on loans is reduced as principal is paid down, what would Marty's 5-year customer value be if the amount of interest she paid on her car loan decreased 20% each year after the first year? (If you correctly answer #1 and #2 and get this calculation right, you'll earn 10 extra credit points.) 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. | 3. Bonus Question: Because interest paid on loans is reduced as principal is paid down, what would Marty's 5-year customer value be if the amount of interest she paid on her car loan decreased 20% each year after the first year? (If you correctly answer #1 and #2 and get this calculation right, you'll earn 10 extra credit points.)
Expert Answer:
Answer rating: 100% (QA)
Total interest paid is calculated as shown below Interest paid on Car loan in 1st ... View the full answer
Related Book For
Fundamentals of Investing
ISBN: 978-0133075359
12th edition
Authors: Scott B. Smart, Lawrence J. Gitman, Michael D. Joehnk
Posted Date:
Students also viewed these organizational behavior questions
-
Use Excel to create a 95% confidence interval of average Woodbon sales, when mortgage rates are 6%, housing starts are 3,500, and advertising expenditure is $3,500. Interpret the interval.
-
Use Excel to create a scatter plot with smooth lines of the Normal Curve. Graph the equation according to these requirements: = 3 = .7 -2 x 8 in increments of .2 Paste the scatter plot into Excel.
-
Use Excel to create all possible Marks models, and then consider those that have two explanatory variables. Note that there are 10 such models. Which of these models is best, and why? Is this model a...
-
The costs of achieving emission reductions in the future will depend greatly on the types of policies used to reduce emissions today. Explain.
-
Newton had an incorrect theory of gases in which he assumed that all gas molecules repel one another and the walls of their container. Thus, the molecules of a gas are statically and uniformly...
-
A beam of protons with various speeds is directed in the positive x direction. The beam enters a region with a uniform magnetic field of magnitude 0.52 T pointing in the negative z direction, as...
-
We see that 75 of the 264 people in the study allowed the pressure to reach its maximum level of \(300 \mathrm{mmHg}\), without ever saying that the pain was too much (MaxPressure=yes). Use this...
-
A large drug company must determine how many sales representatives to assign to each of four sales districts, the cost of having n representatives is ($80,000 + $88,000n) per year. if a rep is based...
-
An electricity company pays a dividend $ 1 . 6 4 per share and the share price is $ 2 7 . a ) If the investors believe that the dividend growth rate will be 3 % annually, what will be the yield that...
-
Below are incomplete financial statements for Benson. Incorporated. Requlred: Calculate the missing amounts. table [ [ BENSON , INCORPORATED ] , [ Income Statement ] , [ Year ended Decem ber 3 1 , 2...
-
Assume that the company, where you are working as a team in Financial Department, is considering a potential project with a new product that is expected to sell for an average price of $22 per unit...
-
Do you think companies have to operate ethically to be nancially successful? Why or why not? 2 Briefly describe the following giving a comparison between them: a) Attribution theory of charismatic...
-
1.How does the positivist school differ from the classical school of criminology (e.g., think about the concept of predestination)? Describe the tenets of each and how they differ. Which of these...
-
Q1. What are your personal assumptions about: How do people develop the kinds of psychological distress that bring them to counseling? What constitutes "good mental health" or "a good life?" How do...
-
Why is it important for an organization to actively manage and update its technology? Consider an industry that has experienced great technological change over the past 10 to 20 years. Describe the...
-
Topic: Why is it important to have a college education? Selected three sources from a library database At least one source that presents an opposing viewpoint, a position that an opponent of your...
-
Determine b so that the slope of PQ is 6, where P and Q are the points (b,3) and (7,33), respectively. What is the value of b? b = (Simplify your answer. Type an integer or a fraction.)
-
Perform the operation by first converting the numerator and denominator to scientific notation. Write the answer in scientific notation. 7,200,00/0.000009
-
You are considering investing $800 in Higgs B. Technology Inc. You can buy common stock at $25 per share; this stock pays no dividends. You can also buy a convertible bond ($1,000 par value) that is...
-
Find the present value of each of the following streams of income, assuming a 12% discount rate. End of Year End of End of Income ($) Year 1-5 6-10 Year Income ($) Income ($) 10,000 yr 8,000 yr 2,200...
-
You are considering 2 investment alternatives. The first is a stock that pays quarterly dividends of $0.25 per share and is trading at $30 per share; you expect to sell the stock in 6 months for $34....
-
When translating Acceletrons fi nancial statements into US dollars, Redline is least likely to use an exchange rate of USD per SGD: A . 0.671. B . 0.588. C . 0.654.
-
Based on Exhibit 1, what is the foreign exchange gain resulting from Transaction 3 on the December 31, 2016 fi nancial statements? A . NVK1.70 per ton B . NVK90.75 per ton C . NVK248.54 per ton
-
Which transaction would generate foreign currency transaction exposure for Ambleu? A . Transaction 1 B . Transaction 2 C . Transaction 3
Study smarter with the SolutionInn App