Please answer ASAP give me step by steps and take a closer look at each question be specific as much as you can I'll thumb up if you answer all parts of the question correctly also, please provide pictures it's an excel work:

Management is considering a project with outlays and returns as follows, yearly over an eightyear period: Outlay of $950 the first year (base case). Outlay of $250 the second year. Thereafter, profits yearly as follows: $400,$500,$650,$750,$900, and $1100. The discount rate is 5.25% a year. In an optimistic scenario, the outlay is only $900 the first year. In a pessimistic scenario, the outlay is $1050 the first year. Format currency amounts (both positive and negative [outlays]) appropriately. Note that in the data given here, in years 4 through 8 , each yearly profit is greater than that of the year before (years 3 through 7). It would be disconcerting if that were not the case. Therefore, if any of the 5 yearly profits (years 4 through 8 ) fails to exceed the profit of the previous year, that cell shall be bold italic. Apply data validation to make sure the initial outlay is negative and that the discount rate is between 2% and 12%. Research the =NPV function to find net present values of these 8 cash flows in each case. The comments made in class about how to insert functions and use function help will assist you, even if you have not used the =NPV function before. Prepare a lovely well-formatted Scenario Summary report presenting the three scenarios. Use Goal Seek to answer the question "Under what first year outlay would the net present value be $2000 ? Place this value in the upload comment box on Canvas when you upload the workbook containing your "working worksheet" and the lovely Scenario Summary sheet