Tax CalcTax Calculation Table For Financial Year 2014-15 (Based on Monthly Salary)SALARY DETAILSTaxable Salary->551,268Salary StructureMonthlyMonthsYearlyFor MenSalary661,284FromUPTOTax %Tax AmtTax CalculationSurchargeCessTotal TaxNon Taxable800129,60010%3%HRA Exempted (Pls fill HRA Calc Sheet)100,4160.0250,000000.0Any Other Income0.0250,001500,0001025,00025,000500,0011,000,00020100,00010,254Gross Salary551,2681,000,001& Above3000.0Tax Rebate u/s 87A0.0DeductionsSub Total35,2540.01,05836,312Less Savings : u/s 80 upto 1.5 LacTDS Deducted0.0Repayment of Self Occupied: PrincipalMonthly TDS4,035Housing Loan: Interest u/s 24(b)Mediclaim Policy: U/s 80DFor WomenHigher Educ. Loan Interest Paid: U/s 80EFromUPTOTax %Tax AmtTax CalculationSurchargeCessTotal TaxBank Interest: U/s 80TTA10%3%Donations: U/s 80G0.0250,000000.0250,001500,0001025,00025,000Saving Expempted0.0500,0011,000,00020100,00010,254Taxable Salary551,2681,000,001& Above3000.0Tax Already Deducted (TDS)Tax Rebate u/s 87A0.0Remaining Months in Current Fin.Yr.9Sub Total35,2540.01,05836,312TDS Deducted0.0Monthly TDS4,035Note:Only sky blue colour cell can be changed i.e., Monthly Salary, Months, Non-taxable and savings & Remaining MonthsFor Senior Citizen=80February55,1072FromUPTOTax %Tax AmtTax CalculationSurchargeCessTotal TaxMarch55,107110%3%Total661,284780.00.0500,000000.0500,0011,000,00020100,00010,2541,000,001& Above3000.0Tax Rebate u/s 87A0.0Sub Total10,2540.030810,562TDS Deducted0.0Monthly TDS1,174Developed by Vivek Sang, Rishikesh. Mobile # +91-9837087627Please mail your suggestions on my email ID: toviveksang@gmail.com

Only Interest Paid without any limit is exempted and that too for max period of 8 years after starting paying interest.Maximum of 15,000/- if paid through Cheque. Additional 15,000/- if paid for parents. Additional 10,000/- if parent is senior citizen.Maximum of 1 Lac including savings u/s 80Maximum of 1.5 Lac e.g. PPF , LIC Premiums, Now u can invest in PPF upto 1.5 lac per financial yearExempted upto Rs.10,000/-Mention CTR value corresponding to the Month in which salary is received.Upto 2 lacMax upto 10% of Gross.Check Eligible for 50% or 100%Please fill the HRA Calc sheet to get the value here

HRA CalcHRA Calculation Sheet u/s 10(13A) Rule 2AMonthly Salary DetailsHRAMonthBasicDATotalReceivedPaid (N-1)Metro CityCond-1Cond-2Cond-3ExemptedApril20,92020,9208,36810,500Y10,4608,3688,4088,368May20,92020,9208,36810,500Y10,4608,3688,4088,368June20,92020,9208,36810,500Y10,4608,3688,4088,368July20,92020,9208,36810,500Y10,4608,3688,4088,368August20,92020,9208,36810,500Y10,4608,3688,4088,368September20,92020,9208,36810,500Y10,4608,3688,4088,368October20,92020,9208,36810,500Y10,4608,3688,4088,368November20,92020,9208,36810,500Y10,4608,3688,4088,368December20,92020,9208,36810,500Y10,4608,3688,4088,368January20,92020,9208,36810,500Y10,4608,3688,4088,368February20,92020,9208,36810,500Y10,4608,3688,4088,368March20,92020,9208,36810,500Y10,4608,3688,4088,368Total251,0400.0251,040100,416126,000125,520100,416100,896100,416Fill only light blue color cells onlyTotal Annual Rent Received100,416NotesExempted Rent100,416N-1 Receipt of Rent paid to landlord is must otherwise it is to be taken as 0Taxable Rent0.0

If residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesActual Rent ReceivedExcess of rent paid over 10% of (Basic+DA)Actual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedActual Rent ReceivedExcess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)Excess of rent paid over 10% of (Basic+DA)If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%If Metro=Y then 50% else 40%Least of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedLeast of Cond-1, 2 & 3 is exemptedIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesIf residing in Delhi, Calcutta, Madras, Bombay enter 'Y' else 'N' without any quotesSee Note N-1 below

Interest-CalcINTEREST CALCULATOR BETWEEN TWO DATESAmount1,000Note: Only Green Coloured Cell Can Be EditedRate in %8.00Send your response to:Email: toviveksang@gmail.comDate From4/1/14FormatDate To3/31/15DD/MM/YYYYDays to Calculate364181.5090.25Days in Year365Calc AreaInterestH.YlyQtrSimple Interest1,079.7879.7813Compound Yearly1,079.7879.7839.7819.78Compound H.Yly1,081.3781.371,040.001,061.21Compounding Qtrly1,082.2082.2041.3720.99Enter Years Below YEAR WISE INTEREST CALCULATIONAmount After Year12345615Simple Interest1,080.001,160.001,240.001,320.001,400.001,480.002,200.00Interest Amount80.00160.00240.00320.00400.00480.001,200.00Compound Yearly1,080.001,166.401,259.711,360.491,469.331,586.873,172.17Interest Amount80.00166.40259.71360.49469.33586.872,172.17Compound H.Yly1,081.601,169.861,265.321,368.571,480.241,601.033,243.40Interest Amount81.60169.86265.32368.57480.24601.032,243.40Compounding Qtrly1,082.431,171.661,268.241,372.791,485.951,608.443,281.03Interest Amount82.43171.66268.24372.79485.95608.442,281.03