ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Are financial functions calculated based on compound interest? (https://www.excelbanter.com/excel-worksheet-functions/8569-financial-functions-calculated-based-compound-interest.html)

KDR

Are financial functions calculated based on compound interest?
 
I am particularly interested in if NPV, PMT, and PPMT are calculated with
compound interest or simple interest?
If simple interest, then how can I get the results for compound interest?

Thank you.


Chip Pearson

Compound interest.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com

"KDR" wrote in message
...
I am particularly interested in if NPV, PMT, and PPMT are
calculated with
compound interest or simple interest?
If simple interest, then how can I get the results for compound
interest?

Thank you.





All times are GMT +1. The time now is 04:35 PM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com