02 Mar Budget Exercise Use an Excel sheet to make the necessary calculations of your monthly budget

Budget Exercise

Use an Excel sheet to make the necessary calculations of

your monthly budget. Submit the sheet through the

designated assignment area. You must break down the

two main areas as: Income and Expenses, and at the end,

indicate the profit or loss obtained. Information on the

different budget activities appears below. The budget

month is January of the current year and on that date you

had a budget of $32.50.

1. You receive a check from a relative as a late holiday gift

for $125.

2. You washed your brother’s car so he gave you $20.

3. You went out to eat with some friends and spent

$23.50.

4. You had to purchase some educational materials, which

amounted to

$18.75.

5. On January 15 you received your biweekly salary. You

worked 20.5 hours and get paid

$8.15/hour. They give you a discount of 8.5% for the

different deductions

payroll

6. Your partner has a birthday on January 18 and wants a

good dinner. Do you estimate that the

expense will be $75.00.

7. You have to go to the stylist during the second week of

January; the cost is $15.