1. The worksheet Base Data in the Excel File Credit Risk Data provides information about 425 bank customers who have applied for loans. The data include the purpose of the loan, checking and savings account balances, number of months as a customer of the bank, months employed, gender, marital status, Age housing status and number of years at current residence, job type and credit risk classification by bank. a. Frequency Distribution for Categorical Data Use the COUNTIF Function to determine (1) how many customers applied for a new-car, business, education, small-appliance, and furniture loans. You may these at the bottom of the spreadsheet. b. Frequency Distribution for Categorical Data Use the COUNTIF Function to determine the number of customers with checking account less than $ 500.00. You may these at the bottom of the spreadsheet. c. Modify the spreadsheet using the IF Functions to include new columns, classifying the checking and savings balances as low if the balance is less than $ 250, medium if between $250 and less than 2000 and high otherwise. Add Conditional formatting. If the Checking account balance is low, change the cell color to red. If the Savings account balance is High change to Green.

Swathmore clothing corporation grants its customers 30 days' credit. the company uses the allowance method for its uncollectible accounts receivable. during the year, a monthly bad debt accrual is made by multiplying 3% times the amount of credit sales for the month. at the fiscal year-end of december 31, an aging of accounts receivable schedule is prepared and the allowance for uncollectible accounts is adjusted accordingly. at the end of 2012, accounts receivable were dollar 586.000 and the allowance account had a credit balance of dollar 50,000. accounts receivable activity for 2013 was as follows: the company's controller prepared the following aging summary of year-end accounts receivable: prepare a summary journal entry to record the monthly bad debt accrual and the write-offs during the year. (if no entry is required for a particular event, select "no journal entry required" in the first account field.) prepare the necessary year-end adjusting entry for bad debt expense. (if no entry is required for an event, select "no journal entry required" in the first account field.) what is total bad debt expense for 2013? calculate the amount of accounts receivable that would appear in the 2013 balance sheet?