• 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…