Select two non-financial companies from the same industry and calculate the percentage of each of the following balance sheet components relative to total revenue (often reported as total net revenue) in the last quarter of each of the last five years:
Developing a Detailed Outline and Develop Question/Answers
August 7, 2017Brainstorming
August 7, 2017Select two non-financial companies from the same industry and calculate the percentage of each of the following balance sheet components relative to total revenue (often reported as total net revenue) in the last quarter of each of the last five years:
Select two non-financial companies from the same industry and calculate the percentage of each of the following balance sheet components relative to total revenue (often reported as total net revenue) in the last quarter of each of the last five years:
- Cash and Cash Equivalents
- Inventory
- Accounts Receivable
- Property, Plant, and Equipment (Gross)
- Accounts Payable
Enter the values in this table.Use the companies’ annual reports to find the income statement and balance sheet entries. The annual reports may be obtained from the Securities and Exchange Commission website.
As an example, the percentage of sales for cash and cash equivalents may be calculated as: (cash and cash equivalents/total sales revenue) x 100.
Include your findings in a 2-3 page summary that answers the following questions:
- What is happening to each company’s percentages over time? Are they roughly stable over time, or have they been trending upward or downward?
- Why do you believe they are trending in that direction?
- Do you believe that the latest percentages can be used to forecast next year’s balance sheet values? Why or why not?
- What are the limitations of the Percentage-of-Sales Method of Forecasting?
