Reference no: EM131167450

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

• Open the Credit.xlsx file from the Chapter 7 folder, and the save it as Automotive Credit Application.xlsx.
• Use the XML Source task pane to create an XML source map using the Smith.xml file in the Chapter 7 folder
• Map the elements in the XML Source task pane to the appropriate cells in the worksheet by dragging them from the XML source task pane and dropping them into the appropriate cells in the worksheet.
• Use the Developer tab to map and import the appropriate elements from the Smith.xml document to the blank cells for the Application Information, Loan Details, and Vehicle information sections in the Automotive Credit Application worksheet.
• Insert the appropriate function and /or formula to calculate the monthly car payment.
• Prepare an amortization schedule based on the information imported from the XML document.
• Save and close the Automotive Credit Application.xlsx workbook.