Jeff borrowed $57,800 from bank to buy an SUV at 3.9% compounded monthly. payments of 2056 are required at the end of every month. construct a complete amortized schedule in Ms Excel showing the details of all payments and the total.
the schedule needs to have the following headings:
payment number
amount paid
interest paid principal repaid
outstanding principal balance ​