How to Build FP&A Cash Flow Forecast Model

• This is a course that teaches you how to create a monthly cash flow forecast model in Excel, based on the business plan and financial statements of a company.

This course covers topics such as:

• Building assumptions and formulas for revenue, expenses, and balance sheet items.


• Forecasting the income statement, balance sheet, and cash flow statement.


• Analyzing the impact of the forecast on the company’s capital structure and credit metrics.


• Creating charts and graphs to present the cash flow profile to management.


• This course is designed for anyone who wants to learn how to build a monthly cash flow forecast model for financial planning and analysis (FP&A) purposes.


• 
  
  
  

  
  

  Eligibilities

  
  

  
  
  
  
  
  

  
  

  
  

  
  

  
  

  
  

  
  

  
  
  • To be eligible for this course, you should have some experience with financial modeling or have completed a 3-Statement Modeling course.
  
  
  • You should also have proficient Excel skills and be able to use advanced functions and formulas.
  
  

  
  

  Note: Eligibility requirements may vary based on the specific course or program you choose. Please refer to the detailed course brochure for more information.

  
  

  
  

  
  

  How to Build FP&A Cash Flow Forecast Model

  
  

  
  

  
  

  
  

   Total Days

  
  

  26 Days

  
  

  
  

  
  

  ---

  
  

  
  

  
  

   Training Mode

  
   Online  Classroom  Hybrid