Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and standard deviation summarized as follows (in $1,000s): Mean Std Dev Monday $180 $23 Tuesday Wednesday Thursday Friday Saturday Sunday $115 $55 $125 $135 $70 $21 $12 $15 $25 $7 $95 $11 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. Keeping excessive cash reserves would guard against this situation. However, cash is a noninterest earning asset, so there is an opportunity cost for holding excess cash reserves. a. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $875,000. Create a spreadsheet model to track the daily cash balance throughout the week. b. What is the probability that the bank will run out of money at some point during the week? c. What amount of money is needed at the start each week to ensure there is at most a 0.05% chance of running out of money? Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and standard deviation summarized as follows (in $1,000s): Mean Std Dev Monday $180 $23 Tuesday Wednesday Thursday Friday Saturday Sunday $115 $55 $125 $135 $70 $21 $12 $15 $25 $7 $95 $11 An armored truck delivers cash to this bank once a week. The manager of the bank can order any amount of cash she desires for this delivery. Of course, running out of cash in any week is very undesirable as customers of the bank expect to be able to withdraw their deposits on demand. Keeping excessive cash reserves would guard against this situation. However, cash is a noninterest earning asset, so there is an opportunity cost for holding excess cash reserves. a. Suppose the bank manager follows the practice of ordering enough cash to start each week with a balance of $875,000. Create a spreadsheet model to track the daily cash balance throughout the week. b. What is the probability that the bank will run out of money at some point during the week? c. What amount of money is needed at the start each week to ensure there is at most a 0.05% chance of running out of money?
Expert Answer:
Answer rating: 100% (QA)
a Spreadsheet model for daily cash balance with 875000 starting balance Day Mean Std Dev Cash Balanc... View the full answer
Related Book For
Spreadsheet Modeling And Decision Analysis A Practical Introduction To Business Analytics
ISBN: 9781305947412
8th Edition
Authors: Cliff T. Ragsdale
Posted Date:
Students also viewed these finance questions
-
"Under Florida law, did Sue's psychologist, Dr. Curran, had a duty to notify Ryan that in the psychological consultation he had with Sue, she confessed to him of her intentions of wanting to slay...
-
Branch banks must keep enough money on hand to satisfy customers' cash demands. Suppose that the daily demand for cash at a branch of University Bank follows a lognormal distribution with means and...
-
Draw Lewis structure(s) showing all possible equivalent resonance forms for the nitryl chloride molecule (NOCI). Draw one structure per sketcher box, and separate any added sketcher boxes with the...
-
Draw structures for the following molecules (a) Acrylonitrile, C3H3N, which contains a carbon-carbon double bond and a carbon-nitrogen triple bond (b) Ethyl methyl ether, C3H8O, which contains an...
-
What is wrong with the following calculation? (Guido Ubaldus thought that this proved the existence of God because something has been created out of nothing.) 0 = 0 +0 + 0 +.. - (1 - 1) + (1 1) + (1...
-
Each of the following equations describes a reaction of a compound called methyl formate. To what class of compounds does methyl formate belong? Which reactions require a reducing agent? Which...
-
Your neighbor, Norman Vetter, has always been tinkering in his garage with his inventions. He believes he has finally come up with one that could really sell well. He is a little concerned about some...
-
Assume a government leases equipment to be used in governmental activities under a noncancelable lease, meeting the requirements for classification as a capital lease. Where would the capital lease...
-
K A company is taking a survey to find out if people like its product. Their last survey indicated that 76% of the population like the product. Based on that, of a sample of 24 people, find the...
-
As a business owner, I have 3 different locations within the Denver Metro area. Two of those places are retail sales operations with about 3,500 square feet in each retail location. The third...
-
Identify common challenges faced in cross-cultural communication. Describe some of the strategies they can use to overcome those barriers. Explain five of the nine levels of differences that can...
-
Why is it important to find the natural frequency of a vibrating system?
-
Complex stiffness or complex damping is defined in the case of a. hysteresis damping b. Coulomb damping c. viscous damping
-
Why does the amplitude of free vibration gradually diminish in practical systems?
-
True or False. The characteristic equation of a single-degree-of-freedom system can have one real root and one complex root.
-
The damping force depends on the frequency of the applied force in the case of a. viscous-damping b. Coulomb damping c. hysteresis damping
-
Which founding father beloved that the president and the senate should serve lifelong terms.
-
Determine whether the lines are parallel, perpendicular, or neither. 2x + 3y = -12, 2y - 3x = 8
-
KPS Communications is planning to bring wireless internet access to the town of Ames, Iowa. Using a geographic information system, KPS has divided Ames into the following 5 by 5 grid. The values in...
-
One of the examples in this chapter dealt with determining the optimal reorder point for a computer monitor sold by Millennium Computer Corp. Suppose that it costs MCC $0.30 per day in holding costs...
-
Each year, the Schriber Corporation must determine how much to contribute to the company's pension plan. The company uses a 10-year planning horizon to determine the contribution, which, if made...
-
Which of the following items would be most useful in analyzing the separation of duties and functions in an application system? (a) document flowchart (b) program flowchart (c) HIPO chart (d) source...
-
An important omission from flowcharts and matrix techniques is ( ___________________ ). (a) the ability to represent decisions (b) the ability to include internal control considerations (c) the...
-
In the preparation of a logical data flow diagram for a payroll processing application, which of the following symbols should be used to indicate the payroll data? (a) terminator symbol (b) data...
Study smarter with the SolutionInn App