Ravi Sir's Cards › Excel
Money Lent Tracker in Excel (card 1 of 2)
Revision card 1 for Money Lent Tracker in Excel: Days so far: =$B$3-C6 gives 199; Interest so far: =B6*D6*F6/365 gives ₹2,180.82; Total to get back: =B6+G6 gives ₹52,180.82. Includes an example data table.
Read card text
What this card says
1 for Money Lent Tracker in Excel: Days so far: =$B$3-C6 gives 199
Interest so far: =B6*D6*F6/365 gives ₹2,180.82
Total to get back: =B6+G6 gives ₹52,180.82. Includes an
Example
data table
Learn this in the lesson: Money Lent Tracker in Excel: Simple Interest by Days, Total Due and Overdue Loans