Pitt Company is considering two alternative investments. The company requires a 12% return from its investments. Neither option has a salvage value. Project X Project Y Initial investment $244,049...


Pitt Company is considering two alternative investments. The company requires a 12% return from its investments. Neither option has a salvage value.














































Project X

Project Y
Initial investment$244,049$180,396
Net cash flows anticipated:
Year 183,00035,000
Year 259,00056,000
Year 391,00071,000
Year 482,00068,000
Year 577,00027,000


A.
Compute the IRR for both projects using the IRR spreadsheet function.













Project Xfill in the blank 1%
Project Yfill in the blank 2%


B.
Which project should be recommended.









Pitt Company is considering two alternative investments. The company requires a 12% return from its<br>investments. Neither option has a salvage value.<br>Project X<br>Project Y<br>Initial investment<br>$244,049<br>$180,396<br>Net cash flows anticipated:<br>Year 1<br>83,000<br>35,000<br>Year 2<br>59,000<br>56,000<br>Year 3<br>91,000<br>71,000<br>Year 4<br>82,000<br>68,000<br>Year 5<br>77,000<br>27,000<br>A. Compute the IRR for both projects using the IRR spreadsheet function.<br>Project X<br>%<br>Project Y<br>%<br>B. Which project should be recommended.<br>

Extracted text: Pitt Company is considering two alternative investments. The company requires a 12% return from its investments. Neither option has a salvage value. Project X Project Y Initial investment $244,049 $180,396 Net cash flows anticipated: Year 1 83,000 35,000 Year 2 59,000 56,000 Year 3 91,000 71,000 Year 4 82,000 68,000 Year 5 77,000 27,000 A. Compute the IRR for both projects using the IRR spreadsheet function. Project X % Project Y % B. Which project should be recommended.

Jun 03, 2022
SOLUTION.PDF

Get Answer To This Question

Related Questions & Answers

More Questions »

Submit New Assignment

Copy and Paste Your Assignment Here