Horngren's Accounting, The Financial Chapters (12th Edition)
12th Edition
ISBN: 9780134486789
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 P26.39CT
Using Excel for capital budgeting calculations
Download an Excel template for this problem online in MyAccountingLab or athttp://www.pearsonhighered.com/Horngren
Glacier Creek Textiles is planning to purchase new manufacturing equipment. The equipment has an acquisition cost of $100,000, an estimated useful life of five years and no residual value. The company uses a 12%
| Year | Net |
Net |
| 0 | $(100,000) | |
| 1 | 25,000 | |
| 2 | 29,000 | |
| 3 | 26,000 | |
| 4 | 28,000 | |
| 5 | 35,000 |
Requirements
1. Compute the accounting rate of return.
2. Compute the
3. Compute the net present value of the investment using Excel's NPV function.
4. Compute the profitability index, rounded to two decimal places.
5. Compute the
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solution
Chapter 26 Solutions
Horngren's Accounting, The Financial Chapters (12th Edition)
Ch. 26 - Prob. 1QCCh. 26 - Prob. 2QCCh. 26 - Prob. 3QCCh. 26 - Prob. 4QCCh. 26 - Prob. 5QCCh. 26 - Prob. 6QCCh. 26 - Prob. 7QCCh. 26 - The IRR is Learning Objective 4 the interest rate...Ch. 26 - Prob. 9QCCh. 26 - Ian Corp, is considering two expansion projects....
Ch. 26 - Prob. 1RQCh. 26 - Describe the capital budgeting process.Ch. 26 - Prob. 3RQCh. 26 - Prob. 4RQCh. 26 - Prob. 5RQCh. 26 - Prob. 6RQCh. 26 - What is the payback method of analyzing capital...Ch. 26 - Prob. 8RQCh. 26 - Prob. 9RQCh. 26 - What is the decision rule for payback?Ch. 26 - Prob. 11RQCh. 26 - What is the accounting rate of return?Ch. 26 - How is ARR calculated?Ch. 26 - Prob. 14RQCh. 26 - Prob. 15RQCh. 26 - What is an annuity? How does it differ from a lump...Ch. 26 - Prob. 17RQCh. 26 - Prob. 18RQCh. 26 - Prob. 19RQCh. 26 - Prob. 20RQCh. 26 - Prob. 21RQCh. 26 - Prob. 22RQCh. 26 - Prob. 23RQCh. 26 - Prob. 24RQCh. 26 - Prob. 25RQCh. 26 - Prob. 26RQCh. 26 - Prob. 27RQCh. 26 - Prob. 28RQCh. 26 - Prob. 29RQCh. 26 - Prob. 30RQCh. 26 - Prob. S26.1SECh. 26 - Prob. S26.2SECh. 26 - Prob. S26.3SECh. 26 - Prob. S26.4SECh. 26 - Prob. S26.5SECh. 26 - Prob. S26.6SECh. 26 - Prob. S26.7SECh. 26 - Using the payback and ARR methods to make capital...Ch. 26 - Prob. S26.9SECh. 26 - Prob. S26.10SECh. 26 - Prob. S26.11SECh. 26 - Prob. S26.12SECh. 26 - Prob. S26.13SECh. 26 - Prob. S26.14SECh. 26 - Prob. S26.15SECh. 26 - Prob. E26.16ECh. 26 - Prob. E26.17ECh. 26 - Prob. E26.18ECh. 26 - Prob. E26.19ECh. 26 - Prob. E26.20ECh. 26 - Using ARE to make capital investment decisions...Ch. 26 - Prob. E26.22ECh. 26 - Prob. E26.23ECh. 26 - Prob. E26.24ECh. 26 - Prob. E26.25ECh. 26 - Prob. E26.26ECh. 26 - Prob. E26.27ECh. 26 - Prob. E26.28ECh. 26 - Prob. P26.29APGACh. 26 - Prob. P26.30APGACh. 26 - Using payback, APR, NPV, IPP, and profitability...Ch. 26 - Using payback, ARP, and NPV with unequal cash...Ch. 26 - Prob. P26.33APGACh. 26 - Prob. P26.34BPGBCh. 26 - Prob. P26.35BPGBCh. 26 - Using payback, APR, NPV, IRR, and profitability...Ch. 26 - Prob. P26.37BPGBCh. 26 - Prob. P26.38BPGBCh. 26 - Using Excel for capital budgeting calculations...Ch. 26 - Prob. P26.40CPCh. 26 - Prob. 1CPCh. 26 - Prob. 2CPCh. 26 - Prob. 3CPCh. 26 - Prob. 4CPCh. 26 - Prob. 26.1TIATCCh. 26 - Prob. 26.1EICh. 26 - Prob. 26.1FC
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
- Consolidated Aluminum is considering the purchase of a new machine that will cost $308,000 and provide the following cash flows over the next five years: $88,000, 92,000, $91,000, $72,000, and $71,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel, see Appendix C.arrow_forwardGarnette Corp is considering the purchase of a new machine that will cost $342,000 and provide the following cash flows over the next five years: $99,000, $88,000, $92,000. $87,000, and $72,000. Calculate the IRR for this piece of equipment. For further instructions on internal rate of return in Excel. see Appendix C.arrow_forwardWould you rather have $7,500 today or at the end of 20 years after it has been invested at 15%? Explain your answer. The following are independent situations. For each capital budgeting project, indicate whether management should accept or reject the project and list a brief reason why.arrow_forward
- Your company is planning to purchase a new log splitter for is lawn and garden business. The new splitter has an initial investment of $180,000. It is expected to generate $25,000 of annual cash flows, provide incremental cash revenues of $150,000, and incur incremental cash expenses of $100,000 annually. What is the payback period and accounting rate of return (ARR)?arrow_forwardDetermine cash flows Natural Foods Inc. is planning to invest in new manufacturing equipment to make a new garden tool. The new garden tool is expected to generate additional annual sales of 5,000 units at 18 each. The new manufacturing equipment will cost 120,000 and is expected to have a 10-year life and a 17,000 residual value. Selling expenses related to the new product are expected to be 3% of sales revenue. The cost to manufacture the product includes the following on a per-unit basis: Determine the net cash flows for the first year of the project, Years 29, and for the last year of the project.arrow_forwardBuena Vision Clinic is considering an investment that requires an outlay of 600,000 and promises a net cash inflow one year from now of 810,000. Assume the cost of capital is 10 percent. Required: 1. Break the 810,000 future cash inflow into three components: a. The return of the original investment b. The cost of capital c. The profit earned on the investment 2. Now, compute the present value of the profit earned on the investment. 3. Compute the NPV of the investment. Compare this with the present value of the profit computed in Requirement 2. What does this tell you about the meaning of NPV?arrow_forward
- Manzer Enterprises is considering two independent investments: A new automated materials handling system that costs 900,000 and will produce net cash inflows of 300,000 at the end of each year for the next four years. A computer-aided manufacturing system that costs 775,000 and will produce labor savings of 400,000 and 500,000 at the end of the first year and second year, respectively. Manzer has a cost of capital of 8 percent. Required: 1. Calculate the IRR for the first investment and determine if it is acceptable or not. 2. Calculate the IRR of the second investment and comment on its acceptability. Use 12 percent as the first guess. 3. What if the cash flows for the first investment are 250,000 instead of 300,000?arrow_forwardGallant Sports s considering the purchase of a new rock-climbing facility. The company estimates that the construction will require an initial outlay of $350,000. Other cash flows are estimated as follows: Assuming the company limits its analysis to four years due to economic uncertainties, determine the net present value of the rock-climbing facility. Should the company develop the facility if the required rate of return is 6%?arrow_forward
arrow_back_ios
arrow_forward_ios
Recommended textbooks for you
Managerial AccountingAccountingISBN:9781337912020Author:Carl Warren, Ph.d. Cma William B. TaylerPublisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...AccountingISBN:9781305970663Author:Don R. Hansen, Maryanne M. MowenPublisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENTFinanceISBN:9781337514835Author:MOYERPublisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2AccountingISBN:9781947172609Author:OpenStaxPublisher:OpenStax College
Managerial Accounting
Accounting
ISBN:9781337912020
Author:Carl Warren, Ph.d. Cma William B. Tayler
Publisher:South-Western College Pub
Cornerstones of Cost Management (Cornerstones Ser...
Accounting
ISBN:9781305970663
Author:Don R. Hansen, Maryanne M. Mowen
Publisher:Cengage Learning
EBK CONTEMPORARY FINANCIAL MANAGEMENT
Finance
ISBN:9781337514835
Author:MOYER
Publisher:CENGAGE LEARNING - CONSIGNMENT
Principles of Accounting Volume 2
Accounting
ISBN:9781947172609
Author:OpenStax
Publisher:OpenStax College
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