@extends('layouts.frontend')
@section('js_after')

@endsection
@section('content')
    <div class="banner">
        <div class="container">
            <div class="row">
                <div class="col-md-12 text-center">
                    <h2 class="page-title">TRAIL CALCULATORS</h2>
                </div>
            </div>
        </div>
    </div>

    @php
         $single_insurance_policy_premium = $_POST['single_insurance_policy_premium'];
         $commission_first_year = $_POST['commission_first_year'];
         $commission_second_year = $_POST['commission_second_year'];
         $one_time_investment_in_mf = $_POST['one_time_investment_in_mf'];

         $period = $_POST['period'];
         $expected_rate_return = $_POST['expected_rate_return'];
         $brokerage_rate = $_POST['brokerage_rate'];

         $monthly_expected_rate_return = (1+$expected_rate_return/100)**(1/12)-1;
         $monthly_brokerage_rate = $brokerage_rate / 12;
    @endphp
    <section  class="main-sec">
        <div id="content" class="container">
            <div class="row">
                <div class="col-md-12 text-center">
                    <a href="javascript:history.back()" class="btn btn-primary btn-round" ><i class="fa fa-angle-left"></i> Back</a>
                    <h5 class="mb-3 text-center">Single Insurance Policy vs One Time Lumpsum in Mutual Fund Trail Calculation</h5>
                    <table class="table table-bordered text-center">
                        <tbody>
                        <tr>
                            <td align="left">
                                <strong>Single Insurance Policy Premium :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($single_insurance_policy_premium)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Commission - 1st Year :</strong>
                            </td>
                            <td align="left">
                                {{$commission_first_year?number_format($commission_first_year, 2, '.', ''):0}} %
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Commission - 2nd Year Onwards :</strong>
                            </td>
                            <td align="left">
                                {{$commission_second_year?number_format($commission_second_year, 2, '.', ''):0}} %
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>One Time Investment in Mutual Fund :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($one_time_investment_in_mf)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Expected Rate Of Return In Mutual Fund :</strong>
                            </td>
                            <td align="left">
                                {{$expected_rate_return?number_format($expected_rate_return, 2, '.', ''):0}} %
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Trail Rate :</strong>
                            </td>
                            <td align="left">
                                {{$brokerage_rate?number_format($brokerage_rate, 2, '.', ''):0}} %
                            </td>
                        </tr>
                        </tbody>
                    </table>
                    <table class="table table-bordered text-center" style="background: #fff;">
                        <tbody>
                        <tr>
                            <th>Year</th>
                            <th>Insurance Annual Commission</th>
                            <th>Insurance Cumulative Commission</th>
                            <th>*MF Annual Trail</th>
                            <th>MF Cumulative Trail</th>
                            <th>Annual Difference</th>
                            <th>Cumulative Difference</th>
                            <th>*Mutual Fund AUM EOY</th>
                        </tr>
                        @php
                            $insurance_cumulative_commission = 0;
                                            $sip_boy_value = $one_time_investment_in_mf;
                                            $cumulative_brokerage_amount = 0;
                                            for ($i = 1; $i <= $period; $i++) {
                                                //insurance
                                                $single_insurance_premium = 0;
                                                $premium_2nd_year_onwards = $single_insurance_policy_premium;

												$investment_in_mf = 0;
                                                if($i == 1) {
                                                    $single_insurance_premium = $single_insurance_policy_premium;
                                                    $premium_2nd_year_onwards = 0;

													$investment_in_mf = $one_time_investment_in_mf;
                                                }
                                                $first_year_commission = $single_insurance_premium * ( $commission_first_year  / 100 );
                                                $second_year_onward_commission = $premium_2nd_year_onwards * ( $commission_second_year / 100 );
                                                $insurance_annual_commission = $first_year_commission + $second_year_onward_commission;
                                                $insurance_cumulative_commission += $insurance_annual_commission;

                                                //MF
                                                $return = $sip_boy_value * ( $expected_rate_return / 100 );
                                                $sip_eoy_value = $sip_boy_value + $return;
                                                $avg = ($sip_boy_value + $sip_eoy_value)/2;
                                                $sip_brokerage_amount = ($avg * $brokerage_rate) / 100;
                                                $cumulative_brokerage_amount += $sip_brokerage_amount;


                                                //new values sip
                                                $sip_boy_value = $sip_eoy_value;
                                $tmp_ad = $sip_brokerage_amount - $insurance_annual_commission;
                                $tmp_cd = $cumulative_brokerage_amount - $insurance_cumulative_commission;
                        @endphp
                            <tr>
                                <td>{{$i}}</td>
                                <td>₹ {{custome_money_format($insurance_annual_commission)}}</td>
                                <td>₹ {{custome_money_format($insurance_cumulative_commission)}}</td>
                                <td>₹ {{custome_money_format($sip_brokerage_amount)}}</td>

                                <td>₹ {{custome_money_format($cumulative_brokerage_amount)}}</td>
                                {{--<td>₹ {{preg_replace("/(\d+?)(?=(\d\d)+(\d)(?!\d))(\.\d+)?/i", "$1,",round($tmp_ad))}}</td>--}}
                                <td>₹ {{custome_money_format($tmp_ad)}}</td>
                                {{--<td>₹ {{custome_money_format($total_brokerage_amount - $annual_insurance_commission)}}</td>--}}
                                {{--<td>₹ {{custome_money_format($cumulative_brokerage_amount - $insurance_cumulative_commission)}}</td>--}}
                                {{--<td>₹ {{preg_replace("/(\d+?)(?=(\d\d)+(\d)(?!\d))(\.\d+)?/i", "$1,",round($tmp_cd))}}</td>--}}
                                <td>₹ {{custome_money_format($tmp_cd)}}</td>
                                <td>₹ {{custome_money_format($sip_eoy_value)}}</td>
                            </tr>
                        @php
                        }
                        @endphp
                        </tbody>
                    </table>
                    <p style="text-align: left; margin-top: 20px;">
                        * The above is for illustration purpose only. The actual figures may vary. <br>
                        * It is assumed that Sales is made on the 1st day of the month and evenly distributed throughout the year.
                    </p>
                    <a href="javascript:history.back()" class="btn btn-primary btn-round" ><i class="fa fa-angle-left"></i> Back</a>

                </div>
            </div>
        </div>
        <div class="btm-shape-prt">
            <img class="img-fluid" src="{{url('/')}}/f/images/shape2.png" alt="">
        </div>
    </section>

@endsection