Excel-based cash flows for financial planning and analysis

Contents

• Introduction Introduction

  • Excel-based cash flows for financial planning and analysis

    46s
• 1. Introduction to Cash Flow Forecasting and Modeling 1. Introduction to Cash Flow Forecasting and Modeling

  • Importance of Excel-based cash flow forecasting in financial planning and analysis

    5m 50s
  • Direct, indirect, weekly, and monthly cash flows

    6m 41s
  • (Locked)
    Overview of an Excel-based cash flow forecasting process

    7m 13s
• 2. Gathering Data and Preparing Assumptions 2. Gathering Data and Preparing Assumptions

  • (Locked)
    Identifying sources of historical financial data

    6m 18s
  • (Locked)
    Building assumptions about future performance

    4m 40s
  • (Locked)
    What happens when you lack good financial information?

    3m 5s
  • (Locked)
    Building an information request and status log in Excel

    4m 37s
• 3. The Monthly Profit and Loss Forecast 3. The Monthly Profit and Loss Forecast

  • (Locked)
    Building a sales forecast in Excel

    8m 33s
  • (Locked)
    Building and forecasting a payroll expense schedule

    12m 31s
  • Forecasting operating and non-operating expenses

    13m 41s
  • (Locked)
    Challenge: Forecasting the profit and loss and scenarios in Excel

    2m 59s
  • (Locked)
    Solution: Forecasting the profit and loss and scenarios in Excel

    12m 44s
• 4. The Working Capital Forecast 4. The Working Capital Forecast

  • (Locked)
    Forecasting accounts receivable collections with SUMIFS

    11m 29s
  • (Locked)
    Forecasting payroll payments with XLOOKUP

    11m 4s
  • (Locked)
    Forecasting accounts payable payments with SUMIFS

    12m 48s
  • Monitoring working capital changes with Excel's watch window

    6m 25s
• 5. Long-Term Assets and Liabilities Forecast 5. Long-Term Assets and Liabilities Forecast

  • (Locked)
    Forecasting capital expenditures (CapEx) with on/off Excel toggles

    12m 44s
  • Forecasting debt service automatically with Excel lookups

    6m 4s
  • (Locked)
    Challenge: Forecasting debt service with INDEX/XMATCH

    1m 1s
  • (Locked)
    Solution: Forecasting debt service with INDEX/XMATCH

    5m 56s
• 6. Scenario Analysis and Sensitivity Testing 6. Scenario Analysis and Sensitivity Testing

  • (Locked)
    Developing business scenarios with Excel's form controls

    9m 1s
  • (Locked)
    Conducting sensitivity analysis of key variables in Excel

    10m 12s
  • (Locked)
    Challenge: Building a dynamic scenario manager tool in Excel

    1m 2s
  • (Locked)
    Solution: Building a dynamic scenario manager tool in Excel

    6m 15s
• 7. Advanced Considerations in Cash Flow Forecasting and Modeling 7. Advanced Considerations in Cash Flow Forecasting and Modeling

  • (Locked)
    Using data mapping to update actuals in the financial model

    11m 19s
  • Dynamic analysis of variances in the cash flow model

    6m 2s
  • (Locked)
    Challenge: Rolling forward and Excel-based cash flow model

    1m 47s
  • (Locked)
    Solution: Rolling forward and Excel-based cash flow model

    4m 44s
• 8. Finalizing, Communicating, and Iterating the Forecast 8. Finalizing, Communicating, and Iterating the Forecast

  • (Locked)
    Designing the cash flow forecasting process in Excel

    6m 2s
  • (Locked)
    Business partners and the cash flow forecasting process

    3m 27s
  • (Locked)
    Implications of cash flow forecasts on the business

    2m 50s
• Conclusion Conclusion

  • (Locked)
    Elevating your cash flow forecasting and modeling in Excel

    1m 6s