Corporate Finance

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.

Ryan O’Connell, CFA, FRM explains Net Present Value (NPV), Internal Rate of Return (IRR), and Discounted Cash Flows. This video is appropriate for finance students, and CFA and FRM candidates.

🎓 *Get 25% Off CFA Courses (Featuring My Videos!) — Use code RYAN25 here:*
👉 https://ryano.finance/cfa

Topics:
1. NPV Definition
2. How to Calculate NPV on BA II Plus Calculator
3. IRR Definition
4. How to Calculate IRR on BA II Plus Calculator
5. IRR Decision Rule

Chapters:
00:00 Net Present Value (NPV) Definition
01:20 NPV Problem Example
03:30 NPV Calculation on Financial Calculator
04:27 Internal Rate of Return (IRR) Definition
05:28 IRR Problem Example
07:17 IRR Calculation on Financial Calculator

*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. Some of the links above are affiliate links, meaning, at no additional cost to you, I will earn a commission if you click through and make a purchase.

Ryan O’Connell, CFA breaks down Financial Planning and Analysis (FP&A) in 5 minutes.

*Use code RYAN300 in the coupon field for up to $500 off Wharton Online’s Financial Planning & Analysis (FP&A) Certificate Program:*
👉 https://ryano.finance/wharton-fpa

He discusses the following topics:
0:00 Intro
0:31 What role does FP&A play in a business?
2:33 What are the pros and cons of working in FP&A?
4:14 How can someone break into FP&A?

*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 YouTube Channel is owned and operated by Portfolio Constructs LLC