# tablepress/3.4/libraries/vendor/PhpSpreadsheet/Calculation/Financial/InterestRate.php

TablePress – Tables in WordPress made easy, version 3.4. 73 lines.

- Page: https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Financial/InterestRate.php
- Raw: https://pluginprobe.com/plugins/tablepress/3.4/raw/libraries/vendor/PhpSpreadsheet/Calculation/Financial/InterestRate.php
- Modified: 2026-09-30T03:50:46+00:00

Line numbers below start at 1. Link to a line or a range by appending a fragment to the
page URL, for example `https://pluginprobe.com/plugins/tablepress/3.4/code/libraries/vendor/PhpSpreadsheet/Calculation/Financial/InterestRate.php#L10-L20`.

```php
<?php

namespace TablePress\PhpOffice\PhpSpreadsheet\Calculation\Financial;

use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Exception;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Functions;
use TablePress\PhpOffice\PhpSpreadsheet\Calculation\Information\ExcelError;

class InterestRate
{
	/**
				 * EFFECT.
				 *
				 * Returns the effective interest rate given the nominal rate and the number of
				 *        compounding payments per year.
				 *
				 * Excel Function:
				 *        EFFECT(nominal_rate,npery)
				 *
				 * @param mixed $nominalRate Nominal interest rate as a float
				 * @param mixed $periodsPerYear Integer number of compounding payments per year
				 * @return string|float
				 */
				public static function effective($nominalRate = 0, $periodsPerYear = 0)
	{
		$nominalRate = Functions::flattenSingleValue($nominalRate);
		$periodsPerYear = Functions::flattenSingleValue($periodsPerYear);

		try {
			$nominalRate = FinancialValidations::validateFloat($nominalRate);
			$periodsPerYear = FinancialValidations::validateInt($periodsPerYear);
		} catch (Exception $e) {
			return $e->getMessage();
		}

		if ($nominalRate <= 0 || $periodsPerYear < 1) {
			return ExcelError::NAN();
		}

		return ((1 + $nominalRate / $periodsPerYear) ** $periodsPerYear) - 1;
	}

	/**
	 * NOMINAL.
	 *
	 * Returns the nominal interest rate given the effective rate and the number of compounding payments per year.
	 *
	 * @param mixed $effectiveRate Effective interest rate as a float
	 * @param mixed $periodsPerYear Integer number of compounding payments per year
	 *
	 * @return float|string Result, or a string containing an error
	 */
	public static function nominal($effectiveRate = 0, $periodsPerYear = 0)
	{
		$effectiveRate = Functions::flattenSingleValue($effectiveRate);
		$periodsPerYear = Functions::flattenSingleValue($periodsPerYear);

		try {
			$effectiveRate = FinancialValidations::validateFloat($effectiveRate);
			$periodsPerYear = FinancialValidations::validateInt($periodsPerYear);
		} catch (Exception $e) {
			return $e->getMessage();
		}

		if ($effectiveRate <= 0 || $periodsPerYear < 1) {
			return ExcelError::NAN();
		}

		// Calculate
		return $periodsPerYear * (($effectiveRate + 1) ** (1 / $periodsPerYear) - 1);
	}
}

```