60.1K

Verified Solution

Link Copied!

Instructions: Using Excel create a simple multi-step Income Statement through Operating Income. (Basic Formula below) Details/Requirements: -Make up your own numbers. The exact amounts are unimportant as long as your formulas and format work properly and logically. (But also dont be too cute (sarcastic, etc), pretend this is a real presentation in your work environment.) -Include 3 years (2020, 2021, 2022). -Use formulas in appropriate cells. -Use appropriate formatting for cells and overall report. -Include a chart to visually display the 2022 results of Revenue, CoGS, Gross Profit, Operating Expenses, and Operating Income. Your choice of chart that makes sense and is helpful in presenting the information. Make sure it updates when inputs are changed. -Label your chart appropriately. -Put the Income Statement and Chart on a workbook page that is separate from the input (reference) data. (One page for the data and one for the presentation.) Make the report attractive for your superiors to view in a presentation. It should look professional. -Name your company, etc. Inclusion of names and other information is part of the professionalism of the document. Pretend it is real, but you can make it up yourself. -Mostly you can follow the directions in the How To video, but use two pages, use the line items below, and make the presentation portion pretty. Your income statement should include the following lines: Revenue Cost of Goods Sold Gross Profit Operating Expenses Operating Income

Answer & Explanation Solved by verified expert

See Answer