please do the work in Excel and show calculations. thank you!

The projects provide a necessary service, so whichever one is selected is expected to be repeated into the foreseeable future. Both projects have an 11% cost of capital. Now apply the replacement chain approach to determine the shorter projects' extended NPV. Which project should be chosen? Now assume that the cost to replicate Project Y in 2 years will increase to $240,000 because of inflationary pressures. How should the analysis be handled now, and which project should be chosen? You are also considering another project which has a physical life of 3 years; that is, the machinery will be totally worn out after 3 years. However, if the project were terminated prior to the end of 3 years, the machinery would have a positive salvage value. Here are the project's estimated cash flows