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
- CG Tax On residential property
- Post Office RD Interest
- Applicable TDS for Purchase of Flat from NRI
- Eway bill for machinery reparing
- Claiming exemption of perquisite for employee-owned car under New Tax Regime in ITR-2
- Gift of mutual fund units to daughter
- Building tax payment deduction in rental Income
- NRI ITR2 account in 2025-26 ,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,,.
- Reporting of STCG on Property in ITR
- Not able to file ITR
- Presumptive income under 2025 ACT
- Upload Level ValidationITR3Category of Defect B/D
- Presumptive income under Income tax act 2025
- Clarification Required on Business Code for 44ADA
- Under construction property in ITR
- PF Taxable Income
- Clarification on Tax Audit Applicability and Reporting of F&O Transactions in ITR-3
- Interest credited in FY2025-2026 & TDS therein by EPFO does not reflect in AIS or Form 26AS
- 44ad eligble money lending interest
- Delisted shares sold in off market/ Rebate u/s87A
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
