In this video we discuss the theory and background on cashflow forecasting, and explore the difference between Cashflow and Profit. We then add a Cashflow Forecast to our Model, which operates like a corkscrew account with opening and closing balances.
Video length: 5 min 50 sec
Hold on, don’t submit your model just yet! We’re still going to make some changes in the next module…
Templates
Continue using the financial model we have been working on in the previous video. Follow along with the video demonstration, and the written instructions. It is a requirement of this course that you submit this model for review on completion and your model will be checked for accuracy. Please save your model, and make sure that your numbers match those in the video before moving to the next one.
Transcript
Download the Transcript for this video.
Please note:
To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.
In this video we cover the theory and background on Profit & Loss Statements, and then add a P&L to our Financial Forecast Model.
Video length: 3 min 30 sec
Templates
Continue using the financial model we have been working on in the previous video. Follow along with the video demonstration, and the written instructions. It is a requirement of this course that you submit this model for review on completion and your model will be checked for accuracy. Please save your model, and make sure that your numbers match those in the video before moving to the next one.
Transcript
Download the transcript for this video.
Please note:
To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.
In this video we now add fixed and volume-related expense calculation to our Financial Forecast Model. Expenses to be calculated include staff costs (including their oncosts), rent, utilities and consumables.
Video length: 3 min
Templates
Continue using the financial model we have been working on in the previous video. Follow along with the video demonstration, and the written instructions. It is a requirement of this course that you submit this model for review on completion and your model will be checked for accuracy. Please save your model, and make sure that your numbers match those in the video before moving to the next one.
Transcript
Download the Transcript for this video.
Please note:
To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.
In this video: Once we’ve inserted and documented our assumptions, we continue to build our Financial Forecast Model by forecasting revenue based on historical sales, including seasonality, and then add an automatic error check.
Video length: 7 min 40 sec
Templates
Continue using the financial model we have been working on in the previous video. Follow along with the video demonstration, and the written instructions. It is a requirement of this course that you submit this model for review on completion and your model will be checked for accuracy. Please save your model, and make sure that your numbers match those in the video before moving to the next one.
Transcript
Download the Transcript for this video.
Please note:
To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.
This video contains an overview of our model inputs and case study background. We’ve been asked by our bank to put together a P&L and Cashflow. We’re going to use all of the tools and the techniques that we’ve been learning about to put together this financial model.
Video length: 11 min 10 sec
Templates
Download the Excel template for this video. Follow along with the video demonstration, and the written instructions. It is a requirement of this course that you submit this model for review on completion and your model will be checked for accuracy. Please save your model, and make sure that your numbers match those in the video before moving to the next one.
Additional Resources
For those new to formatting cells, or for a refresher, see pages 1-8 of this supplementary material document.
Transcript
Download the Transcript for this video.
Please note:
To move forward to the next video, you must mark this video complete. To mark the video complete, please watch the video or if you would like to skip the video, just click on the video time line right at the end to enable the ‘Mark Video Complete’ button. See instructions on the Student Dashboard here for more information.
