Excel AS Teaching Resource: Cash Flow Forecast

Free interactive Excel files designed to teach AS students how to apply the concepts of cash flow. These files are designed to automatically inform students as to whether their answers are correct using prompts. Negative cash balances turn red to facilitate students understanding of overdrafts / cash flow. Ideal for BUSS1. Three files are available. A low ability version, a teacher suggested answer and a higher ability question utilising ‘what-if’ analysis.

An ideal resource for teaching BUSS1 cash flow in an ICT suite. The resource guides students to focus upon the interpretation of the numbers rather than just the ICT. The built in prompts allow students to confirm their own understanding and work independently, freeing up teacher time to focus upon interpretation. A low ability version and a teacher suggested answer are available.
In addition, I have uploaded a more advanced ‘What-if’ Analysis version for higher ability students using scrollbars and spinners for which the teacher can design a more difficult bespoke series of activities for students who are very comfortable with numbers.

Barry_Fry_Builders_Low_Ability_AS_Student_Version.xls
Barry_Fry_Builders_Low_Ability_AS_Teacher_Version.xls
Barry_Fry_Builders_What-If_Version.xls