Please write out all excel functions for the first part and hand write the second part! I will give a thumbs up :)

Consider the following four options with each option having 10-year useful life. (a) Using Microsoft Excel, plot the PW functions for alternatives. Please include all the functions in one plot. (See Slides 59-70 in Lecture 8.) You must attach your Excel file to your submission. (If needed, you can watch a video that I have recorded showing how to plot an NPW function using Microsoft Excel. Please see the announcement for the link.) (b) Construct a choice table using your plot from the previous part. First cost Uniform annual benefit Salvage value $1000 125 B $800 120 C $600 100 D $500 125 750 500 2500 Consider the following four options with each option having 10-year useful life. (a) Using Microsoft Excel, plot the PW functions for alternatives. Please include all the functions in one plot. (See Slides 59-70 in Lecture 8.) You must attach your Excel file to your submission. (If needed, you can watch a video that I have recorded showing how to plot an NPW function using Microsoft Excel. Please see the announcement for the link.) (b) Construct a choice table using your plot from the previous part. First cost Uniform annual benefit Salvage value $1000 125 B $800 120 C $600 100 D $500 125 750 500 2500