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 )
19 Replies
harsha vardhan
(article assistant)
(23 Points)
Replied 06 December 2007
1 lac+ (1 lac * 16%*4yrs)/4yrs
K V Subba Rao
(Service)
(2708 Points)
Replied 06 December 2007
It is Rs 2834 as found using calculator in www.apnaloan.com
Sathish Karunakaran
(ACA)
(614 Points)
Replied 06 December 2007
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
CA Kiran
(consultancy)
(33 Points)
Replied 07 December 2007
I have uploaded the file of loan calculator in others section.
Pioneer
(Education)
(29 Points)
Replied 09 December 2007
Plz send me the loan calculator on my email address: pioneermail2000 @ yahoo.com
Ashish M
(Chartered Accountant)
(2731 Points)
Replied 06 January 2008
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.
CA Naveen Kumar Agrawal
(Chartered Accountant / MBA)
(939 Points)
Replied 30 June 2008
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
Attached File : 27 9 pv calcu.xls downloaded: 333 times
Recent Topics
- NRO Interest - Taxed at source and in Foreign Coun
- Clarity needed on effective date
- Income Tax Refund Deadline Shortened to Five Years
- Rectification Applications for Past GST Demands
- Where can I find a trusted provider to hire a skip
- GST Invoices Series
- FILING OF ITR AY 20-21
- CLAIMING OF U CLAIMED RCM
- Building construction works
- REGARDING GSTR-9 F.Y 2023-24
Related Threads
CAclubindia
