This calculator returns the CAGR value based on Chit fund cash flows using Excel’s XIRR and IRR functions. Even if you have no interest in chit funds (good for you!), if you are someone who uses Excel to calculate returns (of any financial instrument), I strongly urge you play with this calculator as it highlights the limitations of estimating returns for complex cash flows.

Credits:

Reader R. Siva Prasad, requested that I make this calculator to try and make sense of chit fund returns. Earlier, reader Hari sent a video link which pointed out the limitations of XIRR and IRR when he saw my Investment Returns (XIRR) Calculator

Motivation: I am not a fan of chit funds. I did this for two reasons: Siva Prasad requested it and I saw it as a perfect example for illustrating the limitations of calculating returns for complex cash flows and therefore of the XIRR and IRR functions! No fault of Excels. That is just the way the cookie crumbles.

Chit fund Primer: The way a chit fund operates amazes me. A group of people get together and decide to pay an equal sum of money for a few months. Each month the group members bid on the total amount collected. The person with the lowest bid receives the amount after deducting commission or operating charges and can no longer take part in the bidding. The remaining amount is distributed equally to all the members.

How the calculator works functions:

CAGR using Excels IRR: If you wish to assume the payment and receipts each month are made on the same date then you need not enter the dates of payment and receipts. However,I strongly suggest that you do.

CAGR using Excels XIRR: In this case the dates of payments and receipts should be entered (along with amounts of course!).

advice your friends or clients not to use chit funds.

think about the limitation of XIRR and IRR!

Bottom line: Do not enter into chit fund schemes looking for returns. It is one thing to get poor returns, quite another when you cannot even calculate them!

Freefincal has open-source, comprehensive Excel spreadsheets, tools, analysis and unbiased, conflict of interest-free commentary on different aspects of personal finance and investing. If you find the content useful, please consider supporting us by (1) sharing our articles and (2) disabling ad-blockers for our site if you are using one. We do not accept sponsored posts, links or guest posts request from content writers and agencies.

Blog Comment Policy

Your thoughts are vital to the health of this blog and are the driving force behind the analysis and calculators that you see here. We welcome criticism and differing opinions. I will do my very best to respond to all comments asap. Please do not include hyperlinks or email ids in the comment body. Such comments will be moderated and I reserve the right to delete the entire comment or remove the links before approving them.

32 thoughts on “Dealing With Complex Cash Flows -I: Chit Fund Returns Calculator”

Thanks Pattu for choosing to write about this topic. I would like to know your views on whether chit funds are a good place to borrow. Also there is a concept called vacancy chit so does it make sense to get into the chit that way. I.e. enter in the 15 th month of a 40 month chit and exit in the 30 th month. regards Jagan

The trouble with chit fund is, for most cases the net cash flow will be negative. So you cannot determine returns! So why enter into such a scheme. Even a SB account offers more. Chits funds are a kind of personal loan for emergency needs that is all. You can try out the vacancy chit scenario with the calculator.

Thanks Pattu for choosing to write about this topic. I would like to know your views on whether chit funds are a good place to borrow. Also there is a concept called vacancy chit so does it make sense to get into the chit that way. I.e. enter in the 15 th month of a 40 month chit and exit in the 30 th month. regards Jagan

The trouble with chit fund is, for most cases the net cash flow will be negative. So you cannot determine returns! So why enter into such a scheme. Even a SB account offers more. Chits funds are a kind of personal loan for emergency needs that is all. You can try out the vacancy chit scenario with the calculator.

Pattu Sir, Normally we get minimum of 12% return and some times may get upto 20% return in chits. I got 18% return on my chit (net cashflow is +ve). Problem is when net cashflow is -ve. Just because we can not calculate returns, how can we conclude that chits are not profitable. Of course risk is there. I am talking about returns only. Sir, Please correct me if I am wrong.

Trouble there seems to be quite a high chance for getting negative cash flow. When this happens returns are negative. Just that there will be multiple negative solutions that we cannot find out which is the correct one. So I will personally stay away from chits.

Pattu Sir, Normally we get minimum of 12% return and some times may get upto 20% return in chits. I got 18% return on my chit (net cashflow is +ve). Problem is when net cashflow is -ve. Just because we can not calculate returns, how can we conclude that chits are not profitable. Of course risk is there. I am talking about returns only. Sir, Please correct me if I am wrong.

Trouble there seems to be quite a high chance for getting negative cash flow. When this happens returns are negative. Just that there will be multiple negative solutions that we cannot find out which is the correct one. So I will personally stay away from chits.

Dear Sir, Great Calculator. I use chits regularly and this will help monitor returns. One doubt though – typically, we take the chit amount and reinvest it – either in equity or fd…how can those returns be incorporated in this calculator? Do I jus add them in the positive cash flow section?

Dear Sir, Great Calculator. I use chits regularly and this will help monitor returns. One doubt though – typically, we take the chit amount and reinvest it – either in equity or fd…how can those returns be incorporated in this calculator? Do I jus add them in the positive cash flow section?

You are right, I have been advising all my close relatives not to get into Chit funds, I see someone above has posted that they can get return of about 20% or so, but the problem is the time duration is not accounted, we have to understand for one year period what is that we get, it will be much lower. In chit funds, except to the person running the show no one gets benefitted.

You are right, I have been advising all my close relatives not to get into Chit funds, I see someone above has posted that they can get return of about 20% or so, but the problem is the time duration is not accounted, we have to understand for one year period what is that we get, it will be much lower. In chit funds, except to the person running the show no one gets benefitted.

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM could give you a high ROI (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both)

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM could give you a high ROI (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both)

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

Hi, now a days, I see an improvised version of chits, which is famous among white collar guys, fixed no. of months and fixed amount. For ex: Rs 4000/- PM and per 25 months you will get 1,21,000 at end of the 25 months. Also, they give table to show how the amount varies if you lift at 1st, 2nd, 3rd…etc. If calculate this way, i will get 20% do you think this is better than FD and other…if you ignore other risks.

Hi, now a days, I see an improvised version of chits, which is famous among white collar guys, fixed no. of months and fixed amount. For ex: Rs 4000/- PM and per 25 months you will get 1,21,000 at end of the 25 months. Also, they give table to show how the amount varies if you lift at 1st, 2nd, 3rd…etc. If calculate this way, i will get 20% do you think this is better than FD and other…if you ignore other risks.

Thanks Pattu for choosing to write about this topic.

I would like to know your views on whether chit funds are a good place to borrow.

Also there is a concept called vacancy chit so does it make sense to get into the chit that way. I.e. enter in the 15 th month of a 40 month chit and exit in the 30 th month.

regards Jagan

The trouble with chit fund is, for most cases the net cash flow will be negative. So you cannot determine returns! So why enter into such a scheme. Even a SB account offers more. Chits funds are a kind of personal loan for emergency needs that is all. You can try out the vacancy chit scenario with the calculator.

Thanks Pattu for choosing to write about this topic.

I would like to know your views on whether chit funds are a good place to borrow.

Also there is a concept called vacancy chit so does it make sense to get into the chit that way. I.e. enter in the 15 th month of a 40 month chit and exit in the 30 th month.

regards Jagan

The trouble with chit fund is, for most cases the net cash flow will be negative. So you cannot determine returns! So why enter into such a scheme. Even a SB account offers more. Chits funds are a kind of personal loan for emergency needs that is all. You can try out the vacancy chit scenario with the calculator.

Pattu Sir,

Normally we get minimum of 12% return and some times may get upto 20% return in chits. I got 18% return on my chit (net cashflow is +ve). Problem is when net cashflow is -ve. Just because we can not calculate returns, how can we conclude that chits are not profitable. Of course risk is there. I am talking about returns only.

Sir, Please correct me if I am wrong.

Thank You

Trouble there seems to be quite a high chance for getting negative cash flow. When this happens returns are negative. Just that there will be multiple negative solutions that we cannot find out which is the correct one. So I will personally stay away from chits.

Pattu Sir,

Normally we get minimum of 12% return and some times may get upto 20% return in chits. I got 18% return on my chit (net cashflow is +ve). Problem is when net cashflow is -ve. Just because we can not calculate returns, how can we conclude that chits are not profitable. Of course risk is there. I am talking about returns only.

Sir, Please correct me if I am wrong.

Thank You

Trouble there seems to be quite a high chance for getting negative cash flow. When this happens returns are negative. Just that there will be multiple negative solutions that we cannot find out which is the correct one. So I will personally stay away from chits.

Dear Sir,

Great Calculator. I use chits regularly and this will help monitor returns. One doubt though – typically, we take the chit amount and reinvest it – either in equity or fd…how can those returns be incorporated in this calculator? Do I jus add them in the positive cash flow section?

Thanks. I have responded via email.

Sir, Had the same question. Please email the calculator that takes into account, the chit fund amount reinvested in equity/fd. Thanks in advance.

You can just add two more entries in the same calculator and find the net return. If you need help on how to do this, let me know.

Dear Sir,

Great Calculator. I use chits regularly and this will help monitor returns. One doubt though – typically, we take the chit amount and reinvest it – either in equity or fd…how can those returns be incorporated in this calculator? Do I jus add them in the positive cash flow section?

Thanks. I have responded via email.

Sir, Had the same question. Please email the calculator that takes into account, the chit fund amount reinvested in equity/fd. Thanks in advance.

You can just add two more entries in the same calculator and find the net return. If you need help on how to do this, let me know.

You are right, I have been advising all my close relatives not to get into Chit funds, I see someone above has posted that they can get return of about 20% or so, but the problem is the time duration is not accounted, we have to understand for one year period what is that we get, it will be much lower. In chit funds, except to the person running the show no one gets benefitted.

Thanks for your views. It feels good when someone reinforces your convictions. Keep visiting and sharing your thoughts.

You are right, I have been advising all my close relatives not to get into Chit funds, I see someone above has posted that they can get return of about 20% or so, but the problem is the time duration is not accounted, we have to understand for one year period what is that we get, it will be much lower. In chit funds, except to the person running the show no one gets benefitted.

Thanks for your views. It feels good when someone reinforces your convictions. Keep visiting and sharing your thoughts.

I bet you are just a techie guy and not a finance guy. I challenge i can make you accept that chit fund does benefit the general publit/subscriber.

Well I am neither a techie nor a finance guy and I am not interested in your challenge. If you think chits funds are good. So be it. I don’t care.

I bet you are just a techie guy and not a finance guy. I challenge i can make you accept that chit fund does benefit the general publit/subscriber.

Well I am neither a techie nor a finance guy and I am not interested in your challenge. If you think chits funds are good. So be it. I don’t care.

Hey Pattu,

Nice job with the calc.

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

Hey Pattu,

Nice job with the calc.

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM could give you a high ROI (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both)

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

Hey Pattu,

Nice job with the calc.

I agree with your point – returns cannot be calculated. However, that is not reason enough to discard these scheme. That is because

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both

ii) the former point holds true even with the rate of discount at which the loan is bidded. basically higher the discount, higher the return for others

There is a much bigger literature out there on the subject under ROSCA. Rotating savings and credit association. Interesting stuff

Disclaimer: I have nothing to do with chit funds. I don’t run one, neither am I related to one in any way. Landed here on academic interest

Hey Pattu,

Nice job with the calc.

i) Clearly, a bank acts as an intermediary to do lending borrowing right now. They charge an NIM. Theoretically, a chit fund charging a low NIM could give you a high ROI (translate that to lower commissions for the middleman, means higher return for savers, or lower interest for borrowers, or both)

Hi, now a days, I see an improvised version of chits, which is famous among white collar guys, fixed no. of months and fixed amount. For ex: Rs 4000/- PM and per 25 months you will get 1,21,000 at end of the 25 months. Also, they give table to show how the amount varies if you lift at 1st, 2nd, 3rd…etc.

If calculate this way, i will get 20% do you think this is better than FD and other…if you ignore other risks.

Thanks

Hi, now a days, I see an improvised version of chits, which is famous among white collar guys, fixed no. of months and fixed amount. For ex: Rs 4000/- PM and per 25 months you will get 1,21,000 at end of the 25 months. Also, they give table to show how the amount varies if you lift at 1st, 2nd, 3rd…etc.

If calculate this way, i will get 20% do you think this is better than FD and other…if you ignore other risks.

Thanks

Respected sir,

I want to start chits.which one is best and how much interest I will get after 50 months.

Hi Team,

I just noticed that the Chit Fund calculator excel file link is broken, please share the correct file link.