Homework Answers
|
IRR |
Acceptable? |
|
|
Project X1 |
21% |
Yes |
|
Project X2 |
12% |
Yes |
| Project X1 | Project X2 | ||||||||
| -86000 | Initial Investment | -132000 | Initial Investment | ||||||
| 28000 | 1 | 64500 | 1 | ||||||
| 38500 | 2 | 54500 | 2 | ||||||
| 63500 | 3 | 44500 | 3 | ||||||
| 21% | Internal Rate of Return | 12% | Internal Rate of Return | ||||||
Add Answer to:
Exercise 25-13A Internal rate of return LO P4 Following is information on two alternative investments being...
Check my work Exercise 24-13A Internal rate of return LO P4 Following is information on two...
Check my work Exercise 24-13A Internal rate of return LO P4 Following is information on two alternative investments being considered by Tiger Co. The company requires a 4% return from its investments. points Project x1 $(80,000) Project x2 $(120,000) eBook Initial investment Expected net cash flows in year: Print 25,000 35,500 60,500 60,000 50,000 40,000 References Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments Project X1 $ (116,000) Project X2 (192,000) Initial investment Expected net cash flows in year: 43,000 53,500 78,500 87,000 1 2 77,000 67,000 3 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) Acceptable? IRR...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being
considered by Tiger Co. The company requires a 7% return from its
investments.
Project X1
Project X2
Initial investment
$
(106,000
)
$
(172,000
)
Expected net cash flows in:
Year 1
38,000
79,500
Year 2
48,500
69,500
Year 3
73,500
59,500
Compute the internal rate of return for each of the projects using
Excel functions. Based on internal rate of return, indicate whether
each project is acceptable. (Round your answers to...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. Project x1 $(126,000) Project x2 $(212,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 48,000 58,500 83,500 94,500 84,500 74,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) IRR...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. Project X1 $ (126,000) Project X2 Initial investment $ (212,000) Expected net cash flows in 94,500 84,500 Year 1 48,000 Year 2 58,500 83,500 74,500 Year 3 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal...
any help on this would be great Saved Following is information on two alternative investments being...
any
help on this would be great
Saved Following is information on two alternative investments being considered by Tiger Co. The company requires a 8% return from its investments. Project x1 $(128,000) Project x2 $(216,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 49,000 59,500 84,500 96,000 86,000 76,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable....
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 8% return from its investments Project x1 $(1080) Project x2 $(176,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 39,000 49,500 74,500 81.000 71.888 61, Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) IRR...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 6% return from its investments. Project X1 Project X2 Initial investment $ (94,000 ) $ (148,000 ) Expected net cash flows in: Year 1 32,000 70,500 Year 2 42,500 60,500 Year 3 67,500 50,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable.
Exercise 26-17A Using Excel to compute IRR LO P4 Following is information on two alternative investments...
Exercise 26-17A Using Excel to compute IRR LO P4 Following is information on two alternative investments being considered by Jolee Company. The company requires a 11% return from its investments. Project A $(162, 000) Project B $(107,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 40, 500 56, 500 80, 795 90, 900 65,500 32,500 50, 500 66, 500 66,500 66,500 Compute the internal rate of return for each of the...
Following is information on two alternative investments being considered by Tiger Co. The company requires a...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project x1 $ (86,000) Project x2 $ (132,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 28,000 38,500 63,500 64,500 54,500 44,500 a. Compute each project's net present value. b. Compute each project's profitability...
Check my work Exercise 24-13A Internal rate of return LO P4 Following is information on two alternative investments being considered by Tiger Co. The company requires a 4% return from its investments. points Project x1 $(80,000) Project x2 $(120,000) eBook Initial investment Expected net cash flows in year: Print 25,000 35,500 60,500 60,000 50,000 40,000 References Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments Project X1 $ (116,000) Project X2 (192,000) Initial investment Expected net cash flows in year: 43,000 53,500 78,500 87,000 1 2 77,000 67,000 3 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) Acceptable? IRR...
Following is information on two alternative investments being
considered by Tiger Co. The company requires a 7% return from its
investments.
Project X1
Project X2
Initial investment
$
(106,000
)
$
(172,000
)
Expected net cash flows in:
Year 1
38,000
79,500
Year 2
48,500
69,500
Year 3
73,500
59,500
Compute the internal rate of return for each of the projects using
Excel functions. Based on internal rate of return, indicate whether
each project is acceptable. (Round your answers to...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. Project x1 $(126,000) Project x2 $(212,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 48,000 58,500 83,500 94,500 84,500 74,500 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) IRR...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. Project X1 $ (126,000) Project X2 Initial investment $ (212,000) Expected net cash flows in 94,500 84,500 Year 1 48,000 Year 2 58,500 83,500 74,500 Year 3 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal...
any
help on this would be great
Saved Following is information on two alternative investments being considered by Tiger Co. The company requires a 8% return from its investments. Project x1 $(128,000) Project x2 $(216,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 49,000 59,500 84,500 96,000 86,000 76,000 Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable....
Following is information on two alternative investments being considered by Tiger Co. The company requires a 8% return from its investments Project x1 $(1080) Project x2 $(176,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 39,000 49,500 74,500 81.000 71.888 61, Compute the internal rate of return for each of the projects using Excel functions. Based on internal rate of return, indicate whether each project is acceptable. (Round your answers to 2 decimal places.) IRR...
Exercise 26-17A Using Excel to compute IRR LO P4 Following is information on two alternative investments being considered by Jolee Company. The company requires a 11% return from its investments. Project A $(162, 000) Project B $(107,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 Year 4 Year 5 40, 500 56, 500 80, 795 90, 900 65,500 32,500 50, 500 66, 500 66,500 66,500 Compute the internal rate of return for each of the...
Following is information on two alternative investments being considered by Tiger Co. The company requires a 7% return from its investments. (PV of $1, FV of $1, PVA of $1, and FVA of $1) (Use appropriate factor(s) from the tables provided.) Project x1 $ (86,000) Project x2 $ (132,000) Initial investment Expected net cash flows in: Year 1 Year 2 Year 3 28,000 38,500 63,500 64,500 54,500 44,500 a. Compute each project's net present value. b. Compute each project's profitability...
Most questions answered within 3 hours.
-
Suppose that on a temperature scale X, water boils at 203.0°X
and freezes at -105.7°X. What...
asked 36 minutes ago -
BaS crystallizes in a cubic unit cell with S2- ions on each
corner and each face....
asked 1 hour ago -
A. 0≤P(Oi)≤10≤P(Oi)≤1 for each i
B. P(Oi)≤0P(Oi)≤0
C. P(Oi)=1+P(OCi)P(Oi)=1+P(OiC)
D. P(Oi)≥1P(Oi)≥1
If an experiment consists of...
asked 2 hours ago -
A battery has an emf of 9.20V and an internal resistance of 1.20
ohm. a)What resistance...
asked 2 hours ago -
The area of an elastic circular loop decreases at a constant
rate, dA/dt = −6.60×10−3 m2/s...
asked 3 hours ago -
The denaturation of proteins can be described by the
equilibrium
F⇌U
where F and U represent...
asked 5 hours ago -
Please answer what the maximum and minimum force is, and the
angle on the ion is...
asked 5 hours ago -
implement a program that reads a number of rows and a symbol.
The program will draw...
asked 5 hours ago -
Assume that when adults with smartphones are randomly selected,
45% use them in meetings or classes....
asked 5 hours ago -
Determine the number of formula units of
Na2SO4 and moles of oxygen contained in 8.11
moles...
asked 5 hours ago -
Explain in steps on the following code
What would be the output when executed
using System;...
asked 5 hours ago -
Given the information in the table, which of the following
statements is CORRECT?
Stock A
Stock...
asked 5 hours ago