Pick a business. Pick any public firm Try to find one that has a detailed income statement. Many just shove all expenses into SGA. Try to have it be an industry you know something about and can find some information on
Find their income statement. It needs to be detailed for operations, since we are focused on an operating income proforma. You may need to find data from a few areas of their reports.
Ignore taxes, depreciation, interest, and all per share metrics. Go only to earning PROFIT before taxes, interest, etc. This is an operations proforms, so those items are all fairly irrelevant.
The assignment:
Describe the firm. Take a paragraph or so and convince me you actually know what they actually do
Create a detailed operational income statement in excel. As a manager, you need to understand each significant operational area of the company. These areas break down into these general categories:
Revenue
CoGS
Expense line items
Profit
But, as manager you need more detail. Especially expenses. Break down these items, especially expenses, as far as you can, Look around in all the firms financial statements. Show individual expense lines for, at minimum: R&D Marketing, Administration, Sales, IT At worst case, make these up
~ page.
ALL HOMEWORKS ARE TO BE DONE IN BUSINESS FORMAT