Which of the methods used above will yield the lowest figure for gross profit for the income statement? Explain why.

Replicate the Tables and Charts (including the formatting) displayed in the screen captures Answer the following questions in your Excel file and upload the Excel file on BlackBoard a. What percentage of rejected loans have poor or very bad risk scores? b. How many loan applications were rejected where the applicant had more than 5 years of employment? c. What % of rejected loan applications were from applicants with Excellent credit risk score but High DTI? d. In Tables 5 and 6, why might applicants with high DTI (a negative credit risk attribute) have better credit e. Which of the two (DTI or risk score) appears to be the stronger determinant of loan rejections? 1. Run a rough pivot table at your end with State in Rows and Count of Rejected Loans in Values. Give 3 re Replicate the Tables and Charts (including the formatting) displayed in the screen captures Answer the following questions in your Excel file and upload the Excel file on BlackBoard a. What percentage of rejected loans have poor or very bad risk scores? b. How many loan applications were rejected where the applicant had more than 5 years of employment? c. What % of rejected loan applications were from applicants with Excellent credit risk score but High DTI? d. In Tables 5 and 6, why might applicants with high DTI (a negative credit risk attribute) have better credit e. Which of the two (DTI or risk score) appears to be the stronger determinant of loan rejections? 1. Run a rough pivot table at your end with State in Rows and Count of Rejected Loans in Values. Give 3 re