Spreadsheet: 817560d1676320250-amb-w-o-every-date-listed-average-monthly-balance-w-o-every-date-listed-
Sheet: LineOfCredit-TEST (2)

Line of Credit
 |  |  |  |  |  |  |  |  |  |  |  | © 2014-2016 Vertex42 LLC
 |  |  |  |  |  |  |  |  |  |  |  | Line of Credit Tracker
 | Borrower: | CCSI |  |  |  |  |  |  |  | [Lender Name]
 |  |  |  |  |  |  |  |  |  | [Address, City, ST  ZIP] |  | ◄ Update the header information
 |  |  |  |  |  |  |  |  |  | Phone: [Phone]
 |  |  |  |  |  |  |  |  |  |  |  |  | Average Monthly Balance
 |  |  | Credit Limit (reference) | 5000000 | ◄ Enter the Credit Limit |  |  |  |  |  |  |  | January |  | 2023-01-01 00:00:00 | 2023-01-31 00:00:00
 |  |  | Days in Year (for per diem rate) | 360 | ◄ Enter 365 or 360 for calculating the Per Diem rate |  |  |  |  |  |  |  | February |  |  | 2023-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | March |  |  | 2023-03-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | April |  |  | 2023-04-30 00:00:00
Summary To Date |  |  |  |  |  |  |  |  |  |  |  |  | May |  |  | 2023-05-31 00:00:00
 |  |  | Total Payments |  |  |  |  |  |  |  |  |  | June |  |  | 2023-06-30 00:00:00
 |  |  | Net Draws/Pay Downs |  |  |  |  |  |  |  |  |  | July |  |  | 2023-07-31 00:00:00
 |  |  | Total Draws |  |  |  |  |  |  |  |  |  | August |  |  | 2023-08-31 00:00:00
 |  |  | Total Payments |  |  |  |  |  |  |  |  |  | September |  |  | 2023-09-30 00:00:00
 |  |  | Total Interest Accrued |  |  |  |  |  |  |  |  |  | October |  |  | 2023-10-31 00:00:00
 |  |  | Total Interest Paid |  |  |  |  |  |  |  |  |  | November |  |  | 2023-11-30 00:00:00
 |  |  | Total Currently Owed |  |  |  |  |  |  |  |  |  | December |  |  | 2023-12-31 00:00:00
Payment and [NAME] |  |  |  |  |  |  |  |  | Rounding of Interest Accrued is: | Off
Date | Interest Rate | Interest Payment | Draw/Pay Downs | Memo | Interest Accrued | Interest Paid | Interest Balance | [NAME] | Principal Balance | Total Owed
2022-12-27 00:00:00 |  | -738.88 |  | Beginning Accrued Interest |  |  |  |  |  |  |  | ◄ Enter the Date, Interest Rate, Payment, and Draw
2022-12-27 00:00:00 |  |  | 250000 | Draw
2022-12-30 00:00:00 | 0.075 |  |  | Accrued Interest
2022-12-30 00:00:00 |  |  | -100000 | Payment
2023-01-01 00:00:00 | 0.075 |  |  | Statement Date |  |  |  |  |  |  |  |  |  | date | rev
2023-01-01 00:00:00 |  | 738.88 |  | Interest Payment |  |  |  |  |  |  |  |  |  | 2023-01-01 00:00:00
2023-01-06 00:00:00 | 0.075 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-02 00:00:00
2023-01-06 00:00:00 |  |  | -150000 | Payment |  |  |  |  |  |  |  |  |  | 2023-01-03 00:00:00
2023-01-10 00:00:00 |  |  | 550000 | Draw |  |  |  |  |  |  |  |  |  | 2023-01-04 00:00:00
2023-01-12 00:00:00 | 0.075 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-05 00:00:00
2023-01-12 00:00:00 |  |  | 150000 | Draw |  |  |  |  |  |  |  |  |  | 2023-01-06 00:00:00
2023-01-23 00:00:00 | 0.075 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-07 00:00:00
2023-01-25 00:00:00 |  |  | 900000 | Draw |  |  |  |  |  |  |  |  |  | 2023-01-08 00:00:00
2023-01-27 00:00:00 | 0.075 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-09 00:00:00
2023-01-27 00:00:00 |  |  | 200000 | Draw |  |  |  |  |  |  |  |  |  | 2023-01-10 00:00:00
2023-02-01 00:00:00 | 0.075 |  |  | Statement Date |  |  |  |  |  |  |  |  |  | 2023-01-11 00:00:00
2023-02-01 00:00:00 |  | 3520.83 |  | Interest Payment |  |  |  |  |  |  |  |  |  | 2023-01-12 00:00:00
2023-02-01 00:00:00 |  |  | -1000000 | Payment |  |  |  |  |  |  |  |  |  | 2023-01-13 00:00:00
2023-02-02 00:00:00 | 0.0775 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-14 00:00:00
2023-02-07 00:00:00 | 0.0775 |  |  | Accrued Interest |  |  |  |  |  |  |  |  |  | 2023-01-15 00:00:00
2023-02-07 00:00:00 |  |  | 200000 | Draw |  |  |  |  |  |  |  |  |  | 2023-01-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-29 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-30 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-01-31 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-01 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-02 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-03 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-04 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-05 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-06 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-07 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-08 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-09 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-10 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-11 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-12 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-13 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-14 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-15 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-16 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-17 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-18 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-19 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-20 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-21 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-22 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-23 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-24 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-25 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-26 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-27 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  |  | 2023-02-28 00:00:00
 |  |  |  |  |  |  |  |  |  |  |  |  | 738.88 | Statement Balance
 |  |  |  |  |  |  |  |  |  |  |  | ◄ Add new rows above this line (do not forget to copy formulas down)