How to calculate Days Sales Outstanding – DSO

DSO Formula How to calculate Days Sales Outstanding - DSO Objective: In today's competitive world , it is important for any organisation to operate with minimum working capital . If company is buying raw material Read more [...]
Posted in Finance Tagged with:

Depreciation Rate Chart as per Income Tax Act

Depreciation Rates as per Income Tax Act Assets are bifurcated in five classes for the purpose of Depreciation as per Income Act .Below mention Depreciation Rate Chart as per Income Tax Act are applicable for the FY 2017-18(AY 2018-19) as amended Read more [...]
Posted in Income Tax Tagged with: ,

How to use SUMIF Formula in excel

How to use SUMIF Formula in excel How to use SUMIF Formula in excel: Want to do sum of key fields having thousands lines in few minutes ? SUMIF is very useful formula in excel. This Post will provide details regarding how to use SUMIF Read more [...]
Posted in Excel Tips Tagged with:

What is tax benefit of Superannuation Fund

What is tax benefit of Superannuation Fund What is tax benefit of Superannuation Fund You may have knowledge about provident fund however  you may not be aware regarding Superannuation Fund and want to know what is tax benefit of superannuation Read more [...]
Posted in Income Tax Tagged with: ,

TDS Rates Chart for FY 2017-18 ( AY 2018-19)

TDS Rates for FY 2017-18 Over the years there is definite increase in scope of TDS provisions. TDS provision has really become key instrument for Government to get compliance with requirement of Income Tax Law. Assesses has to Read more [...]
Posted in Income Tax Tagged with: , ,

What is Time Value of Money (TVM)

What is Time Value of Money What is Time Value of Money . Background: We may have heard  from our parents, teachers and elders since our childhood that "Respect time as time is money". We may be considering this as a good piece Read more [...]
Posted in Finance Tagged with: ,

How to remove #N/A error in vlookup

How to remove #N/A error in vlookup How to remove #N/A error in vlookup . It is very irritating when you may be using vlookup formula in excel and you will get error like #N/A. You may be wondering how to remove #N/A error in vlookup . Read more [...]
Posted in Excel Tips Tagged with:

Income Tax rates for FY 2017-18

income tax rates for FY 2017-18 Income Tax rates for FY 2017-18 (Financial Year 2017-18)and AY (Assessment Year)2018-19 A. Individuals/HUFs/AOPs/BOI/Artificial Judicial Person A1.  FOR RESIDENT MEN and WOMEN (Age less Read more [...]
Posted in Income Tax Tagged with: ,

TDS Rates Chart for FY 2016-17

TDS Rates for FY 2016-17 Over the years there is definite increase in scope of TDS provisions. TDS provision has really become key instrument for Government to get compliance with requirement of Income Tax Law. Assesses has to Read more [...]
Posted in Income Tax Tagged with: ,

Deduction of Interest on Loan taken for Higher Education

deduction of interest on loan taken for higher education Deduction of Interest on loan taken for Higher education is probably very less known benefit provided by Income Tax Department. Now a days cost of higher education is soaring . Students take loan with Read more [...]
Posted in Finance, Income Tax Tagged with: