Excel formula
This query is : Resolved
29 May 2010
Hello Friends!
Good morning!
I want to know how I'll calculate Quarterly Compound interest(on FDR) in excel.Also please help to calculate accrued interest(qtrly.compound).Please send in MS Excel file.
I'm giving an example for your understanding of my question:
Example
Let's say I made a FDR for Rs.16,00,000/- for 6 months @ 6% (quarterly compound interest) on 16.10.2009 maturity date is 16.04.2010.
Now my question is - how much accrued interest i'll have to booked as on 31.3.2010(financial year closing date).
and interest for the remaining period in the f.y.2010-11.
Please provide me in MS-Excel file only,so that I could solve my other fdr amount by puting the same in your file and keep it for future reference.
Please help.
With regards
Biswojit
Good morning!
I want to know how I'll calculate Quarterly Compound interest(on FDR) in excel.Also please help to calculate accrued interest(qtrly.compound).Please send in MS Excel file.
I'm giving an example for your understanding of my question:
Example
Let's say I made a FDR for Rs.16,00,000/- for 6 months @ 6% (quarterly compound interest) on 16.10.2009 maturity date is 16.04.2010.
Now my question is - how much accrued interest i'll have to booked as on 31.3.2010(financial year closing date).
and interest for the remaining period in the f.y.2010-11.
Please provide me in MS-Excel file only,so that I could solve my other fdr amount by puting the same in your file and keep it for future reference.
Please help.
With regards
Biswojit
29 May 2010
Please search in files section.
29 May 2010
I could not find,because it's just shown the formula of compound interest.But I need for accrued interest as well.please help...
29 May 2010
visit this link
https://www.caclubindia.com/share_files/files_display_search_results.asp?search_txt=interest&B1=GO
https://www.caclubindia.com/share_files/files_display_search_results.asp?search_txt=interest&B1=GO
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
- House Property Reporting in ITR
- Internship/Academic shown in Salary Pay Slip of a Doctor
- TDS Claim year
- Liable to deduct tds and 44ADA
- TDS Challan Code
- Nomination of Bank for refund in itr 2
- Section 56(2) of the Income tax Act 1961 , Gift to relative .
- Refund of 20%pre-deposit paid for stay application
- Rent lease agreement
- If there is Long term capital gain exists how much total income to be considered
- E Commerce GSTR1 & 3B how to file
- GST Cancellation without jurisdiction
- Legal Opinion on Registrar's Refusal to Investigate a Society for Non-Renewal and Non-Compliance
- GST Refund_RFD-01
- Form10BD was uploaded successfully without any Error but after 24 hours, Form10BE are not available
- Annexure B utility for GST Refund
- Tax amount diff in Gstr1 and 3B in tax compare reports
- Tds on GST in connection with sale to public company
- Restoration of certificate of practice
- Regarding change in correspondence address in SSP portal
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
