@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
       $sip_amount = $amount;
       $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">One Time SIP Trail Calculation</h5>
                    <table class="table table-bordered text-center">
                        <tbody>
                        <tr>
                            <td align="left">
                                <strong>SIP Amount :</strong>
                            </td>
                            <td align="left">
                                ₹ {{custome_money_format($amount)}} /-
                            </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>AUM EOY</th>
                        </tr>
                        @php
                            $cumulative_brokerage_amount = 0;
                            $opening_monthly_balance = $sip_amount;
                            for ($i = 1; $i <= $period; $i++) {
                                $total_brokerage_amount = 0;
                                for ($j = 1; $j <= 12; $j++) {
                                    $monthly_return = $opening_monthly_balance * $monthly_expected_rate_return;
                                    $balance_eom_1 = $opening_monthly_balance + $monthly_return;
                                    $monthly_avg = ($opening_monthly_balance + $balance_eom_1)/2;
                                    $brokerage_amount = ($monthly_avg * $monthly_brokerage_rate) / 100;

                                    $cumulative_brokerage_amount = $cumulative_brokerage_amount + $brokerage_amount;
                                    $total_brokerage_amount += $brokerage_amount;
                                    $opening_monthly_balance = $balance_eom_1 + $sip_amount;
                                }
                        @endphp
                            <tr>
                                <td>{{$i}}</td>
                                <td>₹ {{custome_money_format($total_brokerage_amount)}}</td>
                                <td>₹ {{custome_money_format($cumulative_brokerage_amount)}}</td>
                                <td>₹ {{custome_money_format($balance_eom_1)}}</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