Please help solve with formulas if possible.

Foster Company wantsto buy a special automated muchine to replace an existing manual system. The initial outlay (cose) is $3,500,000. The new machine will latt 5 years with no eapected salvage value. The expected annual cash flows are as follow: Foster has a cout of capital equal to 10x 2. Set up a table similur to the one in the Excel ecimple file to show the calculations for the NPV (how you format it is up to you), You MUST show the years, anmual net cant Sow, dincount factoc, present value, and final NPV. MUST use a formula in the ced for any calculutions. (6 points) 3. Now assume that int ation is estimated as a 5$ increase each year (starting with Veur 1) for the entire 5 vears. Calculate the new net. foryourcalculatioens