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/62da585cc9d3abbafd6c44b5

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/courses/finance-valuation-course
👉 Excel for Business & Finance Course: https://www.careerprinciples.com/courses/excel-for-business-finance
📊 Get 25% OFF Financial Edge Using Code KENJI25: https://bit.ly/3Ds47vS

SOCIALS:
📸 Instagram - https://www.instagram.com/kenji_explains/
🤳 TikTok - https://www.tiktok.com/@kenjiexplains?lang=en

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.