# 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!

## closed as off-topic by LocalVolatility, Alex C, Quantuple, Luigi Ballabio, Bob Jansen♦Feb 6 '17 at 13:13

This question appears to be off-topic. The users who voted to close gave this specific reason:

• "Basic financial questions are off-topic as they are assumed to be common knowledge for those studying or working in the field of quantitative finance." – LocalVolatility, Alex C, Quantuple, Luigi Ballabio, Bob Jansen
If this question can be reworded to fit the rules in the help center, please edit the question.

• 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