Investment cost (today) Project life Annual labor costs savings Annual waste disposal cost savings Annual Byproduct...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Investment cost (today) Project life Annual labor costs savings Annual waste disposal cost savings Annual Byproduct sales Required rate of return Tax rate Basic Analysis (All numbers in S Mil Cash flow estimation Given Investment Annual labor costs savings Annual waste disposal cost savings Eatio Annual Byproduct sales EBITDA Less: Depreciation Additional EBIT Less: Taxes NOPAT Plus: Depreciation FCF NPV IRR Analysis Scenario Analysis Sales and NPV numbers are in S Mil Scenario Base Byproduct sales decrease by 10% Byproduct sales decrease by 30% Byproduct sales decrease by 50% Expected NPV Breakeven Breakeven byproduct sales Fosbeck's Automation Project ($400.00) $5.00 $50.00 $10.00 $80.00 $0.12 38% 0 ($400.00) Solution 1 probability Byproduct Sale! NPV 2 Year MACRS Schedule year 1 year 2 year 3 year 4 IRR 3 4 33% 45% 15% 7% 5 Solution Legend Value given in problem Formula Calculation/Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output COGS ratio growth SGA CapEx Revenuel Project Life Tax rate R&D probability of approval probability of obsolescence WACC Real Option Modification CapEx 1 CapEx 2 Jhabud Cost Year Probability of Success Revenue SGA R&D EBIT Depreciation (unconditional) Taxes Net Income OCF CapEx FCF NPV IRR 15% 50% $2.00 $2.00 $10.00 10 years 38% $0.60 10% 5% 12% Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF Year Probability of Success Revenue NPV IRR 2017 Depreciation $0.80 10 years $1.20 8 years 2018 2019 0.1 2017 2018 2020 0.95 Two-stage investment alternative can be evaluated either using Crystal Ball, or by simply calculating the NPV for two different outcomes and then finding the expected value Using Crystal Ball 2019 2021 2022 2023 0.95 0.95 0.95 T 2020 2021 2022 0.1 0.95 2024 0.95 2023 0.95 2024 0.95 2025 0.95 T 2028 2026 2027 0.95 0.95 0.95 2025 0.95 2026 2027 2028 0.95 0.95 0.95 2029 0.95 2029 0.95 Solution Legend Value given in problem. Formula Calculation Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output Evaluating two outcomes Separately If approved If fails Year Probability of Success Revenue Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF NPV IRR Year Probability of Success Revenue Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF NPV IRR Expected NPV 2017 2018 2017 2018 2019 2019 2020 2020 2021 2022 2021 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 2028 2029 2028 2029 COGS ratio growth SGA Fosbeck SGA Pharmaset Pharmaset PPE Revenue 1 Project Life Tax rate R&D Pharmaset probability of ap probability of obsolescence WACC 15% 50% $2.00 $3.50 $3.00 $10.00 10 years 38% $0.60 40% 5% 12% Year 2017 Probability of Succes Revenue Cost SGA if acquired Depreciation (unconditional) EBIT Taxes Net Income OCF FCF 2018 0.4 Value if acquired 2019 0.95 2020 0.95 2021 0.95 2022 0.95 2023 0.95 2024 0.95 2025 0.95 2026 0.95 2027 0.95 Solution Legend Value given in problem Formula/Calculation/Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output A 1 COGS ratio 2 growth 3 SGA Fosbeck 4 SGA Pharmaset 5 Pharmaset PPE 6 Revenuel 7 Project Life 8 Tax rate 9 R&D 0 Pharmaset probability of app 1 probability of obsolescence 2 WACC 3 Menlo Venture Investment 4 Valuation multiple 5 _6 7 Year 8 Revenue 9 Cost 20 SGA if acquired 21 Depreciation (unconditional) 22 EBIT 23 Taxes 24 NOPAT 25 Terminal Value 26 Pharmaset Book Value 15% 50% $2.00 $3.50 $3.00 $10.00 10 years 38% $0.60 40% 5% 12% $5.00 8 x EBIT 2017 Pharmaset If FDA Approved 2018 2019 2020 F 2021 2022 H 2023 2024 2025 Solution Legend Value given in problem Formula/Calculation/Analysis required Assumptions, Qualitative analysis or Short answer req Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output Menlo Ventures Share Dividends 1-4 Dividends 5-8 If Successful If Fails Expected NPV IRR Menlo Ventures Share Coupon Rate If Successful If Fails Expected NPV IRR Menlo Ventures Share Dividend Rate Warrants Price If Successful If Fails Expected NPV IRR 20% 0% 20% Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 All Equity Case 15% 7.5% $0.15 2019 2020 2021 2022 2023 15% 10% Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 2020 2019 Convertible Debt Redeemable Preferred 2021 Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 2019 2020 2021 2022 2022 2024 2023 2023 2024 2025 2025 2024 2025 year 1 year 2 year 3 year 4 33% 3000000 44% 3000000 15% 3000000 7% 3000000 0.4 0.4 0.4 0.4 399,960 533,400 177,720 88,920 998,684 33% 3000000 44% 3000000 15% 3000000 7% 3000000 999,900 1,333,500 444,300 222,300 Investment cost (today) Project life Annual labor costs savings Annual waste disposal cost savings Annual Byproduct sales Required rate of return Tax rate Basic Analysis (All numbers in S Mil Cash flow estimation Given Investment Annual labor costs savings Annual waste disposal cost savings Eatio Annual Byproduct sales EBITDA Less: Depreciation Additional EBIT Less: Taxes NOPAT Plus: Depreciation FCF NPV IRR Analysis Scenario Analysis Sales and NPV numbers are in S Mil Scenario Base Byproduct sales decrease by 10% Byproduct sales decrease by 30% Byproduct sales decrease by 50% Expected NPV Breakeven Breakeven byproduct sales Fosbeck's Automation Project ($400.00) $5.00 $50.00 $10.00 $80.00 $0.12 38% 0 ($400.00) Solution 1 probability Byproduct Sale! NPV 2 Year MACRS Schedule year 1 year 2 year 3 year 4 IRR 3 4 33% 45% 15% 7% 5 Solution Legend Value given in problem Formula Calculation/Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output COGS ratio growth SGA CapEx Revenuel Project Life Tax rate R&D probability of approval probability of obsolescence WACC Real Option Modification CapEx 1 CapEx 2 Jhabud Cost Year Probability of Success Revenue SGA R&D EBIT Depreciation (unconditional) Taxes Net Income OCF CapEx FCF NPV IRR 15% 50% $2.00 $2.00 $10.00 10 years 38% $0.60 10% 5% 12% Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF Year Probability of Success Revenue NPV IRR 2017 Depreciation $0.80 10 years $1.20 8 years 2018 2019 0.1 2017 2018 2020 0.95 Two-stage investment alternative can be evaluated either using Crystal Ball, or by simply calculating the NPV for two different outcomes and then finding the expected value Using Crystal Ball 2019 2021 2022 2023 0.95 0.95 0.95 T 2020 2021 2022 0.1 0.95 2024 0.95 2023 0.95 2024 0.95 2025 0.95 T 2028 2026 2027 0.95 0.95 0.95 2025 0.95 2026 2027 2028 0.95 0.95 0.95 2029 0.95 2029 0.95 Solution Legend Value given in problem. Formula Calculation Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output Evaluating two outcomes Separately If approved If fails Year Probability of Success Revenue Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF NPV IRR Year Probability of Success Revenue Cost SGA R&D Depreciation EBIT Taxes Net Income OCF CapEx FCF NPV IRR Expected NPV 2017 2018 2017 2018 2019 2019 2020 2020 2021 2022 2021 2022 2023 2023 2024 2024 2025 2025 2026 2026 2027 2027 2028 2029 2028 2029 COGS ratio growth SGA Fosbeck SGA Pharmaset Pharmaset PPE Revenue 1 Project Life Tax rate R&D Pharmaset probability of ap probability of obsolescence WACC 15% 50% $2.00 $3.50 $3.00 $10.00 10 years 38% $0.60 40% 5% 12% Year 2017 Probability of Succes Revenue Cost SGA if acquired Depreciation (unconditional) EBIT Taxes Net Income OCF FCF 2018 0.4 Value if acquired 2019 0.95 2020 0.95 2021 0.95 2022 0.95 2023 0.95 2024 0.95 2025 0.95 2026 0.95 2027 0.95 Solution Legend Value given in problem Formula/Calculation/Analysis required Assumptions, Qualitative analysis or Short answer required Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output A 1 COGS ratio 2 growth 3 SGA Fosbeck 4 SGA Pharmaset 5 Pharmaset PPE 6 Revenuel 7 Project Life 8 Tax rate 9 R&D 0 Pharmaset probability of app 1 probability of obsolescence 2 WACC 3 Menlo Venture Investment 4 Valuation multiple 5 _6 7 Year 8 Revenue 9 Cost 20 SGA if acquired 21 Depreciation (unconditional) 22 EBIT 23 Taxes 24 NOPAT 25 Terminal Value 26 Pharmaset Book Value 15% 50% $2.00 $3.50 $3.00 $10.00 10 years 38% $0.60 40% 5% 12% $5.00 8 x EBIT 2017 Pharmaset If FDA Approved 2018 2019 2020 F 2021 2022 H 2023 2024 2025 Solution Legend Value given in problem Formula/Calculation/Analysis required Assumptions, Qualitative analysis or Short answer req Goal Seek, Scenario or Data Table cell Crystal Ball Input Crystal Ball Output Menlo Ventures Share Dividends 1-4 Dividends 5-8 If Successful If Fails Expected NPV IRR Menlo Ventures Share Coupon Rate If Successful If Fails Expected NPV IRR Menlo Ventures Share Dividend Rate Warrants Price If Successful If Fails Expected NPV IRR 20% 0% 20% Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 All Equity Case 15% 7.5% $0.15 2019 2020 2021 2022 2023 15% 10% Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 2020 2019 Convertible Debt Redeemable Preferred 2021 Fosbeck Incremental Cash Flow (After-Tax) 2017 2018 2019 2020 2021 2022 2022 2024 2023 2023 2024 2025 2025 2024 2025 year 1 year 2 year 3 year 4 33% 3000000 44% 3000000 15% 3000000 7% 3000000 0.4 0.4 0.4 0.4 399,960 533,400 177,720 88,920 998,684 33% 3000000 44% 3000000 15% 3000000 7% 3000000 999,900 1,333,500 444,300 222,300
Expert Answer:
Answer rating: 100% (QA)
Ans We need to calculate NPV and IRR to make the decision This can be calculated using the spreadshe... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Argile Textiles is evaluating a new product, a silk/wool blended fabric. Assume that you were recently hired as assistant to the director of capital budgeting, and you must evaluate the proposed...
-
In Problem 10.16, we projected financial statements for Walmart Stores, Inc. (Walmart) for Years +1 through +5. The data in Exhibits 12.17-12.19 (pages 948-950) include the actual amounts for 2012...
-
Unilate Textiles is evaluating a new product, a silk/wool blended fabric. Assume you were recently hired as assistant to the director of capital budgeting, and you must evaluate the new project. The...
-
About "Hilton Honors" 1) Explain what creates value and identify if there are aspects that do not create value. (Please include the citation and references) 2)What is the strength of the Hilton Honor...
-
Why does warehousing exist in a supply chain?
-
In over seven years, the city of Amsterdam (The Netherlands) was transformed into a smart city using information technologies. This case describes the steps the city took from 2009 to 2016 to become...
-
What are the three types of employees who work in MNEs? Explain how an HCN could change to become a TCN in an MNE.
-
Media outlets such as ESPN and Fox Sports often have Web sites that provide indepth coverage of news and events. Portions of these Web sites are restricted to members who pay a monthly subscription...
-
A bond offers 2,9% coupon rate with semi-annual payments. If the face-value of this bond is $10,000, what is the value of the coupon payments? 2. Assume that a bank has a TDS requirement of 0,49. If...
-
The U.S. Department of Commerce publishes a series of census documents referred to as Current Industrial Reports. Included in these documents are the manufacturers shipments, Inventories, and orders...
-
Campbell Uses Technology to Reach Out to the Younger Generation Soup. Canned soup. It's been around for ages. What could be said about it that hasn't been said? What could be done to improve soup...
-
What types of specific socialization practices could you use so that new employees can best adapt to the organizational culture?
-
A goldsmith used a \(500 \mathrm{~g}\) bar of gold and melted it and molded into a small statue of a Roman god. Comment on the change in the inertia of the gold before and after being molded.
-
When you drop a tennis ball on the floor from a height, it will bounce back. (a) Do you expect the ball to return to the same height? (b) Is this collision elastic or inelastic? Justify your answer.
-
A 1-kg box is accidentally dropped from a third-floor window \(7.5 \mathrm{~m}\) above the ground. What is the change in its momentum as it strikes the muddy ground, coming to a complete stop?
-
Why are most of the massive meteoroids not able to hit the Earth's surface? Explain your answer in terms of energy.
-
A ladder with a mass M and length L is placed against a frictionless wall on a surface with the coefficient of static friction of . The ladder makes an angle of with the floor. A man with a mass m...
-
Prove the formula for (d/dx)(cos-1x) by the same method as for (d/dx)(sin-1x).
-
Suppose you own 100 shares of General Motors stock, and the company earned $6 per share during the last reporting period. Suppose also that GM could either pay all of its earnings out as dividends...
-
Look at Table 13-4 and answer these questions: a. Why is the net salvage value shown in Section III reduced for taxes? b. How is the change in depreciation computed? c. What would happen if the new...
-
How does the goal of value maximization relate to lean manufacturing?
-
If youd like to have $5,000,000 at retirement in 45 years and you expect to earn 10 percent annually, which is around the average return over the past 50 years, what lump sum would you have to invest...
-
Obaidullah Hamzah, who recently sold his Ford Mustang, placed $15,000 in a savings account paying annual compound interest of 7 percent. a. Calculate the amount of money that will be accrued if he...
-
How many years will the following take? a. \($550\) to grow to \($1,049.50\) if invested at 6 percent compounded annually b. \($37\) to grow to \($63.87\) if invested at 9 percent compounded annually...
Study smarter with the SolutionInn App