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 Threads
- F&O losses
- Is form 10 IE needed in this case?
- TDS on purchase of property more than 50 lakhs
- Withdrawal from post NSS
- Section 10(11) or 10(12) of exempted income
- New income tax act
- Duplication of Interest on SCSS deposits in postof
- Declaration of foreign investment
- Parent buying property for major child
- LIC maturity amount filing missed
Related Threads
CAclubindia
