Chapter 3:  Questions

Question 1:    Define the basic DuPont decomposition equation and include a brief description of how to interpret its component terms by relating your description to the major decisions made by a firm.

Question 2:   Calculate and provide a brief description of its meaning the following ratios for Best Buy:

i.               Inventory Turnover

ii.            Accounts Receivable Turnover

Question 3: 

i.              If the Inventory Turnover ratio is X, how many days does it take to sell the inventory?

ii.            If the Accounts Receivable Turnover ratio is X, how many days does it take for accounts to be paid?

Question 4:  Define the ratio “ROE” and describe what major firm decisions influence this ratio.

Question 5:  Define “Fundamental Growth” (also known as “Accounting Growth”).  Describe precisely how this number is influenced by major firm decisions.

Question 6:  Consider the following information on Best Buy and Wal-Mart:

Compare the ROE for Wal-Mart and Best Buy and explain precisely why the two companies have different ROE’s by relating your explanation to the major firm decisions.

Question 7:  Estimating Cost Behavior using Account Analysis

In order to estimate the Degree of Operating Leverage, you need to first separate costs into fixed and variable components.  This requires an understanding of cost drivers, and GAAP compliant statements do not provide an easy way to break total costs into fixed and variable parts.  When studying managerial accounting, you are typically introduced to three techniques to assess cost behavior.

i.               Account Analysis

ii.            High Low Technique

iii.           Regression Analysis/Scatter Plots

In this question you will apply the Account Analysis technique.  With this technique start by reading Item 1, 10-K of Amazon’s 10-K filed with the SEC.  This describes their business model.  From this business model and without referring to any quantitative data, so that your answer is based entirely upon your understanding of the business model for Amazon.com, apply the Account Analysis technique (i.e., professional judgment) to assess the cost behavior for the following three cost categories for Amazon.com.  That is, consider how these costs are likely to be generated given your understanding of Amazon’s business.  This will let you understand what the major cost drivers are likely to be for the following three categories:

a.     Cost of Goods Sold

b.    Selling and General Administration

c.    Research and Development

Estimate the proportion of each of the above cost categories that you assess to be variable and fixed (relative to sales revenue).  The sum of these proportions must equal 1.  Provide brief reasons in support of you assessed proportions in relation to your understanding of Amazon’s business model.

Question 8:  Estimating Cost Behavior using High Low Technique

In this question you will apply the High Low technique to separate total costs into fixed and variable components.

This method uses observations on two dates to estimate fixed costs and the variable cost per dollar of sales revenue.  The Y-Axis variable is the aggregate cost category and the X-axis variable is the volume of activity (usually sales revenue for an outsider).

Variable Cost Per $ Sales Revenue   = (Total Costs High Sales Revenue – Total Costs Low Sales Revenue)/(Sales RevenueHigh – Sales RevenueLow)

Data:    Suppose Amazon’s Sales Revenue and COGS for the last 5-years is the following:

Apply the High Low Technique to compute the variable costs per dollar of sales for each of the following categories:

a.    Cost of Goods Sold

b.    Selling and General Administration (S&GA)

c.    Research and Development R&D

Question 9:  Estimating Cost Behavior using Regression Analysis

In this question you will apply the Regression Analysis Technique to separate total costs into fixed and variable components.

This is a statistical technique for estimating fixed and variable costs.span style="mso-spacerun: yes">  The advantage of this technique over the high low technique is that it uses all observations whereas the high/low technique uses only two.  Regression analysis is easy to perform in Excel using the following steps.  WWe show you how to decompose the total COGS into fixed and variable components, the problem you solve is to repeat this for SG&A and R&D using the following information.

Step 1:  In Valuation Tutor select Amazon and then click on Financial Statements, Statements (MSN):

Step 2:  Copy and paste the data into Excel and then use Excel’s Copy/Paste Special Transpose to get the data into the following block form ready for Regression:

The Y-Variable for the regression is in column U (U2..U6) and the X-Variable is in column T (T2..T6).

Step 3: Click on the “Data” menu item in Excel and then select Data Analysis from the Analysis ribbon item

Note:  If the Data Analysis item is not available, then in Excel, click on the Office Button, click on Excel Options, click Add-Ins and at the bottom, under “Manage Excel Add-Ins” – select the Analysis Tool Pack and click OK.  TThen close Excel and re-launch it.

Step 4:  In Data Analysis select Regression:

 

Note in the above the COGS is the Y-Variable and the Sales Revenue is the X-Variable (cost driver).

Click OK and the regression analysis is performed:

 

The variable cost per $ of sales is provided above beside X Variable 1 and equals 0.78.span style="mso-spacerun: yes">  In this example it turns out to be very similar to the High/Low method in the previous question – but this is not the norm.  AAgain the variable cost per $ of sales revenue is 0.78.

Repeat the above exercise to estimate the Variable Cost per $ of Sales for both S&GA and R&D respectively.

Question 10:  If you have completed questions 7 and 8 or questions 7 and 9 then answer the following.

In question 7 you assessed cost behavior using the Account Analysis technique.span style="mso-spacerun: yes">  This required professional judgment in relation to your understanding of Amazon’s business model.  In questions 8 or 9 you made use of data to estimate the proportion of variable to fixed costs in each category.  Did your estimates agree or disagree when using these two approaches?  PProvide a brief discussion as to why or why not.

Information for the next three questions:

 

Question 11:  UUsing the above information for Wal-Mart and Best Buy, define the contribution margin ratio, verify the calculation, and provide a brief description of what it means.

Question 12:  Using the above information for Wal-Mart and Best Buy, provide a brief interpretation of what could explain the differences in the contribution margin ratio for Wal-Mart and Best Buy.

Question 13:  Use the above information for Wal-Mart and Best Buy.  Suppose you expect sales for each company to increase by 3% over the next year.  WWhat is the predicted impact upon EBIT?

Real World Exercises

Exercise 1:  Business Ratios

Select two companies from the Current FTS Dataset that are competitors, or at least are in the same industry even if they do not directly compete with each other. 

Provide a summary report of the results from conducting financial statement analysis of the business ratios for your two stocks relative to each other.  Summarize what you view to be comparative advantages and disadvantages for these two stocks relative to this analysis.  IIn addition, comment on how efficiently you assess each firm is when implementing their business model/business strategy based upon your analysis of their business ratios.

Exercise 2:  Activity Analysis

Select two companies from the Current FTS Dataset that are competitors, or at least are in the same industry even if they do not directly compete with each other. 

By applying Valuation Tutor’s Activity Analysis Calculator (e.g., Asset Turnover and Financial Leverage subsections of the Business Efficiency section), provide a summary report of the results from conducting Activity Analysis for your two stocks and then compare along the following dimensions: 

i.       Degree of Operating Leverage

ii.            Degree of Financial Leverage

iii.           Degree of Total Leverage

iv.           Contribution Margin and Contribution Margin Ratio

v.            Break Even Margin

You will first need to estimate the % variable and fixed costs for each cost category.  You can refer to problems 7-9 above for guidance as to how.