Provide the formulas that were computed in each cell, to receive the final answers 

A B 1 Project Evaluation Techniques 2 3 Discount Rate C D E 20% Accumulated PV Discounted Cash Payback Accumulated 4 Year Cash Flow Cash Payback Present Value 56 0 ($2,000) 1 $1,000 7 2 $859 8 3 $267 9 4 $340 10 5 $466 11 6 $516 12 7 $555 13 8 $615 14 9 $681 15 10 $715 16 Total 17 18 Net Present Value 19 Internal Rate of Return 20 Modified IRR 21 22 23 24 25 26 20% financing rate 15% reinvestment rate use =NPV(...) function use =IRR(...) function use =MIRR(...) function