### Calculating Discount Factors in Excel - Discount Factor Table

### CODES

Discount Rate. The Discount Rate, i%, used in the discount factor formulas is the effective rate per period.It uses the same basis for the period (annual, monthly, etc.) as used for the number of periods, n.If only a nominal interest rate (rate per annum or rate per year) is known, you can calculate the discount rate using the following formula:

*Actived: 4 days ago*

https://www.vertex42.com/ExcelArticles/discount-factors.html ^{}