Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
14th Edition
ISBN: 9780133507690
Author: Lawrence J. Gitman, Chad J. Zutter
Publisher: PEARSON
bartleby

Videos

Textbook Question
Book Icon
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 cash inflows for the project appear 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 cap1tal 1s 13%.

To Do

Create a spreadsheet to answer the following questions.

  1. a. Calculate the project’s net present value (NPV). Is the project acceptable under the NPV technique? Explain.
  2. b. Calculate the project's internal rate of return (IRR). Is the project acceptable under the IRR technique? Explain.
  3. c. In this case, did the two methods produce the same results? Generally, is there a preference between the NPV and IRR techniques? Explain.
  4. 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?
Blurred answer
Students have asked these similar questions
How has AirBnb negatively affected the US and global economy? How has Airbnb negatively affected the real estate market? How has Airbnb negatively affected homeowners and renters market? What happened to Airbnb in the Tax Dispute in Italy?
How has AirBnb positively affected the US and global economy? How has Airbnb positively affected the real estate market? How has Airbnb positively affected homeowners and renters market?
D. (1) Consider the following cash inflows of a financial product. Given that the market interest rate is 12%, what price would you pay for these cash flows? Year 0 1 2 3 4 Cash Flow 160 170 180 230

Chapter 10 Solutions

Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)

Knowledge Booster
Background pattern image
Finance
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
SEE MORE QUESTIONS
Recommended textbooks for you
Text book image
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Text book image
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Text book image
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Economic Value Added EVA - ACCA APM Revision Lecture; Author: OpenTuition;https://www.youtube.com/watch?v=_3hpcMFHPIU;License: Standard Youtube License