×
HomeGr. Level Lesson Plans Poem Generators Google Classroom
Graphic Organizers
Google Classroom
Spreadsheets
iPad Classroom Integration iPad - Mac
Graphic Organizers
Excel Word Word - Graphic Organizers PowerPoint MultiMedia Internet Research Apple / Mac Apple Mac Pages Apple Mac Numbers Apple Mac Multimedia Coding For Kids Resources

iWork Numbers
Lemonade Stand Profit and Loss

Assignment: This lemonade stand profit and loss statement for 6 days teaches students the fundamentals of business finances. Students learn how sales and expenses are related to profits or losses. Students enter sales and expense data and use formulas to automatically calculate profits or losses.

Number Generator: Lemonade-Stand-Sales-and-Expenses-Number-Generator

Profit and Loss Finished Example:

Students create a complete profit and loss statement for 6 days of operations.

Profit and Loss Finished Example:

Spreadsheet Instructions:

  • Spreadsheet Setup: Enter data as shown. If possible, 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.

  • Spreadsheet Setup
  • 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.

  • Generate and Enter Sales and Expense Data
  • Create a Formula to SUM the 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). If possible, use Autofill to calculate the total expenses for weekdays Tues - Sat.

  • Create a Formula to SUM the Total Expenses
  • Create a 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.

  • Create Formula to Calculate Profit or Loss

Lemonade Stand Finished Example:

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

Lemonade Stand Finished Example