HW $5$ Spreadsheet Assignment$($Spreadsheet is the only acceptable submission format$)$ PLEASE SHOW IN EXCEL. I NEED TO KNOW HOW TO DO IT

$1.$ You are interested in buying a new machine that will increase the firm$$s revenues and decrease its costs. The machine costs $$125,000$ today $($time zero$).$ It will provide positive cash flows of $$40,000$ in year $1,$ $$35,000$ in year $2,$ $$40,000$ in year $3,$ and $$30,000$ in year $4.$ The firm$$s required rate of return $($WACC or k$)$ is $10\%.$ Calculate the NPV$,$ IRR, MIRR, P$.$I and payback period of the investment. Should we invest? $$

$2.$ You are interested in buying a new machine that will increase the firm$$s revenues and decrease its costs. The machine costs $$125,000$ today $($time zero$).$ It will provide positive cash flows of $$40,000$ for the first two years and $$50,000$ for year $3$ & $4.$ The firm$$s required rate of return $($k or WACC$)$ is $12\%.$ Calculate the NPV$,$ IRR, MIRR, P$.$I and payback period of the investment. Should we invest? $$

$3.$ You are interested in buying a new machine that will increase the firm$$s revenues and decrease its costs. The machine costs $$200,000$ today $($time zero$).$ It will provide positive cash flows of $$80,000$ in year $1,$ $$100,000$ in year $2$ and $$130,000$ in year $3$ and then a negative cash flow of $$50,000$ in year $4.$ The firm$$s required rate of return $($WACC or k$)$ is $9\%.$ Calculate the NPV$,$ IRR, MIRR, P$.$I and payback period of the investment. Should we invest?