A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND EQUIVALENTS BUT HAS NO ACCESS TO A BANK LINE OF CREDIT. Day Cash Flow Day Cash Flow Day Cash Flow 1 11 2 3 4 5 6 7 9 $26,554.20 $23,110.38 10 -$8,227.22 $13,870.79 $86,705.92 $78,618.38 12 -$64,951.28 $16,518.43 $5,393.37 $14,726.99 -$5,660.26 17 $35,622.40 18 -$10,835.72 19 -$24,064.02 20 -$12,941.02 13 14 15 $23,904.57 16 21 22 23 24 25 26 -$63,396.45 -$17,653.18 8 $124,891.46 28 -$52,783.19 $53,915.35 $52,173.28 $35,184.53 30 $30,095.43 ACCESS THE EXCEL FILE IN THE LEARNING MANAGEMENT SYSTEM TO DO THE FOLLOWING ACTIVITIES: 27 -$4,256.05 $36,571.04 $85,506.95 $67,915.09 29 $10.52 $9,480.78 4. Using Lambda, calculate the probability of liquidity and illiquidity. 5. Interpret the result. 6. 1. Enter the historical daily cash flows in Excel. 2. Use the historical data to calculate expected future daily cash flow and historical cash flow volatility. 3. Calculate Lambda. Recalculate Lambda and the resulting liquidity outcomes backing into a desired amount of a line of credit for a desired Lambda. A FIRM HAS THE FOLLOWING HISTORICAL, DAILY CASH FLOWS. THE FIRM HAS $15,000 IN CASH AND EQUIVALENTS BUT HAS NO ACCESS TO A BANK LINE OF CREDIT. Day Cash Flow Day Cash Flow Day Cash Flow 1 11 2 3 4 5 6 7 9 $26,554.20 $23,110.38 10 -$8,227.22 $13,870.79 $86,705.92 $78,618.38 12 -$64,951.28 $16,518.43 $5,393.37 $14,726.99 -$5,660.26 17 $35,622.40 18 -$10,835.72 19 -$24,064.02 20 -$12,941.02 13 14 15 $23,904.57 16 21 22 23 24 25 26 -$63,396.45 -$17,653.18 8 $124,891.46 28 -$52,783.19 $53,915.35 $52,173.28 $35,184.53 30 $30,095.43 ACCESS THE EXCEL FILE IN THE LEARNING MANAGEMENT SYSTEM TO DO THE FOLLOWING ACTIVITIES: 27 -$4,256.05 $36,571.04 $85,506.95 $67,915.09 29 $10.52 $9,480.78 4. Using Lambda, calculate the probability of liquidity and illiquidity. 5. Interpret the result. 6. 1. Enter the historical daily cash flows in Excel. 2. Use the historical data to calculate expected future daily cash flow and historical cash flow volatility. 3. Calculate Lambda. Recalculate Lambda and the resulting liquidity outcomes backing into a desired amount of a line of credit for a desired Lambda.
Expert Answer:
Answer rating: 100% (QA)
01 Enter Historical Daily Cash Flows in Excel Open Excel and create a new sheet In column A enter th... View the full answer
Related Book For
Basic Finance An Introduction to Financial Institutions Investments and Management
ISBN: 978-1111820633
10th edition
Authors: Herbert B. Mayo
Posted Date:
Students also viewed these accounting questions
-
A firm has the following investment alternatives: Each investment costs $3,000; investments B and C are mutually exclusive, and the firms cost of capital is 8 percent. a. What is the net present...
-
A firm has the following investment alternatives. Each one lasts a year. The firms cost of capital is 7 percent. A and B are mutually exclusive, and B and C are mutually exclusive. a. What is the net...
-
A firm has the following investment alternatives. Each costs $13,000 and has the following cash inflows. Investment A is considered to be typical of the firms investments. Investment Bs cash flows...
-
In the Akerlof example, the individuals are treated as indifferent to risk. What would you expect to see in these markets if individuals wanted to avoid risk? What if there were some risk lovers?
-
Newcastle Corporation was incorporated in 2010. For the years 2010 through 2012, Newcastle has the following net capital gain or loss. If Newcastle is in the 34% marginal tax bracket for each of...
-
When is a Form 8K issued by a company? What specific information does a Form 8K convey?
-
(NPV, IRR, EAC, PI, challenging) Your company is considering an investment in the following projects (cash flows are in thousand dollars). The CFO of your company has calculated the following values...
-
On January 1, 2017, Holland Corporation paid $8 per share to a group of Zeeland Corporation shareholders to acquire 60,000 shares of Zeeland's outstanding voting stock, representing a 60 percent...
-
A company pays its employees at the end of each month. Payroll information is listed below for January. \ table [ [ Salaries , $ 6 0 , 0 0 0
-
McKinney Solvents produces a wide variety of products for the manufacturing industry. The standard mix for producing a single batch of 100 gallons of its biggest-selling product is as follows: There...
-
Scenario: ABC Company is a multi-national corporation that manufactures various consumer products such as laundry detergent, hand soap, and other cleaning products. The company has decided to build a...
-
During the first year of operation, 2012, Wells Appliance Co. recognized \(\$ 300,000\) of service revenue on account. At the end of 2012, the accounts receivable balance was \(\$ 58,000\). For this...
-
In model (1.11) determine the outcome with the following parameters changed: a.Initially 5 are sick, and 15 are sick the next week. b.The flu lasts 1 week. c.The flu lasts 4 weeks. d. There are 4000...
-
Sketch a divided-wall column for an ideal four-component (A, B, C, D) separation with component A most volatile and D least volatile.
-
Godfrey Manufacturing, Inc., operates a plant that produces its own regionally marketed Spicy Steak Sauce. he sauce is produced in two processes, blending and bottling. In the Blending Department,...
-
Burne Building Services offers janitorial services on both a contract basis and an hourly basis. On January 1, Burne collected \(\$ 90,000\) in advance on a six-month contract for work to be...
-
\According to the theory of constraints, throughput is the rate at which product is passed through the manufacturing system. True False
-
Which of the following gives the range of y = 4 - 2 -x ? (A) (- , ) (B) (- , 4) (C) [- 4, ) (D) (- , 4] (E) All reals
-
You win a judgment in an auto accident for $100,000. You immediately receive $25,000 but must pay your lawyer's fee of $15,000. In addition, you will receive $2,500 a year for 20 years for a total of...
-
A firm with sales of $500,000 has average inventory of $200,000. The industry average for inventory turnover is four times a year. What would be the reduction in inventory if this firm were to...
-
You invest $1,000 in a certificate of deposit that matures after 10 years and pays 5 percent interest, which is compounded annually until the certificate matures. a. How much interest will you earn...
-
Analyzing marketing variances A manufacturing company makes three different sizes of bass boats. These boats are sold to distributors who outfit them for fishing by adding outboard motors and...
-
Direct material variances The Baba Jim Company makes a variety of furniture items. One product, a sofa, has the following material standards: Pine lumber Oak lumber Springs 20 board feet @ $ .80 per...
-
Direct labor variances Wha Joon Company makes steel shelves, steel furniture, and several other steel products primarily for use in offices and industrial organizations. Standard labor costs for the...
Study smarter with the SolutionInn App