Tuesday, March 9, 2021

127-EMI statement makers for all types of loan

PURPOSE/OBJECTIVES

This tool will help users to verify the EMI-statement with the bank’s EMI-statement. It will help users to prevent bank fraudulence if any. 

I faced the same type of problem. A huge amount was included in my loan amount after the payments of 6 EMI's by one of the well-known finance company which could not be noticed by anyone. At the end of the year, my program was not tallying with the statements of the loan finance company. So, I re-checked my software, thinking that the bank may not do such types of mistakes. I modified my software and checked the statement. There was fraudulence in the bank's statement and the same was sorted out at that time and everything became normal as per my software. So, it will be very useful to everyone who takes a loan from the bank of any finance company. 

Overview

For any loan taken, we must repay it with equated monthly installments called EMI. This tool requires limited information like: 
1) The opening balance of a loan.
2) EMI-start-Month.
3) EMI amount.
4) Rate of interest.
5) Part payment amounts with month.
6) The details of EMI skipped.

Based on your information, this tool will calculate the entire EMI account statement, which can be compared with the statement of the loan-providing company.

Procedure

Step-1

Here, enter the principal amount (P), rate of interest (PCPA), (write 13 for 13%), and the number of months of EMI, then we will get EMI-amount. The information will be forwarded for the first-year EMI chart.

The software will take the principal-loan-amount, rate-of-interest, and EMI-start-month directly from the previous sheet. The latest modified information of these fields will be available throughout the EMI charts. 

Step-2



For any changes in the EMI amount, enter the month from the drop-down menu and the new EMI amount in the next cell under the head "EMI".


For any changes in the rate of interest, enter the month from the drop-down menu and the new rate of interest in the next cell under the head "INTEREST".


If any part-payment is done, then enter the month from the drop-down menu and part-payment amount in this cell under head "Part-Payment".


If any EMI is missed, it will be entered here under the head "EMI not paid for some month".

Step-3

Summary of the EMI statement:


All the information is available with the graph.

ANIL SATPUTE


No comments:

Post a Comment