iou form excel

B2: "Lender Name" C2: "Amount Borrowed" D2: "Date of Loan" E2: "Due Date" F2: "Interest Rate (%)" G2: "Interest Amount" (auto-calculated) H2: "Total Repayment" I2: "Amount Paid" J2: "Remaining Balance" K2: "Notes" Step 3: Inputting Formulas Interest Calculation: In G3, input `=C3F3/100(DATEDIF