Question: please include excel formulas 3 Parker & Stone, Inc., is looking at setting up a new manufacturing plant in South Park to produce garden tools.

3 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 for construction. What is the proper cash flow amount to use as the initial investment in fixed assets when evaluating this project? 5 7 Purchase price Current value Cost to build Grading costs 8 $ 3,500,000 $ 3,900,000 $ 16,700,000 $ 850,000 6 9 10 11 12 13 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 14 15 16 Sheet1 Saved OD Calibri 11 100 de Paste M B IU- A % - A Alignment Number Conditional Format as Cell Formatting" Table Styles Styles f Cells Editing Clipboard Font A1 V X > B D E 4 F G G H 5 7 8 Purchase price Current value Cost to build Grading costs $ 3,500,000 $ 3,900,000 $ 16,700,000 $ 850,000 9 10 11 12 Complete the following analysis. Do not hard code values in your calculations. Enter a "0" for any cost that should not be included. 13 14 15 16 Current value Cost to build Grading costs Total cost oca 17 18
Step by Step Solution
There are 3 Steps involved in it
Get step-by-step solutions from verified subject matter experts
