K5 Computer Lab Lesson Plans
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
iPad Classroom Tech Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple Mac Keynote Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

iWork Numbers - Lemonade Stand Profit and Loss

Students Create a Profit and Loss Spreadsheet for a Lemonade Stand

Students enter sales and expense data and use formulas to calculate profits or losses for 6 days.


Students learn to save time by using AutoFill to automatically fill in the days of the week, recurring number values (Rent), and repeating formulas (Total Expenses, Profit and Loss).


Grades 4+





iWork Numbers Lemonade Stand Profit and Loss Finished Example:

iWorks Numbers Lemonade Stand


Spreadsheet Instructions:

Step 1 - Spreadsheet Setup

Enter data as shown. Use autofill to automatically enter weekdays Tues - Sat into the cells. Improve visual appearance by formatting text using larger font size and bold as necessary.

lemonade stand spreadsheet



20 Second Autofill Tutorial:

Drag the handle (lower right corner) of a selected cell to autofill.




Step 2 - Generate and Enter Sales and Expense Data

Use the Lemonade Stand Sales and Expense Number Generator to quickly generate numbers for each day of the week. Enter the sales and expense data for each day as shown.

lemonade stand data



Step 3 - Create Formula to Sum Total Expenses

Select all of the expenses in the Monday column as shown. Click the Formula button and click Sum. This will add all the selected expenses and enter the total underneath the selection ($17.00).

Use Autofill to calculate the total expenses for weekdays Tues - Sat.

lemonade stand calculate total expenses



Step 4 - Create Formula to Calculate Profit or Loss

Select the cell in the Profit and Loss row in the Monday Column. Enter the equal sign and the cell location of Monday's Sales (b4) minus the cell location of Monday's Total Expenses (b12) as shown below. Click the green checkmark to complete the calculation.

Use Autofill to calculate the profits or losses for weekdays Tues - Sat.

lemonade stand profit and loss



Lemonade Stand Finished Example:

Students can format the completed spreadsheet with their name, alternate fonts, font colors, sizes, etc.

lemonade stand spreadsheet


More Ideas
For PC's and Microsoft Office

  • Excel
    Bar Chart
  • Excel Bar Chart
  • Thanksgiving
    Copy and Paste
  • Thanksgiving Copy and Paste
  • Green Screen
    Photo Editing
  • Green Screen Photo Editing
  • Computer Lab
  • Computer Lab Rules Essentials
  • California Regions
  • California Regions Brochure
  • Amazing Animals
  • Amazing Animals
  • I Am
    Poem Generator
  • I Am Poem Generator
  • "Floater"
  • I Can Float Animation
  • Learn PowerPoint
    in One Minute
  • Learn PowerPoint in One Minute
  • Copy and Paste
  • Copy and Paste Practice
  • M & M
    Excel Chart
  • Excel Pie Chart
  • Newspaper
  • Newspaper Template