Spreadsheet modelling for business

What you'll learn

1. 1

   Imagine you run a lemonade stand 🍋. A spreadsheet helps you track money coming in (sales) and going out (costs).

2. 2

   What does a spreadsheet help a business do?

3. 3

   Set up a simple model: each bottle of lemonade costs £2. Drag to show what happens when you sell 5 bottles.

4. 4

   Let's model profit together. You sell 10 cups of lemonade at £1 each. Your costs are £4 for lemons and sugar.

5. 5

   Now you try: you sell 8 cups at £1.50 each. Costs are £5. What's the profit?

6. 6

   If sales = £12 and costs = £5, what is the profit?

7. 7

   What formula would you type in a spreadsheet to calculate profit if sales are in cell B2 and costs are in cell C2?