EBK FINANCIAL MANAGEMENT: THEORY & PRAC
15th Edition
ISBN: 9781305886902
Author: EHRHARDT
Publisher: CENGAGE LEARNING - CONSIGNMENT
expand_more
expand_more
format_list_bulleted
Concept explainers
Videos
Textbook Question
thumb_up100%
Chapter 10, Problem 23SP
Start with the partial model in the file Ch10 P23 Build a Model.xlsx on the textbook’s Web site. Gardial Fisheries is considering two mutually exclusive investments. The projects’ expected net cash flows are as follows:
- a. If each project’s cost of capital is 12%, which project should be selected? If the cost of capital is 18%, what project is the proper choice?
- b. Construct
NPV profiles for Projects A and B. - c. What is each project’s
IRR ? - d. What is the crossover rate, and what is its significance?
- e. What is each project’s MIRR at a cost of capital of 12%? At r = 18%? (Hint: Consider Period 7 as the end of Project B’s life.)
- f. What is the regular payback period for these two projects?
- g. At a cost of capital of 12%, what is the discounted payback period for these two projects?
- h. What is the profitability index for each project if the cost of capital is 12%?
Expert Solution & Answer
Trending nowThis is a popular solution!
Students have asked these similar questions
Nile Inc. wants to choose the bettter of two mutually exclusive projects that expand warehouse capacity. The projects cash flows are shown in the following table attached. The cost of capital is 14%
a. Calculate the IRR for each of the projects . Assess the acceptabiity of each project on the basis of the IRRs.
b. Which project is preferred?
a. Calculate the projects’ NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks.b. If the two projects are independent, which project(s) should be chosen?c. If the two projects are mutually exclusive and the WACC is 10%, which project(s)should be chosen?d. Plot NPV profiles for the two projects. Identify the projects’ IRRs on the graph.e. If the WACC was 5%, would this change your recommendation if the projects weremutually exclusive? If the WACC was 15%, would this change your recommendation?Explain your answers.f. The crossover rate is 13.5252%. Explain what this rate is and how it affects the choicebetween mutually exclusive projects.g. Is it possible for conflicts to exist between the NPV and the IRR when independentprojects are being evaluated? Explain your answer.h. Now look at the regular and discounted paybacks. Which project looks better whenjudged by the paybacks?i. If the payback was the only method a firm used to accept or reject projects, what paybackshould it…
Consider the following two projects:
Project
Year 0
Year 1
Year 2
Year 3
Year 4
Discount
Cash Flow Cash Flow Cash Flow Cash Flow Cash Flow
Rate
A
- 100
40
50
60
N/A
0.18
B
- 73
30
30
30
30
0.18
Assume that projects A and B are mutually exclusive. The correct investment decision and the best rationale for that decision is to
A. invest in project B, since NPV, > NPV,
A
B. invest in project A, since NPV, > 0.
OC. invest in project A, since NPV, IRR,
A'
Chapter 10 Solutions
EBK FINANCIAL MANAGEMENT: THEORY & PRAC
Ch. 10 - Define each of the following terms:
Capital...Ch. 10 - What types of projects require the least detailed...Ch. 10 - Explain why the NPV of a relatively long-term...Ch. 10 - When two mutually exclusive projects are being...Ch. 10 - Suppose a firm is considering two mutually...Ch. 10 - A project has an initial cost of 40,000, expected...Ch. 10 - Refer to Problem 10-1. What is the project’s IRR?
Ch. 10 - Refer to Problem 10-1. What is the projects MIRR?Ch. 10 - Prob. 4PCh. 10 - Prob. 5P
Ch. 10 - Prob. 6PCh. 10 - Your division is considering two investment...Ch. 10 - Edelman Engineering is considering including two...Ch. 10 - Davis Industries must choose between a gas-powered...Ch. 10 - Project S has a cost of 10,000 and is expected to...Ch. 10 - Your company is considering two mutually exclusive...Ch. 10 - Prob. 12PCh. 10 - Cummings Products is considering two mutually...Ch. 10 - Prob. 14PCh. 10 - Shao Airlines is considering the purchase of two...Ch. 10 - The Perez Company has the opportunity to invest in...Ch. 10 - Filkins Fabric Company is considering the...Ch. 10 - Prob. 19PCh. 10 - The Aubey Coffee Company is evaluating the...Ch. 10 - Your division is considering two investment...Ch. 10 - Prob. 22PCh. 10 - Start with the partial model in the file Ch10 P23...Ch. 10 - What is capital budgeting?Ch. 10 - Prob. 2MCCh. 10 - c. (1) Define the term net present value (NPV)....Ch. 10 - Prob. 4MCCh. 10 - Draw NPV profiles for Franchises L and S. At what...Ch. 10 - What is the underlying cause of ranking conflicts...Ch. 10 - Define the term modified IRR (MIRR). Find the...Ch. 10 - What does the profitability index (PI) measure?...Ch. 10 - (1) What is the payback period? Find the paybacks...Ch. 10 - Prob. 10MCCh. 10 - In an unrelated analysis, you have the opportunity...Ch. 10 - You are also considering another project that has...
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 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,000arrow_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_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
- You are choosing between two projects. The cash flows for the projects are given in the attached table ($miilion) . a. What are the IRRs of the two projects? (A &B) b. If your discount rate is 4.9%,what are theNPVs of the two projects? (A & B) c. Why do IRR and NPV rank the two projects differently?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_forwardUse the information provided to answer the questions.Use the information provided below to calculate the following. Where applicable, use the presentvalue tables provided in APPENDICES 1 and 2 that appear after QUESTION 5. 5.1.3 Calculate the Net Present Value of each project (with amounts rounded off to the nearest Rand). 5.1.4 Use your answers from question 5.1.3 to recommend the project that should be chosen. Motivateyour choice. INFORMATION Zeda Enterprises has the option to invest in machinery in projects A and B but finance is only available to invest inone of them. You are given the following projected data:Project A Project BInitial cost R300 000 R300 000Scrap value R40 000 0Depreciation per year R52 000 R60 000Net profitYear 1 R20 000Year 2 R30 000Year 3 R50 000Year 4 R60 000Year 5 R10 000Net cash flowsYear 1 R90 000Year 2 R90 000Year 3 R90 000Year 4 R90 000Year 5 R90 000 Additional informationThe discount rate used by the company is 12%.arrow_forward
- A financial analyst is evaluating the following projects, which are mutually exclusive, meaning that only one of them can be chosen. Based on financial theory and the NPV criterion, which one of these projects should be chosen over the other three? Time A C D -26,000 -7,200 -14,500 -19,600 8,100 11,900 8,100 2,360 8.600 1,150 10,000 2,120 5,700 800 11,100 11,00O0 4,200 850 1,130 9,800 12,480 9,700 830 11,600 Discount 13.9% 13.9% 13.9% 13.9% Rate O Project A O Project B O Project C O Project D O12 345arrow_forwardUse the information below and help the management in choosing the most desirable Project using all the following techniques:1) Payback Period Technique.2) Discounted Payback Period Technique.3) Net Present Value Technique4) Profitability Index Technique. Based on your answer which project is better and why? please show the steps and formula Thanksarrow_forwardSuppose the net present values of projects A and B show a distribution as follows. a) Compare the projects by expected value criteria?b) Compare the projects by standard deviation criteria?c) Evaluate A and B projects according to the coefficient of variation criterion?Calculate on paper.arrow_forward
- Please see attached:arrow_forwardYou are evaluating five investment projects. You already calculated the rate of return for each alternative investment and incremental rate of return between the two alternatives as well. In calculating the incremental rate of return, a lower cost investment project is subtracted from the higher cost investment project. All rate of return figures are rounded to the nearest integers. Investment Alternative Initial Investment ($) Rate of Return (%) Rate of Return on Incremental Investment (%) A CDE A B C D E b.Select E. c. Select B. 35,000 45,000 d. Do nothing. 50,000 65,000 80,000 12 15 13 20 18 B 28 20 36 27 12 40 22 If all investment alternatives are mutually exclusive and the MARR is 12%, which alternative should be chosen? a. Select D. 42 25 -5arrow_forwardplease give Step by Step Solution otherwise i give you DISLIKE !arrow_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
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