How to calculate xirr manually without using ms-excel
This query is : Resolved
26 December 2015
Date Transactions No of units Rate value
15-Jan-11 Unit Purchased 1000 14 -14000
01-Jul-11 Dividend 1000 2 2000
10-Dec-11 Dividend 1000 1.50 1500
01-Feb- 12 Unit sold 1000 14.85 14850
Calculate XIRR?
15-Jan-11 Unit Purchased 1000 14 -14000
01-Jul-11 Dividend 1000 2 2000
10-Dec-11 Dividend 1000 1.50 1500
01-Feb- 12 Unit sold 1000 14.85 14850
Calculate XIRR?
11 February 2016
Simple puts dates on one side and amount on other side. Keep Opening balance as negative.
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
- GSTR-1A How to update Invoice
- Excess salary payment.
- Stamp Paper for partnership firm change new income tax 2025
- Capital gain from sale of house property
- Current Account Opening for Sole Proprietorship with Udyam Certificate - Zero Turnover
- TDS on Purchase of Immovable Property by NRI from NRI
- FORM 26A APPLICABILITY
- SFT Cash Deposit in Current Account
- Annual return in Gst
- When TDS on GST applied
- Cash gift by grand mother to her grand daughter
- 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
- No Compliences after incorporation
- USEFUL LIFE OF USED/SECOND HAND COMMERCIAL VEHICLES
- Claiming TDS deducted by builder on Hardship compensation and Corpus
- Address Change to another state of a Registered Trust with 12AB approval
- Updated return in budget 2026
Trending Online Classes
-
DT & Audit (Exam Oriented Fastrack Batch) - For May 26 Exams and onwards Full English
CA Bhanwar Borana & CA Shubham Keswani
CAclubindia
