Now go to the 'PQR with MC simulation' tab. In it you will find a fully...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Now go to the 'PQR with MC simulation' tab. In it you will find a fully functioning MC simulation model for PQR Corp. (NOTE: If you open this workbook without first opening @RISK you'll see a lot of #NAME errers.) You also will find 3 histograms in this worksheet-one for the total additional funds needed over the next 5 years, one for EBITDA in 2020, and one for PQR's total intrinsic (DCF) value. (I encourage you to take the model to the biz school's computer lab and run it.) Use either my or your histograms to answer questions 2-4. b) PQR has a bank line of credit for $400 million. The bank will not expand this line, nor can PQR borrow from anyone else on reasonable terms. What is the likelihood PQR will need more funds before 2022? c) What is PQR's cash-flow-at-risk in 2020 at the 95th percentile (the left 5% tail)? d) What is PQR's value-at-risk at the 95% level (left 5% tail)? e) In what year(s) is PQR likely to exceed its credit limit? Now go to the 'PQR with MC simulation' tab. In it you will find a fully functioning MC simulation model for PQR Corp. (NOTE: If you open this workbook without first opening @RISK you'll see a lot of #NAME errers.) You also will find 3 histograms in this worksheet-one for the total additional funds needed over the next 5 years, one for EBITDA in 2020, and one for PQR's total intrinsic (DCF) value. (I encourage you to take the model to the biz school's computer lab and run it.) Use either my or your histograms to answer questions 2-4. b) PQR has a bank line of credit for $400 million. The bank will not expand this line, nor can PQR borrow from anyone else on reasonable terms. What is the likelihood PQR will need more funds before 2022? c) What is PQR's cash-flow-at-risk in 2020 at the 95th percentile (the left 5% tail)? d) What is PQR's value-at-risk at the 95% level (left 5% tail)? e) In what year(s) is PQR likely to exceed its credit limit?
Expert Answer:
Answer rating: 100% (QA)
b To determine the likelihood PQR will need more funds before 2022 you would typically look at the h... View the full answer
Related Book For
Essentials of Investments
ISBN: 978-0078034695
9th edition
Authors: Zvi Bodie, Alex Kane, Alan Marcus
Posted Date:
Students also viewed these finance questions
-
A system consists of two subsystems connected in series, as shown in the following schematic illustration. Each subsystem consists of two components connected in parallel. The AB subsystem fails when...
-
Planning is one of the most important management functions in any business. A front office managers first step in planning should involve determine the departments goals. Planning also includes...
-
Why does allocating an array of length \(n\) take time proportional to \(n\) ?
-
Evangelista Torricelli (1608-1647) was the first to put forward the idea that we live at the bottom of an ocean of air. (a) Given the value of atmospheric pressure at the surface of the Earth, and...
-
Consider the following data: From the information given, fill in the blanks below. The flexible-budget variance is $ Fixed $ Variable $ The fixed overhead volume variance is $ The total...
-
As is indicated in Fig. P4.42, the speed of exhaust in a car's exhaust pipe varies in time and distance because of the periodic nature of the engine's operation and the damping effect with distance...
-
Brazil Group purchases a vehicle at a cost of $50,000 on January 2, 2012.Individual components of the vehicle and useful lives are as follows. Instructions(a) Compute depreciation expense for 2012,...
-
Evil One drops Joe out a plane flying horizontally. After 2 seconds of thought, he throws a rock vertically down to scare Joe (even more). If the rock is moving 10 m/s faster than Joe when it passes...
-
An operations manager has narrowed down the search for a new king kola plan to three locations. Fixed and variable costs follow: A - Fixed Cost $100,000 and variable cost $10 B - Fixed Cost $150,000...
-
You can paint a certain room in 7 hours. Your brother can do it in 4 hours. How many hours does it take the two of you working together to paint the room?
-
Calculate the monthly payment for a mortgage of $180,000 with rate of 4% over a period of 15 years. Round to the nearest dollar.
-
Percent survival of 200 seeds of SPECIES X planted in ten sets of experimental pots under different combinations of temperature and simulated rainfall. NOTE: all pots were of the same size. LOW = 10...
-
Stressless, Inc. is authorized to issue 5%, 10-year bonds payable. On January 1, 2024, when the market interest rate is 12%,the company issues $500,000 of the bonds. The bonds pay interest...
-
There is some economic research that suggests that oil prices play a central role in causing recessions in developed countries. In particular, this research suggests that it is specifically increases...
-
How we measure risk is related to our perspective. The president of the company would look at the correlation between projects which is measured by the correlation coefficient. The well-diversified...
-
Problem 3.5 (4 points). We will prove, in steps, that rank (L) = rank(LT) for any LE Rnxm (a) Prove that rank (L) = rank (LTL). (Hint: use Problem 3.4.) (b) Use part (a) to deduce that that rank(L) =...
-
The following bond swaps could have been made in recent years as investors attempted to increase the total return on their portfolio. From the information presented below, identify possible reason(s)...
-
Download the annual returns on the combined NYSE/NASDAQ/AMEX markets as well as the S&P 500 from the Online Learning Center at www.mhhe.com/bkm. For both indexes, calculate: a. Average return. b....
-
What are some differences between hedge funds and mutual funds?
-
In developing a capital budgeting portfolio, there are times when a project with a lower return is squeezed in to the budget but a higher-return project is excluded. How can this be fair? Wouldn't...
-
If bond money tends to be the least expensive cost of capital, why do we bother with the WACC in project analysis? It seems like the cost of equity is hard to estimate, and maybe we are just guessing...
-
In capital budgeting, a distinction has been made regarding the process of "assessment" as being distinctively different than "evaluation." What is the difference and why is it important?
Study smarter with the SolutionInn App