Excel: Building a 13-Week Cash Flow

سرفصل های دوره

In this practical course, learn how to create a robust and dynamic cash flow forecast using Microsoft Excel. Instructor Christopher Reilly shows you how to clean up your source data, build a cash flow forecast from scratch, summarize your findings, and refresh the forecast with new data. You'll also discover how to perform variance analysis to compare actual results against your projections. By the end of this course, you'll have a powerful tool to help you manage your business's cash flow and make informed financial decisions.

01 - Introduction

01 - Unlocking the power of cash flow forecasting

02 - 1. Foundations of 13-Week Cash Flow Forecasting in Excel

01 - 13-week cash flow overview

02 - A simple cash flow

03 - What were going to build

04 - Email from the CFO

03 - 2. Clean Up Your Source Data

01 - Format bank data

02 - Inserting helper columns

03 - Add the week-ending date

04 - Import cash forecast template

05 - Build the error checking tab

06 - Conditional format error checking

07 - Build transaction mapping tab

08 - Build unique IDs and categories

09 - Build an exact match formula

10 - Build a text contains formula

04 - 3. Build the Cash Flow Forecast in Excel

01 - Calculate the history

02 - Bring in the AP aging report

03 - Bring in the AR aging report

04 - Link the AR and AP aging reports

05 - Finish the cash forecast

05 - 4. Build the Cash Flow Summary

01 - Establish summary dates

02 - Populate the summary

03 - Build a cash flow chart

06 - 5. Refresh the Cash Flow Forecast

01 - New email from CFO

02 - Duplicate the cash forecast

03 - Bring in new bank data

04 - Bring in the AR and AP reports

05 - Refresh the history in the cash forecast

06 - Update the forecast

07 - Update the summary

07 - 6. Build Variance Analysis

01 - Add variance tags

02 - Begin the variance report

03 - Bring in the variance report layout

04 - Start populating the bridge

05 - Calculate the category variances

06 - Finish the bridge

07 - Close out the file

08 - Conclusion

01 - Course summary and conclusion

139,000 تومان

خرید اشتراک افزودن به سبد خرید

خرید دانلودی فوری

در این روش نیاز به افزودن محصول به سبد خرید و تکمیل اطلاعات نیست و شما پس از وارد کردن ایمیل خود و طی کردن مراحل پرداخت لینک های دریافت محصولات را در ایمیل خود دریافت خواهید کرد.

تولید کننده: LinkedIn Learning (Lynda)