Foster Company wants to buy a special automated machine to replace an existing manual system. The outlay required is $3,500,000. Thenew machine will last 5 years with no expected salvage value. The expected annual cash flows are as follows: Foster has a cost of capital equal to 10K. 1. Cal culate the owback neriod. Must use a formula in the coll for wnas raleulation. It mainsi 2. Set up a table similar to the one in the Excel example file to show the calculations for the NPV (how you format it is up to you). You MUST thow the years, annual net cath flow, discount factor, present value, and final NPV. MUST use a formula in the cell for any calculations. (6 points) 3. Now anume that inflation over the s year useful life of the machineis expected to be 5% nach year. How would the company account for thisintlation percentage in their estimates? 2 points 4. Calculate the new net cash flow values for each year. Hint: infiation does not affect the outlay in year 0 . (3 points. MUST use a formula In the cell for your calculations) 5. Using the new net cash flow values in A4, create a table to find the new NPV. Same requirements for the table as m2. (6 points) 6. Accountine for infation is a necessty in any planking/bud geting decision. How does induding inflationary effects for this investment afect the company's decislon? Or does it not? Use the NPri you calculated to support your response. (2 noints )