4 C D E H. 1 1 K Blooper's analysts have come up with the following revised estimates for its magnoosium mine: 1 2 Range 3 Pess 10,000 2.000 15,000 1 5 20.0% Pesseistic Optimistic 15 + 50% - 25 153 + 254 - 254 - 154 - 256 -30% - 304 G Initial investment Revenues Variable costs Fixed cost Working capital TA.Inputs Inicial ingement is thousands Salvage values thausands Iriia revenues the ins) Variable costs of revenues Initial fixed costs is thousands) Inflation rate! Discount raceM) Receivable of sales) Inaryota Tes 1841 4.cco 7 5.0% 8 12.0% 9 16.74 10 15.04. 11 21.0% 12 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.) 13 Year: 1 2 3 5 14 B. Fixed sets 15 10,CCO 16 Investments in xed assets Sales of lases Cash low from lises Project NPV 1,580 1,540 17 -10.000 Pessimistic 18 Expected Optimistis 19 C. Operating cash flow 20 Revenues 15,000 15,750 16.539 21 Variable expenses 6.300 5.515 Iritial investment Revenues Variable bases FxAd coats 17,350 5.920 4,531 22 4,410 G.000 4,000 2,000 3,000 28,233 7.293 4,852 2,000 4,078 4,200 2,000 3,250 23 2.000 2.000 24 3,513 3.7BR Working capital Fbred expenses Depreciation Prera profit Prufit were Operating cash flow 25 6.30 683 73R 705 R55 25 2,55 2,725 2.993 27 4,370 4,558 4,725 4,993 3,221 25 29 30 1,500 4.075 4.279 4,493 4.717 3039 0 D. Working capital Working capital Change in working Capital Callaw from investment in working capital 31 204 214 225 3,039 1,500 -1,500 2,575 -2,575 -1,679 1,679 32 -204 -214 -225 3,039 0.400 11.08 1.4 AMOR 0.250 L. Project Nation Total project cash flow -11,500 1,795 4.364 4.551 4.768 6,909 4,619 3G 1.cco 0.893 0.797 1.712 0.535 0.557 0.307 Discountator des Potcash How 37 1,603 3,479 3,246 3.030 3.915 2.340 11,SCO 6,113.2 38 Ne present value 39 4 C D E H. 1 1 K Blooper's analysts have come up with the following revised estimates for its magnoosium mine: 1 2 Range 3 Pess 10,000 2.000 15,000 1 5 20.0% Pesseistic Optimistic 15 + 50% - 25 153 + 254 - 254 - 154 - 256 -30% - 304 G Initial investment Revenues Variable costs Fixed cost Working capital TA.Inputs Inicial ingement is thousands Salvage values thausands Iriia revenues the ins) Variable costs of revenues Initial fixed costs is thousands) Inflation rate! Discount raceM) Receivable of sales) Inaryota Tes 1841 4.cco 7 5.0% 8 12.0% 9 16.74 10 15.04. 11 21.0% 12 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.) 13 Year: 1 2 3 5 14 B. Fixed sets 15 10,CCO 16 Investments in xed assets Sales of lases Cash low from lises Project NPV 1,580 1,540 17 -10.000 Pessimistic 18 Expected Optimistis 19 C. Operating cash flow 20 Revenues 15,000 15,750 16.539 21 Variable expenses 6.300 5.515 Iritial investment Revenues Variable bases FxAd coats 17,350 5.920 4,531 22 4,410 G.000 4,000 2,000 3,000 28,233 7.293 4,852 2,000 4,078 4,200 2,000 3,250 23 2.000 2.000 24 3,513 3.7BR Working capital Fbred expenses Depreciation Prera profit Prufit were Operating cash flow 25 6.30 683 73R 705 R55 25 2,55 2,725 2.993 27 4,370 4,558 4,725 4,993 3,221 25 29 30 1,500 4.075 4.279 4,493 4.717 3039 0 D. Working capital Working capital Change in working Capital Callaw from investment in working capital 31 204 214 225 3,039 1,500 -1,500 2,575 -2,575 -1,679 1,679 32 -204 -214 -225 3,039 0.400 11.08 1.4 AMOR 0.250 L. Project Nation Total project cash flow -11,500 1,795 4.364 4.551 4.768 6,909 4,619 3G 1.cco 0.893 0.797 1.712 0.535 0.557 0.307 Discountator des Potcash How 37 1,603 3,479 3,246 3.030 3.915 2.340 11,SCO 6,113.2 38 Ne present value 39