Question: 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
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
Step by Step Solution
There are 3 Steps involved in it
SOLUTION To conduct a sensitivity analysis and compute the NPV for each variable and range youll need to consider the provided data and perform calculations based on the given ranges Heres a stepbyste... View full answer
Get step-by-step solutions from verified subject matter experts