please include both formulas that will work in excel, thank you.

Net present value-unequal lives Bunker Hill Mining Company has two competing proposals: a processing mill and an electric shovel. The following data is provided: DATA Net Cash Flow Processing Mill Electric Shovel $304,000 $349,000 253,000 316,000 253,000 321,000 246,000 322,000 280,000 172,000 126,000 149,000 149,000 4 (residual value) Initial investment 19 Minimum rate of return Using formulas and cell references, perform the required analysis, and input your answers into the Processing Mill and Electric Shovel 21 columns. Transfer the numeric results for the green entry cells (C24:D24) into the appropriate fields in CNOWV2 for grading. Processing Mill Electric Shovel Formulas Net present value