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:
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64f1e943f11a9_49164f1e943edf47.jpg)
![image](https://dsd5zvtm8ll6.cloudfront.net/si.experts.images/questions/2023/09/64f1e94424ce1_49264f1e944216dd.jpg)
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...
-
In a survey of children 5 to 17 years old, 1,050 children were randomly selected from the nine states in the Northeast, and the proportion who spoke a language other than English in their home was...
-
George is camped deep in the jungle, and he wants to make his way back to the coast and civilization. Each of the paths he can take through the jungle has obstacles that can delay him, including...
-
Design your own bad sample. Your college wants to gather student opinion about parking for students on campus. It isnt practical to contact all students. (a) Give an example of a way to choose a...
-
The Perpetual Life Insurance Co. is trying to sell you an investment policy that will pay you and your heirs $ 15,000 per year forever. If the required return on this investment is 5.2 percent, how...
-
Your division is considering 2 investment projects, each which requires an upfront expenditure of $25 million. You estimate the cost of capital is 10% and that the investments will produce the...
-
Richard McCarthy (born 2/14/64; Social Security number 100-10-9090) and Christine McCarthy (born 6/1/1966; Social security number 101-21- 3434) have a 19-year-old son (born 10/2/99 Social Security...
-
ASSUME that in 25 years you will need $500,000 for your retirement (i.e. retirement is actually 25 years away, and you want to have saved $500,000). If you will make equal MONTHLY payments at the end...
-
Do you think digital wallets will revolutionize electronic banking and in-store transactions? 2. How do you think digital wallets will affect traditional banks? 3. What are some of the risks of...
-
5.14 Strains are measured on the surface of a brass alloy part as follows: Ex 160010-6 y=1300106, and Yxy = 1500106. Estimate the in-plane stresses x, y, and Txy, and also the strain normal to the...
-
E) prepare preclosing trial balances at december 31,2026. for the debt service fund, considering only the proceeds, expenditures, and transfers resulting from transactions of the capital projects...
-
Explain at least 8 types of Google ads brieflyAnalyze the ad & share your opinion on its performance and suggest changes if required. * add the snapshots, and pictures of examples
-
Categorize each variable as quantitative or qualitative GPA is continuous Number of students is Discrete GPA ( Continuous) and Number of Students ( Discrete) GPA ( Discrete) and the Number of...
-
During the year, the Senbert Discount Tire Company had gross sales of $ 5 5 0 , 9 0 0 . The company's cost of goods sold and selling expenses were $ 1 8 5 , 6 0 0 and $ 1 0 8 , 2 0 0 , respectively....
-
The manager of a local convenience store is expanding his line of small toy items. To price these new items, the manager is looking at the prices being charged by competing retailers in his area. For...
-
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...
-
40. The City of Pfeiffer starts the year of 2008 with the General Fund and an enterprise fund. The General Fund has two activities: education and parks/recreation. For convenience, assume that the...
-
41. Use the information in problem 40 to prepare the 2008 fund-based financial statements for the gov ernmental funds and the proprietary funds. A statement of cash flows is not required. Assume that...
-
37. The County of Maxnell decides to create a sanitation department and offer its services to the pub lic for a fee. As a result, county officials plan to account for this activity within the...
![Mobile App Logo](https://dsd5zvtm8ll6.cloudfront.net/includes/images/mobile/finalLogo.png)
Study smarter with the SolutionInn App