Sunday, July 15, 2018

106-Detailed EMI Statement maker

Purpose/Objectives

Purpose of this tool is to help users to verify EMI account statement with the bank’s EMI account statement. This tool can help users to prevent bank fraudulence if any. Features like the variable rate of interest, part payment made and skip of any EMI allow the users to analyze their loan easily.

Overview

For any loan taken, we must repay it with equated monthly installments called as EMI. This tool requires limited information like the opening balance of a loan, rate of interest, EMI amount, part payment amounts if any and the details of EMI skipped if any as input. Based on the information this tool will give the entire EMI account statement like the Opening balance of a loan, its interest, the principal amount reduced due to EMI and part payment made and closing balance for that respective month.

An educational loan of amount 3394016 is taken at an interest in 13 % pa with an EMI of 55747. EMI started from Oct-2016. Part payment of 125000 is made in Oct-2016. Then the splitting of EMI 55747 on a loan amount 3394016 at the rate of interest of 13 % per annum for Oct-2016 is 36769 (interest) and 18978 (principal amount). Here the principal amount is reduced by 143978 (125000+18978), so the new closing balance for Oct-2016 is 3250038. See the following diagram.


In Dec-2016 and Feb-2017, these two EMIs were not paid, so they are reflected in the statement. EMI of Dec-2016 was paid in May-2017 is reflected on the month May-2017. So, the total of EMI for the month May-2017 (55747) and EMI of Dec-2016 (55747) 111494 is reflected in the month of May-2017. An interest in 55747 for 5 months (Dec-16 to May-2017) at 18% interest in EMI skipped with a penalty for 427 is also reflected on this sheet for all such charges for this year.

This tool takes care of all the criteria such as:
1)      Change in EMI.
2)      Change in rate of interest.
3)      Part payment of a loan.
4)      If any EMI is skipped.
5)      The charges and interest for skipped EMI.

This interactive tool for calculating the entire EMI account statement will help all of us to verify it with the loan provider company.

3 comments:


  1. Do you need Personal Loan?
    Business Cash Loan?
    Unsecured Loan
    Fast and Simple Loan?
    Quick Application Process?
    Approvals within 24-72 Hours?
    No Hidden Fees Loan?
    Funding in less than 1 Week?
    Get unsecured working capital?
    Contact Us At :oceancashcapital@gmail.com
    Phone number :+16474864724 (Whatsapp Only)

    LOAN SERVICES AVAILABLE INCLUDE:
    ================================
    *Commercial Loans.
    *Personal Loans.
    *Business Loans.
    *Investments Loans.
    *Development Loans.
    *Acquisition Loans .
    *Construction loans.
    *Credit Card Clearance Loan
    *Debt Consolidation Loan
    *Business Loans And many More:

    LOAN APPLICATION FORM:
    =================
    Full Name:................
    Loan Amount Needed:.
    Purpose of loan:.......
    Loan Duration:..
    Gender:.............
    Marital status:....
    Location:..........
    Home Address:..
    City:............
    Country:......
    Phone:..........
    Mobile / Cell:....
    Occupation:......
    Monthly Income:....

    Contact Us At oceancashcapital@gmail.com
    Phone number :+16474864724 (Whatsapp Only)

    ReplyDelete
  2. Do you need Finance?
    Are you looking for Finance?
    Are you looking for a money to enlarge your business?
    We help individuals and companies to obtain loan for business
    expanding and to setup a new business ranging any amount. Get a loan at affordable interest rate of 3%, Do you need this cash/loan for business and to clear your bills? Then send us an email now for more information contact us now via Email:maxcreditfinance@googlemail.com

    ReplyDelete
  3. Do you need Finance?
    Are you looking for Finance?
    Are you looking for a money to enlarge your business?
    We help individuals and companies to obtain loan for business
    expanding and to setup a new business ranging any amount. Get a loan at affordable interest rate of 3%, Do you need this cash/loan for business and to clear your bills? Then send us an email now for more information contact us now via Email:maxcreditfinance@googlemail.com

    ReplyDelete