I just put this together for anyone needing to do CAGR calculations.
Here is the function:
function CAGR($start_year, $end_year, $start_amount, $end_amount){
$total_years = $end_year - $start_year;
echo pow(($end_amount/$start_amount),(1/$total_years))-1;
}
And here is a working file:
<?php
$start_year = $_POST['start_year'];
$end_year = $_POST['end_year'];
$start_amount = $_POST['start_amount'];
$end_amount = $_POST['end_amount'];
function CAGR($start_year, $end_year, $start_amount, $end_amount){
$total_years = $end_year - $start_year;
echo pow(($end_amount/$start_amount),(1/$total_years))-1;
}
if($_POST){
echo "CAGR = ";
echo CAGR($start_year, $end_year, $start_amount, $end_amount);
} else {
?>
<p>
<form action='index.php' method='post'>
start year: <input name='start_year' type='text'><br>
start amount: <input name='start_amount' type='text'><br><br>
end year <input name='end_year' type='text'><br>
end amount <input name='end_amount' type='text'><br><br><br>
<input type='submit' value='calculate CAGR'>
</form>
<?php
}
?>
Hope it helps someone