MyFinanceLab With eText - Access (Custom Package)
15th Edition
ISBN: 9781269945684
Author: Pearson
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Videos
Textbook Question
Chapter 10, Problem 1SE
Spreadsheet Exercise
The Drillago Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future
| Year | Cash inflows |
| 1 | $ 600,000 |
| 2 | 1,000,000 |
| 3 | 1,000,000 |
| 4 | 2,000,000 |
| 5 | 3,000,000 |
| 6 | 3,500,000 |
| 7 | 4,000,000 |
| 8 | 6,000,000 |
| 9 | 8,000,000 |
| 10 | 12,000,000 |
The firm’s current cost of cap1tal 1s 13%.
To Do
Create a spreadsheet to answer the following questions.
- a. Calculate the project’s
net present value (NPV). Is the project acceptable under the NPV technique? Explain. - b. Calculate the project's
internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain. - c. In this case, did the two methods produce the same results? Generally, is there a preference between the NPV and IRR techniques? Explain.
- d. Calculate the payback period for the project. If the firm usually accepts projects that have payback periods between 1 and 7 years, is this project acceptable?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
AXON Mobile Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $150 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table:
Year Cash inflows
$ 6,000,000
10,000,000
10,000,000
20,000,000
30,000,000
30,500,000
40,000,000
60,000,000
80,000,000
120,000,000
The firm’s current cost of capital is 13%.
a. Calculate the project’s net present value (NPV). Is the project acceptable under the NPV technique? Explain.
b. Calculate the project’s internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain.
c. In this case, did the two methods produce the same results? Generally, is there a preference between the NPV and IRR techniques? Explain.
d. Calculate the payback period for the project. If the firm usually accepts projects that have payback periods between 1 and 7 years, is…
AXON Mobile Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $150 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table:
Year Cash inflows
1 $ 6,000,000
2 10,000,000
3 10,000,000
4 20,000,000
5 30,000,000
6 30,500,000
7 40,000,000
8 60,000,000
9 80,000,000
10 120,000,000
The firm’s current cost of capital is 13%.
a.Calculate the project’s net present value (NPV). Is the project acceptable under the NPV technique? Explain.
b.Calculate the project’s internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain.
c.In this case, did the two methods produce the…
AXON Mobile Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $150 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table:
Year Cash inflows
1 $ 6,000,000
2 10,000,000
3 10,000,000
4 20,000,000
5 30,000,000
6 30,500,000
7 40,000,000
8 60,000,000
9 80,000,000
10 120,000,000
The firm’s current cost of capital is 13%.
Calculate the payback period for the project. If the firm usually accepts projects that have payback periods between 1 and 7 years, is this project acceptable?
Chapter 10 Solutions
MyFinanceLab With eText - Access (Custom Package)
Ch. 10.1 - What is the financial managers goal in selecting...Ch. 10.2 - Prob. 1FOPCh. 10.2 - What is the payback period? How is it calculated?Ch. 10.2 - What weaknesses are commonly associated with the...Ch. 10.3 - How is the net present value (NPV) calculated for...Ch. 10.3 - Prob. 10.5RQCh. 10.3 - Prob. 10.6RQCh. 10.4 - Prob. 10.8RQCh. 10.4 - Prob. 10.9RQCh. 10.4 - Prob. 10.10RQ
Ch. 10.5 - Prob. 1FOECh. 10.5 - How is a net present value profile used to compare...Ch. 10.5 - Prob. 10.13RQCh. 10 - Prob. 1ORCh. 10 - Prob. 10.1STPCh. 10 - Elysian Fields Inc. uses a maximum payback period...Ch. 10 - Prob. 10.2WUECh. 10 - Prob. 10.3WUECh. 10 - Prob. 10.4WUECh. 10 - Prob. 10.5WUECh. 10 - Prob. 10.1PCh. 10 - Payback comparisons Nova Products has a 5-year...Ch. 10 - Prob. 10.3PCh. 10 - Long-term investment decision, payback method Bill...Ch. 10 - Prob. 10.5PCh. 10 - Prob. 10.6PCh. 10 - Prob. 10.7PCh. 10 - Prob. 10.8PCh. 10 - Prob. 10.9PCh. 10 - Prob. 10.10PCh. 10 - Prob. 10.11PCh. 10 - Prob. 10.12PCh. 10 - NPV and EVA A project costs 2,500,000 up front and...Ch. 10 - Prob. 10.14PCh. 10 - Prob. 10.15PCh. 10 - Prob. 10.16PCh. 10 - Prob. 10.17PCh. 10 - Prob. 10.18PCh. 10 - Prob. 10.19PCh. 10 - Prob. 10.20PCh. 10 - Prob. 10.21PCh. 10 - Prob. 10.22PCh. 10 - Prob. 10.23PCh. 10 - Prob. 10.24PCh. 10 - Prob. 10.25PCh. 10 - Integrative: Multiple IRRs Froogle Enterprises is...Ch. 10 - Integrative: Conflicting Rankings The High-Flying...Ch. 10 - ETHICS PROBLEM Diane Dennison is a financial...Ch. 10 - Spreadsheet Exercise The Drillago Company is...
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
- Gallant Sports s considering the purchase of a new rock-climbing facility. The company estimates that the construction will require an initial outlay of $350,000. Other cash flows are estimated as follows: Assuming the company limits its analysis to four years due to economic uncertainties, determine the net present value of the rock-climbing facility. Should the company develop the facility if the required rate of return is 6%?arrow_forwardDetermine cash flows Natural Foods Inc. is planning to invest in new manufacturing equipment to make a new garden tool. The new garden tool is expected to generate additional annual sales of 5,000 units at 18 each. The new manufacturing equipment will cost 120,000 and is expected to have a 10-year life and a 17,000 residual value. Selling expenses related to the new product are expected to be 3% of sales revenue. The cost to manufacture the product includes the following on a per-unit basis: Determine the net cash flows for the first year of the project, Years 29, and for the last year of the project.arrow_forwardThe Drillago Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table. Year Cash Inflows 1 $ 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6 3,500,000 7 4,000,000 8 6,000,000 9 8,000,000 10 12,000,000 The firms current cost of capital is 13% Solution Estimated life (years) 10 Cost-of-capital (r) 13% Initial investment $ 15,000,000 Year Cash Flow 0 $ -15,000,000 1 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6…arrow_forward
- The Drillago Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table. Year Cash Inflows 1 $ 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6 3,500,000 7 4,000,000 8 6,000,000 9 8,000,000 10 12,000,000 The firm’s current cost of capital is 13%. Solution Estimated life (years) 10 Cost-of-capital (r) 13% Initial investment $ 15,000,000 Year Cash Flow 0 $ -15,000,000 1 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5…arrow_forwardThe Drillago Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table: Year Cash inflows 1 $ 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6 3,500,000 7 4,000,000 8 6,000,000 9 8,000,000 10 12,000,000 The firm’s current cost of capital is 13%. TO DO Create a spreadsheet to answer the following: Calculate the project’s net present value (NPV). Is the project acceptable under the NPV technique? Explain. \ Calculate the project’s internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain. In this case, did the two methods produce the same results? Generally, is there a preference between the NPV and IRR techniques? Explain. d. Calculate the payback period for the…arrow_forwardThe Drillago Company is involved in searching for locations in which to drill for oil. The firm’s current project requires an initial investment of $15 million and has an estimated life of 10 years. The expected future cash inflows for the project are as shown in the following table. Year Cash Inflows 1 $ 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6 3,500,000 7 4,000,000 8 6,000,000 9 8,000,000 10 12,000,000 The firm’s current cost of capital is 13%. Solution Estimated life (years) 10 Cost-of-capital (r) 13% Initial investment $ 15,000,000 Year Cash Flow 0 $ -15,000,000 1 600,000 2 1,000,000 3 1,000,000 4 2,000,000 5 3,000,000 6…arrow_forward
- Basic Concepts Sato Company is considering an investment in equipment that is capable of producing more efficiently than the current technology. The outlay required is $2,200,000. The equipment is expected to last five years and will have no salvage value. The expected cash flows associated with the project are as follows: Year Cash Revenues Cash Expenses 1 $2,940,000 $2,280,000 2 2,940,000 2,280,000 3 2,940,000 2,280,000 4 2,940,000 2,280,000 5 2,940,000 2,280,000 The present value tables provided in Exhibit 19B.1 and Exhibit 19B.2 must be used to solve the following problems. Required: 1. Compute the project's payback period. If required, round your answer to two decimal places.fill in the blank 1 years 2. Compute the project's accounting rate of return. Enter your answer as a whole percentage value (for example, 16% should be entered as "16" in the answer box).fill in the blank 2 % 3. Compute the project's net present value, assuming a required rate of return of 10…arrow_forwardQuestion The Bush Oil Company is deciding whether to drill for oil on a tract of land that the company owns. The company estimates that the project will cost $450 million today. Bush estimates that once drilled, the oil will generate positive cash flows of $215 million a year at the end of each of the next 4 years. Although the company is fairly confident about its cash flow forecast, it recognizes that if it waits 2 years, it will have more information about the local geology as well as the price of oil. Bush estimates that if it waits 2 years, the project will cost $600 million, and cash flows will continue for 4 years after the initial investment is made. Moreover, if it waits 2 years, there is a 95% chance that the cash flows will be $220 million a year for 4 years, and there is a 5% chance that the cash flows will be $120 million a year for 4 years. Assume that all cash flows are discounted at 11%. 1. If the company chooses to drill today, what is the project's expected net…arrow_forwardExpansion versus replacement cash flows Tesla Systems has estimated the cash flows over the 5-year lives for two projects, A and B. These cash flows are summarized in the following table. (Click on the icon here in order to copy the contents of the data table below into a spreadsheet.) Project A Project B Initial investment −$4,646,000 $1,553,000* Year Operating cash flows 1 $562,000 $390,000 2 915,000 390,000 3 1,343,000 390,000 4 2,218,000 390,000 5 3,405,000 390,000 *After-tax cash inflow expected from liquidation. a. If Project A, which requires an initial investment of −$4,646,000, is a replacement for Project B and the $1,553,000 initial investment shown for Project B is the after-tax cash inflow expected from liquidating it, what would be the net cash flows for this replacement decision? b. How can an expansion decision such as project A be viewed as a special form of a…arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...AccountingISBN:9781337115773Author:Maryanne M. Mowen, Don R. Hansen, Dan L. HeitgerPublisher:Cengage Learning
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting: The Cornerstone of Busines...
Accounting
ISBN:9781337115773
Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger
Publisher:Cengage Learning
Economic Value Added EVA - ACCA APM Revision Lecture; Author: OpenTuition;https://www.youtube.com/watch?v=_3hpcMFHPIU;License: Standard Youtube License