@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
        $lumpsum_business_month = $lumpsum_business_month;
        $new_sip_month = $new_sip_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;
        $cumulative_brokerage = 0;
        $cumulative_sip_eoy = 0;
    @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">Monthly Lumpsum + Monthly New SIP Trail Calculation</h5>
                    <table class="table table-bordered text-center">
                        <tbody>
                        <tr>
                            <td align="left">
                                <strong>Net Lumpsum Sales Every Month :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($lumpsum_business_month)}} /-
                            </td>
                        </tr>
                        <tr>
                            <td align="left">
                                <strong>New SIP Every Month :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($new_sip_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>Total Annual Trail</th>
                            <th>Cumulative Trail</th>
                            <th>Cumulative SIP EOY</th>
                            <th>AUM from Lumpsum EOY</th>
                            <th>AUM from SIP EOY</th>
                            <th>Total AUM EOY</th>
                        </tr>
                        @php
                            //sip calculation
                             $sip_bom_value = $new_sip_month;

                             //lumpsum calculation
                             $lumpsum_bom_value = $lumpsum_business_month;
                             $month_counter = 1;
                             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;

                                     $cumulative_sip_eoy += $new_sip_month;

                                     //new values sip
                                     $sip_bom_value = $sip_eom_value + $new_sip_month;
                                     $sip_bom_value += ($new_sip_month * $month_counter);
                                     $month_counter++;
                                     //new values lumpsum
                                     $lumpsum_bom_value = $lumpsum_eom_value + $lumpsum_business_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($cumulative_sip_eoy)}}</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 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