create your own

EXCEL BASED CALCULATOR FOR LOAN EMI

68
rate or flag this page

By FREEWORKING


calculator of loan

Excel Spreadsheet to view loan amortization schedule with extra payments option. This calculator accommodates loan upto 20 years.
This calculator has the option of extra payment too which is very easy to work

How Loan Calculator with Extra Payments Works?


Simply enter:

1. Loan Amount:-Simply enter the loan amount for which you have applied for/have the loan of that amount. It's a simple procedure to enter the loan amount


2. Annual Interest Rate:- Annual interest rate is the rate on which your loan is passed or applied for. IS it a fixed loan account or the dimnishing interest rate


3. Loan Period in Years:- simple enter the tenure of the loan.


4. Number of Payments per Year:- Is it the monthly or quartly or weekly simple enter like

If there is monthly payment enter 12

if there is quartly payment enter 4

weekly payment enter 52


5. Date:- tell whats the loan date and emi date

Now you can view total, principal and interest payments. Also you can make extra payments each perio
d

Simple copy & paste the following link to download calculator

http://nitinaggarwal.webasyst.net/files/3ff6eb8b

  • What is Advance Tax- Pay On time Advance Tax

    Advance Tax:- As the name suggests tax paid in advance means to advance tax. If the tax paid amount is more than 10000 rupees than the tax should be paid in previous year itself and not to be deferred to... - 2 days ago

  • Challan Form 280,281,282,283 Free Excel Utility Download

    CHALLAN 280- this challan is used for depositing self assessment tax,advance tax and tax demand on regular assessment. So this challan is important as well as in regular use for assessment. Challan... - 7 days ago

  • Clubbing of Income- How income can be Clubbed

    Clubbing of Income: - Some assesses distribute and accumulate wealth on the names of various family members for cutting the tax burden. Income tax department has one instrument to club the income and... - 2 weeks ago

  • Top Ten Temples of Lord Shiva

    OM NAMAH SHIVAY, JAI BHOLE KI As you know the Lord Shiva has a great palace in hindu. Lord Shiva has many temples but it is amazing to see these temples in their faith as which is in top ten list. So i am... - 3 weeks ago

  • How to Avoid TDS( Tax Deduction on Source) on Fixed Deposit

    Fixed Deposit( F.D)- Fixed Deposit are the fund on which the interest is paid for the fixed term & the funds can’t be withdrawn before maturity, & if the fund is withdrawn before maturity giving notice,... - 3 weeks ago

  • TDS Rate Chart for Financial Year 2009-10 After Budget

    The Finance Minister made some changes in the rates of TDS/TCS in the annual budget which will be applicable from 1st October 2009 for the financial year 2009-10.The new rates of TDS has created a lot of... - 3 weeks ago

  • What is ACES (Automation of Central Excise & Service Tax)

    ACES Automation of Central Excise & Service Tax. It is a web based software for assesses & the department which make automatic different processes of CENTRAL EXCISE & THE SERVICE TAX Department like filing... - 4 weeks ago

  • First Discussion Paper on GST( Goods & Service tax) released

    The Empowered Committee of State Finance Minister has released GST (Goods & Service tax) First discussion paper. GST is the combition of Goods tax like VAT, CST, Excise & service tax. GST is coming to India... - 5 weeks ago


Print   —   Rate it:  up  down  flag this hub

Comments

RSS for comments on this Hub

No comments yet.

Submit a Comment

Members and Guests

Sign in or sign up and post using a hubpages account.


optional


  • No HTML is allowed in comments, but URLs will be hyperlinked
  • Comments are not for promoting your hubs or other sites

working