Discounting rate excel

This query is : Resolved

Report Abuse Follow Query Ask a Query

kailash

kailash (Querist)
Follow

12 May 2014 how get discounting rates ans through excel

PRATIK AGRAWAL

PRATIK AGRAWAL (Expert)
Follow

14 May 2014 Here is the Formula:
Put the Interest rate in cell A1 for example the rate is 10% the Put 0.10

Then the formula follows
Cell A2- Then for Year 0 put 1
Cell A3- FOr year 1 formula is =A2/(1+$A$1)
Cell A4- For Year 2 FOrmula is = A3/(1+$A$1)

And then copy paste this till the end of year you want.

And now you can change the Rate of Interest in A1 cell and the Answer will change accordingly..

I have also uploaded a Excel file, to get it, go to Files tab, then search for Discounting rate in Excel, i believe it will be available by tomorrow.

Let me know if your query is Solved.. Ok