A Inputs Inicial investment ($thousands) Salvage value ($ thousands) Initial revenues ($thousands) Variable costs of revenues) Initial fined costs ($thousands) Inflation rate() Discount rate 1% Peceivables (% of sales) Inventory of next year's costs) Tantate 1) 15,000 2.000 15.000 40.0% 4000 5.0% 12.06 16.7% 15.0% 21.0%. Year: 0 15,000 B Fixed assets Investments in fixed assets Sales of fined assets Cash flow from fired assets 1,580 -15,000 1580 C. Operating cash flow Revenues Variable expenses Fored expenses Depreciation Pretan profit 15.000 6.000 4.000 3000 2000 420 1580 4,580 5.750 6.300 4.200 3,000 2.250 473 1,778 4,778 16.538 6.615 4.410 3000 2.513 528 1985 4.985 17.364 6.946 4.631 3.000 2.788 586 2.203 5,203 18.233 7293 4.862 3.000 3.078 646 .431 5,431 Tan 2 Profit alter tan Operating cash flow D. Vorking capital Working capital Change in working capital Cash flow from investment in working capi 1500 1.500 1500 4,493 214 4,075 2575 2575 0.408 4,279 204 204 0.409 4.717 225 225 0.409 3.039 16793039 1679 3,039 0250 0.409 E. Project valuation Total project cash flow Discount factor PV of cash Hov Net present value - 16,500 1.000 -16,500 1870.1 2005 0.893 1790 4,574 0.797 3,646 4.771 0.712 3,396 4,978 0.636 3,164 7.110 0.567 4,034 4,619 0.507 2,340 Sheet1 Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs Fixed cost Working capital Range Pessimistic Optimistic + 40% - 15% - 15% + 20% - 20% + 40% - 20% 45% - 25% + 25% + 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.) Project NPV Expected Pessimistic Optimistic Initial investment Revenues Variable costs Fixed costs Working capital A Inputs Inicial investment ($thousands) Salvage value ($ thousands) Initial revenues ($thousands) Variable costs of revenues) Initial fined costs ($thousands) Inflation rate() Discount rate 1% Peceivables (% of sales) Inventory of next year's costs) Tantate 1) 15,000 2.000 15.000 40.0% 4000 5.0% 12.06 16.7% 15.0% 21.0%. Year: 0 15,000 B Fixed assets Investments in fixed assets Sales of fined assets Cash flow from fired assets 1,580 -15,000 1580 C. Operating cash flow Revenues Variable expenses Fored expenses Depreciation Pretan profit 15.000 6.000 4.000 3000 2000 420 1580 4,580 5.750 6.300 4.200 3,000 2.250 473 1,778 4,778 16.538 6.615 4.410 3000 2.513 528 1985 4.985 17.364 6.946 4.631 3.000 2.788 586 2.203 5,203 18.233 7293 4.862 3.000 3.078 646 .431 5,431 Tan 2 Profit alter tan Operating cash flow D. Vorking capital Working capital Change in working capital Cash flow from investment in working capi 1500 1.500 1500 4,493 214 4,075 2575 2575 0.408 4,279 204 204 0.409 4.717 225 225 0.409 3.039 16793039 1679 3,039 0250 0.409 E. Project valuation Total project cash flow Discount factor PV of cash Hov Net present value - 16,500 1.000 -16,500 1870.1 2005 0.893 1790 4,574 0.797 3,646 4.771 0.712 3,396 4,978 0.636 3,164 7.110 0.567 4,034 4,619 0.507 2,340 Sheet1 Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment Revenues Variable costs Fixed cost Working capital Range Pessimistic Optimistic + 40% - 15% - 15% + 20% - 20% + 40% - 20% 45% - 25% + 25% + 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.) Project NPV Expected Pessimistic Optimistic Initial investment Revenues Variable costs Fixed costs Working capital