Payment in a line of credit loan using Excel

[John2222]

Hello,
Kindly, help with this task:
I want to use Microsoft excel to show loan payment at the beginning of every month, by first creating a schedule for the last 2 months of a draw period of a line of credit (LOC) loan using the average daily balance method with a fixed APR. For example, a file shows a beginning balance of $10,000 and charges (loan advances) throughout October. Payments of $2500 are made on the 1st and 15th of each month and there are no new charges in the month of November. The "Payment/deposit" column represents payments that are in addition to the Nov. 1 payment and the Dec. 1 payment. Find the Nov. 1 payment and Dec. 1 payment respectively?

I have attached the file image here. Thank you.

 

[John2222]

Below is the file.

Last Two Months of Draw Period
7.0%​	interest rate (APR, fixed rate)
			Nov. 1 payment:	$323.57​
			Dec. 1 payment:	$406.21​
Date	Beg. Balance	Charge (Loan Advance)	Payment/ deposit	End Balance
10/1/2020​	$ 10,000.00	$ -	$ 2,500.00	$ 7,500.00
10/2/2020​	$ 7,500.00	$ -	$ -	$ 7,500.00
10/3/2020​	$ 7,500.00	$ 300.00	$ -	$ 7,800.00
10/4/2020​	$ 7,800.00	$ -	$ -	$ 7,800.00
10/5/2020​	$ 7,800.00	$ -	$ -	$ 7,800.00
10/6/2020​	$ 7,800.00	$ 800.00	$ -	$ 8,600.00
10/7/2020​	$ 8,600.00	$ -	$ -	$ 8,600.00
10/8/2020​	$ 8,600.00	$ -	$ -	$ 8,600.00
10/9/2020​	$ 8,600.00	$ 200.00	$ -	$ 8,800.00
10/10/2020​	$ 8,800.00	$ -	$ -	$ 8,800.00
10/11/2020​	$ 8,800.00	$ -	$ -	$ 8,800.00
10/12/2020​	$ 8,800.00	$ 1,500.00	$ -	$ 10,300.00
10/13/2020​	$ 10,300.00	$ -	$ -	$ 10,300.00
10/14/2020​	$ 10,300.00	$ -	$ -	$ 10,300.00
10/15/2020​	$ 10,300.00	$ -	$ 2,500.00	$ 7,800.00
10/16/2020​	$ 7,800.00	$ 1,200.00	$ -	$ 9,000.00
10/17/2020​	$ 9,000.00	$ 350.00	$ -	$ 9,350.00
10/18/2020​	$ 9,350.00	$ -	$ -	$ 9,350.00
10/19/2020​	$ 9,350.00	$ -	$ -	$ 9,350.00
10/20/2020​	$ 9,350.00	$ -	$ -	$ 9,350.00
10/21/2020​	$ 9,350.00	$ 200.00	$ -	$ 9,550.00
10/22/2020​	$ 9,550.00	$ -	$ -	$ 9,550.00
10/23/2020​	$ 9,550.00	$ 500.00	$ -	$ 10,050.00
10/24/2020​	$ 10,050.00	$ -	$ -	$ 10,050.00
10/25/2020​	$ 10,050.00	$ -	$ -	$ 10,050.00
10/26/2020​	$ 10,050.00	$ -	$ -	$ 10,050.00
10/27/2020​	$ 10,050.00	$ -	$ -	$ 10,050.00
10/28/2020​	$ 10,050.00	$ 1,300.00	$ -	$ 11,350.00
10/29/2020​	$ 11,350.00	$ 800.00	$ -	$ 12,150.00
10/30/2020​	$ 12,150.00	$ -	$ -	$ 12,150.00
10/31/2020​	$ 12,150.00	$ -	$ -	$ 12,150.00
11/1/2020​	$ 12,150.00	$ -	$ 2,500.00	$ 9,650.00
11/2/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/3/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/4/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/5/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/6/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/7/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/8/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/9/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/10/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/11/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/12/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/13/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/14/2020​	$ 9,650.00	$ -	$ -	$ 9,650.00
11/15/2020​	$ 9,650.00	$ -	$ 2,500.00	$ 7,150.00
11/16/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/17/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/18/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/19/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/20/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/21/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/22/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/23/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/24/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/25/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/26/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/27/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/28/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/29/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00
11/30/2020​	$ 7,150.00	$ -	$ -	$ 7,150.00