Net Present Value & Payback Calculations (USE EXCEL SPREADSHEET & SHOW STEPS) Use 7% annual discount rate. French consid

[answerhappygod]

Net Present Value & Payback Calculations (USE EXCELSPREADSHEET & SHOW STEPS) Use 7% annual discountrate.
French considered the details of each option, keeping in mindthat for long-term projects he would use adiscount rate of 7%.Option 1: Purchase a New CNC Machine with CashAlthough it would be costly, the idea of adding a third CNC machineappealed to French. It would providehim peace of mind that if there were a breakdown, jobs wouldcontinue on schedule. French’s preliminaryresearch revealed that the cost of the new equipment would be$142,000. He also estimated that there wouldbe increased out-of-pocket operating costs of $10,000 per month ifa new machine were brought online. Afterfive years, the machine would have a salvage value of $40,000.Although Peregrine did not have the cashreadily available to make the purchase, French believed that with asmall amount of cash budgeting andplanning, this option would be feasible.
Please solve this all the parts because it is part of this onequestion.
Set up net cash flow over time (cash inflows minus cashoutflows)
Compute and compare the NPV and payback period of eachoption
Rounding to the nearest 1%, at what discount rate doesleasing produce a higher NPV than paying cash?