Question

45. FINANCIAL RATIOS DuBois Furniture, Inc., reported these figures for 20x7 and 20x6: Income statement: 20x7 20x6 Net income 12,000,000 18,700,000 Balance sheet: Preferred stock, $1.30, no-par, 100,000 shares issued and outstanding . Common stockholders equity . .. 2,500,000 2,500,000
Spreadsheet Assignments 81 Compute rate of return on total assets and rate of return on 20x7. Do these rates of return suggest strength or weakness? Give yo common stockholders equity for

Note: Can you put this answer on Microsoft Excel !
0 0
Add a comment Improve this question Transcribed image text
Answer #1

Return on total assets (ROTA) = Earnings before Interest and Taxes (EBIT)/ Total Net Assets * 100

The ratio is considered to be an indicator of how effectively a company is using its assets to generate earnings before contractual obligations must be paid.

EBIT= Net income + interest expenses

        =$ 17,400,000 + $12,000,000

        = $ 29,400,000

Total Net Assets= $ 351,000,000

Return on total assets (ROTA) = $ 29,400,000 / $ 351,000,000 * 100

                                                     =8.38%

Return on common stockholders= (Net Income- Preferred Dividend)/ Common Stockholders equity * 100

This ratio indicates how much return the equity shareholders have earned during the year on their investment in % terms

Return on common stockholders = ( $12,000,000 - $1.3 * 100,000) / $ 164,000,000 * 100

                                                          = 7.23%

This rates of return suggest strength as the return is positive.

Add a comment
Know the answer?
Add Answer to:
Note: Can you put this answer on Microsoft Excel ! 45. FINANCIAL RATIOS DuBois Furniture, Inc.,...
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for? Ask your own homework help question. Our experts will answer your question WITHIN MINUTES for Free.
Similar Homework Help Questions
  • 45. FINANCIAL RATIOS DuBois Furniture, Inc., reported these figures for 20x7 and 20x6: Income statement: 20x7...

    45. FINANCIAL RATIOS DuBois Furniture, Inc., reported these figures for 20x7 and 20x6: Income statement: 20x7 20x6 12,000,000 18,700,000 Net income Balance sheet: Preferred stock, $1.30, no-par, 100,000 shares issued and outstanding Common stockholders' equity Total stockholders' equity .. 2,500,000 2,500,000 Spreadsheet Assignments 81 Compute rate of return on total assets and rate of return on 20x7. common stockholders' equity for Do these rates of return suggest strength or weakness? Give your reason.

  • How to put this answer in Microsoft Excel? Spreadsheet Assignments 42. Assume that Wilson Sporting Goods...

    How to put this answer in Microsoft Excel? Spreadsheet Assignments 42. Assume that Wilson Sporting Goods completed these selected transactions during December PARTIAL BALANCE SHEET 79 20x6: a. Champs, a chain of sporting goods stores, ordered $15,000 of tennis and golf equipment. With its order, Champs sent a check for $15,000 in advance. Wilson will ship the goods on January 3, 20x7. The December payroll of $195,000 is subject to employee withheld income tax of 9%, FICA tax of 8%...

  • Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...

    Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 2015: December 31 2017 2016 2015 Total assets $4,800,000 $4,400,000 $4,000,000 Notes payable (8% interest) 2,250,000 2,250,000 2,250,000 Common stock 250,000 250,000 250,000 Preferred 4% stock, $100 par (no change during year) 500,000 500,000 500,000 Retained earnings 1,574,000 1,222,000 750,000 The 2017 net income was $372,000, and the 2016 net income was $492,000. No dividends on common stock were...

  • Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...

    Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 20Y5: December 31 2017 2016 2015 Total assets $244,000 $220,000 $196,000 Notes payable (8% interest) 80,000 80,000 80,000 Common stock 32,000 32,000 32,000 Preferred 6% stock, $100 par 16,000 16,000 16,000 (no change during year) Retained earnings 83,360 59,840 48,000 The 2017 net income was $24,480, and the 2016 net income was $12,800. No dividends on common stock were...

  • Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for...

    Profitability Ratios The following selected data were taken from the financial statements of Vidahill Inc. for December 31, 2017, 2016, and 2015: December 31 2017 2016 2015 Total assets $162,000 $146,000 $130,000 Notes payable (8% Interest) 50,000 50,000 50,000 Common stock 20,000 20,000 20,000 Preferred 4% stock, $100 par 10,000 10,000 10,000 (no change during year) Retained earnings 60,560 39,780 30,000 The 2017 net income was $21,180, and the 2016 net income was $10,180. No dividends on common stock were...

  • Calculator Print Item Exercise 12-79 Debt Management Ratios Financial statements for Steele Inc. follow. Steele Inc....

    Calculator Print Item Exercise 12-79 Debt Management Ratios Financial statements for Steele Inc. follow. Steele Inc. Consolidated Income Statements (in thousands except per share amounts) 2019 2018 2017 $6,944,296 (4,953,556) $1,990,740 (1,202,042) $6,149,218 (4,355,675) $1,793,543 (1,080,843) Net sales Cost of goods sold Gross margin General and administrative expenses Special and nonrecurring items Operating income Interest expense Other income Gain on sale of investments Income before income taxes Provision for income taxes Net income $7,245,088 (5,286,253) $1,958,835 (1,259,896) 2,617 $701,556 (63,685)...

  • Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical...

    Help on my Finance homework please! Integrative: Complete ratio analysis Given the following financial statements, historical ratios, and industry averages, calculate Sterling Company’s financial ratios for the most recent year. (Assume a 365-day year.) Sterling Company Income Statement for the Year Ended December 31, 2019 Sales revenue $10,000,000 Less: Cost of goods sold 7,500,000       Gross profits $ 2,500,000 Less: Operating expenses        Selling expense $ 300,000        General and administrative expenses 650,000        Lease expense 50,000        Depreciation expense...

  • I have posted the instructions and the lab template. please answer it fully. Thank you! Lab...

    I have posted the instructions and the lab template. please answer it fully. Thank you! Lab #1 - Chapter 13 Assignment Instructions: 1) On the template provided, use Excel to calculate each subtotal or total (blank underlined and highlighted space) on the Balance Sheet and the Income Statement 2) For the Income Statement, perform a vertical analysis USING EXCEL FORMULAS for 20X9 and 20X8 in the cells labeled "% of Sales." Round to two decimal places. (To copy a formula,...

  • please need help on those blue space with answer. thank you Excel Fie Eat View Insert...

    please need help on those blue space with answer. thank you Excel Fie Eat View Insert Format Tools Data Window Helo Complbity Mode Take home problemais · Home Insert Page Layout Formulas Data ReviawVe Formutsing sable Style Denald Jamlson was brought in as an assistant to Freida Pance, Electotron's chalrman, who had the task of getting he company back inte a sound financial pesition. Electotron's 2016 and 2017 balance sheets and income statements together with projections for 2018, are shown...

  • can you help me solve the highlighted areas with excel formulas Module 5 Student Version 4/4/96...

    can you help me solve the highlighted areas with excel formulas Module 5 Student Version 4/4/96 Financial Statements for the Year Ended December 31, 1995 (Millions) ACE REPAIR, INC. Cost of Capital (Easy ERSION Cash & Sec. A/R Inventory $5.0 46.3 74.1 A/P Accruals N/P $39.0 14.7 35.5 This case illustrates the cost of capital estimation process. It demonstrates (1) the mechanics of determining the component costs of capital--specifically debt, preferred stock and common equity, (2) the effects of changes...

ADVERTISEMENT
Free Homework Help App
Download From Google Play
Scan Your Homework
to Get Instant Free Answers
Need Online Homework Help?
Ask a Question
Get Answers For Free
Most questions answered within 3 hours.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT