Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

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

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

image text in transcribedimage text in transcribed
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

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Mastering 21st Century Enterprise Risk Management

Authors: Gregory M Carroll

1st Edition

1483510441, 9781483510446

More Books

Students also viewed these Accounting questions

Question

What is the CVP relation?

Answered: 1 week ago