loan EMI interest
This query is : Resolved
12 June 2010
Rs. 100000 @ 8% P.A for 2 yrs
EMi comes to Rs.4523
how can i calulate the amount of interest and amount of pricipal from it by manual method only , ??
Rs. 100000 @ 8% P.A for 2 yrs
EMi comes to Rs.4523
how can i calulate the amount of interest and amount of pricipal from it by manual method only , ??
SAMBASIVARAO
(Expert)
12 June 2010
Here is the bifirication of Intrest, principle and EMI
Instalment Amount Principle Interest Balance Principle
4,523 4,107 416 95,893
4,523 3,892 631 92,001
4,523 3,898 625 88,103
4,523 3,924 599 84,179
4,523 3,969 554 80,210
4,523 3,978 545 76,232
4,523 4,022 501 72,210
4,523 4,032 491 68,178
4,523 4,060 463 64,118
4,523 4,130 393 59,988
4,523 4,115 408 55,873
4,523 4,156 367 51,717
4,523 4,172 351 47,545
4,523 4,210 313 43,335
4,523 4,229 294 39,106
4,523 4,257 266 34,849
4,523 4,294 229 30,555
4,523 4,315 208 26,240
4,523 4,350 173 21,890
4,523 4,374 149 17,516
4,523 4,404 119 13,112
4,523 4,443 80 8,669
4,523 4,464 59 4,205
4,233 4,205 28 -
- - - -
Instalment Amount Principle Interest Balance Principle
4,523 4,107 416 95,893
4,523 3,892 631 92,001
4,523 3,898 625 88,103
4,523 3,924 599 84,179
4,523 3,969 554 80,210
4,523 3,978 545 76,232
4,523 4,022 501 72,210
4,523 4,032 491 68,178
4,523 4,060 463 64,118
4,523 4,130 393 59,988
4,523 4,115 408 55,873
4,523 4,156 367 51,717
4,523 4,172 351 47,545
4,523 4,210 313 43,335
4,523 4,229 294 39,106
4,523 4,257 266 34,849
4,523 4,294 229 30,555
4,523 4,315 208 26,240
4,523 4,350 173 21,890
4,523 4,374 149 17,516
4,523 4,404 119 13,112
4,523 4,443 80 8,669
4,523 4,464 59 4,205
4,233 4,205 28 -
- - - -
12 June 2010
Please send the email id , i will sent you excel sheet in which you put loan amount and rate of interest, automatically you get all detail, prnciapl, interest portion etc.
SAMBASIVARAO
(Expert)
12 June 2010
Please send the email id , i will sent you excel sheet in which you put loan amount and rate of interest, automatically you get all detail, prnciapl, interest portion etc.
You need to be the querist or approved CAclub expert to take part in this query .
Click here to login now
Click here to login now
Similar Resolved Queries
Unanswered Queries
- GST Audit whether Govt Companies are exempt?
- PTRC Show Cause Notice on Email
- Accounting treatment of AMC alongwith the purchase of Laptop
- Unable to File TDS Q2 Return – New TRACES Portal Error
- Condonation Request sec 119(2) b -Enhancement Limit of Leave Exemption prior to AY 2023
- GST Treatment of Purchases with GST Paid where Outward Supplies of Manufactured CattleFeed Exempt
- Taxation of crypto futures in India Fy 2026- 2027
- Issuing of delivery challan by seller of goods
- Transfer of Physical Stock Between Two Proprietorship Concerns
- EPF ECR NEW RULES Sep 17th 2026
- Expert Help Required for TDS Refund 100000 Through TRACES – AY 2022–23
- IMPORT PURCHASE ENTRY PASSED IN BOOKS OF ACCOUNT
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Regime change
- Goods sold but invoice not issued
- Tally: Imported bank entries do not show up in manual reconciliation
- Sales of goods of amount Rs97 lakhs to a party
- Confused About My Career After 12th — Cyber Security, AI or Finance? Need Guidance
- FAST-DS 2026 Under Tax Law - No recourse or support for person declaring via this scheme?
- Guidance Needed: Linking Multiple Form 26QB Payments and Responding to ITD Defaulter Notice
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
Subscribe to Pro
Join an elite circle of professionals
CAclubindia
