Can someone help me out with this problem?? I need to see excel formulas though. Thank you so much!

	Expected net cash flows
Time	Project A	Project B
0	($30)	($30)
1	$5	$20
2	$10	$10
3	$15	$8
4	$20	$6

Problem 5 Your division is considering two projects. Its WACC is 10%, and the projects' after-tax cash flows (in millions of dollars) would be as follows: Expected net cash flows Project B 530) $20 $10 $8 $6 Project A Time 0 $5 $10 $15 $20 4 a. Calculate the projects' NPVs, IRRs, regular paybacks. b. If the two projects are independent, which project(s) should be chosen? C. If the two projects are mutually exclusive and the WACC is 10%, which project(s) should be chosen