Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic...

Transcribed Image Text:

Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment +25% -20% Revenues -25% +15% Variable costs, percent of +20% -25% revenues Fixed costs ook +25% -45% Working capital, percent of expected value +25% -45% Ask ferences Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanyin 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. Project NPV Pessimistic Expected Optimistic Initial investment Revenues Variable costs Fixed costs Working capital Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment +25% -20% Revenues -25% +15% Variable costs, percent of +20% -25% revenues Fixed costs ook +25% -45% Working capital, percent of expected value +25% -45% Ask ferences Conduct a sensitivity analysis for each variable and range and compute the NPV for each. Use Spreadsheet 10.1 and accompanyin 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. Project NPV Pessimistic Expected Optimistic Initial investment Revenues Variable costs Fixed costs Working capital