80.2K

Verified Solution

Link Copied!

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 pro$-$forma. 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 pro$-$forms, so those items are all fairly irrelevant. The assignment: Pick any public firm.

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$.$

please create the excel sheet file $!$

Answer & Explanation Solved by verified expert

See Answer