# Exponential Discounting of Cash Flows [closed]

I wonder for exponential discounting method to do the discount cash flow, may I doing it right as the following screenshot from Excel, assuming the discount rate is 4%?

Thanks!

• Why \$G\$8-C\$8 ? Shouldn't just be C\$8 ? – Alex C Feb 5 '17 at 23:17
• That's the part where I'm confused about, because it says tn = the time until the nth cash flow. – Paul Ellen Feb 5 '17 at 23:37
• The cash flows that are close to the present in time have to be discounted only a little, those that are far in time have to be discounted (reduced in value) more. You seem to be doing the opposite. – Alex C Feb 5 '17 at 23:52
• Then I suppose the following will be how it should be done? imgur.com/a/48ZX7 – Paul Ellen Feb 6 '17 at 0:05
• In discrete time with discrete compounding, the formula for the discount factor should be, using your notation: $\frac{1}{(1+r(t_n))^{t_n}}$. – Marie. P. Feb 6 '17 at 10:45

## 1 Answer

Then I suppose the following will be how it should be done?