Rashmitha
asked
What is EMI? How do I calculate EMI manually?
0
0
Answer Now
Comment
Report
1
Answers
Important Note – Preparing for CA Final?
CAKART provides Indias top faculty each subject video classes and lectures – online & in Pen Drive/ DVD – at very cost effective rates. Get video classes from CAKART.in. Quality is much better than local tuition, so results are much better.
Watch Sample Video Now by clicking on the link(s) below –
For any questions Request A Call Back
narahari
answered
1. If you can use excel
One of the easiest ways of calculating the EMI is by using the Excel spreadsheet. In Excel, the function for calculating the EMI is PMT and not EMI. You need three variables. These are rate of interest (rate), number of periods (nper) and, lastly, the value of the loan or present value (pv).:
use formula
=-pmt(rate,nper,pv)
e.g.
a. rate = per month rate = 10/12 = .83333
