(The exact formulas are also included in the table below.) For ease of auditing ... back the initial investment after discounting cash flows. In Excel, create a cell for the discounted rate ...