Budget Document

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

Requirements$/$Instructions:

create an excel document described below.

Use Excel to create a budgeting document. Must include:

Title of the Job you have or would like to have $($SALES REPRESENTATIVE$)$

Salary or estimated salary $($$$35,000$ PLUS COMMISSION $\{$roughly $$50,000$ total$\})$

$+$ Any additional income $($spouse$,$ child support, side$-$gig$)$

AMOUNT AFTER TAXES

AMOUNT PER MONTH AFTER TAXES

List of the monthly bills $($examples below$)$

Rent$/$Mortgage

Childcare

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