Hello All,
I am working on a project for a school club and want to see what the community's thoughts are on building a worksheet that tracks funds lent and funds borrowed would look like. Essentially, I will be a middle bank, borrowing from an outside lender funds and then lending those funds to internal borrowers. I would be able to track the due dates for the money borrowed as well as track the maturity dates for the money lent out.
Where I am stuck on is a way to build the worksheet for a long period of time, say 20 days, and be able to accurately track the principal lent out, maturity date for the lender who I have borrowed and the borrower who borrowed from me, the interest rate paid out/received, etc. Please let me know if you have any examples or thoughts on this. Thank you for giving me you time.
Best regards
Bookmarks