Loan EMI Schedule and Calculator in Excel

Loan EMI Calculator Sample / ExampleLOAN 500000 INTEREST RATE p.a 9% Total Interest 122750.59NO OF MONTHS 60 Total Principal 500000.21DATE OF EMI STARTS 5/1/2003 Total Cash Outflow 622750.80EMI 10,379.18 1 5/1/2003 500000.00 10379.18 3750.00 6629.18 493370.82 2 6/1/2003 493370.82 10379.18 3700.28 6678.90 486691.92 3 7/1/2003 486691.92 10379.18 3650.19 6728.99 479962.93 4 8/1/2003 479962.93 10379.18 3599.72 … Read more

Gratuity Calculator in Excel free

Some Basics about Gratuity:Gratuity Act is applicable to all establishments, where number of employees, are 10 or more in any day of the preceding 12 months.  Click here to download the Gratuity bare act.Charitable institutes and hospital are also covered under the act.It includes both commercial and non commercial establishment like educational institutes etc.Only Basic … Read more

Service Tax Delayed Payment and Interest

Service Tax Delayed Payment and Interest in Excel Format FreeService Tax Delayed Payment and Interest in xls file free Contents:Summary of Work ContractInput credit detailSummary for other work contractSummary of Manpower SupplyWater ChargesNOC ChargesSewerages ChargesSummary of Residential Complex CLICK HERE to Download Service Tax Delayed Payment and Interest Excel file Download

TDS Deduction Calculator from Monthly Salary

TDS Deduction Calculator from Monthly Salary in ExcelCalculates TDS to deduct monthly from Salary for the current year i.e. F.Y. 2015-16 from Employee declaration form. Provide also quick computation sheet to calculate tax liability.House Rent –  I am staying in a house and I agree to submit rent receipts when required. The Rent paid is … Read more

Simple Income Tax Formula for A.Y. 2016-17

Latest Simple Income Tax Formula for A.Y. 2016-17Latest Simple Income Tax Formula for Assessment Year 2016-17Latest Simple Income Tax Formula for F.Y. 2015-16Latest Simple Income Tax Formula for Financial Year 2015-16 New Simple Income Tax Formula for A.Y. 2016-17 in excel format freeNew Simple Income Tax Formula for Assessment Year 2016-17  in excel format freeNew … Read more