Hellow Freind,
Please provide me in excel format , how to calculate Fix EMI Amount . if rate of Interest is 16 % for 4 year and principal amount 1 lac
Thanks & Regards
Kamlesh ( ICWA-Inter )
Menu
EMI Calculation
Replies (19)
1 lac+ (1 lac * 16%*4yrs)/4yrs
It is Rs 2834 as found using calculator in www.apnaloan.com
U can use function from Insert Menu in Excel.
Under category Financial/PMT
PMT[Rate/12/100,No.of Months,(-)Principal]
PMT[.01333,48,-100000]
EMI - 2834
pls send tome the calculator
I have uploaded the file of loan calculator in others section.
Please provide EMI When rate of int is 14% of Rs.3,00,000 for the period of 3 years.
My actual E-mail ID IS :
simhachalam.gadibantu @ gmail.com
EMI Calculation
Hi,
Plz send me the EMI calculator to my below mentioned mail id:-
siba_gopal @ infosys.com
Thanks in advance
Siba Gopal
the formula is (p * r) ( 1 + r)^n
--------------------------
(1 + r) ^ n - 1
Plz send me the excel sheet of loan calculation on my email address pioneermail2000 @ yahoo.com
Plz send me the loan calculator on my email address: pioneermail2000 @ yahoo.com
I hve the EMI calculator in the excel format just as u want. if u r interested, i can mail u the same. just mail me ur e-mail id at my id i.e. ashishmitra @ myself.com. i will give it to u via attachment.
Pls provide me EMI calculatur
hey guys! stop crying for EMI calculator.
i hv attached an excel file which can calculate EMI (if Loan amount provided) as well as loan amount (if EMI provded)
Regards,
CA Naveen Kumar Agrawal
Recent Topics :
- Capital gains on sale of flat from wife to husband
- TDS filing for the 1st quarter of TY 2026-27
- Login into Old Traces Portal
- Professional Income reporting in ITR-3
- Pf exemption in hand of spouse on demised of husba
- Missed deadline to revise ITR for a foreign asset
- Durga Puja 2026 Dates: Mahalaya, Shashthi to Vijay
- Indo-MIM IPO Allotment Date, Status Check and List
- GSTR 1 filed but GSTR 3 B no filed
- ITR FORM FILING REGARDS
Related Topics :
CAclubindia
