Garage, Inc., has identified the following two mutually exclusive projects.a. What is the IRR for each project?b. If the required return is 11 percent, what is the NPV for each project?c. What is the crossover rate between these two projects?Year 0Year 1Year 2Year 3Year 4Required returnSSSSSA(43,500)21,40018,50013,8007,600$ESSASALA$$$$B(43,500)6,40014,70022,80025,20011%Complete the following analysis. Do not hard code values in your calculations.You must use the built-in Excel functions to answer this question. Complete the following analysis. Do not hard code values in your calculations.You must use the built-in Excel functions to answer this question.Cash flow A IRRCash flow B IRRCash flow A NPVCash flow B NPVYear 0Year 1Year 2Year 3Year 4Crossover rateDifference in cash flows+

In order to determine if a project is financially feasible and viable or not we make use of capital…

Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS $ $ A (43,500) 21,400 18,500 13,800 7,600 $ $ $ 14,700 22,800 25,200 555 $ B (43,500) 6,400 $ 11%

Garage, Inc., has identified the following two mutually exclusive projects. a. What is the IRR for each project? b. If the required return is 11 percent, what is the NPV for each project? c. What is the crossover rate between these two projects? Year 0 Year 1 Year 2 Year 3 Year 4 Required return SSSSS $ $ A (43,500) 21,400 18,500 13,800 7,600 $ $ $ 14,700 22,800 25,200 555 $ B (43,500) 6,400 $ 11%

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Related questions

Q: Emusk Inc. is evaluating two mutually exclusive projects. The required rate of return on these…

A: IRR is the internal rate of return. It is an important capital budgeting tool. IRR is the rate at…

Q: Project B has an upfront cost of $45,000 and expected OCFs (already calculated) of $22,000 year 1,…

A: See above.

Q: You are considering the following two mutually exclusive projects. The crossover rate between these…

A: > Please refer to the spreadsheet below for calculation and answer. Cell reference is also…

Q: Answer this question as it is pertaining to two MUTUALLY EXCLUSIVE projects on the following figure.…

A: From the given graph of NPV vs required rate, we can see that at the required rate of 8% both A and…

Q: Lopez Company is considering three alternative investment projects below: Project 1 5.2 years…

A: Payback Period: The time required to recover the initial investment in a project. Choose an option…

Q: (a). Using the net present value method, which project should be accepted? (b). Using the internal…

A: NPV = -Initial outlay + Present value of cash flows. IRR is the internal rate of return at which the…

Q: Consider the following two projects: Project Year 0 Year 1 Year 2 Year 3 Year 4 Year 5 Year 6 Year 7…

A: To ensure the correctness of the chosen answer, let's briefly analyze the projects using the…

Q: Suppose that you could invest in the following projects but have only $29,670 to invest. How would…

A: Step 1: Given that,ProjectCostNPVA$8,260$4,300B$10,850$6,470C$9,070$4,830D$7,170$3,940 Step 2: The…

Q: Better plc is comparing two mutually exclusive projects, whose details are given below. The…

A: The process of evaluating potential investments and projects is known as capital budgeting. It…

Q: Consider the two projects in the following table: Year 0 1 23 3 14.95% What is the crossover point…

A: This pertains to capital budgeting.Crossover point is that point in which the NPV of the two…

Q: Emusk Inc. is evaluating two mutually exclusive projects. The required rate of return on these…

A: Internal rate of return refers to the return that is earned by the investors over the investment…

Q: Kaleb Konstruction, Inc., has the following mutually exclusive projects available. The company has…

A: Payback Period: It represents the period in which the initial investment of a project is recovered.…

Q: Compute the (a) net present value, (b) internal rate of return (IRR), (c) modified internal rate of…

A: Hello. Since your question has multiple sub-parts, we will solve first three sub-parts for you. If…

Q: Determine the project's NPV if the Profitability Index is 0.4; and the investment value is $500,000.…

A: Net present value(NPV) of the project is calculated using following equation Profitability index =…

Q: 3. Connor Corporation is considering two projects (see below). For your analysis, assume these…

A: Capital Budgeting is a technique in finance to evaluate the profitability and the feasibility of…

Q: ← Internal rate of return and modified internal rate of return. Quark Industries has three potential…

A: The given problem can be solved using IRR and MIRR function in excel.

Q: What is the NPV, payback period, and internal rate of return for all project. With the initial…

A: Project A Calculations:NPV Calculation:Year 1 cash flow: $250,000 / (1 + 0.10)^1 = $227,273Year 2…

Q: Iggy Company is considering three capital expenditure projects. Relevant data for the projects are…

A: Here, Depreciation Method is Straight Line Method.

Q: 27. Net Present Value (NPV) and Internal Rate of Return (IRR) calculation results for three separate…

A: As per the rule of Net Present value (NPV) , a project should be accepted, only if it has positive…

Q: need step by step answer

A: Project 1 NPV over 6 year period = $5,173.26 Project 2 NPV over 6 year period = $5,019.86…

Q: 10 You are trying to determine which of two none mutually exclusive projects to undertake. Project…

A: NPV means Net present value.It is a capital budgeting technique used for making investment…

Q: Weston Systems is considering the following independent projects for the coming year:…

A: To find the minimum acceptable return for each project, we'll use the adjusted WACC for each level…

Q: Consider the following projects. Project A -10,000 6,000 6,000 7,000 What is the ROR of the…

A: A rate that helps to evaluate the yield as a percentage of the investment amount over the life of an…

Q: The Company has three potential projects from which to choose. Selected information on each of the…

A: Capital budgeting is used to evaluate the projects. With the help of capital budgeting, the…

Concept explainers

Production Budget

A budget can be defined as a financial plan designed by an undertaking for a definite period in the future that can contribute towards enhancing the financial success of the business undertaking. It is used to estimate the revenue and expenses. The budget generally takes into account both current and future income and expenses.

Question

Garage, Inc., has identified the following two mutually exclusive projects.
a. What is the IRR for each project?
b. If the required return is 11 percent, what is the NPV for each project?
c. What is the crossover rate between these two projects?
Year 0
Year 1
Year 2
Year 3
Year 4
Required return
SSSSS
A
(43,500)
21,400
18,500
13,800
7,600
$
ESSASALA
$
$
$
$
B
(43,500)
6,400
14,700
22,800
25,200
11%
Complete the following analysis. Do not hard code values in your calculations.
You must use the built-in Excel functions to answer this question.

Expert Solution

This question has been solved!

Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.

SEE SOLUTION Check out a sample Q&A here

Step 1: Introduction to capital budgeting

VIEW

Step 2: Calculation of IRR

VIEW

Step 3: NPV calculations

VIEW

Step 4: Cross over rate calculations

VIEW

Solution

VIEW

Step by step

Solved in 5 steps with 6 images

SEE SOLUTION Check out a sample Q&A here

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

Cooney Co. is evaluating the following mutually exclusive projects. The manager has determined that the appropriate discount rate is 6.2% for all the recommended projects. Rank order the projects based on the profitability index. Project A Project B Project C (35,000) (65,000) (86,000) Year 0 1 2 3 55,000 40,000 22,000 22,000 44,000 44,000 35,000
Cooney Co. is evaluating the following mutually exclusive projects. The manager has determined that the appropriate discount rate is 6.20% for all the recommended projects. Rank order the projects based on the net present value. Project A Project B Project C (35,000) (65,000) (86,000) Year 0 1 2 3 55,000 40,000 22,000 22,000 44,000 44,000 35,000
Project A: IRR = 4%, Initial cost =100, NPV = 200 Project B: IRR = 14%, Initial cost =200, NPV = 230 Project C: IRR = 6%, Initial cost = 300, NPV = 300 Project D: IRR = 22%, Initial cost = 100, NPV = 260 If you can only choose 1 of the above projects above, which one should you choose? Project A Project B Project C Project D Not enough information to determine which project is preferred
Emusk Inc. is evaluating two mutually exclusive projects. The required rate of return on these projects is 8%. Calculate the profitability index for project A. (Round to 3 decimals) Year 0 1 2 3 4 5 Project A -15,000,000 2,000,000 3,000,000 5,000,000 5,000,000 6,000,000 Project B -15,000,000 6,000,000 6,000,000 6,000,000 1,000,000 1,000,000
3. You are analyzing the following two mutually exclusive projects and have developed the following Which information. Please calculate the IRRS for the two projects and the crossover rate. project should you accept if the cost of capital is 5%, and which project should you accept if the cost of capital is 10%? Year 0 1 3 Project A Cash Flow -$84,500 $29,000 $40,000 $27,000 IRR A: IRR B: Crossover Rate: If WACC-5%, accept If WACC=10%, accept Project B Cash Flow -$76,900 $25,000 $35,000 $26,000 J
"Consider the following two mutually-exclusive altematives: Project Alternatives n Project A1 Cash Flows Project A2 Cash Flows 0-514,000 1+$4,000 - $17,000 $21,000 2- 54,000 3-$12,000 If MARR=15% and assuming indefinite required service and repeatability, use the incremental NPV and IRR analyses in parts (a) and (b) of the problem, respectively, to choose the project in part (c). Please note that project alternatives A7 and A2 have different lives, namely three years for A1 and one year for A2. The alternatives should be compared over the same period, so project A2 will have to be repeated twice." axThe Net Present Value of the incremental investment is: YbrThe rternal Rate of Retun of the incremental investment is: (oWe shoulo choose project alternative: Note: Please enrer your onswvers to two decimal places. If using the interest factor method, apply the value of the factor os presented in the table or spreocsheet (with all four decimal places).
Mutually exclusive projects and NPV you have been assigned the task of evaluating two mutually exclusive projects with the following projected cash flows. year. Project A (cash flow) Project B 0 $(102,000) $(102,000) 1 31,000 0 2 31,000 0 3 31,000 0 4 31,000 0 5 31,000 240,000 if the appropriate discount rate on these is 11 percent, which would be chosen and why? the NPV of project A is $
The profitability analysis of three projects is provided below: Project A Project B Project C NPV $10,000 $5,000 - $1,000 IRR 10% 15% 15% WACC 8% 12% 16% If these projects were independent, which project(s) would be accepted? Why? If these projects were mutually exclusive, which project(s) would be accepted? Why?
Cooney Co. is evaluating the following mutually exclusive projects. The manager has determined that the appropriate discount rate is 6.20% for all the recommended projects. Rank order the projects based on the internal rate of return. Project A Project B Project C (35,000) (65,000) (86,000) 44,000 Year 0 1 2 3 55,000 40,000 22,000 22,000 44,000 35,000
An interior design studio is trying to choose between the following two mutually exclusive design projects: Year 0 1 2 3 Cash Flow Cash Flow (0) -$64,000 31,000 31,000 31,000 a-1 If the required return is 10 percent, what is the profitability index for both projects? (Round your answers to 3 decimal places. (e.g., 32.161)) Project I Project II -$18,000 9,700 9,700 9,700 Profitability Index a-2 If the company applies the profitability index decision rule, which project should the firm accept? O Project I O Project II Project I Project II b-1 What is the NPV for both projects? (Round your answers to 2 decimal places. (e.g., 32.16)) O Project I Project II NPV b-2lf the company applies the NPV decision rule, which project should it take?
Coore Manufacturing has the following two possible projects. The required return is 12 percent. Year Project Y Project Z 0 -$27,500 -$55,000 1 13,500 19,500 234 2 11,900 26,000 3 14,300 17,500 9,900 24,000 a. What is the profitability index for each project? (Do not round intermediate calculations and round your answers to 3 decimal places, e.g., 32.161.) b. What is the NPV for each project? (Do not round intermediate calculations and round your answers to 2 decimal places, e.g., 32.16.) c. Which, if either, of the projects should the company accept? a. Project Y Project Z 1.38 ง b. Project Y 3 decimal places required. Project Z c. Accept project x
The following information is available on two mutually exclusive projects. Project Year 0 Year 1 Year 2 Year 3 Year 4 A -$700 $200 $300 $400 $500 B -$700 $600 $300 $200 $100 If the required rate of return is 10%, which project should be selected using the net present value (NPV) method? Group of answer choices A B