Last active
October 8, 2024 12:26
-
-
Save pranid/c4f44eff085ae5646e6e52460b15d33e to your computer and use it in GitHub Desktop.
Amortization Schedule Example -- PHP Version
This file contains bidirectional Unicode text that may be interpreted or compiled differently than what appears below. To review, open the file in an editor that reveals hidden Unicode characters.
Learn more about bidirectional Unicode characters
<?php | |
/** | |
* AMORTIZATION CALCULATOR | |
* @author PRANEETH NIDARSHAN | |
* @version V1.0 | |
*/ | |
class Amortization | |
{ | |
private $loan_amount; | |
private $term_years; | |
private $interest; | |
private $terms; | |
private $period; | |
private $currency = "XXX"; | |
private $principal; | |
private $balance; | |
private $term_pay; | |
public function __construct($data) | |
{ | |
if($this->validate($data)) { | |
$this->loan_amount = (float) $data['loan_amount']; | |
$this->term_years = (int) $data['term_years']; | |
$this->interest = (float) $data['interest']; | |
$this->terms = (int) $data['terms']; | |
$this->terms = ($this->terms == 0) ? 1 : $this->terms; | |
$this->period = $this->terms * $this->term_years; | |
$this->interest = ($this->interest/100) / $this->terms; | |
$results = array( | |
'inputs' => $data, | |
'summary' => $this->getSummary(), | |
'schedule' => $this->getSchedule(), | |
); | |
$this->getJSON($results); | |
} | |
} | |
private function validate($data) { | |
$data_format = array( | |
'loan_amount' => 0, | |
'term_years' => 0, | |
'interest' => 0, | |
'terms' => 0 | |
); | |
$validate_data = array_diff_key($data_format,$data); | |
if(empty($validate_data)) { | |
return true; | |
}else{ | |
echo "<div style='background-color:#ccc;padding:0.5em;'>"; | |
echo '<p style="color:red;margin:0.5em 0em;font-weight:bold;background-color:#fff;padding:0.2em;">Missing Values</p>'; | |
foreach ($validate_data as $key => $value) { | |
echo ":: Value <b>$key</b> is missing.<br>"; | |
} | |
echo "</div>"; | |
return false; | |
} | |
} | |
private function calculate() | |
{ | |
$deno = 1 - 1 / pow((1+ $this->interest),$this->period); | |
$this->term_pay = ($this->loan_amount * $this->interest) / $deno; | |
$interest = $this->loan_amount * $this->interest; | |
$this->principal = $this->term_pay - $interest; | |
$this->balance = $this->loan_amount - $this->principal; | |
return array ( | |
'payment' => $this->term_pay, | |
'interest' => $interest, | |
'principal' => $this->principal, | |
'balance' => $this->balance | |
); | |
} | |
public function getSummary() | |
{ | |
$this->calculate(); | |
$total_pay = $this->term_pay * $this->period; | |
$total_interest = $total_pay - $this->loan_amount; | |
return array ( | |
'total_pay' => $total_pay, | |
'total_interest' => $total_interest, | |
); | |
} | |
public function getSchedule () | |
{ | |
$schedule = array(); | |
while ($this->balance >= 0) { | |
array_push($schedule, $this->calculate()); | |
$this->loan_amount = $this->balance; | |
$this->period--; | |
} | |
return $schedule; | |
} | |
private function getJSON($data) | |
{ | |
header('Content-Type: application/json'); | |
echo json_encode($data); | |
} | |
} | |
$data = array( | |
'loan_amount' => 20000, | |
'term_years' => 1, | |
'interest' => 10, | |
'terms' => 12 | |
); | |
$amortization = new Amortization($data); | |
?> |
good work, but some time no result shown. i.e. if interest=2.5 or 7.5 or 12 or 12.5 or 14
$data = array(
'loan_amount' => 20000,
'term_years' => 1,
'interest' => 7.5,
'terms' => 12,
);
$amortization = new Amortization($data);
The calculations give a balance greater than 0.
Solved this by changing the loop to work with the term instead of the balance. Like
$i = 1;
while ($i <= $this->terms) {
array_push($schedule, $this->calculate());
$this->loan_amount = $this->balance;
$this->period--;
$i++;
}
How can I rewrite this using vanilla php? Am looking for this kind of solution for the last 1 week now.
How can I rewrite this using vanilla php? Am looking for this kind of solution for the last 1 week now.
What do you mean vanilla php? the script is php only.
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
good work, but some time no result shown. i.e. if interest=2.5 or 7.5 or 12 or 12.5 or 14
$data = array(
'loan_amount' => 20000,
'term_years' => 1,
'interest' => 7.5,
'terms' => 12,
);
$amortization = new Amortization($data);