Creating a Loan Application and Amortization Schedule for CKG Auto
CKG Auto’s Financial Department has asked you to finish developing an Excel workbook that it plans to use to use to analyze automotive credit application data stored in individual XML documents. The workbook is based on an existing credit analysis spreadsheet. The work book will be used to calculate loan payment information and create a loan payment information and create a loan authorization schedule for customers purchasing new and used vehicles from dealerships that provide financing options through CKG auto. The Smith.xml file contains simple data that you will import into the spreadsheet to test the workbook.
Complete the following