Excel work 5 hrs
EXERCISE 2: CONSUMER MATHEMATICS
EXERCISE 2: CONSUMER MATHEMATICS
Learning Outcomes
After completing this exercise, you will be able to:
• conduct research on what your approximate starting salary will be once you have
graduated
• plan a monthly budget based on your starting salary which will include basic
necessities such as rent, food, mortgage, and electricity
• define and describe the applications of fundamental mathematical concepts from
consumer mathematics
• develop solutions to problems observed in personal experience based on
fundamental mathematical ideas and principles
• operate applicable technological tools to effectively analyze and visualize data.
Overview
The purpose of this exercise is to begin to think about your monthly income and
expenses after graduation. You will determine your monthly pay and take into account
any possible expenses. You are to turn in all mathematical work. Use as many different
sources as possible to make your results as realistic as possible and cite all of your
sources.
Procedure
1 Determine the average starting salary for your desired position after graduation by
either using the Internet or asking those working in the field (you can likely ask your
major professor). You must cite your source using APA Style (asking someone is
also a source). Then, calculate your monthly pay with the appropriate taxes taken
out. Use the following table to determine the percentage of tax taken from your
salary.
2 List all your monthly expenses. Again, cite your sources.
3 Use Zillow or another realtor site to find a place to live in your desired city. Add the
cost of rent to your monthly expenses. Again, cite your source.
4 Then, create an Excel spreadsheet of your monthly budget detailing each month’s
income and expenses. Make sure to budget for rent, food, gas/public
transportation, cell phone, electricity, water, student loan payments, etc.Remember
to also budget savings and special expenses like gifts and vacation. Your expenses
should also be less than your income.
5 Use Zillow or another realtor site to choose a future home (house, condo,
townhouse, etc.), land, or office space in your desired city. Calculate how much
you need to save each month for your down payment and for how long you need
to save for this down payment. A typical down payment is 20%. Incorporate this
calculated savings amount into your budget. Look up the current mortgage interest
rates. Do the calculations for the monthly payments and total home cost for a 15-
year fixed and 30-year fixed rate. Then, identify which home loan you will choose.
Again, cite your source.
https://www.zillow.com/
Sheet1
EXERCISE 2 | ||||||||||||||||||||||||||
Film Producer | ||||||||||||||||||||||||||
Starting Salary: $66,599 | ||||||||||||||||||||||||||
Location: Atlanta, GA | ||||||||||||||||||||||||||
Average Film/TV Producer Salary. (n.d.). Retrieved July 19, 2019, from https://www.payscale.com/research/US/Job=Film/TV_Producer/Salary | ||||||||||||||||||||||||||
Income | Taxes | |||||||||||||||||||||||||
Tax Type | Marginal Tax Rate | Effective Tax Rate | ||||||||||||||||||||||||
Federal | 25.00% | 11.94% | $7,951 | |||||||||||||||||||||||
FICA | 7.65% | $5,095 | ||||||||||||||||||||||||
State | 6.00% | 5.06% | $3,368 | |||||||||||||||||||||||
Local | 0.00% | $0 | ||||||||||||||||||||||||
Total Income Taxes | 24.65% | $16,414 | ||||||||||||||||||||||||
Income After Taxes | $50,185 | |||||||||||||||||||||||||
Federal Income Tax Plus FICA : $13,046 | ||||||||||||||||||||||||||
Monthly income: $4,182.08 | Monthly Expenses | |||||||||||||||||||||||||
Rent | $1,778 | |||||||||||||||||||||||||
Food | $500 | |||||||||||||||||||||||||
Apartment in Atlanta | Internet | $90 | ||||||||||||||||||||||||
Gas | $300 | |||||||||||||||||||||||||
$1,778 / mo | Utilities | $150 | ||||||||||||||||||||||||
Health Insurance (estimated) | $440 | |||||||||||||||||||||||||
1 bed | Car Insurance | $125 | ||||||||||||||||||||||||
1 bath | Spending | $200 | ||||||||||||||||||||||||
783 sqft | Cell Phone | $80 | ||||||||||||||||||||||||
Downpayment: $355.60 | Savings | $519.08 | ||||||||||||||||||||||||
Zillow, Inc., & Zillow, Inc. (n.d.). Ayla Apartment Rentals – Atlanta, GA. Retrieved July 19, 2019, from https://www.zillow.com/b/ayla-atlanta-ga-65XDqb/ | ||||||||||||||||||||||||||
Future Condo After Apartment (Atlanta) | ||||||||||||||||||||||||||
Condo Price $332,900 | ||||||||||||||||||||||||||
Zillow, Inc. (n.d.). 587 Virginia Ave NE APT 806, Atlanta, GA 30306. Retrieved July 20, 2019, from https://www.zillow.com/homedetails/587-Virginia-Ave-NE-APT-806-Atlanta-GA-30306/2087910320_zpid/ | ||||||||||||||||||||||||||
30 Year Fixed | 15 Year Fixed | |||||||||||||||||||||||||
Down Payment 20% | $66,850 | |||||||||||||||||||||||||
RATE | 3.25% | 3.13% | ||||||||||||||||||||||||
APR | 3.42% | 3.15% | ||||||||||||||||||||||||
MO. PAYMENT | $1,184 | $1,855 | ||||||||||||||||||||||||
CREDIT | $639 | LENDER FEES | $466 | |||||||||||||||||||||||
Zillow, Inc. (n.d.). Get Customized Loan Quotes From Zillow. Retrieved July 20, 2019, from https://www.zillow.com/mortgage-rates/quotes/?auto=true&loantype=purchase&zip=26201&value=332900&cscore=720-739&va=true&type=SingleFamilyHome&use=Primary&down=60000#request=ZR-QHQBSYKW | ||||||||||||||||||||||||||
11 Years (at the very least) To Save For A Down Payment | ||||||||||||||||||||||||||
Savings A Month: $519.08 | Monthly Payment | |||||||||||||||||||||||||
$519.08 x 12= $6,228.96 | ||||||||||||||||||||||||||
Savings A Year: $6,228.96 | ||||||||||||||||||||||||||
$6,228.96 x 12= 68,518.56 | ||||||||||||||||||||||||||
Fees depend on loan. For this instance, I chose a 15 year fixed loan. So, the extra fee, in addition to the down payment, would be $466. | ||||||||||||||||||||||||||
*RESULTS VARY DEPENDING IF SALARY CHANGES* | ||||||||||||||||||||||||||
Salary, in this instance, would probably be higher after this amount of time. | ||||||||||||||||||||||||||
HOA | $250.00 | |||||||||||||||||||||||||
$100 | ||||||||||||||||||||||||||
$42.08 |
Sheet1
EXERCISE 2 | |||||||||||||||||||||||||||
Interior designer | |||||||||||||||||||||||||||
Starting Salary: | $36,000 | ||||||||||||||||||||||||||
Location: Georgia, Savvannah | |||||||||||||||||||||||||||
Bruce. (n.d.). Retrieved from https://work.chron.com/starting-salary-beginner-interior-designers-26624.html | |||||||||||||||||||||||||||
Income | Taxes | ||||||||||||||||||||||||||
Tax Type | Marginal Tax Rate | Effective Tax Rate | |||||||||||||||||||||||||
Federal | 25.00% | 11.94% | $4,298 | ||||||||||||||||||||||||
FICA | 7.65% | $2,754 | |||||||||||||||||||||||||
State | 6.00% | 5.06% | $1,822 | ||||||||||||||||||||||||
Local | 0.00% | $0 | |||||||||||||||||||||||||
Total Income Taxes | 24.65% | $8,874 | |||||||||||||||||||||||||
Income After Taxes | $27,126 | ||||||||||||||||||||||||||
Federal Income Tax Plus FICA : =$7052 | $7,052 | ||||||||||||||||||||||||||
Monthly income: =$2260.5 | $2,260.50 | ||||||||||||||||||||||||||
Monthly Expenses | |||||||||||||||||||||||||||
Rent | $480 | ||||||||||||||||||||||||||
Food | $375 | ||||||||||||||||||||||||||
Apartment in Savannah | Internet | $90 | |||||||||||||||||||||||||
Gas | $250 | ||||||||||||||||||||||||||
$480/ mo | Utilities | $130 | |||||||||||||||||||||||||
Health Insurance | $440 | ||||||||||||||||||||||||||
1 bed | Car Insurance | $125 | |||||||||||||||||||||||||
1 bath | Spending | $135 | |||||||||||||||||||||||||
2347 sqft | Cell Phone | $55 | $2,080 | ||||||||||||||||||||||||
Downpayment: $150.50 | Savings | $180.50 | |||||||||||||||||||||||||
Zillow, Inc., & Zillow, Inc. (n.d.). Apartment Rentals – Atlanta, GA. Retrieved October 12, 2019, from https://www.zillow.com/b/Savannah-ga-65XDqb/ | |||||||||||||||||||||||||||
Future Condo After Apartment (Atalanta) | |||||||||||||||||||||||||||
Condo Price $ | 102600 | ||||||||||||||||||||||||||
Zillow, Inc., & Zillow, Inc. (n.d.). Ayla Apartment Rentals – Atlanta, GA. Retrieved October 12, 2019, from https://www.zillow.com/b/ayla-atlanta-ga-65XDqb/ | |||||||||||||||||||||||||||
30 Year Fixed | 15 Year Fixed | ||||||||||||||||||||||||||
Down Payment 20% | $20,520 | ||||||||||||||||||||||||||
RATE | 3.12% | 3.88% | |||||||||||||||||||||||||
APR | 3.42% | 3.15% | |||||||||||||||||||||||||
MO. PAYMENT | $535 | ||||||||||||||||||||||||||
CREDIT | $450 | LENDER FEES | $350 | ||||||||||||||||||||||||
Zillow, Inc. (n.d.). Get Customized Loan Quotes From Zillow. Retrieved October,12, 2019, from https://www.zillow.com/mortgage-rates/quotes/?auto=true&loantype=purchase&zip=26201&value=332900&cscore=720-739&va=true&type=SingleFamilyHome&use=Primary&down=60000#request=ZR-QHQBSYKW | |||||||||||||||||||||||||||
11 Years (at the very least) To Save For A Down Payment | |||||||||||||||||||||||||||
Savings A Month: $180.50 | Monthly Payment | ||||||||||||||||||||||||||
$180.50 x 12= $ | 2166 | ||||||||||||||||||||||||||
Savings A Year: $2166 | |||||||||||||||||||||||||||
$2166x 12= 25992 | |||||||||||||||||||||||||||
Fees depend on loan. For this instance, I chose a 15 year fixed loan. So, the extra fee, in addition to the down payment, would be $334. | Health Insurance (estimated) | ||||||||||||||||||||||||||
HOA | $0.00 | ||||||||||||||||||||||||||
$126 |