How to create a personal, or household, cash flow forecast using Microsoft Excel.
HTML-код
- Опубликовано: 28 июл 2024
- How to create a personal, or household, cash flow forecast using Microsoft Excel. A daily balance is calculated, together with a weekly summary showing closing balances and minimum balance throughout the week. An explanation of the key formulae is given.
Chapters:
00:00 - Introduction & Example Cash Flow Forecast
05:15 - How to create the Cash Flow Forecast in Excel
21:55 - The formulae explained
22:11 - Excel IF function
22:40 - Excel DATEDIF function
24:59 - Excel QUOTIENT function
28:44 - Excel INDEX function
29:51 - Excel MATCH function
Income/Expense by date: =IF(QUOTIENT(DATEDIF($F7, H$2, $E7),$D7)(GreaterThanSymbol)QUOTIENT(DATEDIF($F7, H$2-1, $E7),$D7),$C7,"")
(You'll need to substitute the actual greater than symbol for (GreaterThanSymbol) - without the brackets.)
Summary Closing Balance: =INDEX(ClosingBalance,1,MATCH(D2,DateHeadings,0))
Summary Minimum Balance: =MIN(Week1)
Blog post with detailed instructions: blazorcode.uk/personalcashflo... Наука
Wow, excellent explanation, thanks
Glad you liked it