Categories: Bank NewsBank Staff

Arrears Calculator for Sub Staff / Customer Service Assistants

Download the File!

Arrears Calculator For Sub-Staff / Customer Service Assistants

1. Download the Excel file by clicking the blue button.

2. Open the file from your Downloads folder. It should look similar to the screen in the video. The layout may vary slightly depending on your spreadsheet software and screen size, but the basic functionality will be the same.

3. If the file opens in read-only mode, look for an ‘Enable Editing’ option and select it before making changes

If you don’t have MS Excel or need help with the file, please email your salary details (basic salary, SPL. PAY, PQP, FPP, HRA to iamvarunnaik@gmail.com. I’ll fill out the form and send the PDF back to you.
Arrears Calculator Sub Staff

INSTRUCTIONS

BASIC SALARY

  • Click cell B10.
  • Select salary from the drop-down.
  • If your salary changed, update the correct month’s cell.

SPECIAL PAY

  • Click cell D10.
  • Select special pay from the drop-down.

PQP and FPP

  • Click cell E10 to update PQP (drop-down).
  • Click cell F10 to update FPP (drop-down).

Scroll down to compare salaries and see your arrears/take-home.

HOW-TO VIDEO

REFERENCE CHART FOR EXISTING AND REVISED SALARIES

Old BASIC New BASIC
14500 19500
15000 20165
15500 20830
16000 21495
16500 22160
17115 22990
17730 23820
18345 24650
18960 25480
19575 26310
20315 27300
21055 28290
21795 29280
22535 30270
23405 31440
24275 32610
25145 33780
26145 35125
27145 36470
28145 37815
29145 39160
30145 40505
31145 41850
32145 43195
33145 44540
34145 45885
35145 47230
36145 48575
37145 49920
ADD STAG 1- 51265
ADD STAG 2 – 52610
admin

Share
Published by
admin
11 months ago

Recent Posts

What is Weighted Marginal Cost of Capital?

The marginal cost of capital (MCC) is the total combined cost of debt, equity, and…

3 hours ago

Meaning of WACC and factors affecting the WACC

The weighted average cost of capital (WACC) is the average rate that a business pays…

20 hours ago

Regulations on Interest Rate Resets on EMI based personal loans explained

The Reserve Bank of India (RBI) defines a personal loan as a type of unsecured…

21 hours ago

Determining the Proportion:  Preference V/s Equity Shares

A share is a unit of ownership in a company and has an exchangeable value…

1 day ago

Overview: Cost of Debt, Taxation, & Capital Structure

The cost of debt is the interest rate a company pays on its debt, and…

2 days ago

Various Theories/Approaches on Capital Structuring Explained

This article explains the assumptions and key aspects of approaches to capital structuring, including the…

3 days ago