Best writers. Best papers. Let professionals take care of your academic papers

Order a similar paper and get 15% discount on your first order with us
Use the following coupon "FIRST15"
ORDER NOW

ABC Company’s management is also considering 3 new projects consisting of the purchase of new equipment.

/in /by

ABC Company’s management is also considering 3 new projects consisting
of the purchase of new equipment. The company has limited resources, and may not be able to complete/make all 3 purchases. Therefore, calculate the NPV for each, and place the projects in the order in which they should be completed using NPV as the reasoning. The information is as follows for the purchases below.

Project 1
Project 2
Project 3
Purchase Price
$80,000
$175,000
$22,700
Required Rate of Return
6%
8%
12%
Time Period
3 years
5 years
2 years
Cash Flows – Year 1
$48,000
$85,000
$13,000
Cash Flows – Year 2
$36,000
$74,000
$13,000
Cash Flows – Year 3
$22,000
$38,000
N/A
Cash Flows – Year 4
N/A
$26,800
N/A
Cash Flows – Year 5
N/A
$19,000
N/A

Using Excel formulas, calculate the NPV for each of the 3 potential projects.

 
Looking for a Similar Assignment? Order now and Get 10% Discount! Use Coupon Code "Newclient"