xls, 30.5 KB
xls, 30.5 KB
xls, 37.5 KB
xls, 37.5 KB
xls, 56.5 KB
xls, 56.5 KB
doc, 42 KB
doc, 42 KB
doc, 46 KB
doc, 46 KB
pdf, 285.28 KB
pdf, 285.28 KB

This activity/ exercise challenges students to create firstly a start up year 12 month cashflow forecast for a business, followed by a year 2 12 month cashflow forecast using data provided. The idea is to get them used to the cashflow process - creating and calculating a cashflow table - and to encourage them to think about the challenges businesses face when payments have to be met at different times of the year and the fact that cash inflows can also fluctuate.

Use the answers to discuss the financial position of this business. What should the owner plan for/ when? Where did the numbers likely come from? Are they likely to be accurate? This is a budget - what can they do to ensure that this is as realistic as possible etc. etc.

Included in the pack are some notes on cashflow forecasting, data for 2 years (separate exercises), a blank excel spreadsheet that can be printed for a written exercise, an excel spreadsheet with formulae included, and the answers.

Get this resource as part of a bundle and save up to 29%

A bundle is a package of resources grouped together to teach a particular topic, or a series of lessons, in one place.

Reviews

Something went wrong, please try again later.

This resource hasn't been reviewed yet

To ensure quality for our reviews, only customers who have purchased this resource can review it

Report this resourceto let us know if it violates our terms and conditions.
Our customer service team will review your report and will be in touch.