Online edition of India's National Newspaper
Saturday, Feb 28, 2004

About Us
Contact Us
Property Plus — Chennai Published on Saturdays

Features: Magazine | Literary Review | Life | Metro Plus | Open Page | Education Plus | Book Review | Business | SciTech | Entertainment | Young World | Property Plus | Quest | Folio |

Property Plus — Chennai

Printer Friendly Page Send this Article to a Friend

EMI on Excel spreadsheet

It is much easier these days to use Excel spreadsheet than search for calculators, formulae and tables for calculating EMI.

The function in Excel for calculating EMI is not EMI but PMT. It requires minimum three arguments. They are 1. Rate of interest (Rate), 2. Number of periods (Nper) and 3. Value of loan or present value (Pv) in that order, that is, PMT (Rate, Nper, Pv)

If you want to find EMI for 1 lakh at 10% annual interest for 10 years you enter the following in one of the cells:

= pmt(10%/12, 10*12, 100000)

Avoid unnecessary spaces particularly between `pmt' and `('. Answer will be in the negative or in red colour indicating cash outflow for the borrower.

Taking another example, Equated Quarterly Instalments for 1 lakh at 7.5% annual interest for 20 years you enter the following in one of the cells:

= pmt( 7.5%/4, 20*4, 100000)

The `Goal Seek' option in `Tools' menu helps you to back work any of the three given the other two. Alternatively, there are other financial formulae like `PV', `Rate' to calculate the eligible loan, corresponding rate of interest and so on.

Send in your queries as well as feedback to propertyplus@thehindu.co.in or post them to

PropertyPlus,
The Hindu, 859/860, Anna Salai,
Chennai 600 002.

Hariharan. N

Printer friendly page  
Send this article to Friends by E-Mail

Property Plus — Chennai

Features: Magazine | Literary Review | Life | Metro Plus | Open Page | Education Plus | Book Review | Business | SciTech | Entertainment | Young World | Property Plus | Quest | Folio |


The Hindu Group: Home | About Us | Copyright | Archives | Contacts | Subscription
Group Sites: The Hindu | Business Line | The Sportstar | Frontline | The Hindu eBooks | Home |

Comments to : thehindu@vsnl.com   Copyright 2004, The Hindu
Republication or redissemination of the contents of this screen are expressly prohibited without the written consent of The Hindu