Comments on: Background and Orientation

By: Karthik Rangappa

Karthik Rangappa — Fri, 08 Nov 2024 06:23:10 +0000

In reply to Nakul Chandra. Noted. Thanks :)

By: Nakul Chandra

Nakul Chandra — Fri, 08 Nov 2024 03:12:01 +0000

Hey, love the content. Just a correction – In the table (4th column), the title should be “Sister 3”, and not “Sister 2”.

By: Karthik Rangappa

Karthik Rangappa — Fri, 27 Sep 2024 05:50:16 +0000

In reply to Anirban Basak. No, not yet Anirban. But if its via a mutual fund, then you can via Coin right?

By: Anirban Basak

Anirban Basak — Thu, 26 Sep 2024 05:29:17 +0000

Sir,

Do Zerodha has provision to invest in US growth Index funds/MFs? I found one for Motilal oswal. However it allows for SIP. However, I am a lumpsum investor. Could you kindly help me how to proceed?

By: Karthik Rangappa

Karthik Rangappa — Wed, 25 Sep 2024 04:02:14 +0000

In reply to Mamta. Hey, I need to double check this. But looks like you've done that already.

By: Mamta

Mamta — Tue, 24 Sep 2024 08:21:10 +0000

Hey Karthik, I think for the first 9 years, it works same as the SIP. The formula for those 9 years is FV = P × (((1 + i)^n – 1) / i) × (1 + i).

By: Karthik Rangappa

Karthik Rangappa — Tue, 24 Sep 2024 07:34:48 +0000

In reply to Mamta. I need to double check this. But your formula seems right.

By: Karthik Rangappa

Karthik Rangappa — Tue, 24 Sep 2024 07:33:44 +0000

In reply to Mamta. Did you check the formulas linked to the excel? If not, please do let me know.

By: Mamta

Mamta — Mon, 23 Sep 2024 13:30:29 +0000

Hi, I have found how the first sister’s money accelerated to 4.89 crores. Do have a look at this sheet.

Principal Interest(%) Interest (INR) Amount
50000 12 6000 56000
106000 12 12720 118720
168720 12 20246.4 188966.4
238966.4 12 28675.968 267642.368
317642.368 12 38117.08416 355759.4522
405759.4522 12 48691.13426 454450.5864
504450.5864 12 60534.07037 564984.6568
614984.6568 12 73798.15881 688782.8156
738782.8156 12 88653.93787 827436.7535

This data is for the first 9 years and then the last amount i.e. 827436 gets compounded for the rest 36 years.
827436 * (1+12%)^36 = 48930902.7492 i.e. 4.89 crores.
let me know if you have any formula for the first 9 years because simply the compound interest formula won’t work there as the amount is reinvested every year. So the principal amount becomes (Amount of the previous year+50000).

By: Mamta

Mamta — Mon, 23 Sep 2024 12:56:07 +0000

Hi,
Please explain me how 4,50,000 turned into 4.89 crores. Your sheet does not help me. Please guide me through calculation.

By: Karthik Rangappa

Karthik Rangappa — Mon, 23 Sep 2024 05:55:22 +0000

In reply to Maddy. About the math, I think my sheet is correct, but I will double check.

By: Karthik Rangappa

Karthik Rangappa — Mon, 23 Sep 2024 04:58:55 +0000

In reply to Mayank Jain. Ah, thanks for pointing that Mayank. Will surely look into this and fix.

By: Maddy

Maddy — Sun, 22 Sep 2024 16:17:59 +0000

Hi!
If the 3rd sister invested Rs. 19 lakh, then it means she invested 28 years annually from 28 to 65 years. So, that means even the amount received on the 65th birthday was invested. Shouldn’t the amount be 3.41 crores instead of 3.05 crores?
Also, for the 1st & 2nd sister the amount stayed invested till their 65th birthday, so the amount received by them should be 5.48 crores and 2.21 crores respectively. Please confirm

By: Mayank Jain

Mayank Jain — Sun, 22 Sep 2024 04:46:09 +0000

Sir,
Recommending a small correction –
In the Excel screenshot which you shared, the headers should be sister1, sister2 and sister 3. As of now it’s sister1, sister2 and sister2 🙂

Hope you don’t mind.

Thanks,
Mayank

By: Karthik Rangappa

Karthik Rangappa — Wed, 29 May 2024 09:07:55 +0000

In reply to Sahil. The mobile certification is a more of a casual certification, which you can give anytime, on your own. But the one on the website is proctored and scheduled. Its like a proper exam.