The nominal interest rate usually refers to the interest rate before taking inflation into account. But, the nominal interest rate can also refer to the stated or advertised interest rate on a loan. Without taking into consideration any fees or compounding of interest, that is.<\/p>\n
Syntax<\/h3>\n
NOMINAL(effective_rate, periods_per_year)<\/strong><\/p>\n [\/et_pb_text][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n This is relatively a simple formula to master. Nevertheless, let us try our hands with a few examples as shown in the screenshot below. They help us attain more clarity as to how the formula behaves with a different set of input values.<\/p>\n [\/et_pb_text][et_pb_image src=”https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/NOMINAL-formula-Illustration-Frame-1.png” alt=”NOMINAL Interest Rate Formula” title_text=”nominal-formula” _builder_version=”4.16″ width=”640px” max_width=”640px” height=”440px” max_height=”440px” global_colors_info=”{}” theme_builder_area=”post_content”][\/et_pb_image][et_pb_text _builder_version=”4.16″ global_colors_info=”{}” theme_builder_area=”post_content”]<\/p>\n The NOMINAL interest rate formula is used on column D, whereas the columns A and B have the input source values on them. For ease of reference, we have included the formulas used on column E. They correspond to the adjacent output values on column D.<\/p>\n We will observe that the formula accepts numeric values. But from the snapshot above, we see that it has no problem accepting references to the cells that have these numeric values.<\/p>\n [\/et_pb_text][\/et_pb_column][\/et_pb_row][\/et_pb_section]<\/p>\n","protected":false},"excerpt":{"rendered":" With the\u00a0NOMINAL\u00a0interest rate formula\u00a0in Google Sheets, we can calculate the annual nominal interest rate. We just need to have an effective interest rate per annum and the number of compounding periods per year. The nominal interest rate usually refers to the interest rate before taking inflation into account. But, the nominal interest rate can also […]<\/p>\n","protected":false},"author":40,"featured_media":8317,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"_et_pb_use_builder":"on","_et_pb_old_content":"With the NOMINAL<\/a> formula in Google Sheets, we can calculate the annual nominal interest rate. We just need to have the effective interest rate per annum and the number of compounding periods per year.\n\nNominal interest rate usually refers to the interest rate before taking inflation into account. But, the nominal interest rate can also refer to the stated or advertised interest rate on a loan. Without taking into consideration any fees or compounding of interest, that is.\n\n
Usage: NOMINAL interest rate formula in Google Sheets<\/h3>\n
Syntax<\/h3>\nNOMINAL(effective_rate, periods_per_year)<\/strong>\n
\n \t
Usage: NOMINAL formula in Google Sheets<\/h3>\nThis is relatively a simple formula to master. Nevertheless, let us try our hands with a few examples as shown in the screenshot below. They help us attain more clarity as to how the formula behaves with a different set of input values.\n\n
![\"NOMINAL](\"https:\/\/static.sheetgo.com\/wp-content\/uploads\/2018\/05\/NOMINAL-formula-Illustration-Frame-1.png\")
\n\nThe NOMINAL formula is used on column D, whereas the columns A and B have the input source values on them. For ease of reference, we have included the formulas used on column E. They correspond to the adjacent output values on column D.\n\nWe will observe that the formula accepts numeric values. But from the snapshot above, we see that it has no problem accepting references to the cells that have these numeric values.","_et_gb_content_width":"","footnotes":""},"categories":[54],"tags":[39,28],"class_list":["post-8316","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-google-sheets-formulas","tag-connections-t","tag-spreadsheets"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8316","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/users\/40"}],"replies":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/comments?post=8316"}],"version-history":[{"count":0,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/posts\/8316\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media\/8317"}],"wp:attachment":[{"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/media?parent=8316"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/categories?post=8316"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.sheetgo.com\/es\/wp-json\/wp\/v2\/tags?post=8316"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}