Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
6th Edition
ISBN: 9780134486857
Author: Tracie L. Miller-Nobles, Brenda L. Mattison, Ella Mae Matsumura
Publisher: PEARSON
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
Chapter 26, Problem 33AP
Hayes Company is considering two capital investments. Both investments have an initial cost of $10,000,000 and total net
Requirements
- 1. Use Excel to compute the
NPV andIRR of the two plans. Which plan, if any, should the company pursue? - 2. Explain the relationship between NPV and IRR. Based on this relationship and the company’s required rate of return, are your answers as expected in Requirement 1? Why or why not?
- 3. After further negotiating, the company can now invest with an initial cost of $9,500,000 for both plans. Recalculate the NPV and IRR. Which plan, if any, should the company pursue?
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Students have asked these similar questions
A company is considering three alternative investment projects with different net cash flows. The
present value of net cash flows is calculated using Excel and the results follow.
Potential Projects
Present value of net cash flows (excluding initial investment)
Initial investment
Project A
$ 11,226
(10,000)
Project B
$ 10,568
(10,000)
a. Compute the net present value of each project.
b. If the company accepts all positive net present value projects, which of these will it accept?
c. If the company can choose only one project, which will it choose on the basis of net present value?
Complete this question by entering your answers in the tabs below.
Required A
Required B
Required C
Compute the net present value of each project.
Potential Projects
Project A
Project B
Project C
Present value of net cash flows
Initial investment
Net present value
$
$
$
Yokam Company is considering two alternative projects. Project 1 requires an initial investment of $400,000 and has a present value of
cash flows of $1,100,000. Project 2 requires an initial investment of $4,000,000 and has a present value of cash flows of $6,000,000.
1. Compute the profitability index for each project.
2. Based on the profitability index, which project should the company prefer?
Complete this question by entering your answers in the tabs below.
Required 1 Required 2
Compute the profitability index for each project.
Project 1
Project 2
Choose Numerator:
Profitability Index
T
7
Choose Denominator:
4 of 5
180
#
Next >
G O
A company is considering three alternative investment projects with different net cash flows. The present value of net cash flows is
calculated using Excel and the results follow.
Potential Projects
Present value of net cash flows (excluding initial investment)
Initial investment
Project A
$ 8,328
(10,000)
Project B
$ 10,809
(10,000)
Project C
$ 10,685
(10,000)
a. Compute the net present value of each project.
b. If the company accepts all positive net present value projects, which of these will it accept?
c. If the company can choose only one project, which will it choose on the basis of net present value?
Complete this question by entering your answers in the tabs below.
Required A
Required B
Required C
Compute the net present value of each project.
Potential Projects
Project A
Project B
Project C
Present value of net cash flows
Initial investment
Net present value
Chapter 26 Solutions
Horngren's Financial & Managerial Accounting, The Managerial Chapters (6th Edition)
Ch. 26 - Match the following business activities to the...Ch. 26 - Match the following business activities to the...Ch. 26 - Prob. 3TICh. 26 - Prob. 4TICh. 26 - Prob. 5TICh. 26 - Match the following business activities to the...Ch. 26 - Prob. 7TICh. 26 - Prob. 8TICh. 26 - Prob. 9TICh. 26 - Based on your answers to the above questions,...
Ch. 26 - Prob. 11TICh. 26 - Prob. 12TICh. 26 - Prob. 13TICh. 26 - What is the NPV of the project?Ch. 26 - Prob. 15TICh. 26 - Prob. 16TICh. 26 - What is the second step of capital budgeting? a....Ch. 26 - Which of the following methods does not consider...Ch. 26 - Suppose Francine Dunkelbergs Sweets is considering...Ch. 26 - Your rich aunt has promised to give you 2,000 per...Ch. 26 - Prob. 5QCCh. 26 - Prob. 6QCCh. 26 - In computing the IRR on an expansion at Mountain...Ch. 26 - Prob. 8QCCh. 26 - Which of the following is the most reliable method...Ch. 26 - Prob. 10QCCh. 26 - Explain the difference between capital assets,...Ch. 26 - Describe the capital budgeting process.Ch. 26 - What is capital rationing?Ch. 26 - Prob. 4RQCh. 26 - Prob. 5RQCh. 26 - List some common cash outflows from capital...Ch. 26 - What is the payback method of analyzing capital...Ch. 26 - Prob. 8RQCh. 26 - Prob. 9RQCh. 26 - Prob. 10RQCh. 26 - What are some criticisms of the payback method?Ch. 26 - What is the accounting rate of return?Ch. 26 - How is ARR calculated?Ch. 26 - What is the decision rule for ARR?Ch. 26 - Prob. 15RQCh. 26 - What is an annuity? How does it differ from a lump...Ch. 26 - Prob. 17RQCh. 26 - Explain the difference between the present value...Ch. 26 - Prob. 19RQCh. 26 - Prob. 20RQCh. 26 - Prob. 21RQCh. 26 - Prob. 22RQCh. 26 - What is the decision rule for NPV?Ch. 26 - What is the profitability index? When is it used?Ch. 26 - What is the internal rate of return?Ch. 26 - Prob. 26RQCh. 26 - Prob. 27RQCh. 26 - What is the decision rule for IRR?Ch. 26 - Prob. 29RQCh. 26 - Why should both quantitative and qualitative...Ch. 26 - Review the following activities of the capital...Ch. 26 - Carter Company is considering three investment...Ch. 26 - Carter Company is considering three investment...Ch. 26 - Consider how Hunter Valley Snow Park Lodge could...Ch. 26 - Consider how Hunter Valley Snow Park Lodge could...Ch. 26 - Prob. 6SECh. 26 - Consider how Hunter Valley Snow Park Lodge could...Ch. 26 - Suppose Hunter Valley is deciding whether to...Ch. 26 - Prob. 9SECh. 26 - Prob. 10SECh. 26 - Prob. 11SECh. 26 - Refer to the Hunter Valley Snow Park Lodge...Ch. 26 - Consider how Hunter Valley Snow Park Lodge could...Ch. 26 - Prob. 14SECh. 26 - Prob. 15SECh. 26 - Match each capital budgeting method with its...Ch. 26 - Fill in each statement with the appropriate...Ch. 26 - Prob. 18ECh. 26 - Prob. 19ECh. 26 - Prob. 20ECh. 26 - Prob. 21ECh. 26 - Prob. 22ECh. 26 - Prob. 23ECh. 26 - Holmes Industries is deciding whether to automate...Ch. 26 - Use the NPV method to determine whether Hawkins...Ch. 26 - Refer to the data regarding Hawkins Products in...Ch. 26 - Hudson Manufacturing is considering three capital...Ch. 26 - Prob. 28ECh. 26 - You are planning for a very early retirement. You...Ch. 26 - Splash Nation is considering purchasing a water...Ch. 26 - Hill Company operates a chain of sandwich shops....Ch. 26 - Henderson Manufacturing, Inc. has a manufacturing...Ch. 26 - Hayes Company is considering two capital...Ch. 26 - You are planning for an early retirement. You...Ch. 26 - Water City is considering purchasing a water park...Ch. 26 - Howard Company operates a chain of sandwich shops....Ch. 26 - Hughes Manufacturing, Inc. has a manufacturing...Ch. 26 - Prob. 38BPCh. 26 - Prob. 39PCh. 26 - This problem continues the Piedmont Computer...Ch. 26 - Darren Dillard, majority stockholder and president...Ch. 26 - Prob. 1TIATCCh. 26 - Spencer Wilkes is the marketing manager at Darby...Ch. 26 - Prob. 1FCCh. 26 - Prob. 1CA
Additional Business Textbook Solutions
Find more solutions based on key concepts
Preparing Financial Statements from a Trial Balance The following accounts are taken from Equilibrium Riding, I...
Fundamentals of Financial Accounting
This year, Prewer Inc. received a 160,000 dividend on its investment consisting of 16 percent of the outstandin...
Principles Of Taxation For Business And Investment Planning 2020 Edition
Adjusting Journal Entries; Adjusted Trial Balance. Magic Cleaning Services (MCS) has a fiscal year-end of Decem...
Intermediate Accounting (2nd Edition)
Discussion Analysis A13-41 Discussion Questions 1. How do managers use the statement of cash flows? 2. Describ...
Managerial Accounting (5th Edition)
(a) Standard costs are the expected total cost of completing a job. Is this correct? Explain, (b) A standard im...
Managerial Accounting: Tools for Business Decision Making
Calculating certain information using the direct method (Learning Objective 4) 20-25 min. Trudeaus Marine, Inc....
Financial Accounting, Student Value Edition (5th Edition)
Knowledge Booster
Learn more about
Need a deep-dive on the concept behind this application? Look no further. Learn more about this topic, accounting and related others by exploring similar questions and additional content below.Similar questions
- Fenton, Inc., has established a new strategic plan that calls for new capital investment. The company has a 9.8% required rate of return and an 8.3% cost of capital. Fenton currently has a return of 10% on its other investments. The proposed new investments have equal annual cash inflows expected. Management used a screening procedure of calculating a payback period for potential investments and annual cash flows, and the IRR for the 7 possible investments are displayed in image. Each investment has a 6-year expected useful life and no salvage value. A. Identify which project(s) is/are unacceptable and briefly state the conceptual justification as to why each of your choices is unacceptable. B. Assume Fenton has $330,000 available to spend. Which remaining projects should Fenton invest in and in what order? C. If Fenton was not limited to a spending amount, should they invest in all of the projects given the company is evaluated using return on investment?arrow_forwardThere are two projects under consideration by the Rainbow factory. Each of the projects will require an initial investment of $35,000 and is expected to generate the following cash flows: Use the information from the previous exercise to calculate the internal rate of return on both projects and make a recommendation on which one to accept. For further instructions on internal rate of return in Excel, see Appendix C.arrow_forwardAssume a company is going to make an investment in a machine of $825,000 and the following are the cash flows that two different products would bring. Which of the two options would you choose based on the payback method?arrow_forward
- You are a financial analyst for the Hittle Company. The director of capital budgeting has asked you to analyze six proposed capital investments. Each project has a cost of $1,000, and the required rate of return for each is 12%, determine for each project (a) the payback period, (b) the net present value, (c) the profitability index, and (d) the internal rate of return. Assume under MACRS the asset falls in the three-year property class and that the corporate tax rate is 25 percent. You are limited to a maximum expenditure of $3000 only for this capital budgeting period. Which projects you will accept and why? Justify your suggestions Project A Project B Project C Project D Project E Project F Investment -1000 -1000 -1000 -1000 -1000 -1000 1 150 200 250 800 900 1000 2 350 300 250 350 300 200 3 400 500 600 200 150 100 4 700 650 600 200 150 50 12 Capital Budgeting and Estimating Cash Flows Table 12.2 PROPERTY CLASS RECOVERY YEAR MACRS depreciation percentages 3-YEAR 5-YEAR 7-YEAR 10-YEAR…arrow_forwardQuestions: Crowell Company is considering two capital investments. Both investments have an initial cost of $9,000,000 and total net cash inflows of $17,000,000 over 10 years. Crowell requires a 15% rate of return on this type of investment. Expected net cash inflows are as follows: Requirements - X 1. Use Excel to compute the NPV and IRR of the two plans. Which plan, if any, should the company pursue? 2. Explain the relationship between NPV and IRR. Based on this relationship and the company's required rate of return, are your answers as expected in Requirement 1? Why or why not? 3. After further negotiating, the company can now invest with an initial cost of $8,100,000. Recalculate the NPV and IRR. Which plan, if any, should the company pursue? Print Done Data Table Year Plan Alpha Plan Beta 1 1,700,000 $ 1,700,000 2 1,700,000 2,400,000 1,700,000 3,100,000 4 1,700,000 2,400,000 1,700,000 1,700,000 6 1,700,000 1,600,000 1,700,000 1,300,000 8 1,700,000 1,000,000 9 1,700,000 700,000…arrow_forwardRegarding the proposed investments, XYZ INC. gathers the following data: a cash cost of 13,000, net annual cash flows of 45,000, and a present value factor of 5.40 rounded for cash inflows over a ten-year period. Find out all the relevant details that will be important when choosing an investment. Please let me know whether you think our firm should receive an investment based on the following information:arrow_forward
- Ivanhoe Manufacturing is evaluating two capital projects. The company's choice will be based on the profitability index. Project #1 has a present value of cash flows of $216,000 and a net initial investment of $194,400 while Project #2 has a present value of future cash flows of $885,600 and a net initial investment of $864,000. Click here to view the factor table. Using the present value tables, which project will Ivanhoe choose? (Round answers to 3 decimal places, e.g. 2.575.) Project #1 Project #2 Profitability Index Ivanhoe should choose since its profitability index is * than the profitability index ofarrow_forwardYokam Company is considering two alternative projects. Project 1 requires an initial investment of $400,000 and has a present value of cash flows of $1,100,000. Project 2 requires an initial investment of $4 million and has a present value of cash flows of $6 million. Compute the profitability index for each project. Based on the profitability index, which project should the company prefer? Explain.arrow_forwardYokam Company is considering two alternative projects. Project 1 requires an initial investment of $420,000 and has a present value of all its cash flows of $1,350,000. Project 2 requires an initial investment of $5 million and has a present value of all its cash flows of $6 million. (a) Compute the profitability index for each project.(b) Based on the profitability index, which project should the company select?arrow_forward
- Consider the following project balance profiles for proposed investment projects. Statement 1-For Project A, the cash now at the end of year 2 is $100.Statement 2-For Project C, its net future worth at the end of year 2 is $150.Statement 3-For Project B, the interest rate used is 25%.Statement 4-For Project A, the rate of return should be greater than 15%.Which of the statement(s) above is (are) correct?(a) Just Statements 1 and 2(b) Just Statements 2 and 3(c) Just Statements 1 and 3( d) Just Statements 2, 3, and 4arrow_forwardA company is considering three alternative Investment projects with different net cash flows. The present value of net cash flows is calculated using Excel and the results follow. Potential Projects Present value of net cash flows (excluding initial investment) Initial investment Complete this question by entering your answers in the tabs below. a. Compute the net present value of each project. b. If the company accepts all positive net present value projects, which of these will It accept? c. If the company can choose only one project, which will it choose on the basis of net present value? Required A Required B Compute the net present value of each project. Potential Projects Project A Present value of net cash flows Initial investment Net present value Required C Project E Project C $10,685 (10,000)arrow_forwardArnold Engineering has available two mutually exclusive investment proposals, A and B. Their net cash flows are as shown in the table over a 10-year planning horizon. MARR is 12%. Determine which alternative the decision maker should select using an external rate of return approach.arrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Financial And Managerial AccountingAccountingISBN:9781337902663Author:WARREN, Carl S.Publisher:Cengage Learning,
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Financial And Managerial Accounting
Accounting
ISBN:9781337902663
Author:WARREN, Carl S.
Publisher:Cengage Learning,
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Capital Budgeting Introduction & Calculations Step-by-Step -PV, FV, NPV, IRR, Payback, Simple R of R; Author: Accounting Step by Step;https://www.youtube.com/watch?v=hyBw-NnAkHY;License: Standard Youtube License