This project asks the student to complete an accounts receivable workbook for an auto dealership which provides in-house auto loans. They will need to import loan data, and add 3 additional borrower accounts, calculate monthly payments, calculate whether the borrower is on time or past due in their payments, apply conditional formatting, and if an account is past due how many days they’re in default. They are to prepare a status sheet, in addition to creating a histogram of the default accounts,