Excel

profileMafia76
cost_of_living_project.xlsx

Table 1

w Central New Jersey Miami FL Oakland California
Entry Level Salary $94,603.00 $54,986.00 $56,837.00 $ 82,988.00
Cost of living index Woodbridge NJ Miami FL Oakland California
Overall 118.8 122.8 179.3
Food 106.5 105.6 118.4
Housing 134.2 156.5 326.1
Utilities 133.6 99.2 95.8
Transportation 104.6 112.3 106.3

Table 2

Gross Pay Taxes Net Pay
$ 4,698.92 $ 751.83 $ 3,947.09
Food $ 78.94
Utilities $ 197.35
Housing $ 1,105.19
Transportation $ 473.65
TOTAL $ 1,855.13

Detailed Justification

House
Price of Listing $190,000
Type of Home condo
Number of Bedrooms/Bathrooms 1 bed 1 bath
Down Payment (10%) 19000
Loan Amount ($) $171,000
Estimated monthly payment $1,168
Property taxes or condo fees $206
Is it in your price range? no over by $ 50
Does it meet your standards? yes
Target Monthly Payment $ 473.65 Car
Loan Term 36 months Make/Model Honda Accord
Market Finance Rate 2.99 Price $13,888 $252/mo
Sticker Price Range $13,600 - $16,600 Year 2014
Maximum TMV Price $ 15,100.00 Mileage 37,854
Color Grey
Doors 4
Special Features Sunroof, Heated seats, Back up Camera Side camera, Leather, Power seats, Fog Lights.

Ranking

Rank City
#1 Oakland, California
#2 Miami, FL
#3 Woodbridge NJ