Bank overdraft account rate of interest calculation

This query is : Resolved

sathish (Querist)
Follow

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

Asha Kanta Sharma

Asha Kanta Sharma

(Expert)
Follow

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)