Mastering Short-Term Cash Flow Forecasting

Prepare a Cash Flow forecast from scratch. Learn how to make key financial decisions

What you’ll learn
Develop a short-term cashflow forecast from scratch.
Understand the various benefits of using a short-term cashflow forecast.
Manage day-to-day liquidity in an efficient manner.
Understand the cash forecast templates and business scenarios.
Optimize interest income and interest expenses

Requirements
Basic understanding of finance and financial terms.
Knowledge of Microsoft excel

Description
According to a Big 4 survey of 220 CFO’s and Treasurers, more than half of the CFO’s and Treasurers mentioned cash forecasting as their top-most priority. In this course, I am going to take you through the step-by-step process of short-term cashflow forecasting. Starting from a blank spreadsheet, I will demonstrate, how you can build a short-term cashflow forecast from scratch. You will also learn the various advantages and uses of a short-term cashflow forecast. I will show you how you can make important financial decisions for your organization using a short-term cashflow forecast like managing day-to-day liquidity, managing payment obligations, ensuring timely collections, managing loans & borrowings, managing investments, improving interest income, reducing interest costs, understanding future cash positions, performing variance analysis. This course will help you become an expert in short term cash management and impress your bosses and colleagues and add value to your team and organization. Implementing a short-term cashflow forecasting process in your organization will help you improve the profitability of the company, offer you greater visibility in to your bank account balances, help you make day-to-day tactical decisions and enhance the control you have on your uncertain future cashflows. By the end of this course, you will be able to develop a short-term cashflow forecast for your organization independently and help your senior management in making data-driven decisions.

Overview
Section 1: Getting started

Lecture 1 What you will learn in this course ?

Lecture 2 Who is this course for ?

Section 2: The cashflow fundamentals

Lecture 3 Defining a short-term cashflow forecast

Lecture 4 Uses of a short-term cashflow forecast

Section 3: Preparing a short-term cashflow forecast

Lecture 5 Creating short-term cashflow forecast template

Lecture 6 Sources of information

Lecture 7 Assumptions

Lecture 8 Forecasting collections

Lecture 9 Forecasting payments

Lecture 10 A quick check

Section 4: Making key decisions using cashflow forecast

Lecture 11 Managing day-to-day borrowing

Lecture 12 Maintaining a target minimum balance

Lecture 13 Investing surplus cash

Lecture 14 Meeting payment obligations

Lecture 15 Ensuring timely collections

Lecture 16 Fulfilling adhoc payment requests

Lecture 17 Meeting debt service obligations

Lecture 18 Scheduling flexible payments

Lecture 19 Optimizing cost of capital

CFOs, Treasurers, Treasury managers, Finance managers, Accountants, Entrepreneurs