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 :
- GSTR 9 LATE FEE
- Best Online Mock Test Series for CA Inter January
- COST OF IMPROVEMENT
- Pillows and Mattresses
- GST Applicability for Reg. / Un-Reg. Indian custom
- Amended GST Act & Rules
- FAST DS 2026 MAIL QUERY
- Does Anyone need CA Foundation books of May2026 at
- Last day for ITR-U for AY 2023-2024 (FY 2022-2023)
- Sale of shares in indian company by a non resident
Related Topics :
CAclubindia
