Analyze performance through common-sized income statements with Excel
Takeaway: Perform percentage and comparison analyses in Excel by creating a common-sized income statement. Find out how in this tip by Mary Ann Richardson.
How do your company's profit margins compare with others in your industry? What percentage of revenue goes to salaries? What percentage of revenue goes to the cost of goods sold? You can perform this analysis in Excel by converting your income statement to a common-sized income statement that divides each item in the statement by total revenues. Follow these steps:
- Activate the Income Statement sheet and select the entire range containing the income statement.
- Click Copy.
- Right-click the Sheet tab, click Insert, and then click OK.
- Go to Edit | Paste Special.
- Click the Values check box under Paste and then click OK.
- Click the Income Statement sheet, press [Esc], and then click the cell containing the Total Revenues.
- Click Copy and then click the new Sheet1.
- Select the entire income statement range in the new sheet.
- Go to Edit | Paste Special.
- Under Operation, click Divide and click OK.
- With the income statement still selected, click the Percent Style button in the formatting toolbar.
Miss a tip?
Check out the Microsoft Excel archive, and catch up on our most recent Excel tips.
Help users increase productivity by automatically signing up for TechRepublic's free Microsoft Office Suite newsletter, featuring Word, Excel, and Access tips, delivered each Wednesday.
Print/View all Posts Comments on this article
All those tips are useless without a sample file to download!
icad@... | 04/11/07
|
|
RE: Analyze performance through common-sized income statements with Excel
bgr1212@... | 06/16/07
|
RE: Analyze performance through common-sized income statements with Excel
cjsheth@... | 03/19/08
|
White Papers, Webcasts, and Downloads
- Email Security and Archiving - Clearer in the Cloud Google The time is NOW for businesses and organizations of all sizes to implement ... Download Now
- Five Steps to Determine When to Virtualize YourServers VMware Thinking of virtualizing the servers at your company? Use this step-by-step guide to determine when's the best time to make your big move. Download Now
- VMware Infrastructure: A Guide to Bottom-Line Benefits VMware Frustrated by the high cost of maintaining or building ever-larger data centers? Get the facts you need to formulate your Virtualization Action Plan. Download Now
- The True Costs of Virtual Server Solutions VMware Discover ways to streamline and simplify your assessment of the total acquisition costs of a server virtualization environment. Download Now
- The Scalable Enterprise: VMware ESX Server on the Dell PowerEdge 6650 Dell This paper introduces the server virtualization software, VMware ESX ... Download Now
Article Categories
- Security
- Security Solutions, IT Locksmith
- Networking and Communications
- E-mail Administration NetNote, Cisco Routers and Switches
- CIO and IT Management
- Project Management, CIO Issues, Strategies that Scale
- Desktops, Laptops & OS
- Windows 2000 Professional, Microsoft Word, Microsoft Excel, Microsoft Access, Windows XP,
- Data Management
- Oracle, SQL Server
- Servers
- Windows NT, Linux NetNote, Windows Server 2003
- Career Development
- Geek Trivia
- Software/Web Development
- Web Development Zone, Visual Basic, .NET
