Acct 315 Excel Aol Assignment

AIS 315 Excel Project Credit Score Analysis The specific learning objectives of the case are for students to learn to: 1. Plan data analysis based on the business situation and the available data. 2. Analyze the data to compare loan performance for the two cutoff points for the credit scores: a. Develop a spreadsheet model for the analysis. 3. Write a one-paragraph memorandum to the CFO with a recommendation to raise the minimum credit score or to keep the current minimum score and a rationale for the recommendation. Using the attached Excel file and assignment document. Complete the steps and submit your assignment. Case for Analyzing Data - Excel Steps.pdf AIS 315 Excel Project Credit Score Analysis The specific learning objectives of the case are for students to learn to: 1. Plan data analysis based on the business situation and the available data. 2. Analyze the data to compare loan performance for the two cutoff points for the credit scores: a. Develop a spreadsheet model for the analysis. 3. Write a one-paragraph memorandum to the CFO with a recommendation to raise the minimum credit score or to keep the current minimum score and a rationale for the recommendation. The Scene Executives at YouDriveOut, a chain of used car lots, are brainstorming about how to ensure better financial performance. Alicia is the chief financial officer (CFO), and Manuel is the controller. Alicia: Manuel, I’m thinking about switching our minimum credit score cutoff from 430 to 450 to improve our overall loan performance, that is, to increase the proportion of payments that our customers make on loans. Manuel: You want me to compare the loan default rates for these? Alicia: Yes, that’s the idea. Manuel: Any particular format? Alicia: No, but whatever you create should show the difference in overall loan currency with the impact on sales for the two cutoff numbers. And be sure to do the analysis by dealer with the dealer street address. Pivot tables could be useful. It would also be helpful to see the analys