Blooper's analysts have come up with the following revised estimates for its magnoosium mine: Conduct a sensitivity
Fantastic news! We've Found the answer you've been seeking!
Question:
Blooper's analysts have come up with the following revised estimates for its magnoosium mine:
Transcribed Image Text:
1 2 A. Inputs 8069 SA EN 3 Initial investment Salvage value Initial revenues Variable costs (% of revenues) Initial fixed costs Inflation rate (%) 9 Discount rate (%) 10 Receivables (% of sales) 4 5 A B C D E F G SPREADSHEET 10.1 Financial projections for Blooper's Magnoosium mine (dollar values in millions) 7 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 30 D. Working capital 31 Working capital 32 Change in working capital 33 Cash flow from investment in working cap 34 35 E. Project valuation 36 Total project cash flow 37 Discount factor 38 PV of cash flow 39 Net present value Year: 150 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 20.05 45.74 0.8929 0.7972 17.90 36.46 3 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 44.93 2.14 -2.14 0.408 4 47.71 0.7118 33.96 47.17 2.25 -2.25 0.408 49.78 0.6355 31.64 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 71.10 0.5674 40.34 H 6 15.80 15.80 0.00 -30.39 30.39 46.19 0.5066 23.40 1 2 A. Inputs 8069 SA EN 3 Initial investment Salvage value Initial revenues Variable costs (% of revenues) Initial fixed costs Inflation rate (%) 9 Discount rate (%) 10 Receivables (% of sales) 4 5 A B C D E F G SPREADSHEET 10.1 Financial projections for Blooper's Magnoosium mine (dollar values in millions) 7 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 30 D. Working capital 31 Working capital 32 Change in working capital 33 Cash flow from investment in working cap 34 35 E. Project valuation 36 Total project cash flow 37 Discount factor 38 PV of cash flow 39 Net present value Year: 150 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 20.05 45.74 0.8929 0.7972 17.90 36.46 3 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 44.93 2.14 -2.14 0.408 4 47.71 0.7118 33.96 47.17 2.25 -2.25 0.408 49.78 0.6355 31.64 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 71.10 0.5674 40.34 H 6 15.80 15.80 0.00 -30.39 30.39 46.19 0.5066 23.40
Expert 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
-
Evaluate different operating systems explaining their role in managing resources. -Operating systems: the role of an operating system, OS types
-
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 % ...
-
Timco is considering the construction of a new retail outlet. The construction cost will be 400000. Net working capital will increase by 10000. The depreciation is 10 year MACRS. The new location...
-
Elaborate the conclusions, draw about market research and the level of analysis and planning employed Barb and Pat.
-
Jenn Bard, who lives in the San Francisco Bay area, commutes by car from home to work. She knows that it takes her an average of 28 minutes for this commute in the morning. However, due to the...
-
A \(50-\mathrm{kg}\) pneumatic hammer is fitted with a shock absorber at the top to lessen the impact on the worker. The vertical displacement of the hammer as a function of time is given by \(x(t)=a...
-
Using the STUDENT table structure shown in Table P6.4, do the following: a. Write the relational schema, draw its dependency diagram, and identify all dependencies, including all transitive...
-
What financial statements (and periods covered) are required to be included in Form 10-Q? Are these financial statements required to be audited by the company's independent public accountants? What...
-
Indexes are cost-free mechanisms that dramatically improve the performance of a database.?Explain briefly
-
What type of deduction is HSA contribution? What is Deduction Itemized and Deduction Standard?
-
You work for the CEO of a new company that plans to manufacture and sell a new product, a watch that has an embedded TV set and a magnifying glass crystal. The issue now is how to finance the...
-
Caleb created a column chart that lists numbers from $50,000 to $0 on the left. What can he add to the chart to indicate that these are monthly revenue amounts?
-
Explain the CONCEPT OF ROUTINE ACTIVITY THEORY INRELATION TO CRIME
-
Read about the SDWA cost-benefit analysis conducted by EPA by clicking on the link. What did you learn? Be specific in your answer. You answer should be about two hundred words. Read about the...
-
Internet data sessions are randomly started on a mobile node. Let S1, S2,, Sn be the arrival/starting times of the data sessions o on the mobile node. The starting times of the sessions are sorted in...
-
6. (Potential Energy and Conservation of Energy) What should be the spring constant k of a spring designed to bring a 1200-kg car to rest from a speed of 95 km/h so that the occupants undergo a...
-
A firm has an asset turnover ratio of 2.0. Its plowback ratio is 50%, and it is all-equity-financed. If the profit margin of the firm is 6%, what is the maximum possible growth rate that can be...
-
a. Use the Black-Scholes formula to find the value of a call option on the following stock. (You can find the spreadsheet in this chapter as well as in Connect.) i. Time to expiration 1 year ii....
-
The current exchange rate is USD2 = GBP1. ClickEasy is a large British firm that exports computer games to the United States. If the dollar depreciates relative to the pound, ClickEasy will increase...
-
For a sample of data where n = 7 given below: a. Calculate the mean, median, and mode. b. Calculate the range, variance, standard deviation, and coefficient of variation. c. Calculate the Z score....
-
For a sample of data where n = 6 given below: a. Calculate the mean, median, and mode. b. Calculate the range, variance, standard deviation, and coefficient of variation. c. Calculate the Z scores....
-
Classic LEGO plastic bricks have been fixtures in homes around the world for more than 70 years. Just 15 years ago, The LEGO Group (TLG) was near bankruptcy, spiraling downward and losing money at a...
Study smarter with the SolutionInn App