Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Initial investment...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
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 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
Expert Answer:
Answer rating: 100% (QA)
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 the full answer
Related Book For
Fundamentals of Corporate Finance
ISBN: 978-1259722615
9th edition
Authors: Richard Brealey, Stewart Myers, Alan Marcus
Posted Date:
Students also viewed these finance questions
-
1- Why tourists might not be interested in buying package holidays and how big companies can change their strategies to attract these tourists? Use examples. 2- What type of holidays do you think...
-
Bloopers analysts have come up with the following revised estimates for its magnoosium mine: Range Pessimistic Optimistic Initial investment + 30 % 25 % Revenues 25 % + 20 % Variable costs + 25 % ...
-
Blooper's analysts have come up with the following revised estimates for its magnoosium mine Conduct a sensitivity analysis using the revised data. Label your answers as follows: Range Initial...
-
The strike price of a compensation option is generally set on the day the option is issued. On November 10, 2000, the CEO of Analog Devices, Jerald Fishman, received 600,000 options. The stock price...
-
Explain why M&M Proposition I in a world of no taxes and no bankruptcy states that the firm's value does not depend on its capital structure.
-
True or False It is not usually necessary to validate the users menu selection.
-
The main assertions in the financial statements relating to inventory, for which audit procedures should be designed and performed are: (a) Existence (b) Ownership (c) Completeness (d) Valuation
-
In Kagan Company, materials are entered at the beginning of each process. Work in process inventories, with the percentage of work done on conversion costs, and production data for its Sterilizing...
-
I am trying to produce the data tables on the bottom right using What-if analysis data table and keep getting the same number run down through the graph. How do I correct this?. 162 X fx...
-
Create a query in Design view, using the Cap1 Inventory table to answer the question For the supplier ID of SUPP-06, for each item name and retail price, what is the markup for each item if marked up...
-
The Congress will discuss the role of bees and beekeeping in sustainable development, and the challenges and opportunities that beekeepers face in a changing world. Around 400 words
-
Find a regular expression to describe each of the following languages. {aa, ab, ac}. {a, aaa, aaaaa, ..., a2n+1, ".. .}. {A, a, b, c, aa, bb, cc, . . ., a", b", c", . . .}. {ak|kN} {bk+1|kN}.
-
What are chromosomes that are homologous?
-
As a senior manager of your information technology group, discuss how you would demonstrate, by example, the importance of security and then propose a method for creating a security aware culture....
-
(26p) Dependency: Using your own words and explanation, answer the following: (3p) Where can we find parallelism in programming? (6p) What is dependency and what are its types (provide one example...
-
What is the definition of meiosis?
-
What type of analysis is a useful way to analyze alternative methods of capital financing? What type of analysis is a useful way to analyze alternative methods of capital financing? Net future value...
-
l ask this second time correnct answer is 38,01 can we look pls Consider a non-conducting rod of length 8.8 m having a uniform charge density 4.5 nC/m. Find the electric potential at P, a...
-
In 2017, Cumnor Towers had sales of $618 million and cost of goods sold of $522 million. Its average inventory was $50 million. a. What was Cumnor's average inventory period? b. How much would the...
-
In February 2009, the Dow Jones Industrial Average was at a level of about 8,000. In January 2016, it was about 17,150. Would you expect the Dow in 2016 to be more or less likely to move up or down...
-
Suppose that Paymore's cash balance (from Problem 7) at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Work out the short-term financing requirements for the...
-
The following information is taken from the accounting records of Donald Company: Average receivables \(\$ 700,000\) Cost of goods sold \(.2,900,000\) Sales \(8,000,000\) Average inventory...
-
How does a forensic accountant analyze inventories and receivables?
-
What is horizontal analysis?
Study smarter with the SolutionInn App