05 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.
