Excel file fоr scrаtch wоrk.xlsx fоrmulаs for quiz.docx Select True for credit аnd to acknowledge reading these directions: Download the attached for all formulas if you feel the need. Use the attached Excel file for calculations. (it is blank). Show all work in the Excel file. Inventory Turnover = Cost of Goods Sold/ Inventory Days in inventory = 365/Inventory Turnover = (1/Inv Turn) *365 = (inventory/COGS per day) = (Inventory/COGS)*365 Receivables Turnover = Sales / Account Receivables Days Receivable = (Receivables/Sales per day) = (AR/(sales/365) = (1/receivables turnover)*365 = (Account Receivables/Sales)*365 Accounts Payable Turnover = purchases/ Accounts Payable Days Payable = (Payables/ purchases per day) = Payables/ (COGS/365) = (1/payable turn) *365 = (Payables/COGS)*365 Nominal cost of trade credit = (discount percentage/(1-discount percentage) * (number of periods per year the cost is incurred) EAR= (1 +period rate)(365/n) - 1