Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Budget Document * Need a step by step of everything with equations. Please also include screenshots Purpose: To create a document to track your budget
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: $
AMOUNT AFTER TAXES
AMOUNT PER MONTH AFTER TAXES
List of the monthly bills pts
Car
Cell phoneinternetcable
Insurance healthcaretc
WaterGarbageHeatGas
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
Estimating being removed for taxes, leaving us with
Amount per month after taxes Take the salary after taxes cell divided by 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 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 : Amount after taxes Take the salary amount cell
This criterion is linked to a Learning OutcomeFunction : Amount per month after taxes Take the salary after taxes cell divided by
This criterion is linked to a Learning OutcomeList of the monthly bills
This criterion is linked to a Learning OutcomeFunction : Total Amount for Bills Need to use the sum function
This criterion is linked to a Learning OutcomeFunction : 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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started