Annual cash flow forecast projection in Excel

A simple cash book projection for small business. The video shows a single Excel worksheet detailing monthly income and expenditure projected over a year. The example shown is deliberately incomplete and ask you to create and complete a sheet yourself in order to practice the required skills. The video assumes a VAT rate of 15%, which can easily be adjusted for your local rate using the example formulae. As always, watch out for the data entry errors!
A simple double entry cash book for small business accounts is shown at:
• Video