Budget Document

$*$Need a step by step of everything with equations. Please also include screenshots

Purpose: To create a document to track your budget to determine if a certain salary could work for your lifestyle.

Use Excel to create a budgeting document. Must include:

Title of the Job: Sales Representative

Salary: $$50,000$

AMOUNT AFTER TAXES

AMOUNT PER MONTH AFTER TAXES

List of the monthly bills $4$ pts

Car

Cell phone$/$internet$/$cable

Insurance $($health$/$car$/$etc$.)$

Water$/$Garbage$/$Heat$/$Gas

Student Loans

Credit Cards

Appx cost for food $($grocery and going out to eat$)$

Any other monthly costs

BILL TOTAL

TOTAL LEFT PER MONTH AFTER BILLS ARE PAID

Two columns $$ one for the info; the other for the amounts of money Four places using functions:

Amount after taxes $$ Take the salary amount cell $*(\mathrm{.}75)...$

Estimating $25\%$ being removed for taxes, leaving us with $75\%$

Amount per month after taxes $$ Take the salary after taxes cell divided by $12$ Total Amount for Bills $$ Need to use the sum function Total Amount left after Bills paid $$ Needs to be salary per month cell minus total amount for bills Example of what the Excel document will look like $$ the $4$ colored cells are where formulas will be used:

Budget pic example

This criterion is linked to a Learning OutcomeTitle of the Job you have or would like to have

This criterion is linked to a Learning OutcomeSalary or estimated salary

This criterion is linked to a Learning OutcomeFunction $1$: Amount after taxes $$ Take the salary amount cell $*(\mathrm{.}75)$

This criterion is linked to a Learning OutcomeFunction $2$: Amount per month after taxes $$ Take the salary after taxes cell divided by $12$

This criterion is linked to a Learning OutcomeList of the monthly bills

This criterion is linked to a Learning OutcomeFunction $3$: Total Amount for Bills $$ Need to use the sum function

This criterion is linked to a Learning OutcomeFunction $4$: Total Amount left after Bills paid $$ Needs to be salary per month cell minus total amount for bills

This criterion is linked to a Learning OutcomeTwo columns $$ one for the info; the other for the amounts of money