From the course: Excel for Accountants
Join today to access over 22,600 courses taught by industry experts or purchase this course individually.
Cash flow budgeting in Excel - Microsoft Excel Tutorial
From the course: Excel for Accountants
Cash flow budgeting in Excel
- [Presenter] It's time to jump in and start getting our hands dirty in Excel. We're going to start with something simple: using Excel to create a cash budget. I'm in the 01_03_Begin Excel exercise file. Now, as you can see in this exercise file, we have a small business cash flow projection for ABC Company, and we've done this for the period January 2018 through December 2018. Now, below we have our areas for cash receipts, this is all the incoming cash flow, and we also have the area for cash paid out, all of the cash outflows. Once we've taken in all of the cash we're going to take in for a particular month and paid out all of the cash we're going to pay out, we come down below and look at the total amount of cash paid out versus cash paid in and the cash on hand at the end of each month. Now, this type of cash flow projection is critical for any business that's out there, right? It's not enough to make an accounting profit. We also need to be generating positive cash flow over…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Download courses and learn on the go
Watch courses on your mobile device without an internet connection. Download courses using your iOS or Android LinkedIn Learning app.