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...
-
Do a Financial analysis on the Merck & co. Inc (American pharmaceutical company for year 2016,2015 and 2014)
-
Find the set of values of x for which x(x + 2) < x.
-
Copying of the successful practices of others is called __________. (a) mimicry (b) scanning (c) grafting (d) strategy
-
The manager of a chain of electronics stores is considering running a sale on a Lexmark printer model that contains many popular features. The store buys these printers for $60 apiece and, at the...
-
incorrect for the work you have completed s 8 10 points 03:56:27 Krall Company recently had a computer malfunction and lost a portion of its accounting records. The company has reconstructed some of...
-
Calculate the enthalpy and entropy of saturated isobutane vapor at 360 K from the following information: 1. Table 6.1 gives compressibility-factor data (values of Z) for isobutane vapor. 2. The vapor...
-
Use the Maclaurins series from above question to evaluate give an answer correct to 6 decimal places( 4 terms needed) Find the Maclaurin's series for: Ln(1+ [a]x/[b] + [c]x?/[d] + [e]x/[f] + [g]x*/[h]
-
Explain how onboarding and emotional intelligence have changed processes in HRM. Discuss the major difference between training and development, providing examples of common situations where training...
-
15 identical Christmas tree bulbs are connected in series. When the lights are plugged into a 120 V power source, the current through each is 0.8 A. Calculate the resistance of each bulb.
-
The main aim of this project is to transition the current on-premises data storage* of the Australia and New Zealand Banking Group (ANZ Bank) to Google Cloud, a secure and flexible cloud computing**...
-
Write a statement that displays these fields: customer's first name customer's last name order id order date of orders placed Use the default JOIN type, use table aliases of C for customers and O for...
-
Assume that a palladium metal foil has been saturated with a homogenous concentration of hydrogen atoms at equilibrium. Assume that at room temperature the overall hydrogen concentration in the foil...
-
Please help. QUESTION FOUR PART A The following are extracts from the financial records of ABC Lid for the year ended 31 August 2021. ABC Ltd Extract from the Statement of financial statement as at...
-
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...
-
The Raupe Lease has the following working interest owners: Reed Corporation 50%, League Energy 25%, and Sunshine Oil Company 25%. There is a 1/8 royalty on the lease. On April 1, 2011, Reed...
-
Identify the types of interests that are created in the following situations. If the interest is an overriding royalty or a production payment interest, also state whether it is a retained or...
-
Session Gas Company owns a 33.3% working interest in a lease in West Texas. Roger Williams, a local farmer, owns a 1/8 royalty interest in the lease. Session is the operator, and its partners, Rocky...
Study smarter with the SolutionInn App