Question

In: Finance

Prepare comparative common-sized statements, rounding percent to one decimal place. Interpret the analyses.


  1. Prepare comparative common-sized statements, rounding percent to one decimal place. Interpret the analyses.

                                                                                    Dell Inc.                      Apple Inc.

Sales (net)                                                                    61,101                         36,537

Cost of sales                                                                50,144                         23,397

Gross profit                                                                 10,957                          13,140

Selling, general, and admin expenses 7,104                             4,149

Research and development                                             663                          1,333

Operating expenses                                                       7,767                           5,482

Income from operations                                               3,190                         7,658

  1. What are the objectives of comparative common -sized statements?

Solutions

Expert Solution

Common-size Income statements
Dell Inc. % of sales Apple Inc. % of sales Analysis & intrepretation as a % of sales
Sales(net) 61101 100.0% 36537 100.0%
Cost of sales 50144 82.1% 23397 64.0% Apple's Cost of sales as a % to sales is less compared to that of Dell
Gross profit 10957 17.9% 13140 36.0% Dell's G/P % is less due to high proportion of Cost of Sales
S,G & A expense 7104 11.6% 4149 11.4% S, G & A are neraly the same % to sales for both the companies.
R& D 663 1.1% 1333 3.6% R&D expenses are more in Apple
Opg. Exp. 7767 12.7% 5482 15.0% Opg. expenses are more in Apple
Income from operations 3190 5.2% 7658 21.0% Income from operations as a % of sales is less for Dell mainly due to the high proportion of cost of sales.
b..Items of expenses expressed as a % of sales, or balance sheet items as a % of total assets ----  
between companies or covering different periods,
make the comparison , very easy , & distortions /variations can be identified , just at a glance ,
to form a quick & meaningful opinion about the various components of the financial statements.
The main objective of comparative common-sized statements are
1.to have knowledge about the performance of the companies involved, with a view to improve
2.analyse & find out variations, if any, so as to control costs /expenses & improve efficiency of operations.
3. To study the trend, if compared with prior years ,so that expenses/incomes under different heads or items like accounts receivables/payables--can be justified or reasons established for any wide variations with the past trend .

Related Solutions

3. GRM/GIM Estimates of Appraised Value. Please go to the seventh decimal place, no intermittent rounding:...
3. GRM/GIM Estimates of Appraised Value. Please go to the seventh decimal place, no intermittent rounding:                                Subject               Comp. 1            Comp. 2             Comp. 3 V & C rates                3%                      3%                    3.6%                    4.1% Units                        195                      190                    195                      205 Average Rent           $910                   $915                  $920                   $925 Selling Price               ?                $16,500,000         $15,900,000      $18,200,000 Calculate either the Gross Rent Multiplier for the Comps: Show the estimated price range from a low value to a high value for the subject property:
how do you prepare a common sized income statement?
how do you prepare a common sized income statement?
I agree that it is important to analyze the financial statements using comparative and horizontal analyses....
I agree that it is important to analyze the financial statements using comparative and horizontal analyses. Do you think that vertical and horizontal analyses should be done independently of each other or together? Explain in your own words.
Determine (a) the return on stockholders’ equity and (b) the return on common stockholders’ equity. Round percentages to one decimal place.
A company reports the following:Net income $ 375,000Preferred dividends 75,000Average stockholders’ equity 2,500,000Average common stockholders’ equity 1,875,000Determine (a) the return on stockholders’ equity and (b) the return on common stockholders’ equity. Round percentages to one decimal place.
Determine (a) the return on stockholders’ equity and (b) the return on common stockholders’ equity. Round percentages to one decimal place.
A company reports the following:Net income $ 125,000Preferred dividends 5,000Average stockholders’ equity 1,000,000Average common stockholders’ equity 800,000Determine (a) the return on stockholders’ equity and (b) the return on common stockholders’ equity. Round percentages to one decimal place.
Determine the cash payback period. Round to one decimal place.
A project has estimated annual net cash flows of $95,200. It is estimated to cost $580,720. Determine the cash payback period. Round to one decimal place.
Determine the asset turnover ratio. Round to one decimal place
A company reports the following:Sales $1,800,000Average total assets 1,125,000Determine the asset turnover ratio. Round to one decimal place.
Determine the asset turnover ratio. Round to one decimal place.
A company reports the following:Sales $4,400,000Average total assets 2,000,000Determine the asset turnover ratio. Round to one decimal place.
Determine McDonald’s Corporation’s dividend yield. Round to one decimal place.
At the market close on May 12 of a recent year, McDonald’s Corporation had a closing stock price of $129.51. In addition, McDonald’s Corporation had a dividend per share of $3.56 during the previous year
Determine the times interest earned ratio. Round to one decimal place.
A company reports the following:Income before income tax $4,000,000Interest expense 400,000Determine the times interest earned ratio. Round to one decimal place.
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT