Enclosing my working Swaraj Engine for an investor who got allotment in IPO and continue to hold without any action (neither participating in buyback nor subscribing in rights but continue to hold orignial holding and receive dividend). Over a period (since 1989 when compnay did IPO (assumed at par of Rs 10 each) Rs 1000 invested (100 share @ 10 per share), would have grown to ~850,000/- (600 shares @ 1408 share price on March 2019) giving XIRR of 46% (cell W34 in enclosed excel file) over 30 years. Net profit data available from FY92 to FY19 (27 years) increased at 16% CAGR.
Please refer to enclosed file for details.
Swaraj Engine XIRR since IPO.xlsx (43.4 KB)