Excel file fоr scrаtch wоrk.xlsx fоrmulаs for quiz.docx You do NOT need to аttach the Excel file to the quiz before you turn it in. Select True for credit and 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). You do NOT need to attach the Excel file to the quiz before you turn it in. 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