please calculate IRR and MIRR using excel functions

D A B E F G Discounted Payback Project Evaluation Techniques 2 3 Discount Rate 20% Accumulated 4 Year Cash Flow Cash Payback Present Value 5 0 ($2,000) ($2,000) ($2,000) 6 1 $1,000 ($1,000) $833 7 2 $859 ($141) $597 8 3 $267 $126 3.12 $155 9 4 $340 $466 $164 10 5 $466 $932 $187 11 6 $516 $1,448 $173 12 7 $555 $2,003 $155 13 8 $615 $2,618 $143 14 9 $681 $3,299 $132 15 10 $715 $4,014 $115 16 Total $653.80 17 18 Net Present Value $653.80 use =NPV(...) function 19 Internal Rate of Return use =IRR(...) function 20 Modified IRR use =MIRRO...) function 21 20% financing rate 22 15% reinvestment rate Accumulated PV Cash ($2,000) ($1,167) (5570) ($416) ($252) ($64) $108 $263 $406 $538 $654 5.59