S2

Instructions:Use the following information to create a spreadsheet:

Michelle would like to buy a new bike, but she found that they are expensive. She decided to save some money each week. Use the following information to complete a cash flow analysis for Michelle. She earns $25.00 for mowing the neighbor’s lawn, $26.00 for delivering newspapers, $60.00 for babysitting, and receives a $15.00 allowance each week. She spends about $11.75 on school lunch, $6.00 a week on snack food, $12.00 on entertainment, and $45.00 a week on clothes.

Create a spreadsheet. Similar to this rough draft:

2. Use the currency format in column B.

3. Save the spreadsheet as S2

4. Enter all labels and values according to the rough draft and using the instructions at the top.

5. Adjust the width of column A so that all the labels fit. Don’t make it too wide!

6. Create a =sum formula to determine the Total Weekly Income.

7. Create a =sum formula to determine the Total Weekly Expenses.

8. Enter a formula to determine the Weekly Savings.

=Total Weekly Income cell-Total Weekly Expenses cell

9. Format the spreadsheet to make the 3 sections easier to read.

Use fonts, colors, bold, italic...what ever it takes to make it look good!

10. Place your name and assignment (S2) in a custom header’s left section.

11. Be sure all the original values are on your spreadsheet and print two copies: