Comprehensive Spreadsheet Problem 11-23, page 40S) Your division is considering two projects. Its WACC is 10%, and the projects of dollars) would be as follows: Time period:0 after-tax cash flows (in millions Cash flow: Cumulative cash flow: Cash Flows Paybacka: Time Project A Project B ($30) S20 S10 S8 S6 S5 S10 S15 S20 Time period:0 Cash flow: Cumulative cash flow: Paybacks: a. Calculate the projects' NPVs, IRRs, MIRRs, regular paybacks, and discounted paybacks. 100% S7.04 S5.96 Use Excel's NPV function as explained in 11modeliss. Note that r the initial costs, which are added separately NPVA Discounted Pavyback t the range does not include Time period:0 Cash flo Disc. cash flow: Disc. cum. cash flow: We find the internal rate of return with Excel's IRR function: IRRA- IRRB 19.19 22.52 % Discounted Paybacka We find the modified internal rate of return with Excel's MIRR function usin the 10% WACC: MIRRA = 16.500 MIRRB- Time period: 0 15.57% Cash flom Disc. cash flow: Disc. cum. cash flow: Discounted PaybackB