Talk:Documentation/Calc Functions/NOMINAL
SF Comments
- (1) Summary. Suggest replacing with “Calculates the nominal interest rate, given the effective rate and the number of compounding periods”.
- (2) Returns. Insert “decimal” before “fraction”. Delete “annual”. Maybe state that the default formatting is as a percentage, while the Excel NOMINAL function does not return the value formatted as a percentage?
- (3) Arguments, Effective Rate. Insert “decimal” before “fraction”.
- (4) Arguments, NPerY. Change “whole number” to “integer”.
- (5) Additional details. Consider link to Wikipedia’s “Nominal interest rate” page.
- (6) Additional details. The somewhat simpler formula in the code is = ( POWER( Effective Rate + 1.0, 1.0 / NPerY ) - 1.0 ) * NPerY;. Perhaps change to use this one?
- (7) Additional details. May be worth stating that the calculation assumes that interest is credited at the end of exactly equal periods.
--Stevefanning (talk) 2020-11-20T19:07:01 (UTC)