Go Ad-Free on CAclubindia with Daily Mobile Updates. Subscribe Now!

Excel base E.M.I. Calculator

Rajesh (Service) (181 Points)

24 July 2008

Heres the excel base EMI calculator. Now you can calculate your interest and principal component of loan or for loan your are looking for.

Reply
Follow
Share

12 Replies

Kalyan Kumar V (Student) (30 Points)
Replied 25 July 2008

hi friends,

please send me the excel calculator for calculation of EMI on loans

Thank you,

kalyan

Upgrade to CAclubindia Pro. Subscribe Now!

Rushikesh (Chartered Accountant - Manager Finance) (2375 Points)
Replied 30 July 2008

thanks

(Guest)

jgaodjfkhanadnan;bnab cv nfgd bm x vxzbvxcbfcnmvnv

(Guest)

Originally posted by :Rajesh
"	Heres the excel base EMI calculator. Now you can calculate your interest and principal component of loan or for loan your are looking for.	"

May be you would like to look at this, https://cpmlive.wordpress.com/2008/11/08/advance_loan_amortization_emi_calc/

(Guest)

thank u sir

Upgrade to CAclubindia Pro. Subscribe Now!

ashwini kumar sharma (retired engineer) (23 Points)
Replied 10 January 2009

IT IS VERY USE FUL TOOL.THANKS.

vishnu (Manager) (22 Points)
Replied 30 March 2009

You can try the excel EMI calculator and check the results. It uses the same parameters such as loan amount, rate and tenure to generate an EMI chart.

Thanks,

Saurabh Toshniwal (ca final) (2363 Points)
Replied 10 August 2010

thanksssssssssssssssssssssssss

jitendra (cc) (42 Points)
Replied 03 January 2017

As per my practical experience EMI Calculator will be more appropriate in correct results and in prompt action. It is one of the helpful tool that will make you familiar with the existing and the future monthly amount paid as installments

Upgrade to CAclubindia Pro. Subscribe Now!

PARUL YADAV (finance expet) (93 Points)
Replied 11 July 2024

An Excel-based EMI calculator is a useful tool for calculating Equated Monthly Installments (EMI) for loans. By inputting the loan amount, interest rate, and loan tenure into the Excel sheet, you can easily compute your EMI. For instance, if you take a personal loan from Kotak Mahindra Bank, you can use their interest rate and the desired tenure to calculate your monthly EMI using the PMT function in Excel. This helps in planning your finances effectively and comparing different loan options to choose the best one that suits your needs.

1 Like