1.0HR Letter Formatshttps://www.yourhrworld.com/formatsrich600338<blockquote class="wp-embedded-content" data-secret="Xa4JwD2JXh"><a href="https://www.yourhrworld.com/formats/hr/ctc-format-attached/">Cost To Company or CTC Salary Format in Excel</a></blockquote><iframe sandbox="allow-scripts" security="restricted" src="https://www.yourhrworld.com/formats/hr/ctc-format-attached/embed/#?secret=Xa4JwD2JXh" width="600" height="338" title="“Cost To Company or CTC Salary Format in Excel” — HR Letter Formats" data-secret="Xa4JwD2JXh" frameborder="0" marginwidth="0" marginheight="0" scrolling="no" class="wp-embedded-content"></iframe><script> /*! This file is auto-generated */ !function(d,l){"use strict";l.querySelector&&d.addEventListener&&"undefined"!=typeof URL&&(d.wp=d.wp||{},d.wp.receiveEmbedMessage||(d.wp.receiveEmbedMessage=function(e){var t=e.data;if((t||t.secret||t.message||t.value)&&!/[^a-zA-Z0-9]/.test(t.secret)){for(var s,r,n,a=l.querySelectorAll('iframe[data-secret="'+t.secret+'"]'),o=l.querySelectorAll('blockquote[data-secret="'+t.secret+'"]'),c=new RegExp("^https?:$","i"),i=0;i<o.length;i++)o[i].style.display="none";for(i=0;i<a.length;i++)s=a[i],e.source===s.contentWindow&&(s.removeAttribute("style"),"height"===t.message?(1e3<(r=parseInt(t.value,10))?r=1e3:~~r<200&&(r=200),s.height=r):"link"===t.message&&(r=new URL(s.getAttribute("src")),n=new URL(t.value),c.test(n.protocol))&&n.host===r.host&&l.activeElement===s&&(d.top.location.href=t.value))}},d.addEventListener("message",d.wp.receiveEmbedMessage,!1),l.addEventListener("DOMContentLoaded",function(){for(var e,t,s=l.querySelectorAll("iframe.wp-embedded-content"),r=0;r<s.length;r++)(t=(e=s[r]).getAttribute("data-secret"))||(t=Math.random().toString(36).substring(2,12),e.src+="#?secret="+t,e.setAttribute("data-secret",t)),e.contentWindow.postMessage({message:"ready",secret:t},"*")},!1)))}(window,document); //# sourceURL=https://www.yourhrworld.com/formats/wp-includes/js/wp-embed.min.js </script> Attached herewith CTC format that may help u to identify net take home salary, monthly CTC, yearly CTC in Excel. company’s Logo ANNEXURE-I Notes:- SALARY BREAK-UP value PF deposited in PF department NAME ANNUAL BENEFITS:- ESIC deposited with ESIC dept DESIGNATION Individual Component (IC) Prof tax paid to PT department DEPARTMENT Bonus Lumpsum LTA payable in August in some company DATE OF JOINING Bonus paid at the time of Diwali Gratuity will be paid after 5 yrs services EARNINGS DEDUCTIONS Exgratia SALARY HEAD AMOUNT (Rs.) SALARY HEAD AMOUNT (Rs.) canteen subsidy Basic                       12,000 PF Employee                            1,440 Company Component