Jump to content

excel PMT formula to PHP help ?


sasori

Recommended Posts

hi, how to convert this excel spreadsheet into PHP ?

 

 

B3 = principal = 1,934
B4 = interest flat rate = 15% fixed
B5 = tenor in months = 60 fixed
 
B10 = monthly = $46.01
 

 

the formula for cell B10 is 

 

 PMT(B4/12,B5,B3)

 

so how did the B10 became 46.01

Link to comment
Share on other sites

  • 3 months later...

Something like this?

function pmt($apr, $loanlength, $loanamount){
    $apr /= 1200;
    return ($apr * -$loanamount * pow((1 + $apr), $loanlength) / (1 - pow((1 + $apr), $loanlength)));
}

for 18%APR over 8 months on a principal of 1099
 

pmt(18, 8, 1099);

=146.80884303075

Link to comment
Share on other sites

Archived

This topic is now archived and is closed to further replies.

×
×
  • Create New...

Important Information

We have placed cookies on your device to help make this website better. You can adjust your cookie settings, otherwise we'll assume you're okay to continue.