Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs, percent of revenues Fixed costs Working capital, percent of expected value Initial investment Revenues Variable costs Fixed costs Working capital Pessimistic +30% 20% +25% +20% +35% Pessimistic Range Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. Note: Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answer in millions rounded to 2 decimal places. Optimistic 15% +20% 25% 20% 30% Project NPV Expected Optimistic 4 Salvage value 5 Initial revenues 6 Variable costs (% of revenues) 7 Initial fixed costs 8 Inflation rate (%) 9 Discount rate (%) 10 Receivables (% of sales) 11 Inventory (% of next year's costs) 12 Tax rate (%) 13 14 15 B. Capital Investments 16 Investments in fixed assets 17 Sales of fixed assets 18 Cash flow investment in fixed assets 19 20 C. Operating cash flow 21 Revenues 22 Variable expenses 23 Fixed expenses 24 Depreciation 25 Pretax profit 26 Tax 27 Profit after tax 28 Operating cash flow 29 Year: 30 D. Working capital 31 Working capital 32 Change in working capital 33 Cash flow from investment in working 34 35 E. Project valuation 36 Total project cash flow 37 Discount factor 38 PV of cash flow 39 Net present value 40 B 20 150 40.0% 40 5.0% 12.0% 16.7% 15.0% 21.0% 0 150.00 150.00 15.00 15.00 15.00 165.00 1.00 165.00 18.70 с 1 2 150.00 157.50 60.00 63.00 40.00 42.00 30.00 30.00 20.00 22.50 4.20 4.73 15.80 17.78 45.80 47.78 40.75 25.75 25.75 0.408 42.79 2.04 2.04 0.408 45.74 20.05 0.8929 0.7972 17.90 36.46 E 3 F 44.93 2.14 2.14 0.408 4 165.38 173.64 66.15 69.46 44.10 46.31 30.00 30.00 25.13 27.88 5.28 5.86 19.85 22.03 49.85 52.03 47.17 2.25 2.25 0.408 G 5 182.33 72.93 48.62 30.00 30.78 6.46 24.31 54.31 30.39 16.79 16.79 0.250 47.71 49.78 71.10 0.7118 0.6355 0.5674 33.96 31.64 40.34 H 6 15.80 15.80 0.00 30.39 30.39 46.19 0.5066 23.40
Expert Answer:
Answer rating: 100% (QA)
SOLUTION To conduct a sensitivity analysis and compute the NPV for each variable and range you ll need to consider the provided data and perform calculations based on the given ranges Here s a step by ... View the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 9781259722615
9th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus
Posted Date:
Students also viewed these finance questions

Bloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 30 % 25 % Revenues 25 % + 20 % Variable costs + 25 % ...

Blooper's analysts have come up with the following revised estimates for its magnoosium mine Conduct a sensitivity analysis using the revised data. Label your answers as follows: Range Initial...

How does a project manager calculate start and finish times?

What are the advantages and disadvantages of the computerassisted audit technique known as parallel simulation?

Explain carefully why greater inequality in wealth distribution tends to shift the supply curve of labor to the right and the demand curve to the left when there are imperfect capital markets. In the...

Although this chapter has introduced Verilog processes to describe sequential circuits, combinational circuits can also be described using processes. Write a Verilog description for the multiplexer...

Determine the diffusivity of H2S in water, using the penetration theory, from the following data for the absorption of H2S into a laminar jet of water at 20?C. Jet diameter = 1 cm, Jet length = 7 cm,...

The shaft made from steel (shear modulusG =80 MPa). First and second parts  circle (d =36 mm), third rectangular ( b = 36 mm, h =54 mm), fourth and fifth  annular (di = 30,0 mm, de =40 mm). Shaft...

Create a program that will scrape the sayings from: https://quotes.toscrape.com/page/2/ Set up your program to allow the user to input a page number (110) which will return the quotes from that...

Don makes a one time investment. He purchases a 30 year bond with semiannual coupons and face value $800, and with a semiannual coupon rate r^(2) and a semiannual yield rate i^(2) = 6%. Immediately...

You should see some sharp upsidedown spikes in the total energy E(t). Explain where all the energy went to, when at the spike the total energy E is momentarily zero.

An IV warmer heats 125 mL/h of IV fluid from room conditions (20 C and 1 atm) to body temperature (37 C). Assume that the fluid properties are similar to those of water. a) Determine the required...

e } Compute the code and write the output only in the box below. #include int main() { int i, j; for (i = 1; i 0; 1) for (j = 0; j < 1; ++j) { } printf("%d", j); printf(" ");

1. What is Ecell for a redox reaction that has AG = 45 kJ mol at 25C ? Assume 6 electrons are transferred in the balanced redox reaction. If needed, F = 96485 C/mol. 2. What is the equilibrium...

Freshwater eels make notorious aquatic pets and are quite a challenge to keep in aquariums. This is primarily because they are more active and require a higher concentration of dissolved oxygen to...

a. Explain (in words, without using diagram) what would happen to the equilibrium consumption of two goods X and Y if i) income doubled and all prices tripled, ii)all prices doubled and income...

Research an article from an online source, such as The Economist, Wall Street Journal, Journal of Economic Perspectives, American Journal of Agricultural Economics, or another academic journal. The...

In 2017, Cumnor Towers had sales of $618 million and cost of goods sold of $522 million. Its average inventory was $50 million. a. What was Cumnor's average inventory period? b. How much would the...

In February 2009, the Dow Jones Industrial Average was at a level of about 8,000. In January 2016, it was about 17,150. Would you expect the Dow in 2016 to be more or less likely to move up or down...

Suppose that Paymore's cash balance (from Problem 7) at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Work out the shortterm financing requirements for the...

Describe the geometry of the electron groups and name the molecular shape resulting from that geometry. Also, draw the molecule, and label the size of all bond angles in your drawing. NH 4 + (cation).

We left three possible situations out of Table 6.2: 1. Four electron groups (SN = 4): one bonding group and three lone pairs. 2. Three electron groups (SN = 3): one bonding group and two lone pairs....

Describe the geometry of the electron groups and name the molecular shape resulting from that geometry. Also, draw the molecule, and label the size of all bond angles in your drawing. C 2 Cl 2 ,...