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.
Note: Can you put this answer on Microsoft Excel ! 45. FINANCIAL RATIOS DuBois Furniture, Inc.,...
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 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 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 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 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. 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 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 #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 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 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...