Ryan O'Connell, CFA, FRM shows how to create a financial model in Excel and build an income statement from scratch.
👨💼 Freelance Financial Modeling Services:
► Custom financial modeling solutions tailored for your needs: ryanoconnellfinance.com/freelance-finance-services/
🎓 Tutor With Me: 1-On-1 Video Call Sessions Available
► Join me for personalized finance tutoring tailored to your goals: ryanoconnellfinance.com/finance-tutoring/
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:
[ Ссылка ]
Download the COMPLETE file for free here:
[ Ссылка ]
Music Credit:
Rewind by 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.
Build an Income Statement in 10 Minutes
Теги
income statementfinancial modelingfinancial modelfinancial model excel examplefinancial modeling in excelfinancial model excel youtubebuilding financial model in excelfinancial model excelbasic financial modelhow to make financial model in excelsimple financial model excelincome statement exampleincome statement accountingincome statement analysisincome statement formatincome statement explainedincome statement excelmicrosoft excel