Question: please solve only with excel formula. please show also the formula used. Parker & Stone, Inc., is looking at setting up a new manufacturing plant

please solve only with excel formula. please show also the formula used.
please solve only with excel formula. please show also the formula used.
Parker & Stone, Inc., is looking at setting up a new manufacturing

Parker & Stone, Inc., is looking at setting up a new manufacturing plant in South Park to produce garden tools. The company bought some land six years ago for $3.5 million in anticipation of using it as a warehouse and distribution site, but the company has since decided to rent these facilities from a competitor instead. If the land were sold today, the company would net $3.9 million. The company wants to build its new manufacturing plant on this land; the plant will cost $16.7 million to build, and the site requires $850,000 worth of grading before it is suitable f&construction. What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project? $ Purchase price Current value Cost to build Grading costs $ $ $ 3,500,000 3,900,000 16,700,000 850,000 Complete the following analysis. Do not hard code values in your calculations. Enter a "0" for any cost that should not be included. Current value Cost to build Grading costs Total cost +

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!