• Jun 2, 2026 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 By Kathlyn Hamill
