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...
-
In the wake of the financial crisis of 2007-2009, negative connotations often surrounded the term mortgage-backed security. What arguments could you make to convince someone that they may have...
-
According to Equation 14.4, if expectations about the future exchange rate suddenly fall, all other things constant, what should happen to E? E = exp(E++1) i-+1
-
Water flows in a 10-m-wide open channel with a flowrate of \(5 \mathrm{~m}^{3} / \mathrm{s}\). Determine the two possible depths if the specific energy of the flow is \(E=0.6 \mathrm{~m}\).
-
On January 1, 2017, Tango-In-The-Night, Inc., issued $75 million of bonds with an 8% coupon interest rate. The bonds mature in 10 years and pay interest semi-annually on June 30 and on December 31 of...
-
The controller of Rather Production has collected the following monthly expense data for analyzing the cost behavior of electricity costs. Total Electricity Costs Total Machine Hours January $2,500...
-
A job shop consists of 6 different machines and 4 different jobs are to be processed through these machines. The job interarrival time follows Exp(15) mins. Each job is processed on a series of...
-
As a newly appointed manager, you are tasked with leading a team of diverse individuals. How would you ensure effective communication and collaboration within the team to achieve common goals?
-
What are the 3 subscription levels on offer for QuickBooks Online Payroll? Explain.
-
Which assumption permits businesses to record property and equipment as assets at their cost without having to be concerned about what they are worth in case of liquidation in the near future?
-
Your property has six units: Unit # 1 rents for $950 per month and has a scheduled increase in month seven to $1,050 Unit # 2 rents for $1,100 per month Unit # 3 rents for $1,200 per month Units # 4...
-
What questions come from The Coahuila y Texas Immigration Law of 1825 raise?
-
1. Provide a definition for civil rights and civil liberties. How are they alike and how are they similar? Provide an example of each in a thoughtful discussion. 2. What kinds of laws are important...
-
integrals: Using R, apply Monte Carlo integration to estimate the following 0 3 = Se-x+ dx
-
In the circuit shown in Figure 4, a battery supplies a constant voltage of 40 V, the inductance is 2 H, the resistance is 10, and l(0) = 0. (a) Find l(t). (b) Find the current after 0.1s.
-
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?
-
A copper sheet of thickness \(2 L=2 \mathrm{~mm}\) has an initial temperature of \(T_{i}=118^{\circ} \mathrm{C}\). It is suddenly quenched in liquid water, resulting in boiling at its two surfaces....
-
The heat transfer coefficient for hydrogen flowing over a sphere is to be determined by observing the temperature-time history of a sphere fabricated from pure copper. The sphere, which is \(20...
-
A power transistor mounted on a finned heat sink can be modeled as a spatially isothermal object with internal heat generation and an external convection resistance. (a) Consider such a system of...
Study smarter with the SolutionInn App