I need help creating an amortization schedule in excel with a prorated first month payment

The situation is a leased piece of equipment with 48 payments of 701.00.   However, the first month payment  is prorated based in delivery date of the equipment. 

SO the first month payment is 316.58 calculated as: 701.00/31=22.61, and then 22.61 x 14 days = 316.58.  The first month payment for partial October was charged in November along with the first payment of 701.00.

1st payment: 316.58 (Charged in November 2019 that was for Oct 2019)
47 payments: 701.00 (Charged November 2019 - Sept 2023)
49th payment: 384.42 (Charged Oct 2023)

There is a remaining book value of 9,975.00 at the end of the lease that needs to be included.

The capitalized amount is 35,600.00.   We paid 8,900.00 as a pre-paid amount that should be the interest amount.  In messing around in excel, I haven't been able to get an amortization schedule that has interest close to this amount.

How do I setup an amortization schedule for this in excel?

Thanks.