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