@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
         $current_aum = $current_aum;
         $lumpsum_business_every_month = $lumpsum_business_every_month;
         $current_sip = $current_sip;
         $new_sip_every_month = $new_sip_every_month;
         $period = $period;
         $expected_rate_return = $expected_rate_return;
         $brokerage_rate = $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">Current AUM & SIP + Monthly New Lumpsum & SIP</h5>
                    <table class="table table-bordered text-center">
                        <tbody>
                        <tr>
                            <td align="left">
                                <strong>Current AUM :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($current_aum)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Net Lumpsum Sales Every Month :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($lumpsum_business_every_month)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Current SIP :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($current_sip)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>New SIP Every Month :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($new_sip_every_month)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>Rate of Return :</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>Annual Trail</th>
                            <th>Cumulative Trail</th>
                            <th>Lumpsum AUM EOY</th>
                            <th>SIP AUM EOY</th>
                            <th>Total AUM EOY</th>
                        </tr>
                        @php
                            //sip calculation
                            $sip_bom_value = $current_sip + $new_sip_every_month;

                            //lumpsum calculation
                            $lumpsum_bom_value = $current_aum + $lumpsum_business_every_month;
                            $month_counter = 1;
                            $cumulative_brokerage = 0;
                            for ($i = 1; $i <= $period; $i++) {
                                $total_brokerage_amount = 0;
                                for ($j = 1; $j <= 12; $j++) {
                                    //sip
                                    $monthly_return = $sip_bom_value * $monthly_expected_rate_return;
                                    $sip_eom_value = $sip_bom_value + $monthly_return;
                                    $monthly_avg = ($sip_bom_value + $sip_eom_value)/2;
                                    $sip_brokerage_amount = ($monthly_avg * $monthly_brokerage_rate) / 100;

                                    //lumpsum
                                    $monthly_return = $lumpsum_bom_value * $monthly_expected_rate_return;
                                    $lumpsum_eom_value = $lumpsum_bom_value + $monthly_return;
                                    $monthly_avg = ($lumpsum_bom_value + $lumpsum_eom_value)/2;
                                    $lumpsum_brokerage_amount = ($monthly_avg * $monthly_brokerage_rate) / 100;

                                    $total_brokerage = $sip_brokerage_amount + $lumpsum_brokerage_amount;
                                    $total_brokerage_amount += $total_brokerage;
                                    $cumulative_brokerage += $total_brokerage;

                                    //new values sip
                                    $month_counter++;
                                    $sip_bom_value = $sip_eom_value + ($new_sip_every_month * $month_counter) + $current_sip;
                                    //new values lumpsum
                                    $lumpsum_bom_value = $lumpsum_eom_value + $lumpsum_business_every_month;
                                }
                        @endphp
                            <tr>
                                <td>{{$i}}</td>
                                <td>₹ {{custome_money_format($total_brokerage_amount)}}</td>
                                <td>₹ {{custome_money_format($cumulative_brokerage)}}</td>
                                <td>₹ {{custome_money_format($lumpsum_eom_value)}}</td>
                                <td>₹ {{custome_money_format($sip_eom_value)}}</td>
                                <td>₹ {{custome_money_format($lumpsum_eom_value + $sip_eom_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 the new Investment  and SIP is started on the 1st day of the month.
                    </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