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 :
- On which amount 200% penalty under section 270A is
- RECEIVED INTIMATION U/S 399 FOR TDS PAYMENT ON PRO
- How do CA firms track SEBI/AMFI circulars and dead
- Jurisdictional validity of Sec 148 notice after fa
- Taxable Income or Not
- GST Input Tax Credit (ITC) on Camera Purchase &
- What makes CA Himanshu Singla different from other
- TAX TREATMENT AND ACCOUNTING ENTRIEOF PERQUISITES
- Gifting money to my father-in-law (my husband's da
- GSTR-1 JSON from marketplace exports (Myntra / Ama
Related Topics :
CAclubindia
