jaramillo3.11.7 - 1907/07/2011 A 1 2 3 4 5 6 7 8 9 10 11 12...

Info iconThis preview shows pages 1–2. Sign up to view the full content.

View Full Document Right Arrow Icon
1907/07/2011 Juan Jaramillo Vishak Sivakamur Period #5 Tutorial #3 jaramillo@ufl.edu PRACTICE BUDGET 2008 107/07/201118:05:25file:////home/vdimitrov/30184/c81b6bd0af08226e96abfa8bdb37315486012247.xl BUDGET for SIX MONTHS OF 2008 CONSTRAINTS: Income Tax 16.25% Social Security 6.79% Comic Relief 3.43% Promotion Raise 7.79% Rent Maintenance Increase 6.82% RENT AS % OF GROSS 29.34% >=30%? No RENT AS % AFTER TAX/FEE 37.99% >=30%? Yes BUDGET FOR JUAN JARAMILLO SPRING 2008 BUGDET: JAN FEB MAR APR MAY JUN AVERAGE PERCENT Bank Balance 1294 1154 2108 2520 2878 3240 $2,198.80 82.13% INCOME: Gross Wages 566 2678 2678 2887 2887 2887 $2,430.31 90.78% LESS: Income Tax 92 435 435 469 469 469 $394.93 14.75% Social Security 38 182 182 196 196 196 $165.02 6.16% Comic Relief 99 99 99 $99.01 3.70% NET WAGES: 436 2061 2061 2123 2123 2123 $1,820.86 68.02% Bonus/Extras 256 212 267 245 278 223 $246.83 9.22% TOTAL INCOME: 822 2890 2945 3132 3165 3110 $2,677.14 100.00% AFTER TAX/FEE INCOME: $691.59 $2,272.99 $2,327.99 $2,367.53 $2,400.53 $2,345.53 $2,067.69 77.24% EXPENSES: Rent 492 811 811 866 866 866 $785.49 29.34% Food 123 141 165 187 208 239 $177.17 6.62% Utilities 62 88 86 94 83 94 $84.50 3.16% Entertainment 87 144 165 192 212 194 $165.67 6.19% Credit Card Payment 33 51 59 60 51 62 $52.67 1.97% Publications 14 25 27 33 42 37 $29.67 1.11% Transportation 21 59 65 41 39 32 $42.83 1.60% School Loan Payments 398 398 398 398 $398.02 14.87% Car Loan Payments 139 139 139 139 $139.10 5.20% TOTAL EXPENSES: 832 1319 1915 2010
Background image of page 1

Info iconThis preview has intentionally blurred sections. Sign up to view the full version.

View Full DocumentRight Arrow Icon
Image of page 2
This is the end of the preview. Sign up to access the rest of the document.

Page1 / 9

jaramillo3.11.7 - 1907/07/2011 A 1 2 3 4 5 6 7 8 9 10 11 12...

This preview shows document pages 1 - 2. Sign up to view the full document.

View Full Document Right Arrow Icon
Ask a homework question - tutors are online