Excel Tutorial: How to Create an Income Statement

Final Customization and Formatting00:14:35

Final steps to improve the visual presentation by adding borders, bolding key totals like Net Income, and ensuring the final report is clear and ready for financial analysis.

Setting Up the Spreadsheet Structure00:00:00

The tutorial begins with creating the layout for the income statement. This involves adding the company name, the time period, and setting up the column headers for consecutive years (2016 and 2015) to ensure a clean, professional appearance.

Defining Financial Line Items00:02:17

Explanation of the standard income statement components, including sales, cost of goods sold (COGS), gross profit, operating expenses, depreciation, EBIT (Earnings Before Interest and Taxes), interest expense, taxes, and net income.

Entering Data and Applying Formulas00:04:06

Practical guidance on inputting financial data, formatting numbers with commas, removing decimals for readability, and using Excel functions like SUM and subtraction to calculate key metrics like gross profit and EBIT.

Calculating Secondary Year Data00:08:35

The process of populating 2015 data and dragging formulas from 2016 to 2015 to automate calculations. It includes a specific tip on locking cells using dollar signs ($) for constants like the tax rate.