File Coverage

lib/Spreadsheet/Engine/Function/PMT.pm

Criterion	Covered	Total	%
statement	15	15	100.0
branch	4	4	100.0
condition	2	2	100.0
subroutine	5	5	100.0
pod	2	2	100.0
total	28	28	100.0

package Spreadsheet::Engine::Function::PMT;

use strict;
use warnings;

use base 'Spreadsheet::Engine::Fn::investment';

sub signature { 'n', '!=0', 'n', 'n', 'n' }

sub calculate {
  my ($self, $rate, $n, $pv, $fv, $type) = @_;
  $fv ||= 0;
  $type = $type ? 1 : 0;

  return ($fv - $pv) / $n if $rate == 0;
  return (0 - $fv - $pv * (1 + $rate)**$n) /
    ((1 + $rate * $type) * ((1 + $rate)**$n - 1) / $rate);
}

1;

__END__