Build a Cash Flow Statement From Scratch Using a Balance Sheet and Income Statement
Kenji Explains Kenji Explains
482K subscribers
165,081 views
0

 Published On May 22, 2022

Create a Cash Flow Statement from scratch on Excel using a balance sheet and income statement.
👉 Get 25% OFF Financial Edge using code KENJI25: https://bit.ly/3Lla95f
🆓 DOWNLOAD Free Excel file for this video:
https://view.flodesk.com/pages/62da58...

In this lesson you will learn to build a cash flow statement from scratch using a balance sheet and an income statement. This is one of the most common interview questions in accounting or finance.

First, we'll explain the cash flow statement looking at the 3 main sections: he cash flow from operating activities, investing activities, and financing activities. We'll also explain the 2 main methods to calculate cash flow which are the direct method, and the indirect method.

Then, using the both the income statement and balance sheet, we'll calculate all the relevant line items to reach net change in cash. Finally, we'll link the ending cash amount to the most recent balance sheet to match assets and liabilities plus shareholders' equity.

LEARN:
📈 The Complete Finance & Valuation Course: https://www.careerprinciples.com/cour...
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/cour...
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS

SOCIALS:
📸 Instagram -   / kenji_explains  
🤳 TikTok - https://www.tiktok.com/@kenjiexplains...

GEAR:
📹 My Favorite Books & Gear: https://kit.co/kenjiexplains
▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬▬

Chapters:
0:00​ -​ The Cash Flow Statement
1:01 - Operating Activities
7:10​ - Investing Activities
8:36​ - Financing Activities
11:50​ - Net Change in Cash & Formatting

Disclaimer: I may receive a small commission on some of the links provided at no extra cost to you.

show more

Share/Embed