Ryan O’Connell, CFA, FRM shows how to create a financial model in Excel and build an income statement from scratch.
📊 Download Free Excel Financial Models:
► Access a range of powerful, customizable financial models: https://ryanoconnellfinance.com/financial-models/
*Seeking Alpha deals to help manage your portfolio:*
💰 *Get $50 OFF Alpha Picks:* https://ryano.finance/alpha-picks
📈 *Get $159 OFF Seeking Alpha Premium and Alpha Picks Bundle:* https://ryano.finance/seeking-alpha-bundle
🔥 *Get $30 OFF Seeking Alpha Premium:* https://ryano.finance/seeking-alpha
*Get 10% Off Snowball Analytics to help manage your portfolio with code RYAN here:*
https://snowball-analytics.com/register/ryan
Chapters:
0:00 – Intro and Template File Download
0:13 – Outline the Income Statement and Assumptions
0:30 – Calculate Net Sales
2:42 – Calculate Cost of Goods Sold (COGS)
4:39 – Calculate Operating Expenditures (OPEX)
6:25 – Calculate EBITDA, EBIT, and EBT
7:47 – Calculate Income Taxes and Net Income
8:37 – Changing the Assumptions
Download the BLANK TEMPLATE file for free here:
https://ryanoconnellfinance.com/product/excel-financial-model-template-income-statement/
Download the COMPLETE file for free here:
https://ryanoconnellfinance.com/product/excel-financial-model-template-income-statement/
Music Credit:
Rewind by Markvard https://soundcloud.com/markvard
Creative Commons — Attribution 3.0 Unported — CC BY 3.0
*Disclosure: This is not financial advice and should not be taken as such. The information contained in this video is an opinion. Some of the information could be wrong. This channel is owned and operated by Portfolio Constructs LLC.
