@php //Numbers of month $number_of_months = $investment_period*12; //Monthly Debt return (1+T11%)^(1/12)-1 $monthly_debit_return = pow((1+$debt_fund/100),(1/12))-1; //Monthly Equity return (1+T12%)^(1/12)-1 $monthly_equity_return = pow((1+$equity_fund/100),(1/12))-1; $future_value_of_debt_fund = 0; $future_value_of_equity_fund = 0; $total_fund_value = 0; $irr = 0; if($monthly_transfer_mode=='CA'){ //Monthly Appreciation T8*AT41 $monthly_appreciation = $initial_investment*$monthly_debit_return; //Future Value of Debt Fund $future_value_of_debt_fund = $initial_investment; //Future Value of Equity Fund AT43*(((1+AT42)^(AT40)-1)/AT42) $future_value_of_equity_fund = $monthly_appreciation*((pow((1+$monthly_equity_return),$number_of_months)-1)/$monthly_equity_return); //Total Fund Value AT44+AT45 $total_fund_value = $future_value_of_debt_fund+$future_value_of_equity_fund; //IRR (AT46/T8)^(1/T9)-1 $irr = pow(($total_fund_value/$initial_investment),(1/$investment_period))-1; }else{ if(isset($fixed_transfer_mode) && $fixed_transfer_mode=='FP'){ //Monthly Switch T8*AC15% $monthly_switch = $initial_investment*($fixed_percent/100); }else{ //Monthly Switch T8*AC15% $monthly_switch = $fixed_amount; } $debt_transfer_amount = $monthly_switch; $debt_switch_amount = $monthly_switch; $equity_transfer_amount = $monthly_switch; $equity_switch_amount = $monthly_switch; $debt_balance = 0; $equity_eom_value = 0; $total_fund_value = 0; $irr = 0; for ($j=1;$j<=$number_of_months;$j++){ if ($j==1){ $debt_bom_value = $initial_investment; }else{ $debt_bom_value = $debt_balance; } // AS80+AS80*AT80 $debt_eom_value = $debt_bom_value+$debt_bom_value*$monthly_debit_return; if ($debt_eom_value>=$debt_transfer_amount){ $debt_monthly_transfer = $monthly_switch; }else{ $debt_monthly_transfer = 0; } if ($debt_switch_amount>0){ $debt_switch_amount = $debt_monthly_transfer; }else{ $debt_switch_amount =0; } //Balance AU80-AV80 $debt_balance = $debt_eom_value - $debt_switch_amount; //Equity Calculation if ($j==1){ $equity_bom_value = 0; }else{ $equity_bom_value = $equity_eom_value; } // BA80+BA80*BC80+BB80 $equity_eom_value = $equity_bom_value+$equity_bom_value*$monthly_equity_return+$debt_switch_amount; //Total Value AW80+BD80 $total_value = $debt_balance + $equity_eom_value; //IRR ((1+(BF80-BE80)/BE80))^(12/AZ80)-1 $irr = (pow(((1+($total_value-$initial_investment)/$initial_investment)),(12/$j))-1); } $future_value_of_debt_fund = $debt_balance; $future_value_of_equity_fund = $equity_eom_value; $total_fund_value = $future_value_of_debt_fund + $future_value_of_equity_fund; } @endphp

STP Investment @if(isset($clientname)) Proposal For {{$clientname?$clientname:''}} @else Planning @endif

Initial Investment

₹ {{custome_money_format($initial_investment)}}

Monthly Transfer Mode

@if($monthly_transfer_mode=='CA') Capital Appreciation @else @if(isset($fixed_transfer_mode) && $fixed_transfer_mode=='FP') {{$fixed_percent?number_format($fixed_percent, 2, '.', ''):0}} % of Initial Investment @else ₹ {{custome_money_format($fixed_amount)}} @endif @endif

Period

{{$investment_period?$investment_period:0}} Years

Expected Rate of Return

Debt Fund	{{$debt_fund?number_format($debt_fund, 2, '.', ''):0}} %
Equity Fund	{{$equity_fund?number_format($equity_fund, 2, '.', ''):0}} %

Expected Future Value

Debt Fund Value	₹ {{custome_money_format($future_value_of_debt_fund)}}
Equity Fund Value	₹ {{custome_money_format($future_value_of_equity_fund)}}
Total Fund Value	₹ {{custome_money_format($total_fund_value)}}
Annualised Returns	{{$irr?number_format($irr*100, 2, '.', ''):0}} %

* Mutual fund investments are subject to marker risks, read all scheme related documents carefully.
* Returns are not guaranteed. The above is for illustration purpose only.

@include('frontend.calculators.common.footer') @if(isset($report) && $report=='detailed')

Projected Annual Investment Value

@if($monthly_transfer_mode=='CA') @for($i=1;$i<=$investment_period;$i++) @php if ($i==1){ $equity_fund_value_at_the_begining_of_year = 0; }else{ $equity_fund_value_at_the_begining_of_year = $equity_fund_value_at_the_end_of_year; } //Equity Fund Value at the end of year AU79*(((1+AW79)^(AR79*12)-1)/AW79) $equity_fund_value_at_the_end_of_year = $monthly_appreciation*((pow((1+$monthly_equity_return),($i*12))-1)/$monthly_equity_return); //AT79+AX79 $total_value_at_the_end_of_the_year = $initial_investment+$equity_fund_value_at_the_end_of_year; //IRR (AY79/AS79)^(1/AR79)-1 $irr = (pow(($total_value_at_the_end_of_the_year/$initial_investment),(1/$i))-1)*100; @endphp @if($i%25==0 && $investment_period>25 && $investment_period>$i)

Year	Debt Fund Value at the beginning of year	Transfer to Equity every year	Equity Fund Value at the beginning of year	Equity Fund Value at the end of year	Total Value at the end of year (Debt+Equity)	IRR
{{$i}}	₹ {{$initial_investment?custome_money_format($initial_investment):0}}	₹ {{$monthly_appreciation?custome_money_format($monthly_appreciation*12):0}}	₹ {{$equity_fund_value_at_the_begining_of_year?custome_money_format($equity_fund_value_at_the_begining_of_year):0}}	₹ {{$equity_fund_value_at_the_end_of_year?custome_money_format($equity_fund_value_at_the_end_of_year):0}}	₹ {{$total_value_at_the_end_of_the_year?custome_money_format($total_value_at_the_end_of_the_year):0}}	{{$irr?number_format((float)$irr, 2, '.', ''):0}} %

@include('frontend.calculators.common.footer')

@endif @endfor @else @if(isset($fixed_transfer_mode) && $fixed_transfer_mode=='FP' || isset($fixed_transfer_mode) && $fixed_transfer_mode=='FA') @php $i = 1; $debt_transfer_amount = $monthly_switch; $debt_switch_amount = $monthly_switch; $equity_transfer_amount = $monthly_switch; $equity_switch_amount = $monthly_switch; $ech_counter = 13; $tmp_dbt_fnd_bgyear = 0; $tmp_transfer_to_equity_every_year = 0; $tmp_equity_fund_value_beg_of_year = 0; @endphp @for ($j=1;$j<=$number_of_months;$j++) @php if ($j==1){ $debt_bom_value = $initial_investment; }else{ $debt_bom_value = $debt_balance; } if (($ech_counter-12)==$j){ if ($j==1){ $tmp_dbt_fnd_bgyear = $initial_investment; $tmp_equity_fund_value_beg_of_year = 0; }else{ $tmp_dbt_fnd_bgyear = $debt_balance; $tmp_equity_fund_value_beg_of_year = $equity_eom_value; } } // AS80+AS80*AT80 $debt_eom_value = $debt_bom_value+$debt_bom_value*$monthly_debit_return; if ($debt_eom_value>=$debt_transfer_amount){ $debt_monthly_transfer = $monthly_switch; }else{ $debt_monthly_transfer = 0; } if ($debt_switch_amount>0){ $debt_switch_amount = $debt_monthly_transfer; }else{ $debt_switch_amount =0; } //Balance AU80-AV80 $debt_balance = $debt_eom_value - $debt_switch_amount; //Equity Calculation if ($j==1){ $equity_bom_value = 0; }else{ $equity_bom_value = $equity_eom_value; } // BA80+BA80*BC80+BB80 $equity_eom_value = $equity_bom_value+$equity_bom_value*$monthly_equity_return+$debt_switch_amount; //Total Value AW80+BD80 $total_value = $debt_balance + $equity_eom_value; //IRR ((1+(BF80-BE80)/BE80))^(12/AZ80)-1 $irr = (pow(((1+($total_value-$initial_investment)/$initial_investment)),(12/$j))-1)*100; $tmp_transfer_to_equity_every_year = $tmp_transfer_to_equity_every_year + $debt_switch_amount; @endphp @if($j%12==0) @php $ech_counter = $ech_counter+12; $tmp_transfer_to_equity_every_year = 0; $i++; @endphp @if($i%26==0 && $investment_period>26 && $investment_period>$i)

Year	Debt Fund Value at the beginning of year	Transfer to Equity every year	Equity Fund Value at the beginning of year	Equity Fund Value at the end of year	Total Value at the end of year (Debt+Equity)	IRR
{{$i}}	₹ {{custome_money_format($tmp_dbt_fnd_bgyear)}}	₹ {{custome_money_format($tmp_transfer_to_equity_every_year)}}	₹ {{custome_money_format($tmp_equity_fund_value_beg_of_year)}}	₹ {{custome_money_format($equity_eom_value)}}	₹ {{custome_money_format($debt_balance+$equity_eom_value)}}	{{$irr?number_format((float)$irr, 2, '.', ''):0}} %

@include('frontend.calculators.common.footer')

@endif @endif @endfor @endif @endif

Year	Debt Fund Value at the beginning of year	Transfer to Equity every year	Equity Fund Value at the beginning of year	Equity Fund Value at the end of year	Total Value at the end of year (Debt+Equity)	IRR

*Returns are not guaranteed. The above is for illustration purpose only. Report Date : {{date('d/m/Y')}}

@include('frontend.calculators.common.footer') @endif @include('frontend.calculators.suggested.pdf')