Please answer with excel showing all the formulas

Cla Lab 10(1) (1) - Microsoft Excel Home Insert Page Layout Formulas Data Review View Developer Foxit PDF QuickBooks X AutoSum - Calibri 11 General Comma 3 Normal 2 Normal 3 AL Wrap Text Merge & Center Fill - BIU $ - % % .00 Normal Cut E) Copy Paste Format Painter Clipboard 023 Bad Good Insert Delete Format Conditional Format Formatting as Table - Clear Sort & Find & Filter Select Font Alignment Number 5 Styles Cells Editing fac A B C D E F G H 1 K L M N 0 P 1 2 Your firm is considering two projects with the following cash flows. 3 WACC 12% 12% 4 5 year 0 1 6 7 2 8 3 3 4 Project A -55,000 15,000 14,000 13,000 11,000 10,000 9,500 8,500 7,500 Project B -70,000 20,000 18,000 16,000 14,000 12,000 10,000 10,000 9,000 9 10 5 11 12 6 7 8 S 13 14 15 Calculate NPV and IRR for both projects 16 NPV 17 IRR Based on the findings above, should you 18 accept the project respectively? 19 20 21 22 III Ho Sheet1 Ready @ 100% +