Cash Flow Analysis & Projection

This training will provide an in-depth discussion on Cash Flow, including how to analyze and project it. Participants will learn different types of cash flow activities, forecasting model and also sensitivity analysis of the cash flow projection.

Certificate of completion (supplied by PasarTrainer)

Training Material

1. Construct Cash Flow Projection
2. Assess Debt Repayment Capacity
3. Sensitivity Analysis
4. Case Discussion

Participants will be provided with a case where they need to conduct Cash Flow Projection using excel, analyze and then discuss the projection result

Case Study - Excel Based

A multiple-choice test to assess the participants' proficiency level prior to enrolling in the training program.

Pre-Test (25 Questions - Closed Book)

A multiple-choice test to assess the participants' proficiency level after enrolling in the training program.

Post Test (25 Questions - Closed Book)

1. Three Way Forecasting Model
2. Setting "Dashboard" for Summarizing Key Financial Metrics
3. Model/ Forecasting Flows: "Input", "Process", "Output"
4. Determining Assumptions for Financial Projections
5. Three Way Forecasting Model Construction (in Excel)
6. Sensitivity Analysis

In this module, participants will learn the basics of conducting a cash flow projection as well as how to develop a cash flow projection model in excel.

Cash Flow Projection - Overview of the Basic

1. Understanding Type of Corporate Cash Flow Activities
2. Understanding Operating Activities and Working Capital
3. Understanding Investing Activities and CAPEX
4. Understanding Financing Sources
5, Testing and Assessing Cash Flow (Projection)

This module explains an in-depth understanding of cash flow activities and how to properly test and assess a cash flow projection