It is a dynamic excel sheet which has option to calculate loan amount eligibility for given amount of average income.
It also has facility to calculate loan eligibility on the basis of Income tax paid in last three financial years
It also gives amount of income one should have during three financial years for desired loan amount.
It calculates result on the basis of average income during three years.
Loan eligibility depends upon many factors such as Nature of business, Age of borrowers, Level of Security provided, banks policy for loan, purpose of loan, cibil score, credit rating, track record etc. , all these factors also affects loan eligibility criteria. These are difficult to incorporate in the sheet. Therefore this result of this calculator is not an assurance of loan amount from particular bank in particulars case.
This sheet is useful for individual assesses. Corporate assesses calculation will be different because of difference in tax rates etc. #xlsx