Principles of Managerial Finance (14th Edition) (Pearson Series in Finance)
14th Edition
ISBN: 9780133507690
Author: Lawrence J. Gitman, Chad J. Zutter
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 solutionStudents 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)
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
- Explain why financial institutions generally engage in foreign exchange tradingactivities. Provide specific purposes or motivations behind such activities.arrow_forwardA. In 2008, during the global financial crisis, Lehman Brothers, one of the largest investment banks, collapsed and defaulted on its corporate bonds, causing significant losses for bondholders. This event highlighted several risks that investors in corporate bonds might face. What are the key risks an investor would encounter when investing in corporate bonds? Explain these risks with examples or academic references. [15 Marks]arrow_forwardTwo companies, Blue Plc and Yellow Plc, have bonds yielding 4% and 5.3%respectively. Blue Plc has a credit rating of AA, while Yellow Plc holds a BB rating. If youwere a risk-averse investor, which bond would you choose? Explain your reasoning withacademic references.arrow_forward
- B. Using the probabilities and returns listed below, calculate the expected return and standard deviation for Sparrow Plc and Hawk Plc, then justify which company a risk- averse investor might choose. Firm Sparrow Plc Hawk Plc Outcome Probability Return 1 50% 8% 2 50% 22% 1 30% 15% 2 70% 20%arrow_forward(2) Why are long-term bonds more susceptible to interest rate risk than short-term bonds? Provide examples to explain. [10 Marks]arrow_forwardDon't used Ai solutionarrow_forward
- Don't used Ai solutionarrow_forwardScenario one: Under what circumstances would it be appropriate for a firm to use different cost of capital for its different operating divisions? If the overall firm WACC was used as the hurdle rate for all divisions, would the riskier division or the more conservative divisions tend to get most of the investment projects? Why? If you were to try to estimate the appropriate cost of capital for different divisions, what problems might you encounter? What are two techniques you could use to develop a rough estimate for each division’s cost of capital?arrow_forwardScenario three: If a portfolio has a positive investment in every asset, can the expected return on a portfolio be greater than that of every asset in the portfolio? Can it be less than that of every asset in the portfolio? If you answer yes to one of both of these questions, explain and give an example for your answer(s). Please Provide a Referencearrow_forward
- Hello expert Give the answer please general accountingarrow_forwardScenario 2: The homepage for Coca-Cola Company can be found at coca-cola.com Links to an external site.. Locate the most recent annual report, which contains a balance sheet for the company. What is the book value of equity for Coca-Cola? The market value of a company is (# of shares of stock outstanding multiplied by the price per share). This information can be found at www.finance.yahoo.com Links to an external site., using the ticker symbol for Coca-Cola (KO). What is the market value of equity? Which number is more relevant to shareholders – the book value of equity or the market value of equity?arrow_forwardFILE HOME INSERT Calibri Paste Clipboard BIU Font A1 1 2 34 сл 5 6 Calculating interest rates - Excel PAGE LAYOUT FORMULAS DATA 11 Α΄ Α΄ % × fx A B C 4 17 REVIEW VIEW Alignment Number Conditional Format as Cell Cells Formatting Table Styles▾ Styles D E F G H Solve for the unknown interest rate in each of the following: Complete the following analysis. Do not hard code values in your calculations. All answers should be positive. 7 8 Present value Years Interest rate 9 10 11 SA SASA A $ 181 4 $ 335 18 $ 48,000 19 $ 40,353 25 12 13 14 15 16 $ SA SA SA A $ Future value 297 1,080 $ 185,382 $ 531,618arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax CollegeManagerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College PubEBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
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