To Verify the interest amount calculated for a bank deposit!
This query is : Resolved
15 January 2011
Dear Experts,
Pls. tell me which option i have to select in the Excel for verifying whether the bank has correctly calculated compound interest where the deposit period is for 500 days.
In other words pls tell me which function in the finanacial - MS Excel should be used to verify the interest amount calculated by the bank is correct or not.
With regards,
Rajesh.
Pls. tell me which option i have to select in the Excel for verifying whether the bank has correctly calculated compound interest where the deposit period is for 500 days.
In other words pls tell me which function in the finanacial - MS Excel should be used to verify the interest amount calculated by the bank is correct or not.
With regards,
Rajesh.
16 January 2011
There is no single formula for calculation of bank interest in excell.
You have claculate quarterly basis by multiplying the priciple amount with rate of interest.
You have claculate quarterly basis by multiplying the priciple amount with rate of interest.
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
- TDS CREDIT MISMATCHING
- Buy back of shares u/s69
- Tax Audit Applicability – Newly Formed Partnership Firm with Profit Below 6%/8%
- RELATED TO TRIBUNAL APPEAL
- ADDITION OF CHALLAN IN TDS RETURN FORM 140
- TODAY INCOME TAX SITE IS NOT WORKING ANY OFFICIAL EXTENSION
- Need Professional Opinion - AY 2012-13 Old Demand & AY 2026-27 Refund Adjustment
- ITR 4 and Bank transactions
- HOUSING LOAN ISSUE
- TDS AND ITR ISSUE
- Journal entry of busniess expenses
- Cash balance limit and property purchases limit
- CALCULATION OF DEFFERED TAX - OP BL IS DTL & CURRET IT DTA
- LLP audit under companies act
- Experienced CA recommendation from Kolkata for FNO return filing
- Interest Reporting in Form 168
- Sales of goods of amount Rs77 lakhs to a party
- Tax Demand of ₹4,650 for AY 2026-27
- Concept of Vendor and customner reconciliation
- Mistake in e-invoice identified after 24 hours
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
