***PLEASE PROVIDE EXCEL FORMULAS***

x) ? El X 1 Calculating relevant cash flows - Excel FORMULAS DATA REVIEW FILE HOME INSERT PAGE LAYOUT VIEW Sign In Calibri - 11 | R Paste BIU T % Alignment Number Conditional Format as Cell Formatting Table Styles Styles T Cells Editing Clipboard Font A1 fac A B C D E F G H 1 J 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? 4 5 6 7 Purchase price Current value Cost to build Grading costs $ $ $ $ 3,500,000 3,900,000 16,700,000 850,000 8 20 $ D 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. 14 15 Current value Cost to build Grading costs Total cost 16 17