Excel work 5 hrs

profileVincent666
consumermathematics.xlsx

Sheet1

EXERCISE 2
Interior designer
Starting Salary: $36,000 $36,000
Location: Georgia, Savvannah
Bruce. (n.d.). Retrieved from https://work.chron.com/starting-salary-beginner-interior-designers-26624.html
Income Taxes Breakdown
Tax Type Marginal Tax Rate Effective Tax Rate Taxes
Federal 25.00% 11.94% $4,298
FICA 7.65% 7.65% $2,754
State 6.00% 5.06% $1,822
Local 0.00% 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 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 Down Payment 20% $20,520
RATE 3.12% RATE 3.88%
APR 3.42% APR 3.15%
MO. PAYMENT $535 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  Monthly Expenses 15 Year Fixed
Savings A Month: $180.50 Monthly Payment $535
$180.50 x 12= $2166 Food $375
2166 Internet $90
Savings A Year: $2166 Gas $250
$2166x 12= 25992 Utilities $130
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) $440
Car Insurance $125
Spending $135
Cell Phone $55
HOA $0.00
Savings $126