Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
15th Edition
ISBN: 9780134476315
Author: Chad J. Zutter, Scott B. Smart
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
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 solutionChapter 10 Solutions
Gitman: Principl Manageri Finance_15 (15th Edition) (What's New in Finance)
Ch. 10.1 - What is the financial managers goal in selecting...Ch. 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.10RQCh. 10.5 - How is a net present value profile used to compare...
Ch. 10.5 - Prob. 10.13RQCh. 10 - Prob. 1ORCh. 10 - All techniques with NPV profile: Mutually...Ch. 10 - Elysian Fields Inc. uses a maximum payback period...Ch. 10 - Prob. E10.1WUECh. 10 - Prob. 10.2WUECh. 10 - Prob. E10.2WUECh. 10 - Axis Corp. is considering investment in the best...Ch. 10 - Prob. E10.3WUECh. 10 - Prob. 10.4WUECh. 10 - Prob. E10.4WUECh. 10 - Cooper Electronics uses NPV profiles to visually...Ch. 10 - Prob. E10.5WUECh. 10 - Payback period The Ball Shoe Company is...Ch. 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 - All techniques with NPV profile: Mutually...Ch. 10 - Integrative: Multiple IRRs Froogle Enterprises is...Ch. 10 - Integrative: Conflicting Rankings The High-Flying...Ch. 10 - Problems with IRR White Rock Services Inc. has an...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.Recommended textbooks for you
- Essentials Of InvestmentsFinanceISBN:9781260013924Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.Publisher:Mcgraw-hill Education,
- Foundations Of FinanceFinanceISBN:9780134897264Author:KEOWN, Arthur J., Martin, John D., PETTY, J. WilliamPublisher:Pearson,Fundamentals of Financial Management (MindTap Cou...FinanceISBN:9781337395250Author:Eugene F. Brigham, Joel F. HoustonPublisher:Cengage LearningCorporate Finance (The Mcgraw-hill/Irwin Series i...FinanceISBN:9780077861759Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan ProfessorPublisher:McGraw-Hill Education
Essentials Of Investments
Finance
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:9780134897264
Author:KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:Pearson,
Fundamentals of Financial Management (MindTap Cou...
Finance
ISBN:9781337395250
Author:Eugene F. Brigham, Joel F. Houston
Publisher:Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i...
Finance
ISBN:9780077861759
Author:Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:McGraw-Hill Education
Economic Value Added EVA - ACCA APM Revision Lecture; Author: OpenTuition;https://www.youtube.com/watch?v=_3hpcMFHPIU;License: Standard Youtube License