Managerial Accounting
3rd Edition
ISBN: 9780077826482
Author: Stacey M Whitecotton Associate Professor, Robert Libby, Fred Phillips Associate Professor
Publisher: McGraw-Hill Education
expand_more
expand_more
format_list_bulleted
Question
Chapter 11, Problem 1.5GAP
To determine
Concept introduction:
To calculate:
The Estimated IRR based on NPV at different rates.
Expert Solution & Answer
Want to see the full answer?
Check out a sample textbook solutionStudents have asked these similar questions
Calculate for each project:
The payback period for each project
The Net Present Value (NPV)
The Profitability index
Which project should be accepted and why?
PLEASE SEE ATTACHED PHOTO TO ANSWER THE ABOVE QUESTIONS
Consider the two mutually exclusive projects described in the table below. the question requires a step by step excel solutionFor any positive value of the MARR, divide the possible MARR values into ranges with different decisions;describe and discuss what decision would be made in each range and why. You will need to calculate the crossover rate to determine the precise MARR where the decision changes. Include an NPV profile table and chart to illustrate your answer.Year Cash Flow Project A Cash Flow Project B0 -450,000 -700,0001 200,000 200,0002 150,000 200,0003 100,000 200,0004 100,000 200,0005 75,000 200,000
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
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)
Chapter 11 Solutions
Managerial Accounting
Ch. 11 - Prob. 1QCh. 11 - Prob. 2QCh. 11 - Prob. 3QCh. 11 - Which capital budgeting methods incorporate the...Ch. 11 - What is a company’s hurdle rate? How is it...Ch. 11 - How do cash flow and net income differ? Explain...Ch. 11 - In everyday terms, explain what information the...Ch. 11 - What do a positive NPV and a negative NPV indicate...Ch. 11 - Prob. 9QCh. 11 - Prob. 10Q
Ch. 11 - Why is the net present value method generally...Ch. 11 - Briefly explain how the profitability mdcx is...Ch. 11 - Prob. 13QCh. 11 - Prob. 14QCh. 11 - Prob. 15QCh. 11 - When would you use the PV of annuity table instead...Ch. 11 - Prob. 17QCh. 11 - Which of the following requires managers to...Ch. 11 - Prob. 2MCCh. 11 - Prob. 3MCCh. 11 - Prob. 4MCCh. 11 - Prob. 5MCCh. 11 - Prob. 6MCCh. 11 - Prob. 7MCCh. 11 - Prob. 8MCCh. 11 - Prob. 9MCCh. 11 - Prob. 10MCCh. 11 - Matching Key Terms and Concepts to DefinitionsCh. 11 - Prob. 2MECh. 11 - Prob. 3MECh. 11 - Prob. 4MECh. 11 - Prob. 5MECh. 11 - Prob. 6MECh. 11 - Prob. 7MECh. 11 - Prob. 8MECh. 11 - Computing Present Value of Complex Contract As a...Ch. 11 - Prob. 11MECh. 11 - Prob. 12MECh. 11 - Prob. 1ECh. 11 - Prob. 2ECh. 11 - Prob. 3ECh. 11 - Prob. 4ECh. 11 - Prob. 5ECh. 11 - Prob. 6ECh. 11 - Prob. 8ECh. 11 - Prob. 9ECh. 11 - Using NPV to Evaluate Mutually Exclusive Projects...Ch. 11 - Prob. 12ECh. 11 - Prob. 13ECh. 11 - Prob. 1.1GAPCh. 11 - Prob. 1.2GAPCh. 11 - Prob. 1.3GAPCh. 11 - Prob. 1.4GAPCh. 11 - Prob. 1.5GAPCh. 11 - Prob. 2.1GAPCh. 11 - Prob. 2.2GAPCh. 11 - Prob. 2.3GAPCh. 11 - Prob. 2.4GAPCh. 11 - Prob. 2.5GAPCh. 11 - Making Automation Decision Beacon Company is...Ch. 11 - Prob. 3.1GAPCh. 11 - Prob. 3.2GAPCh. 11 - Prob. 3.3GAPCh. 11 - Prob. 3.4GAPCh. 11 - Prob. 4.1GAPCh. 11 - Prob. 4.2GAPCh. 11 - Prob. 4.3GAPCh. 11 - Prob. 4.4GAPCh. 11 - Prob. 4.5GAPCh. 11 - Prob. 5.1GAPCh. 11 - Prob. 5.2GAPCh. 11 - Prob. 6.1GAPCh. 11 - Evaluating Sustainability Projects Citco Company...Ch. 11 - Evaluating Sustainability Projects Citco Company...Ch. 11 - Evaluating Sustainability Projects Citco Company...Ch. 11 - Prob. 1.1GBPCh. 11 - Prob. 1.2GBPCh. 11 - Prob. 1.3GBPCh. 11 - Prob. 1.4GBPCh. 11 - Prob. 1.5GBPCh. 11 - Prob. 2.1GBPCh. 11 - Prob. 2.2GBPCh. 11 - Prob. 2.3GBPCh. 11 - Prob. 2.4GBPCh. 11 - Prob. 2.5GBPCh. 11 - Prob. 2.6GBPCh. 11 - Prob. 3.1GBPCh. 11 - Comparing, Prioritizing Multiple Projects Harmony...Ch. 11 - Prob. 3.3GBPCh. 11 - Prob. 3.4GBPCh. 11 - Prob. 4.1GBPCh. 11 - Prob. 4.2GBPCh. 11 - Prob. 4.3GBPCh. 11 - Prob. 4.4GBPCh. 11 - Prob. 4.5GBPCh. 11 - Prob. 5.1GBPCh. 11 - Prob. 5.2GBPCh. 11 - Prob. 6.1GBPCh. 11 - Prob. 6.2GBPCh. 11 - Prob. 6.3GBPCh. 11 - Prob. 6.4GBP
Knowledge Booster
Similar questions
- The internal rate of return (IRR) on a project is the average annual rate of return provided by investing in the project. A. Explain this thoroughly. B. Give some example if you have any idea.arrow_forwardYou are analyzing a project and have prepared the following data: a. Based on the net present value of this project, should you reject or accept this project? (Please provide the formulas for calculation or the keys applied if a financial calculator is used) b. What is the internal rate of return (IRR) of this project? Should you reject or accept this project? (Please use a financial calculator and list the keys you use)arrow_forwardMf4. 1. Calculate the Payback period 2. Calculate the Net Present Value (NPV) of both projects 3. Calculate the Internal Rate of Return (IRR) of both projects 4. Critically discuss the merits of each investment appraisal method, then discuss the result of the evaluations you have made of the two projects and advise the company which project should be undertakenarrow_forward
- Struggling to find the payback period and NPV. I believed pay period to be annual net income+depreciation, then divide that number into initial investment. Please if you can, show me what the right equation is? Thank you for the help in advance. Balloons By Sunset (BBS) is considering the purchase of two new hot air balloons so that it can expand its desert sunset tours. Various information about the proposed investment follows: (Future Value of $1, Present Value of $1. Future Value Annuity of $1. Present Value Annuity of $1.) Note: Use appropriate factor(s) from the tables provided. Initial investment (for two hot air balloons). Useful life Salvage value Annual net income generated BBS's cost of capital Assume straight line depreciation method is used. Required: Help BBS evaluate this project by calculating each of the following: 1. Accounting rate of return. Note: Round your answer to 2 decimal places. $ 536,000 Answer is not complete. 1. Accounting rate of return 2. Payback period…arrow_forwardUsing image: a-1. What is the payback period for each project a-2. If you apply the payback criterion, which investment will you choose? b-1. What is the discounted payback period for each project? b-2. If you apply the discounted payback criterion, which investment will you choose? c-1. What is the NPV for each project? c-2. If you apply the NPV criterion, which investment will you choose? d-1. What is the IRR for each project? d-2. If you apply the IRR criterion, which investment will you choose? e-1. What is the profitability index for each project? e-2. If you apply the profitability index criterion, which investment will you choose? f. Based on your answers in (a) through (e), which project will you finally choose?arrow_forwardRequired : 1) Calculate the following investment appraisal criteria for THREE optional projects Selection is from your own choice : Accounting Rate of Return Payback period 3. NPV (Select a cost of capital at your own choic 4. IRR ((Select a cost of capital at your own choice (Note: Refer the attached PV table) .2) Comment on each criterion and take the final decision with justification (Word limit: 200-300) Note: Use a suitable format (introduction, calculation, comments and conclusion) and provide the answer as a management report. It is advisable to use MS Excel for relevant calculations where appropriate.arrow_forward
- Internal rate of return For the project shown in the following table, , calculate the internal rate of return (IRR). Then indicate, for the project, the maximum cost of capital that the firm could have and still find the IRR acceptable. ..... The project's IRR is %. (Round to two decimal places.) Data table (Click on the icon located on the top-right corner of the data table below in order to copy its contents into a spreadsheet.) Initial investment (CF,) $150,000 Year (t) Cash inflows (CF;) $35,000 $30,000 $35,000 $40,000 $50,000 1 2 3 4 5 Print Donearrow_forwardDetermine which equipment should be favored, comparing the net present values of the two proposals and assuming a minimum rate of return of 15%. Use the present value table appearing above. Processing Mill Electric Shovel EE Present value of net cash flow total Less amount to be invested Net present value Which project should be favored?arrow_forwardWhat are the internal rates of return (IRR) on the three projects? Does the IRR rule in this case give the same decision as NPV? How do you know? If the opportunity cost of capital is 11%, what is the profitability index for each project? Please analyze if, in general, decisions based on the profitability index are consistent with decisions based on NPV. What is the most generally accepted measure to choose between the projects? Please justify your answer. Project A -5000 +1000 +1000 +3000 0 B -1000 0 +1000 +2000 +3000 C -5000 +1000 +1000 +3000 +5000 I will need full analysis (qualitative examples and references citations and examples of relative current investments of big companies.arrow_forward
- Pls refer to the attached image. pls show formula and solution in manual calculation. 1. NPV of Project Z? 2. Payback period of Project X? 3. Payback period of Project Y? 4. Payback period of project Z? 5. Based on the calculated NPV and payback period, which project would you recommend and why? Include the implications of projects' NPVs and payback period in your explanation.arrow_forwardPlease help me with this question (picture below) 1. Calculate the payback period, accounting rate of return, net present value of each project. Based on your calculations, discuss whether the projects should go ahead. Assume that the target value for payback is 3 years for project A and 2 years for project B.2. List advantages and disadvantages of payback period, accounting rate of return, net present value of each project.arrow_forwardCompute the Profitability Index (PI) for each project? Project A Project B Profitability Index (PI) 5- In light of your answers above, suppose that these two projects might be mutually exclusive or independent. According to these two assumptions, fill in the blanks in the table below with the suitable answer: Points Investment Criteria If A and B are mutually exclusive, then I would select If A and B are independent, then I would select PBP NPV IRR PIarrow_forward
arrow_back_ios
SEE MORE QUESTIONS
arrow_forward_ios
Recommended textbooks for you
- Intermediate Financial Management (MindTap Course...FinanceISBN:9781337395083Author:Eugene F. Brigham, Phillip R. DavesPublisher:Cengage Learning
Intermediate Financial Management (MindTap Course...
Finance
ISBN:9781337395083
Author:Eugene F. Brigham, Phillip R. Daves
Publisher:Cengage Learning