Using the data in the following table for a number of firms inthe same industry,

Question

Using the data in the following table for a number of firms inthe same industry, do the following: a) compute the total asset turnover, the net profit margin,the equity multiplier, and the return on equity for eachfirm. b) evalute each firms performance by comparing the firms withone another which firm or firms appear to be having problems? whatcorrective action would you suggest the poorer performing firmstake? finally what data would you want to have on hand whenconducting your data? In millions Firm A: sales=$20, net income after tax=3, totalassets=15, stock holders equity=10 Firm B: sales =10, net income after tax=.5, total assets=7.5,stock holders equity=5.0 Firm C: sales =15 net income after tax=2.25, total assets=15,stockholders equity=14 Firm D: sales=25, net income after tax=3, total assets=24,stockholders equity=10 Using the data in the following table for a number of firms inthe same industry, do the following: a) compute the total asset turnover, the net profit margin,the equity multiplier, and the return on equity for eachfirm. b) evalute each firms performance by comparing the firms withone another which firm or firms appear to be having problems? whatcorrective action would you suggest the poorer performing firmstake? finally what data would you want to have on hand whenconducting your data? In millions Firm A: sales=$20, net income after tax=3, totalassets=15, stock holders equity=10 Firm B: sales =10, net income after tax=.5, total assets=7.5,stock holders equity=5.0 Firm C: sales =15 net income after tax=2.25, total assets=15,stockholders equity=14 Firm D: sales=25, net income after tax=3, total assets=24,stockholders equity=10

Explanation / Answer

(a)   Total Asset TurnoverRatio = Total Revenue (Sales) / Total Assets

          FirmA = $20 / $15   = 1.33

          FirmB   = $10 / $7.5 =   1.33

          FirmC   = $15 / $15 =   1

          FirmD   = $25 / $24 =   1.04

Net Profit Margin   =   Net Incomeafter taxes / Revenue (Sales)

Firm A   = $3 / $20   = 0.15

Firm B   = $0.5 / $10 = 0.05

Firm C   = $2.25 / $15 = 0.15

Firm D   = $3 / $25 =   0.12

                Equity Multiplier: Total Assets / TotalStockholder’s Equity

                Firm A = $15 / $10 = 1.5

                Firm B = $7.5 / $5.0 = 1.5

                Firm C = $15 / $14   = 1.07

                Firm D = $24 / $10   = 2.40

                Return on Equity: Net Income / Shareholdersequity

                

                Firm A = $3 / $10 = 0.3

                Firm B   = $5 / $5.0 = 0.1

                Firm C   = $2.25 / $14 = 0.16

Related Questions

Navigate

• Browse (All)
• Browse U
• Subjects

---

---

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.