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 allow 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 EMIs by one of the well-known finance companies 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 advantageous 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 were 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 the 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 starts month directly from the previous sheet. The latest modified information on 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, enter the month from the drop-down menu and the part-payment amount in this cell under the 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 in the graph.

ANIL SATPUTE

126-Calculator of a commutation of a pension

Dear friends,

Now you can download FORM-1 from this site also. Go to the bottom, click on the top-right symbol which shows as a "pop-out " and download the form.

Click here to watch a video on this topic. 

This post calculates the commutation of a pension and the pension amount after commutation. So many employees have taken VRS even at the age of 50 years. So, this software will help them to set a reminder for submission of Form-1 in their admin office. The following essential particulars regarding the commutation of a pension will be available in this software.

Enter only the following information:

The output will be as follows:

125-How to open your NPS Account Online

Dear friends,
Due to COVID-19, it is always safe to stay at home. So this blog will help you to open your NPS account (National Pension System) online. 

It will really help you a lot.

NPS Tier 1 Tax Benefits

You get a tax deduction under Section 80CCD(1) and 80CCD(2) on contributions to the NPS up to Rs 1.5 lakh per annum.

• In addition, you can get a tax deduction on contributions up to Rs 50,000 under Section 80CCD(1B). Hence the total tax benefit on contributions to the NPS is Rs 2 lakh per annum.
• In addition, the returns on NPS are tax-exempt while the money is retained in the NPS account.
• On maturity, up to 60% of the accumulated NPS corpus can be withdrawn free of tax. Another 40% must be used to buy an annuity (regular pension).

When I was trying to open an online NPS account, I faced some problems and the same is being shared here.

So we will see the procedure step by step:

124-Interest and amount calculator of Senior Citizen Saving Scheme

Dear friends,

We started getting various amounts from our organization. Here is your personal calculation sheet for SCSS (Senior Citizen Saving Scheme) where you will get the details of the receivable amount at the time of maturity. It is developed in excel for you  This file you can download on your mobile, laptop, or desktop.

Step 1:

If you are using mobile for this software use, then install EXCEL from the App station. Different methods are there for mobile as well as laptop. We will see both.

Click here to download the calculator of the SCSS account.

It is in "View only" format, so download it on your laptop or mobile. First of all, Enter your name,  then start using it.

Here you must open RD (Recurring Deposit) account in any nationalized bank or post office for 5 years at the same time when you opened your SCSS account.

How to use this software tool:

1) Enter your name.

2) Enter the amount which you want to deposit in the SCSS account either in the bank or post-office.

3) Enter the rate of interest of the SCSS account.
4) Enter the rate of interest of the Recurring Deposit account.

Here you can enter your data only in 4 yellow colored cells.

Thanks for visiting my site.

ANIL SATPUTE

123-Details of the Amount received from MTNL/BSNL

We started getting various amounts from our organization. Now, this software will keep records of all such details of amounts received systematically and very simple manner.

Step 1:

If you are using mobile for this software use, then install EXCEL from the App station. Different methods are there for mobile as well as laptop. We will see both.

Click here to visit the software tool.

Step 2:

Now you will reach the software as shown below: (For laptop users) 

122-First installment amount of EX-Gratia of VRS-2019-for MTNL and BSNL Employees

Dear friends,

Click here to see the video on this software tool.

Note: Please enter the same staff number while checking your VRS Amount details that you entered in the form.

On 30/03/2020 our 1st installment of Ex-Gratia will be deposited in our bank. So this is the software to see how much amount will we receive?

We will get the details of the amounts as follows:

This software is prepared for everyone who opted for VRS-2019 and wants to calculate the VRS amount.

MTNL and all BSNL Employees can follow the following steps.

Step-1:

121-Tool-to-calculate-VRS-amount-for MTNL Delhi and BSNL Employees by entering Staff number

Dear friends,

Note: Please enter the same staff number while checking your VRS Amount details that you entered in the form.

Now everything regarding your VRS is over. Now it's time to see how much will we get from this VRS.

This software is prepared for everyone who opted for VRS-2019 and wants to calculate the VRS amount.

MTNL Mumbai employees can click here to get their ready-made calculation sheet.

MTNL Delhi and all BSNL Employees can follow the following steps.

Step-1:

Click here to fill in the following information as per your Last Pay Slip.

1) Your Name,
2) Designation,

3) Date of entry in the department,
4) Actual retirement Date,

5) Basic Pay,

6) EL,

7) HPL.

Please see the following diagram and fill it out completely. (Click here to fill out the form)

Step-2:

As per the VRS schemes for MTNL and BSNL, the following steps will help us to calculate our VRS amount. 

Click HERE to get your VRS calculations.

Enter your staff number (M012345) in the yellow-colored portion of an excel sheet as shown below.

Now we will get all VRS amounts simply by entering our Staff-Number MTNL-Delhi and BSNL employees.

The following results will be available

1) Estimated VRS Amount

2) If, not opted for VRS, the total salary for the remaining period of service

3) Monthly Pension After VRS

4) So, the pension amount received after VRS till the remaining service

5) Total amount received along with monthly pension

6) Opt for VRS or not

7) Gratuity Amount

8) Gratuity Amount with 7.9 % interest after the age of 60 years.

9) Leave encashment.

In this model, an amount equivalent to 35 days of salary for each completed year of service, and 25 days of salary for each year of service left till retirement is considered.

Step-3: Case-1

If your result shows some fields like " #N/A " as shown in the following figure, then follow the instructions given in cell no E12: L21 of your google sheet.

Step-3: Case-2

If your result shows some fields (like Total Ex-Graia, Final estimated VRS Amount, and so on)  as " 0 " as shown in the following figure, then follow the instructions given in cell no E31: L31 of your google sheet, (Correct your form).

This shows that you entered the Actual retirement date as your VRS date, so your calculations are like this. So, now you can correct your details in the form. Please see the following figure.

Clicking on "Edit your response" you can correct your form and recheck your VRS amount details.

Tag: MTNL, BSNL, VRS, VRS Scheme for MTNL and BSNL Staff, VRS Calculator for MTNL, BSNL Employees, VRS tool for MTNL, VRS tool for BSNL

ANIL SATPUTE