Question: Wilson Properties is building a new processing plant. It will cost $8.5 mil and has the following cash flows per year: ($500,000), $2,000,000, $4,000,000, $4,500,000,

Wilson Properties is building a new processing plant. It will cost $8.5 mil and has the following cash flows per year: ($500,000), $2,000,000, $4,000,000, $4,500,000, and $7,500,000. The project will also require a working capital investment of $675,000 in year five. Ignore depreciation and salvage value and calculate the net present value at 12%. Use excel to get calculate the net present value.

(Please explain in steps how to figure out this problem using excel)

Step by Step Solution

There are 3 Steps involved in it

1 Expert Approved Answer
Step: 1 Unlock blur-text-image
Question Has Been Solved by an Expert!

Get step-by-step solutions from verified subject matter experts

Step: 2 Unlock
Step: 3 Unlock

Students Have Also Explored These Related Finance Questions!