Finance Basics

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.

What Students Are Saying About Us

.......... Customer ID: 12*** | Rating: ⭐⭐⭐⭐⭐
"Honestly, I was afraid to send my paper to you, but you proved you are a trustworthy service. My essay was done in less than a day, and I received a brilliant piece. I didn’t even believe it was my essay at first 🙂 Great job, thank you!"

.......... Customer ID: 11***| Rating: ⭐⭐⭐⭐⭐
"This company is the best there is. They saved me so many times, I cannot even keep count. Now I recommend it to all my friends, and none of them have complained about it. The writers here are excellent."


"Order a custom Paper on Similar Assignment at essayfount.com! No Plagiarism! Enjoy 20% Discount!"


0 replies

Leave a Reply

Want to join the discussion?
Feel free to contribute!

Leave a Reply

Your email address will not be published. Required fields are marked *