PRIN.OF CORPORATE FINANCE
13th Edition
ISBN: 9781260013900
Author: BREALEY
Publisher: RENT MCG
expand_more
expand_more
format_list_bulleted
Concept explainers
Question
Chapter 10, Problem 29PS
Summary Introduction
To determine: Whether the additional $20 million investment worthwhile and whether the answer will vary if the probability of success in the phase 3 trails fails to 75%.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Use Microsoft Excel to assess the internal rate of return for an IT initiative. Suppose the initial investment is
$60,000. The returns on investment in dollars for the following 5 years are (a) $10,000, (b) $12,000, (c) $15,000,
(d) $21,000, and (e) $26,000. Use the IRR function to compute the internal rate of return after 2, 4, and 5 years.
Next, assume that the loan for the initial $60,000 is at 8 percent and you are earning 16 percent on the annual
returns. Use the MIRR function to calculate the internal rate of return.
Required:
1. What is the Internal Rate of Return after 2 years?
-46%
-20%
-1%
-10%
Required:
2. What is the Internal Rate of Return after 4 years?
-46%
-20%
-1%
10%
Required:
3. What is the Internal Rate of Return after 5 years?
10%
16%
8%
20%
MCS Corporation is considering two possible investments and needs your help in
determining which will be the better financial option. Perform the necessary
calculations using Microsoft Excel so that maximum precision can be obtained.
(Unless indicated otherwise, enter your answers rounded to the nearest whole
dollar/input code: 0).
Investment Option "North"
This potential investment is a little more risky and longer term, so it has a
minimum rate of return of 17.60%. This investment would require an initial outlay
of cash to purchase a piece of equipment for $131,000, and at the end of the 8-
year life of this investment is expected to have a salvage value of $39,300. For
each year of this investment, net annual cash inflows are expected to be $29,500.
1. How much is the
present value of the
purchase of equipment?
2. How much is the
present value of the
salvage value?
3. How much is the
present value of the
annual cash inflows?
4. How much is the Net
Present Value?
5. What is the value…
You are setting up the shown ONE-WAY data table to calculate the NPV of a hotel project at various rates of return (8.25% to 12.5%). What range would you highlight before selecting: Data → What-if Analysis → Data Table…
Question 51 options:
B15:C32
C14:C32
B14:B32
B14:C32
Chapter 10 Solutions
PRIN.OF CORPORATE FINANCE
Ch. 10 - Terminology Match each of the following terms to...Ch. 10 - Project analysis True or false? a. Sensitivity...Ch. 10 - Sensitivity analysis Otobais staff (see Section...Ch. 10 - Prob. 4PSCh. 10 - Prob. 7PSCh. 10 - Scenario analysis What is the NPV of the electric...Ch. 10 - Prob. 9PSCh. 10 - Break-even analysis Break-even calculations are...Ch. 10 - Prob. 11PSCh. 10 - Prob. 12PS
Ch. 10 - Prob. 13PSCh. 10 - Break-even analysis A financial analyst has...Ch. 10 - Fixed and variable costs In a slow year, Deutsche...Ch. 10 - Operating leverage You estimate that your cattle...Ch. 10 - Prob. 17PSCh. 10 - Prob. 20PSCh. 10 - Real options Explain why options to expand or...Ch. 10 - Prob. 22PSCh. 10 - Real options True or false? a. Decision trees can...Ch. 10 - Prob. 24PSCh. 10 - Real options An auto plant that costs 100 million...Ch. 10 - Decision trees Look back at the Vegetron electric...Ch. 10 - Prob. 27PSCh. 10 - Prob. 28PSCh. 10 - Prob. 29PSCh. 10 - Prob. 32PS
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, finance and related others by exploring similar questions and additional content below.Similar questions
- Below are four cases that you will have to solve using Excel spreadsheets. 2nd case The COMPETIDORA SA company has the possibility of investing in three different projects . The projections show us the following information on which a decision must be made: PROJECT X Y Initial Z$310,000 It is requested: investment $180,000 $250,000 Year 1 cash flows $50,000 $80,000 $150,000 1. Determine the internal rate of return. 2. Determine the present value. Year 2 cash flows 3. Determine the recovery period. 4. Define which is the most viable project. $70,000 $80,000 $120,000 The discount rate for the project will be 9% and the investors propose a MARR of 22%. Year 3 cash flows $80,000 $80,000 $100,000 Year 4 cash flows $100,000 $80,000arrow_forwardThe Quantum Leap Company has set up a weighted scoring matrix for evaluation of potential projects. Below are five projects under consideration. 4. Two new software projects are proposed to a young, start-up cornpany. The Alpha project vvill cost $150.000 to develop and is expect. to have annual net cash flow of $40,000. The Beta project will cost $200,000 to develop and is expected to have annual net cash flow of S50,000. The company is ve, concerned about their cash flow. Using the payback period, which project is better from a cash flow standpoint? Why? a. Assume that the rate of inflation is 6% use the Net Present Value (NVM), aPProach to calculate PaYback Penriod for both project.. Which projeft would you now recommend? Why? b. in your estimation, which approach to calculating payback period is better? Explain your response. giving the pros and cons of each approacharrow_forwardUse Decision Trees to Evaluate Projects with Real Options - The Stewart Pharmaceuticals corporation is considering investing in developing a drug that cures MS. - The preliminary phase includes trials and will last one year and cost $1 billion. Furthermore, the group believes that there is a 60% chance that the drug passes trials. - If the initial trials are successful, Stewart Pharmaceuticals can go ahead with full-scale production. This investment phase will cost $1,600 million. Production will occur over the next 4 years, resulting in $1 Billion FCF every year. - Assume a discount rate of 10%. - Should the firm proceed with investment?arrow_forward
- Below are four cases that you will have to solve using Excel spreadsheets. 1st case The company COMERCIAL SA has two investment alternatives that present the following information: PROJECT A B It is requested Initial investment. $25,000 $22,000 Cash flows year 1 1. Determine the internal rate of return. 2. Determine the present value. $7,000 $12,000 The discount rate for the project will be 10% and the MARR will be 20%. 3. Determine the recovery period. 4. Define which is the most viable project. Year 2 cash flows $15,000 $8,000 Year 3 cash flows $18,000 $12,000arrow_forwardGroove Street Games (GSG) is developing a new free-to-play, massive multiplayer online crime simulator game and wishes to create a simulation model to estimate the expected NPV of the game. GSG faced several uncertain factors and made the following assumptions that would hopefully help them build a simulation model. • Product Life: It is equally likely that the game will stay operational for 1, 2, 4, 6, or 8 years, but there is a 10% possibility that the game will stay operational for the next 10 years. • Microtransaction Rate: GSG estimates that there is a 50% chance that at least 30% of the players would purchase at least one in-game cash item, but there is also an equal chance that the number would fall below 10%. GSG is confident that the distribution of the microtransaction rate closely resembles a bell shape. • Market Share: GSG believes its market share in year 1 would be at best 70%, most likely 35%, and at worst 10%. • Server Maintenance Cost: The annual server maintenance…arrow_forwardFill in the yellow cells using excel funtions (trying to build excel model please use excel functions) Given the following information about 4 mutually exclusive projects that are expected to be repeated infinitely, complete the table information (the shaded blanks). Assume that all projects are equally risky and will have the same cost of capital. Which project should be chosen? (20 Points) \table[[, A, B, C, D], [CF (0), ($1,600, 000), ($2, 225, 000), ($2, 460,000), ($ 1,500,000)], [Inflows (equal for life of the project), $565,000,,, $712,000], [Project Life,5,3,4,], [NPV,, $ 350,000,,], [IRR,,,, 20.00%], [MIRR, 18.50%,..], [PAYBACK (Yrs),,, 2.5,], [Terminal Value,,,,], [WACC,,,,]] 6. Given the following information about 4 mutually exclusive projects that are expected to be repeated infinitely, complete the table information (the shaded blanks). Assume that all projects are equally risky and will have the same cost of capital. Which project should be chosen? (20 Points) CF Inflows…arrow_forward
- Spencer Enterprises is attempting to choose among a series of new investment alternatives. The potential investment alternatives, the net present value of the future stream of returns, the capital requirements, and the available capital funds over the next three years are summarized as follows: Develop and solve an integer programming model for maximizing the net present value. Assume that only one of the warehouse expansion projects can be implemented. Modify your model from part (a). Suppose that if test marketing of the new product is carried out, the advertising campaign also must be conducted. Modify your formulation from part (b) to reflect this new situation.arrow_forwardYou are the head of the project selection team at SIMSOX. Your team is considering three different projects. Based on past history. SIMSOX expects at least a rate of return of 23 percent. Given the following information for each project, which one should be SIMSOX's first priority? Should SIMSOX fund any of the other projects? (Use the NPV function in Excel to solve this problem. Negative amount should be indicated by a minus sign.) Project: Dust Devils Year Investment Revenue Stream 550, 000 1 35,000 275,000 375,000 2 Project: Ospry Year Investment Revenue Stream 300,000 1 30,000 2 30,000 30,000 75,000 Project: Voyagers Year Investment Revenue Stream 85,000 1 25,000 25,000 60,000 2 3 4 55,000 145,000 The NPV for Dust Devils is The NPV for Ospry is The NPV for Voyagers is How many projects should be funded? undefinedarrow_forwardThe data has been collected in the Microsoft Excel file below. Download the spreadsheet and perform the required analysis to answer the questions below. Do not round intermediate calculations. Enter your answers as positive values. Download spreadsheet Time value of money-e826d2.xlsx a. Find the FV of $1,000 invested to earn 12% after 6 years. Round your answer to the nearest cent. $. b. What is the investment's FV at rates of 0%, 6%, and 20% after 0, 1, 2, 3, 4, and 5 years? Round your answers to the nearest cent. Interest Rate Year 0% 6% 20% $ 2$ 1 $ 24 $ 2 $ $ 2$ $4 $ $ 4 $ 2$ $ $ Choose the correct graph of future value as a function of time and rate. Note: blue line is for 0%, orange line is for 6%, and grey line is for 20%. The correct graph is A 7000 FV as Function of Time and Ratearrow_forward
- Perform a financial analysis for an IT Project which requires an initial investment of $32,000, but it is expected to generate revenues of $10,000, $20,000 and $15,000 for the first, second and third years respectively. The target rate of return is 12%. Write the formula and calculate the Net Present Value (NPV). In addition, Justify your result. (For this question Write the answer on the paper and take photo and upload OR Type in the MS Word document and upload the file)arrow_forwardCCM is currently comparing 4 DDC machines (DDC1, DDC2, DDC3, and DDC4) and they plan to procure one of them. CCM's MARR is 15% and the expected useful life of the DCC machine is six years. Use incremental cash flow analysis to determine the economically optimal option. Solve this problem in Excel (IRR), copy/paste a screenshot of your Excel model below and provide an explanation.arrow_forwardYour software development company is considering investing in a new mobile app. If it goes viral (10% probability), you expect an NPV of $1,000,000; if it is moderately successful (20% probability), you expect an NPV of $200,000; and if it fails (70% probability), you expect an NPV of $-200,000. What is the expected NPV of the product? Group of answer choices -$100,000. $40,000. $280,000. $333,000. None of the above.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Essentials of Business Analytics (MindTap Course ...StatisticsISBN:9781305627734Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. AndersonPublisher:Cengage LearningEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Essentials of Business Analytics (MindTap Course ...
Statistics
ISBN:9781305627734
Author:Jeffrey D. Camm, James J. Cochran, Michael J. Fry, Jeffrey W. Ohlmann, David R. Anderson
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Financial Risks - Part 1; Author: KnowledgEquity - Support for CPA;https://www.youtube.com/watch?v=mFjSYlBS-VE;License: Standard youtube license