Bloopers 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	+	20	%			25	%
Fixed cost	+	25	%			45	%
Working capital	+	25	%			45	%

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. (Do not round intermediate calculations. Negative amounts should be indicated by a minus sign. Enter your answers in thousands rounded to the nearest whole dollar.)

Initial Investments Pessimistic Expected Optimistic

Revenues

Variable Costs

Fixed Costs

Working Capital

Spreadsheet:

A. Inputs
Initial investment ($ thousands)	10,000
Salvage value ($ thousands)	2,000
Initial revenues ($ thousands)	15,000
Variable costs (% of revenues)	40.0%
Initial fixed costs ($ thousands)	4,000
Initial total expenses ($ thousands)	10,000
Inflation rate (%)	5.0%
Discount rate (%)	12.0%
Receivables (% of sales)	16.7%
Inventory (% of next year's costs)	15.0%
Tax rate (%)	35.0%