Please help me fill in red squares$($blue was given$).$ Need the formulas go type in$!$

Question $2$: Capital Budgeting

You are considering an Investment in two projects, A and $B.$ Both have an Initial cost of $$65,000,$ and the projected cash flows listed below.

$\backslash$table$[[$Year$,$Project $A,$Project B$],[0,$$$(65,000\mathrm{.}00),$$$(65,000\mathrm{.}00),],[1,$$$4,000\mathrm{.}00,$$$34,000\mathrm{.}00,],[2,$$$13,000\mathrm{.}00,$$$28,000\mathrm{.}00,],[3,$$$30,000\mathrm{.}00,$$$18,000\mathrm{.}00,],[4,$$$35,000\mathrm{.}00,$$$13,000\mathrm{.}00,],[5,$$$40,000\mathrm{.}00,$$$11,000\mathrm{.}00,]]$

Assuming the weighted average cost of capltal $($WACC$)$ is $12\%,$ calculate the payback period, discounted payback period, NPV$,$ and IRR. If the projects are mutually exclusive, which should be selected? $($You may use the white manoin ralle to inn adilitional ralruilatione if nareaceand

WACC

$12\%$

$\backslash$table$[[,$Project $A,$Project $B$