Calculating relevant cash flows - Excel - OME INSERT PAGE LAYOUT FORMULAS DATA REVIEW VIEW S Calibri 11 A A % BIU- Alignment Number Cells Editing Conditional Format as Cell Formatting Table Styles Styles Font B D E F G H 1 J 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? 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. Catalin Sheet1 ADY Hampte 100% 1 of 10 !!! Next > 3 C D E F G H 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 Sheets SY Next