CTC stands for Cost to Company. “Cost to Company” means all the costs borne by a company associated to employ an individual.

Formula For CTC

CTC = Direct benefits + Indirect benefits + Saving Contributions

Direct Benefits: Basic Salary, DA, Conveyance Allowance, HRA, Medical Allowance, LTA and other allowances if any.

Indirect Benefits: Interest-free loans, food coupons, Company leased Accommodations, Medical Insurance, Income Tax savings.

Saving Contributions: Annual benefits, EPF, professional tax etc.

You can find these terms in your salary slips. Note that the Indirect benefits and the Savings contributions do form a part of your compensation but not your take home salary.

You can download ready to use Salary Slip Excel Template from the link below

Salary Slips

Additionally, you can also download other accounting and financial analysis templates from the links below:

Accounting Templates

Financial Analysis Templates

We thank our readers for liking, sharing and following us on different social media platforms.

If you have any queries please share in the comment section below. I will be more than happy to assist you.

Shabbir Bhimani

I have worked in Excel and like to share functional excel templates at ExcelDataPro.

Share
Published by
Shabbir Bhimani

Recent Posts

Download UK VAT Taxable Turnover Calculator Excel Template

To simplify the process, we have created a simple and easy UK VAT Taxable Turnover…

4 years ago

Step By Step Guide TO UK VAT Registration Process

Every business has to register for VAT with HM Revenue and Customs if their VAT…

4 years ago

Download UK VAT Dual Currency Invoice Excel Template

We have created the UK VAT Dual Currency Invoice excel template with predefined formulas that…

4 years ago

Download UK VAT Purchase Register Excel Template

We have created a simple and easy UK VAT Purchase Register Excel Template with predefined…

4 years ago

Download UK VAT Sales Register Excel Template

We have created a simple and easy UK VAT Sales Register Excel Template with predefined…

4 years ago

Download UK VAT Progress Billing Invoice Excel Template

We have created a ready to use UK VAT Progress Billing Invoice template in excel…

4 years ago