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...
-
What three factors determine whether two economies with separate fiscal and monetary authorities should form a currency union? Give an illustration of each factor using NAFTA economies.
-
When Universal City Studios, Inc., and Amblin Entertainment, Inc., were producing the movie How to Make an American Quilt, they contracted with Barbara Brown, a well-known professional quilter. Brown...
-
John Aristote LP is an audit frm based in Dublin (Ohio). In 2017, the frm was hired to compile the fnancial statements of Reggie Inc., a nonpublic entity based within the same state. Reggie Inc....
-
From historical data, Harry's Car Wash estimates that dirty cars arrive at the rate of 10 per hour all day Saturday. With a crew working the wash line, Harry figures that cars can be cleaned at the...
-
I don't know where to start on this problem. What formulas do I use and how can I show my answer? Mattel is a U.S. based company whose sales are roughly two-thirds in dollars (Asia and the Americas)...
-
At your daughter's 6th birthday party she tells you that she wants to go to Princeton. It will cost you $30,000 per year for her to attend this four year program. You start putting money into an...
-
compute for the ending capital of DEF. ABC and DEF formed a partnership for the year 2021 and agreed to share profits and losses in a ratio of 2:3, respectively. The following are the agreement of...
-
Ronaldo Associates is a construction engineering firm that prepares detailed con- struction drawings for single family homes. The market for this service is very competitive. To compete successfully...
-
[33 A-2-1 x 050 a) Given that 4-60. Find the value of x by expanding along the second row. b) By using the answer in a). compute A by using the formula A' = adj(4)
-
Define the terms cognition and cognitive psychology. Suggest several ways that the information from cognitive psychology could be beneficial in your ideal career.?
-
What are the values of a, b, and c after the following code statements? int a = 1; int b = 10; int c = b; a=a+1; b=b-1; c=c+a;
-
The module resources included examples of healthcare providers adopting innovative strategies to increase access to care. Innovations include expanded service through expedited Medicaid funding,...
-
The Lo Tech Co. just issued a dividend of $2.90 per share on its common stock. The company is expected to maintain a constant 9 percent growth rate in its dividends indefinitely. Required: If the...
-
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?
-
\(\frac{3}{14}+\frac{8}{21}\) Perform the indicated operations. Reduce to lowest terms.
-
\(\frac{13}{24}-\frac{4}{117}\) Perform the indicated operations. Reduce to lowest terms.
-
\(\frac{14}{27} \div \frac{7}{12}\) Perform the indicated operations. Reduce to lowest terms.
Study smarter with the SolutionInn App