Fund/Stock Return Calculation and Comparison (தமிழ்)

[@PraveenKumar-hr9rg]

தான் வளர்ந்தால் போதும் என்கிற மனப்பான்மை இல்லாமல் பிறரும் வளர வேண்டும் என்ற எண்ணம் ...❤🙏

[@jyogaraja]

நன்றி

[@vc8172]

exactly, well said!!

[@jk1213ihs]

Agree

[@funtech_founder]

People like you deserve to get ₹100 on every video from viewers. Happy to donate for your knowledge sharing process. I love your content and am educating my spouse too from the knowledge I got it from you. ❤️

[@iamDamaaldumeel]

*மிக்க நன்றி விஜய். உங்க XIRR கூகுள் விரிதாளை என் தேவைக்கேற்ப மாற்றிக்கொண்டேன்.* 😁 *Portfolio dashboard செய்தேன்.* *விற்பனை தேதியை எதிர்காலத்தில் வைத்து வருங்கால IRR கணிப்பிற்கும் மாற்றினேன்.* *மிகமிகப் பயனுள்ளதாக இருக்கிறது.* 🙏🙏🙏

[@mrwiltofficial]

You Deserve At least 1 million subscribers

[@equitytrader_001]

2:16 Actually, I was looking for the formula to calculate CAGR, didn't get it exact one.. Thanks for it! 😊😊

[@jebakumard4855]

Inthaa calculation poda Naa one year ah Google sheet kuda sanda pottu iruken.. thank you sir

[@InvestmentInsightsTamil]

🤣

[@RajaRajan-yc6uh]

Simple, No-Non sense, precise content, super Sir!!

[@Sudhak-z1h]

As I said earlier, I started watching all your videos recently.. for a novice like me, your channel is encyclopedia.. whenever a questions comes up there is a video to it.. I have deep love for Math right from school days which was implanted by my 3rd grade math teacher..You remind me of him in every video and teaching financial literacy to me now.. every video is clear and simple for a beginner.. I pause your video number of times to take notes and watch it multiple times to process the information! Though I feel bad to start very late (37 now😊), your videos give the hope and feel that it’s never too late to start.. Very grateful for your service here! Keep teaching and enlightening us!!

[@rajasekaranmam]

In mutual funds app, used to see XIRR but understood today what it is. Thanks

[@itzdevaraj]

It took me a lot of time to understand these concepts in the past. After watching your video I got more clarity. Thank you for this awesome video.

[@k.vinothmec]

Excellent Sir.. Definitely very much simpler and clearer 👌🙌🔥 Educate us with lot more financial inputs 🎉🎉🎉

[@venkey27389]

One of the most important videos from you. I have seen so many financial influencers use only CAGR for return comparison. Thank you for making this video.

[@justbe3708]

Dear Vijay, very long time I am thinking about the calculation how to do. Now I got it from you. Thanks a lot

[@sunderpp6280]

Very well explained in detail even layman can understand. Thank you very much 🙏🙏

[@IdealInvestIN]

I didnt try to explore these. I was calculating manually with own formulas. Thanks for the info.

[@narainsrividya341]

Can’t say this again. Vijay so simple explanation and giving superb tools to folks who think this is complicated. Kalakkal 🙏

[@priyadurai9303]

Clear explanation in easy to understand way..Thank you so much 💐❤️

[@cjmgtulips]

Super sir, i am watching your videos since February 23, my fear about stock market all clear sir then i invest index fund,its going nice sir, thank you very much sir 💐

[@pravinkumar1987]

Awesome I was trying to understand this XIRR since long time. Thanks for clarifying. ❤

[@prawingr9521]

Fantastic sir. When I started my investment journey a year back, I did tried to make a similar sheet to track my fund's performance. Since I was a beginner at that time, I used many manual formulas with manual entries. Today, you just showed a simplified method for the same. Thank you. Keep enlightening us.

[@sivasenthil24]

விஜய் மோகன் Sir வணக்கம்.. குரு என்பவர் இருட்டிலிருந்து வெளிச்சத்துக்கு அழைத்து செல்பவர்... நிதி சம்பந்தமான உங்களது அனைத்து பதிவுகளும் ஒரு குரு போல என்னை தெளிவாக்கியுள்ளது. வாழ்த்துக்கள் சார்

[@InvestmentInsightsTamil]

🙏🏽

[@seenipoovaraj6941]

Sir.. I have started investment after following your channel.. We are just beginners we need to update more knowledge.. Hence we are requested you to put more videos about investment if possible.. It would be helpful for young people just started investment... Thank you.. Keep rocking

[@RajagopalSankaranarayanan]

Thank you so much for the video sir.. Have been waiting for your new videos so that I can keep learning something new related to investment 🙏🙏

[@arunrajendran529]

Great explanation Vijay sir. Thank you. Romba naal sandhegam solved

[@ArunRaj-vi2ns]

Much needed, Thanks Sir 🙏🙏🙏 and your humours in between is also nice 😂

[@vijisubi8928]

Thank you very much sir, it is useful for my CMA capital budgeting as well as for my investment. Even my MBA and CMA lectures dint explain what is the purpose of IRR and XIRR, simply they explain formula.. which is very hard to understand.. now I got it..

[@vijisubi8928]

Please explain more concepts like this.. future, option, put call parity, strips, straps.

[@sulthanbathusha6224]

Wonderfull explanation sir I love you 😊😊😊

[@private54321]

Thank you so much for this amazing video, really helpful

[@shandreshkumar8811]

Thanks for the clear cut explanation sir🙏🙏🙏

[@jayanthic7188]

Mikka nandri sir... U r one of my best teacher...❤❤

[@ganeshbaskaran9911]

Super, Thanks for explaining XIRR in simple terms👌

[@arunjohnso]

Hi sir, have watched all your videos, very informative and useful. Have been investing for 4yrs. But first time calculating XIRR. Thanks a lot for the nice Excel sheet. I made one correction in 'XIRR with selling ' for total current value. For the units sold, I think we have to subtract the current value of sold units , instead of value during sold date

[@InvestmentInsightsTamil]

Good catch.👏🏽 Thanks for letting me know. I just fixed the sheet.

[@gowrishankarmanickam7631]

Good explanation. Thank you 🙂

[@berne6648]

Thank you so much, this helps in understanding our investment.

[@worldasiknow]

That was very useful. Thank you 😊

[@yourganesan]

Wow! Porulaathara Vaathiyaar ❤

[@ramboo23]

Thanks anna for your valuable teaching as always. 🤟

[@lathan8486]

It's amazing that you provide the sheets for our ease of use. Tremendous help!

[@Kosaksi12]

Thank you sir, last time this question I ask. With in 3 days u post. ( if any grammar mistakes pls apologies)

[@Arunkumar0710]

Sir , You are very great!

[@buvaneswranc5860]

Sir I Appreciate your efforts on this a complex concept told simply also please put a video about getting rate of return from FD and NCD also some corporate bonds.

[@sivakumarganesan5786]

Amazing sir … the contribution you are doing is immense sir … 🙏🙏🤝

[@aravindana1484]

Very useful information. Thank you so much sir.

[@jebastinyabase5955]

Thank you for the video sir, can you please explain about the rolling returns..

[@DevaRaj-iw9wx]

how can time management create and important please explain very helpful for all other

[@a.sathishplk]

Nice new useful info sir, thank you🙏

[@narayanf5493]

That 100rs donate was nice one to wake up most of us 😀

[@InvestmentInsightsTamil]

🤣

[@prabhuism]

wow, can’t explain better than this, outstanding

[@jai123480]

Vijay sir, The concept might seem simple but i can bet many people are there who don't understand it (Myself being one among them), Thank for your effort and time to explain it. Please make a video on which stage of finance one can move to different investment instrument (like trading or individual stock purchase) and what knowledge is required to enter those? Or is it better to stick to mutual funds fully till retirement Once again, Thanks a lot !

[@coolguy914]

Very good and helpful video ..

[@abhijitbalaji]

What is the difference between XIRR and Money weighted rate of return?

[@rajan9018]

For example help me to identify tata steel fund code

[@rajeshnarayanan5723]

Sir , vera level intro🎉

[@KarthikeyanRamaswami]

Thank you VM !!! Although it will be useful for the beginners who are new to investing, this will be helpful to calculate XIRR on their recent investments journey. But what about the seasoned investors who have been investing for the past 5 years ? Do they have to go back to their Investments Histories to find the dates, purchase prices and then do the XIRR calculations?

[@InvestmentInsightsTamil]

If you want to know your exact return, then yeah. Else, at least having a rough idea of your returns should be good enough.

[@KarthikeyanRamaswami]

@@InvestmentInsightsTamil If we sold some of the stocks, How to update this sheet and calculate XIRR ? Can you show us an example(may be in the same google sheet) on calculating XIRR if the event of stocks sold as well ?

[@InvestmentInsightsTamil]

@@KarthikeyanRamaswami It is just another row for that positive cash flow that is all. Say that you are selling VTI for $3000 on May 16, you will add that as a positive cash flow entry (as you are taking the money out). That is all.

[@KarthikeyanRamaswami]

@@InvestmentInsightsTamil Ok. If this applicable for not selling all the SHARES and only partly selling few shares (of the same company) ... ? Also, what do put in the Current Value column for the shares SOLD ? Zero ? Won't the previously BOUGHT Shares (of the same company) Current Value mess up with XIRR if we already SOLD few shares of the same ?

[@InvestmentInsightsTamil]

@@KarthikeyanRamaswami Good point. So when you sell a stock, the "invested money" column will have sales proceeds as a positive value. And the current value cell needs to be updated to be negative of sales proceeds value, so that the current total value reflects the right current total value. let me see if I can add another table that can accommodate for sold units as well, so that it is clear for data entry.

[@esakkiappanramaswamy255]

Thank you for your valuable information

[@thilakbabu9697]

10Y annualized returns lower than category average by 3.36% - Meaning please sir.

[@baratharumugam2292]

Thanks Vijay Sir

[@vijumathew8816]

Vanakkam from kerala 👍👌

[@saravanakumarshanmuganatha4439]

Great information Vijay!

[@inzamamnizarahamath8294]

Thank you ❤

[@JosephAdrian-y2q]

Super sir. We have to include tax paid for dividends and capital gains if we sell anything

[@venkey27389]

I have a question, hope you can help clarify that. If I have a holdings of $30k in my portfolio and due to a need if I plan to sell $15k from it, on what criteria should I pick the assets(stocks and etfs) to sell? - sell stocks/ETFs that has given me good returns? - sell those that has not given good returns? - keep those that have potential to give good returns in future and sell others? - sell ones that were bought earliest and keep ones bought recently? - any other criteria?

[@InvestmentInsightsTamil]

I would sell that has least potential to grow in the future.

[@venkey27389]

@@InvestmentInsightsTamil thank you so much

[@yshankar3943]

Sir Canara Rebecca manufacturing fund apply pannalama

[@kandasamy6401]

Super sir... Stocks calculation sir

[@InvestmentInsightsTamil]

Same. Use the stock ticker instead of fund code.

[@iamkgraman]

Super video... Thanks ❤❤❤

[@sivamusic1]

Nice explanation.

[@kal-el2179]

Nifty bees, it bees, pharma bees, bank bees la invest pannalama 😅yaarachi sollunga and uti index fund ❤

[@ashokkumar-cw8cw]

Sir, index fund returns are volatile daily. If I’m selling a fund, would I get returns based on xirr?

[@thirunavukkarasuvaratharaj8009]

அருமை sir .

[@vimalrajk6576]

Sir explain about how to identify undervalued stocks less then book value ??and monopoly stocks ??

[@karthiksst]

Thanks Sir for the video. can you please also explain how to track the current price of 22 carat gold in google sheets.

[@InvestmentInsightsTamil]

Google finance does not have the option to track commodities for now. But you can track the ETF GLD. =GOOGLEFINANCE("GLD","price")

[@sforsendil]

What is your view on kissan vikas pathra

[@k.sundararajan6886]

நன்றி ஐயா .

[@singaramsingaram2075]

Sir, for Mutual Fund return calculation we can use XIRR. But for comparing two stocks’s return, we can use CAGR right? Because month on month investment illa sir in stocks, one time purchase only for the most part. Kindly clarify

[@InvestmentInsightsTamil]

Most of us buy our investment at different periods of time, not necessarily in SIP. For different dates of investment, XIRR gives you accurate return rate. You can use XIRR even if you have bought a stock just once. Or in other words, XIRR fits all situation to calculate the return rate of our investments.

[@singaramsingaram2075]

@@InvestmentInsightsTamil Thanks for your reply Sir 😊

[@தமிழகஇந்தியா]

Thalaiva super ❤

[@sivareplies]

Thanks Vijay

[@jaikrishna741]

Is rich dad poor dad book is related to india?

[@kaja.mohideen]

Heart felt thanks 🙏

[@harikrishnanselvaraj1732]

Very good explanation… thanks 🙏 How do calculate return rate in case we sell and buy the fund partially and how tax get calculated for it… Ex… assume we bought same fund at different time when the price was falling and sold partially when it was going up

[@InvestmentInsightsTamil]

When you sell, you just add a positive cash flow entry for that amount with the date. That is all.

[@harikrishnanselvaraj1732]

@@InvestmentInsightsTamil thank you 🙏

[@senthilkumar5]

Must need formula 😊

[@karthigaanand2190]

Sir . Nice video . Can you plz suggest some insights for starting investment in Us stock markets from US

[@InvestmentInsightsTamil]

Stocks Portfolio: kzbin.info/www/bejne/gZWmpGZ7jKx9rLM

[@gokulkavin9801]

சாா், வணக்கம். இந்த Sheet டை Stock Return பாா்க்க பயன்படுத்தலாமா? நான் கையில் பணம் இருக்கும் போது மட்டும் ஒரு சில Company shares மட்டும் 1 or 2 என வாங்கிவைத்துள்ளேன். இதற்கு Return எப்படி கணக்கிடுவது? நன்றி.

[@InvestmentInsightsTamil]

Stock Returnகும் பயன் படுத்தலாம்.

[@prajan5971]

Thanks Vijay 😊

[@saiprasadambatiprabhakar1314]

what is your opinion on changing world order of ray dalio? he predicts there might be a drastic change on 2050, USA might lose super power

[@InvestmentInsightsTamil]

He strongly believes in the rise of China. I am not convinced. But anything can happen.

[@rajan9018]

How to get fund code

[@radharangaswamy2257]

People are predicting Recession. What shd we do with our investments.

[@InvestmentInsightsTamil]

People always predict something all the time. It is to our best interest to ignore the noise and stay invested for long term.

[@123ezhumalai]

Oru nalla stock long time ku yeppadi choose pandrathu eppadi patta vidayangal nama therinjukirathu appadinu oru video pannunga, enna madhiri irukiravangalukku payanpadum.

[@InvestmentInsightsTamil]

Stock Screener: kzbin.info/www/bejne/aZy6ZHaPdsyjisU

[@PremKumar-dk1zi]

Vijay , expecting detail video on IUL and whole life insurance . Thanks

[@InvestmentInsightsTamil]

It is never a good idea to mix investment with insurance needs. Why? Watch this: kzbin.info/www/bejne/fKuwoHafmM6Ymac

[@Sudhak-z1h]

I just completed watching building wealth series.. I have a question related to it.. do you have any suggestions for safely investing/growing funds needed for in next 5 years.. I need to save quite high amount in next 5 years (150k to fund daughter’s education due to immigration issue).. we have to save it religiously on monthly basis.. can you please tell me options for low risk with some growth options??

[@InvestmentInsightsTamil]

Which state are you in? Did you consider 529?

[@Sudhak-z1h]

@@InvestmentInsightsTamil in Michigan.. already contributing small portion in MIsave 529 but not seeing much growth there.. it’s in red always (less than capital)

[@InvestmentInsightsTamil]

@@Sudhak-z1h This will be a good option for you: www.misaves.com/investment/enrollment-year/2026-2027-enrollment-option/ They will automatically rebalance every year to have less volatility. Still risky though. If you want to avoid the risk, the only option is to have in High Yield Savings account that pays high interest like Apple Savings account.

[@ராமகிருஷ்ணன்-ச2ர]

ஐயா ஒரு சந்தேகம் நான் index fund ல் பணம் சேமிக்கலாம் என்று உள்ளேன். 30 வருடங்கள் சேமிக்க விரும்புகிறேன். ஆனால் நான் பாதியில் இறந்து விட்டால் அந்த பணம் என்னவாகும், அதை என் வீட்டார்கள் எப்படி பெறுவது?. இந்த சந்தேகம் நீண்ட நாட்களாக எனக்கு தோன்றுகிறது. இதற்கு விளக்கம் வேண்டும் ஐயா 🙏.

[@InvestmentInsightsTamil]

The brokerage/fund house gives you the option to nominate any of your family members as beneficiary.

[@ArjunHari6]

Thank you for the video sir. This is a generic question, considering the current advancement of technology, AI, hacking etc., how safe it is to invest in equities or any other non-physical assets.

[@InvestmentInsightsTamil]

I see the positive side of it. It is more secured than before.

[@ArjunHari6]

@@InvestmentInsightsTamil thank you!

[@VenkatJ-tl8nr]

Hi Vijay, Is XIRR and TWRR same or anywhere close? Clearly understand XIRR, Does is TWRR has a assumption of every month/annually beginning its invested something like that? Portfolio Visualizer gives only TWRR (Not XIRR) for any asset we compare! Can TWRR be considered any close with XIRR? Appreciate your help, Thank you so much in advance!

[@InvestmentInsightsTamil]

They are not same. TWRR is used more for comparing the performance of fund managers. www.solidarity.in/performance-measurement-the-difference-between-twrr-and-xirr/

[@VenkatJ-tl8nr]

@@InvestmentInsightsTamil Thank you Vijay!

[@prabagaran.s1285]

Nice video 👌👍👍

[@lakshmikrishnan5295]

Thank you for the spreadsheet ..🙏.. US debt ceiling, High Inflation... Enna pannalam Stock investment, 401k Safeaa?

[@InvestmentInsightsTamil]

Onnum panna koodaathu... atha thontharavu panaama, appadiye vittudanum.

[@krithikkumaran]

Thank you very much Vijay for all your wonderful insights!! Can you make some videos on how NRIs can invest in Indian stock market and how is the tax calculated? whether its worth after tax deduction (both in India and US) combined with Dollar vs INR appreciation to invest or is there any alternate for NRIs to invest in India?

[@InvestmentInsightsTamil]

India Vs USA: kzbin.info/www/bejne/kGPGmIZmm85-b6c

[@suresh_manokaran]

Sema thala 🎉

[@ravishankar_j874]

Sir, Please post video on how to invest in US index funds ; is Index based MF is better or Direct broker is better. Which platform to choose?

[@MS-xn3ek]

If you live in India you can't invest in us index funds directly. There are some India mutual funds that invest in us market. Direct broker option is best if ur comfortable investing on ur own in india

[@santhanapriyan9906]

Sir.. First of all thanks 👍🏼👍🏼. how the Column-C "purchase price" is getting loaded. You said its happening automatically. Could you plz explain from where its fetching that info? Curious 😅

[@InvestmentInsightsTamil]

Google finance formula. It automatically pulls market data based on date and ticker.

[@santhanapriyan9906]

@@InvestmentInsightsTamil great thanks sir...

[@senthilraja305]

Sir - Can you please put a video on will and trust.

[@karthiks6781]

Sir, please give your opinion on EPF Higher pension scheme, whether a person should opt for it?

[@MS-xn3ek]

Karthik, EPF scheme will be good for those who are going to be dependent on retirement income from this scheme and who has no exposure in other investments vehicles. If ur good in investing in other vehicles like stock market, real estate or any others, u invest ur money in that and you can use the returns in ur old age

[@karthiks6781]

@@MS-xn3ek Let me put it more clear......EPF is standard deduction from the salary on a regular basis.......My question is to leave it as a lumpsum and get the amount while retiring (or) Opt for EPF Higher pension scheme where 8.33% of employer contribution goes into the pension fund, also they retroactively take this contribution money from the starting date of the EPF account opening and credit into Pension fund.....My question is which is beneficial - to opt for higher pension scheme? (or) leave it as a Lumpsum which you can get while retiring.?