How to Calculate a Discount Rate in Excel
Reviewed by Thomas J. Catalano Fact checked by Vikki Velasquez The discount rate refers to the interest rate used when ...
Calculating the Dollar Value of Basis Points in Excel
Reviewed by Charles Potters In the fixed income market, each financial instrument’s smallest increment of movement is called ...
JournalofAccountancy23d
Using Excel’s What-If Analysis with Data Table for data analysis
Other versions of Excel may work differently. For this example, we want to determine the monthly payment on a loan, but we are unsure about the interest rate. We want to see how the payment changes as ...
Investopedia2y
How to Calculate a Discount Rate in Excel
The Excel formula for calculating the discount rate is =RATE (nper, pmt, pv, [fv], [type], [guess]). It’s often used to calculate the interest rate for a loan or determine the rate of return ...