can someone show how to do this in excel and please post formuals ?

thanks!

6/quizzes/141795/history?version=1 0/6 pts Question 10 Sandia corporation is considering two mutually exclusive projects. For our purposes, we will call them projects A and B. Project A is expected to cost $47,767, and project B is expected to cost $33,016. Each project's expected cash flows are presented below. Both project A and B have similar risks to all other projects at Sandia. And the weighted average cost of capital for Sandia is 14.81%. Calculate the net present value of both projects, and enter in the box below how much the value of the firm is expected to increase based on this capital budget (please enter the amount to the nearest penny). Year 1 Year 2 Project A $11,354 $11,381 $10,679 $14,601 $15,480 Project B $11,198 $11,783 $14,433 $10,210 $11,028 Year 3 Year 4 Year 5 ed 46.105.42 ver 6,618.51 margin of error +/-1