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
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
Please help with questions.
What is the research design? How does it work?
What are the differences between Research design and Case Study research?
How to judge the quality of research designs? Could you help explain and give examples?
Chapter 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.Similar questions
- Consider a situation involving determining right and wrong. Do you believe utilitarianism provides a more objective viewpoint than moral rights in this context? Why or why not? How about when comparing utilitarianism to principles of justice? Share your thoughts. Reflect on this statement: "Every principle of distributive justice, whether that of the egalitarian, the capitalist, the socialist, the libertarian, or Rawls, in the end is illegitimately advocating some type of equality." Do you agree or disagree with this assertion? Why might someone claim this, and how would you respond?arrow_forwardI need help checking my spreadsheet. Q: Assume that Temp Force’s dividend is expected to experience supernormal growth of 73%from Year 0 to Year 1, 47% from Year 1 to Year 2, 32% from Year 2 to Year 3 and 21% from year3 to year 4. After Year 4, dividends will grow at a constant rate of 2.75%. What is the stock’sintrinsic value under these conditions? What are the expected dividend yield and capital gainsyield during the first year? What are the expected dividend yield and capital gains yield duringthe fifth year (from Year 4 to Year 5)?arrow_forwardwhat are the five components of case study design? Please help explain with examplesarrow_forward
- Commissions are usually charged when a right is exercised. a warrant is exercised. a right is sold. all of the above will have commissions A and B are correct, C is not correctarrow_forwardWhat is Exploratory Research Case Study? What is the main purpose of Exploratory Research?arrow_forwardplease help with how to solve this thank you.arrow_forward
- Question 25 Jasmine bought a house for $225 000. She already knows that for the first $200 000, the land transfer tax will cost $1650. Calculate the total land transfer tax. (2 marks) Land Transfer Tax Table Value of Property Rate On the first $30 000 0% On the next $60 000 0.5% (i.e., $30 001 to $90 000) On the next $60 000 1.0% (i.e., $90 001 to $150 000) On the next $50 000 1.5% (i.e., $150 001 to $200 000) On amounts in excess of $200 000 2.0% 22 5000–200 000. 10 825000 2.5000.00 2 x 25000 =8500 2 maarrow_forwardQuestion 25 Jasmine bought a house for $225 000. She already knows that for the first $200 000, the land transfer tax will cost $1650. Calculate the total land transfer tax. (2 marks) Land Transfer Tax Table Value of Property Rate On the first $30 000 0% On the next $60 000 0.5% (i.e., $30 001 to $90 000) On the next $60 000 1.0% (i.e., $90 001 to $150 000) On the next $50 000 1.5% (i.e., $150 001 to $200 000) On amounts in excess of $200 000 2.0% 225000–200 000 = 825000 25000.002 × 25000 1= 8500 16 50+ 500 2 marksarrow_forwardSuppose you deposit $1,000 today (t = 0) in a bank account that pays an interest rate of 7% per year. If you keep the account for 5 years before you withdraw all the money, how much will you be able to withdraw after 5 years? Calculate using formula. Calculate using year-by-year approach. Find the present value of a security that will pay $2,500 in 4 years. The opportunity cost (interest rate that you could earn from alternative investments) is 5%. Calculate using the formula. Calculate using year-by-year discounting approach. Solve for the unknown in each of the following: Present value Years Interest rate Future value $50,000 12 ? $152,184 $21,400 30 ? $575,000 $16,500 ? 14% $238,830 $21,400 ? 9% $213,000 Suppose you enter into a monthly deposit scheme with Chase, where you have your salary account. The bank will deduct $25 from your salary account every month and the first payment (deduction) will be made…arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
EBK 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