Selected Answer
Hi Makunku and welcome to the Forum.
How do you do that? With some thought and hard work! (But see my final paragraph.)
The Forum is generally for (relatively straightforward) questions and answers; users shouldn't define a mini-project and expect us to deliver a solution. We expect you to have made an attempt first (preferably attaching that Excel file to your question, using the Add Files button when you create or edit it- but don't include personal details).
You may be lucky and someone will provide a starter file but we don't know anything about your cooperative, its numbers, loans (repayments/ formulae/interest rates etc).
You should forget the concept of "infinite" years incidentally - that's impractical (since Excel has row and column number limitations) and 80 years (say) will probably outlive Excel.
Not sure what your national laws are (Kenyan?) but, in the UK and many other countries, financial institutions are generally highly regulated and use specialist software to record and control transactions. For that reason alone I won't suggest a solution nor recommend that others do.