Bank overdraft account rate of interest calculation
This query is : Resolved
13 June 2023
Dear sir.,
if i am check to our bank rate of interest for monthly kindly provide any example formula with excel , my id -->sathishrajaj@gmail.com
if i am check to our bank rate of interest for monthly kindly provide any example formula with excel , my id -->sathishrajaj@gmail.com
06 July 2024
Example Calculation
Assume you have the following details:
• Principal Amount (Loan): Rs. 100,000
• Annual Interest Rate: 12%
• Loan Term: 12 months
Formula to Calculate Monthly Interest
1. Calculate Monthly Interest Rate:
• Formula: Monthly Interest Rate = Annual Interest Rate / 12
• In Excel: If Annual Interest Rate is in cell B2, use =B2/12
2. Calculate Monthly Payment using PMT function:
• Formula: =PMT(Monthly Interest Rate, Number of Payments, Principal Amount)
• In Excel: =PMT(B4, B3, -B1)
Assume you have the following details:
• Principal Amount (Loan): Rs. 100,000
• Annual Interest Rate: 12%
• Loan Term: 12 months
Formula to Calculate Monthly Interest
1. Calculate Monthly Interest Rate:
• Formula: Monthly Interest Rate = Annual Interest Rate / 12
• In Excel: If Annual Interest Rate is in cell B2, use =B2/12
2. Calculate Monthly Payment using PMT function:
• Formula: =PMT(Monthly Interest Rate, Number of Payments, Principal Amount)
• In Excel: =PMT(B4, B3, -B1)
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
- Price inclusive or exclusive of GST while made entry in P& L Account
- Gst registered proprietorship firm
- TDS Challan - change of FY 2025-26 to TY 2026-27
- Minimum tax payable to file Updated return
- Applicability of GST on Salary Reimbursement Component
- AUDITOR APPOINTMENT FOR THE YEAR ENDING MARCH 27
- Dep. as per companies act
- Change Of Karta In Case of Death
- UDIN ISSUE
- TDS on purchase of under construction property from a reseller
- FAST DS 26 Undisclosed Foreign Asset Disclosure Scheme 2026
- Starting trading business
- 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
- How to pay remaining amount of TDS after due date?
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
Quick Links
09 September 2026
SENIOR AUDITOR & ACCOUNTS MANAGER
Anupam Parashar & Co.
Ghaziabad
CA Final
View Details
ARTICLESHIP
21 September 2026
CA Article Assistant
KK & Company Chartered Accountant
Pune
CA Inter
View Details
CCI
Pro
CAclubindia
