Let S Create a Small Business Budget

Let’s Create a Small Business Budget

Worksheet # 7 (Guided Practice/Independent Practice) – Excel Spreadsheet

Directions: Follow the steps below to create an Excel Spreadsheet budget. Bold prompts will be completed as Independently Practice.

*Refer Worksheet #6 – Excel PowerPoint Interactive Notes

Create the following labels in the in the prescribed cells.

1. Rent A3 (Fill color – yellow)

2. Food A4 (Fill color – yellow)

4. Cell Phone A5 (Fill color – yellow)

5. Gas A6 (Fill color – yellow)

6. Clothes A7 (Fill color – yellow)

7. Utilities A8 (Fill color – yellow)

8. Total A10 (Fill color – green)

9. Difference A12 (Fill color – grey)

10. Dec. B1 (Bold)

11. Jan. D1 (Bold)

12. Projected Cost B2 and D2 (Fill color – light blue)

13. Actual Cost C2 and E2 (Fill color – light blue)

14. Average G2 (Fill color – pink)

Now that we have created our labels, let’s assign values.

15. Dec. and Jan. Projected Cost: Rent 1,100 Food 400 Cell Phone 120 Gas 200 Clothes 150

Utilities 105

16. Dec. Actual Cost: Rent 1,100 Food 350 Cell Phone 120 Gas 185 Clothes 80

Utilities 87

17. Jan. Actual Cost: Rent 1,100 Food 450 Cell Phone 120 Gas 203 Clothes 150

Utilities 115

Now that we have assigned values, let’s create formulas. We are going to do this two different ways.

18. Click on cell B10 and type the formula =SUM(B3:B8) then press enter

19. Click on cell C10 and type the formula =SUM(C3:C8) then press enter

20. Click on cell D10, next click the function button (fx) on the formulas bar, then click SUM, click OK, then click and highlight cells D3 through D8, then click OK

21. Click on cell E10, next click the function button (fx) on the formulas bar, then click SUM, click OK, then click and highlight cells E3 through E8, then click OK

For the rest of this lesson we will be using the function buttons but feel free to use whichever method you like the best.

22. Click on cell G3, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C3 for Number 1 and E3 for Number 2, then click OK

23. Click on cell G4, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C4 for Number 1 and E4 for Number 2, then click OK

24. Click on cell G5, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C5 for Number 1 and E5 for Number 2, then click OK

25. Click on cell G6, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C6 for Number 1 and E6 for Number 2, then click OK

26. Click on cell G7, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C7 for Number 1 and E7 for Number 2, then click OK

27. Click on cell G8, next click the function button (fx) on the formulas bar, then click AVERAGE, click OK, then click and highlight cell C8 for Number 1 and E8 for Number 2, then click OK

28. Click on cell G10, next click the function button (fx) on the formulas bar, then click SUM, click OK, then click and highlight cells G3 through G8, then click OK

29. Click on cell C12 and type the formula =B10-C10 then press enter

30. Click on cell E12 and type the formula =D10-E10 then press enter