Calculate the Leverage used in the DuPont Framework for this company based on its Balance Sheet and Income Statement. Use average balances in your calculation where applicable. (On 11/30/2012, the company had total assets of $60,173 and total equity of $43,835.) PROVIDE an EXCEL FORMULA

Cash and cash equivalents 17,224 Total assets on 11/30/2012: Accounts Receivable, net 3,107 60,173 Inventory 16,695 Other current assets 2,162 Total equity on 11/30/2012: Property, plant and equipment 22,186 43,835 Intangibles, net 2,276 Other non-current assets 2,026 Total assets 65,676 Accounts payable 4,870 Leverage Ratio: Accrued expenses 8,370 Other current liabilities 4,157 Other non-current liabilities 3,031 Common stock 207 Retained earnings 46,957 AOCI & Other equity -1,916 Total liabilities and shareholders' equity 65,676A B C D 22 Income Statement for Year Ended November 30, 2013 23 24 Revenue 128,562 25 Cost of Sales 52,529 = 26 Gross Profit 76,033 27 Marketing and Sales 49,878 28 General and Administrative 3,987 29 Total Operating Expenses 53,865 30 Operating Income 22,168 31 Interest Income 367 32 Interest Expense -9 33 Income Before Taxes 22,526 34 Income Tax Expense 5,374 35 Net Income 17,152 36 37 38 39 40 41 42 43 44 45 46