Okay
  Public Ticket #1320054
Problem with the EMI Calculator
Closed

Comments

  •   pedrohoc started the conversation
  •  2,010
    Ocean replied

    HI,

    you can refer Amortization Calculator

    here: http://demo.oceanthemes.net/borrow/loan-amortization-calculator/

    you can change Amount , Interest, Down Payment, Term

    here: https://www.awesomescreenshot.com/image/2857062/d202fd638c886e4c32c920c03b98df68

  • pedrohoc replied

    What I mean is that the plugin's calculation does not match what it should be. Take a look at the link I gave you. The loan calculation is not correct. Do the calculation with these values that I passed to you. Calculate on both systems. The result should be $ 577.83 / month (which is correct) but is showing $ 428.93 / month (EMI Calculator and Amortization Calculator). Ps: Srry my poor English.

    "
    Look how I wish it were:: http://carteirarica.com.br/tabela-price/ 
    - Valor Financiado: Amount Financed ($ 10,000) 
    - Número prestações: Number of installments (24) 
    - Taxa Efetiva Mensal: Monthly Effective Rate (2.8%) 
    - Valor Prestação: Amount Provision – $ 577.83 (This is the amount that should be)"

  •  2,010
    Ocean replied

    Hi,

    Your mean is that our calculator does not suit you. So you can give us your formula. We'll try hefp for you.

    you can try again with Amortization Calculator

    here http://demo.oceanthemes.net/borrow/loan-amortization-calculator/

    i see the calculate of WP Amortization Calculator is correct.

  • pedrohoc replied

    The result of the amortization calculator is the same as that of the EMI calculator. You can check it out. I'm annoyed because I bought the theme just because of this function. I still puted a question there on the theme page about it before to buy.  If the Amortization Calculator works, it's fine for me! It would help! But as I said, it gives the same result as the EMI Calculator

    I would like you to help me about this situation. The formula EMI is attached.

    Legend:

    P -> Loan amount
    r -> monthly interest rate (= annual interest rate / 12/100)
    n -> loan duration in number of months

  •  2,010
    Ocean replied

    Hello,

    It's calculator exactly: 

    1, Example 1:

    https://codepen.io/michellelpepe/pen/MKjmPK

    http://prntscr.com/gtga4d

    - Monthly payment

    - Total payment

    - Total interest

    2, Example 2:

    http://fxcreditos.com.br/teste/officecred/home-loan/

    http://prntscr.com/gtgaah

    - Monthly payment

    - Total payment

    - Total interest

    3, You can let me know example:

    Amount of the loan ($): 15000

    Annual interest (%): 10% / 1 year

    Repayment period (years): 24 months

    Let me know your result:

    Monthly payment:

    Total payment:

    Total interest:

    4, If your problem can't resolved, I'll refund Borrow theme for you. and you can find and buy other theme for your webiste.

    Thank you

  • pedrohoc replied

    OK, sorry! You're right. It works perfectly. I was wrong, because I was putting the interest amount per month, and it's annual. I just wanted you to help me change that. Could you put the interest amount monthly instead of annually? And in the display of loan amounts (monthly, interest and amount), is it possible to change the comma per point (in the unit of thousands)? Thank you, mainly for your patience!

  •  2,010
    Ocean replied

    Hi,

    interest amount per month is calculated from the annual interest rate.(r -> monthly interest rate (= annual interest rate / 12/100)).

    This change is unnecessary. And this is custom problem.

    we have use comma per point in the unit of thousands

    please check again.http://demo.oceanthemes.net/borrow/loan-amortization-calculator/

  •  2,010
    Ocean replied

    Hello,

    Your loan calculator:

    Legend:

    P -> Loan amount 

    r -> monthly interest rate (= annual interest rate / 12/100) 

    n -> loan duration in number of months

    Our javascript code:

    <script type="text/javascript">
       (function($) {
            $(document).ready(function(){
                $("#la").bind(
                    "slider:changed", function (event, data) {              
                        $("#la_value").html(data.value.toFixed(0)); 
                        calculateEMI();
                    }
                );
                $("#nm").bind(
                    "slider:changed", function (event, data) {              
                        $("#nm_value").html(data.value.toFixed(0)); 
                        calculateEMI();
                    }
                );
                
                $("#roi").bind(
                    "slider:changed", function (event, data) {              
                        $("#roi_value").html(data.value.toFixed(2)); 
                        calculateEMI();
                    }
                );
                
                function calculateEMI(){
                    var loanAmount = $("#la_value").html();
                    var numberOfMonths = $("#nm_value").html();
                    var rateOfInterest = $("#roi_value").html();
                    var monthlyInterestRatio = (rateOfInterest/100)/12;
                    
                    var top = Math.pow((1+monthlyInterestRatio),numberOfMonths);
                    var bottom = top -1;
                    var sp = top / bottom;
                    var emi = ((loanAmount * monthlyInterestRatio) * sp);
                    var full = numberOfMonths * emi;
                    var interest = full - loanAmount;
                    var int_pge =  (interest / full) * 100;
                    $("#tbl_int_pge").html(int_pge.toFixed(2)+" %");
                    //$("#tbl_loan_pge").html((100-int_pge.toFixed(2))+" %");               
                    
                    var emi_str = emi.toFixed(2).toString().replace(/,/g, "").replace(/\B(?=(\d{3})+(?!\d))/g, ",");
                    var loanAmount_str = loanAmount.toString().replace(/,/g, "").replace(/\B(?=(\d{3})+(?!\d))/g, ",");
                    var full_str = full.toFixed(2).toString().replace(/,/g, "").replace(/\B(?=(\d{3})+(?!\d))/g, ",");
                    var int_str = interest.toFixed(2).toString().replace(/,/g, "").replace(/\B(?=(\d{3})+(?!\d))/g, ",");
                    
                    $("#emi").html(emi_str);
                    $("#tbl_emi").html(emi_str);
                    $("#tbl_la").html(loanAmount_str);
                    $("#tbl_nm").html(numberOfMonths);
                    $("#tbl_roi").html(rateOfInterest);
                    $("#tbl_full").html(full_str);
                    $("#tbl_int").html(int_str);                 
                }
                calculateEMI();
            });
        })(jQuery);
    </script>

    r -> monthly interest rate (= annual interest rate / 12/100) 

    var monthlyInterestRatio = (rateOfInterest/100)/12;
    

    Thank you

  • pedrohoc replied

    Okay, I'll leave it like this then. About the comma by dot in the thousands unit, I am referring to the plugin: EMI Calculator. I would use it. Can you change that?

    http://demo.oceanthemes.net/borrow/loan-calculator/

    Thank you in advance for your attention!

  •  2,010
    Ocean replied

    HI,

     About the comma by dot in the thousands unit. Now, loan amount in slider can't show comma by dot in the thousands unit.

    We'll test in our demo and update in future. 

    Or you can use calculator here: http://demo.oceanthemes.net/borrow/loan-amortization-calculator/

    thanks. 

  • pedrohoc replied

    Okay. I'll be waiting for this update.
    1- Another thing, I'm using the contact form of the home loan page. I would like to change the "$" symbol of the loan amount field, by the symbol "R$". How do I do?

    2- The form field slide does not work on mobile devices. How to fix this? (http://officecred.com.br/)

  •  2,010
    Ocean replied

    Hi,

    open file wp-content/theme/borrow/template-tag.php find "#amount"

    then change 

    $("#amount").val("$" + $("#slider-range-min").slider("value"));

    to

    $("#amount").val("R$" + $("#slider-range-min").slider("value"));

    2. you can send me screenshort about your problem.

  • pedrohoc replied

    Problem 2:

    For example, in the loan amount field has the slide to inform the value, right? On the desktop, this slide works perfectly, but on the mobile, this slide does not work well, because when we try to slide the field with your finger, the slide does not match the action, doesn't move!

    Url Page that has the form: www.officecred.com.br

    Problem 3: 

    I would like to add some function that assigns point and also comma in the values of that field (loan amount)

  •  2,010
    Ocean replied

    HI,

    2. You can point fingers on the slide or enter a value. it's like as our demo.

    3. Sorry, now impossible. we need test in our demo.