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

Pessimistic Optimistic

Initial investment +40% -20%

Revenues -25% +25%

Variable costs, % of rev. +20% -25%

Fixed costs +20% -30%

Working capital, % of exp. value +40% -45%

Conduct a sensitivity analysis for each variable and range and compute the NOV for each. Use Spreadsheet 10.1 and accompanying data as a starting point for the analysis. Do not round intermediate calculations.

table {mso-displayed-decimal-separator:"\."; mso-displayed-thousand-separator:"\,";} tr {mso-height-source:auto;} col {mso-width-source:auto;} td {padding-top:1px; padding-right:1px; padding-left:1px; mso-ignore:padding; color:black; font-size:11.0pt; font-weight:400; font-style:normal; text-decoration:none; font-family:Calibri, sans-serif; mso-font-charset:0; text-align:general; vertical-align:bottom; border:none; white-space:nowrap; mso-rotate:0;} .xl18 {font-weight:700; border:.5pt solid windowtext;} .xl19 {border:.5pt solid windowtext;} .xl20 {text-decoration:underline; text-underline-style:single; border:.5pt solid windowtext;} .xl21 {text-align:left; border:.5pt solid windowtext;} .xl26 {font-weight:700; text-align:right; border:.5pt solid windowtext;} .xl27 {font-weight:700; text-align:center; border:.5pt solid windowtext;} .xl28 {font-weight:700; text-align:left; border:.5pt solid windowtext;} .xl31 {color:red; border:.5pt solid windowtext;}

SPREADSHEET 10.1 Financial projections for Blooper's Magnoosium mine (dollar values in millions)A. InputsInitial investment150Salvage value20Initial revenues150Variable costs (% of revenues)40.0%Initial fixed costs40Inflation rate (%)5.0%Discount rate (%)12.0%Receivables (% of sales) 16.7%Inventory (% of next year's costs)15.0%Tax rate (%)21.0%Year:0123456B. Capital InvestmentsInvestments in fixed assets150.00Sales of fixed assets15.80Cash flow investment in fixed assets-150.0015.80C. Operating cash flowRevenues 150.00157.50165.38173.64182.33 Variable expenses 60.0063.0066.1569.4672.93 Fixed expenses 40.0042.0044.1046.3148.62 Depreciation 30.0030.0030.0030.0030.00 Pretax profit 20.0022.5025.1327.8830.78 Tax 4.204.735.285.866.46 Profit after tax 15.8017.7819.8522.0324.31 Operating cash flow 45.8047.7849.8552.0354.31D. Working capitalWorking capital15.0040.7542.7944.9347.1730.390.00Change in working capital15.0025.752.042.142.25-16.79-30.39Cash flow from investment in working capital-15.00-25.75-2.04-2.14-2.2516.7930.390.4080.4080.4080.4080.250 E. Project valuationTotal project cash flow-165.0020.0545.7447.7149.7871.1046.19Discount factor1.000.89290.79720.71180.63550.56740.5066PV of cash flow-165.0017.9036.4633.9631.6440.3423.40Net present value18.70

What is the Project NPV for Pessimistic, Expected, and Optimistic for the following:

Initial investment

Revenues

Variable costs

Fixed costs

Working capital