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
- Reward for festival
- 18% Rent a cab
- Clarification on GST, TDS, and Accounting Provisions for Import/Export Commission Agents,profes. ser
- Clarification on GST, TDS, and Accounting Provisions for Import/Export
- Gratuity paid to legal heir above 20 lakh is taxable or not
- Movement of goods by packers and movers - type of sale - Reg.
- ARCA LOGIN
- RCM and same line
- Closer of business and itc of capital goods
- TDS Return Statement Status
- Missed uploading GST Invoice
- Opting out" of regime provided under subsection (1A) of Section 115BAC but Form 10IEA is not filed.
- "Please ensure that the Total of the Deductions u/s 54F match the same in Table D in Sch CG"
- Need to correct "Whether it is last installment " response in Form 26 QB
- " Income from House Property " in joint names of co-owners
- REGARDING TDS RETURN OF FORM 27Q
- Notice under e-Verification Scheme
- GST demand notice for ITC reversal against exempted supply.
- RCM ON SECURITY CHARGES FROM INDIVIDUALS
- How to get money back from delisted company
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
