Docstoc

PasteLink - Welcome to plaza.ufl.edu

Document Sample
PasteLink - Welcome to plaza.ufl.edu Powered By Docstoc
					                                                              Gator Budget Fall 2004                                                                Kwok Lau
                                                                                                                                            Aruturo Camacho
                                                                                                                                                     Period 9
                                                                                                                                              Assignment #3
BUDGET for SIX MONTHS OF 2004-2005
CONSTRAINTS:
Income Tax                                       18.12%
Social Security                                   6.03%
Comic Relief                                      2.13%
Promotion Raise                                   6.61%
Rent Maintenance Increase                         5.29%

RENT AS % OF GROSS                26.51%                  >=25%?          Yes
RENT AS % OF NET                  32.52%                  >=40%?          No


                                                  BUDGET FOR KWOK LAU:
BUDGET:                     AUG            SEP            OCT             NOV              DEC            JAN             AVERAGE           PERCENT
Bank Balance                        4444           4371            5754             6617           7573           8420          $6,196.48       215.64%
INCOME:
Gross Wages                          578           2944            2944             3139           3139           3139          $2,646.97        92.12%
LESS: Income Tax                     105            533             533              569            569            569            $479.63        16.69%
       Social Security                 6             32              32               34              34             34            $28.92         1.01%
       Comic Relief                                                                                   67             67            $66.85         2.33%
NET WAGES:                           467           2378           2378              2536           2469           2469          $2,116.13        73.64%
Bonus/Extras                         212            265            214               232            247            189            $226.50         7.88%
TOTAL INC0ME:                        790           3209           3158              3371           3386           3328          $2,873.47       100.00%
NET INCOME:                 $     678.95 $     2,643.38 $     2,592.38 $        2,767.59 $     2,715.74 $     2,657.74          $2,342.63        81.53%

EXPENSES:
Rent                                 454            798            798              840             840            840            $761.77        49.29%
Food                                 145            178            189              201             255            264            $205.33        13.29%
Entertainment                         78            145            154              187             208            192            $160.67        10.40%
Credit Card Payment                   35             59              67               64              58             71            $59.00         3.82%
Publications                          18             26              31               37              42             38            $32.00         2.07%
Transportation                        22             54              67               58              42             21            $44.00         2.85%
School Loan Payments                                               339              339             339            339            $339.22        21.95%
Car Loan Payments                                                    85               85              85             85            $84.75         5.48%
TOTAL EXPENSES:                      752           1260           1730             1811            1869           1850          $1,545.42       100.00%
BALANCE:                    $     (73.05) $    1,383.38 $       862.41 $         956.41 $        846.56 $       807.56 $          797.21         51.59%

BALANCE +BANK:              $   4,370.95   $   5,754.33   $   6,616.74    $     7,573.15   $   8,419.71   $   9,227.26    $     6,993.69


LOAN PAYMENT:               SCHOOL         CAR LOAN       TOTAL           SCHOOL           CAR            EXPENSES            AMOUNT            MONTH
Total Principle              $20,123.00     $5,378.00     INTEREST          $8,665.47       $2,519.70     MINIMUM                752             Aug
Annual Interest                6.89%          6.89%       COST             $28,788.47       $7,897.70     MAXIMUM               1869             Dec
Term, Years                     6.25           6.80
Monthly Loan Payment:         $339.22        $84.75




                                                                                                                                                     1
                                                                                                                                             7/19/2011
                                                                                                                                               2:10 AM
                                                                                                              bef51350-0a28-4c6f-b7a7-6da8024ac0c2.xls
                                                                                                  GATOR FORMULA Fall 2004                                                                                                         Kwok Lau
                                                                                                                                                                                                                          Aruturo Camacho
                                                                                                                                                                                                                                   Period 9
                                                                                                                                                                                                                            Assignment #3




BUDGET for SIX MONTHS OF 2004-2005
CONSTRAINTS:
Income Tax                                              0.1812
Social Security                                         0.0603
Comic Relief                                            0.0213
Promotion Raise                                         0.0661
Rent Maintenance Increase                               0.0529

RENT AS % OF GROSS            =H27/H23                                            >=25%?                 =IF(B10>0.25, "Yes", "No")
RENT AS % OF NET              =H27/H24                                            >=40%?                 =IF(B11>0.4, "Yes", "No")


                                                                                           BUDGET FOR KWOK LAU:
BUDGET:                       AUG                       SEP                       OCT                    NOV                          DEC                JAN                AVERAGE                      PERCENT
Bank Balance                  1422                      =B38                      =C38                   =D38                         =E38               =F38               =AVERAGE(B15:G15)            =H15/$H$23
INCOME:
Gross Wages                   578                       2944                      =C17                   =$C$17*(1+$C$7)              =$C$17*(1+$C$7)    =$C$17*(1+$C$7)    =AVERAGE(B17:G17)            =H17/$H$23
LESS: Income Tax              =$C$4*B17                 =$C$4*C17                 =$C$4*D17              =$C$4*E17                    =$C$4*F17          =$C$4*G17          =AVERAGE(B18:G18)            =H18/$H$23
       Social Security        =$C$5*B18                 =$C$5*C18                 =$C$5*D18              =$C$5*E18                    =$C$5*F18          =$C$5*G18          =AVERAGE(B19:G19)            =H19/$H$23
       Comic Relief                                                                                                                   =F17*$C$6          =G17*$C$6          =AVERAGE(B20:G20)            =H20/$H$23
NET WAGES:                    =B17-B18-B19-B20          =C17-C18-C19-C20          =D17-D18-D19-D20       =E17-E18-E19-E20             =F17-F18-F19-F20   =G17-G18-G19-G20   =AVERAGE(B21:G21)            =H21/$H$23
Bonus/Extras                  212                       265                       214                    232                          247                189                =AVERAGE(B22:G22)            =H22/$H$23
TOTAL INC0ME:                 =B17+B22                  =C17+C22                  =D17+D22               =E17+E22                     =F17+F22           =G17+G22           =AVERAGE(B23:G23)            =H23/$H$23
NET INCOME:                   =B23-B19-B18-B20          =C23-C19-C18-C20          =D23-D19-D18-D20       =E23-E19-E18-E20             =F23-F19-F18-F20   =G23-G19-G18-G20   =AVERAGE(B24:G24)            =H24/$H$23

EXPENSES:
Rent                          454                       798                       =C27                   =$C$27*(1+$C$8)              =$C$27*(1+$C$8)    =$C$27*(1+$C$8)    =AVERAGE(B27:G27)            =H27/$H$35
Food                          145                       178                       189                    201                          255                264                =AVERAGE(B28:G28)            =H28/$H$35
Entertainment                 78                        145                       154                    187                          208                192                =AVERAGE(B29:G29)            =H29/$H$35
Credit Card Payment           35                        59                        67                     64                           58                 71                 =AVERAGE(B30:G30)            =H30/$H$35
Publications                  18                        26                        31                     37                           42                 38                 =AVERAGE(B31:G31)            =H31/$H$35
Transportation                22                        54                        67                     58                           42                 21                 =AVERAGE(B32:G32)            =H32/$H$35
School Loan Payments                                                              =$B$45                 =$B$45                       =$B$45             =$B$45             =AVERAGE(B33:G33)            =H33/$H$35
Car Loan Payments                                                                 =$C$45                 =$C$45                       =$C$45             =$C$45             =AVERAGE(B34:G34)            =H34/$H$35
TOTAL EXPENSES:               =SUM(B27:B34)             =SUM(C27:C34)             =SUM(D27:D34)          =SUM(E27:E34)                =SUM(F27:F34)      =SUM(G27:G34)      =AVERAGE(B35:G35)            =H35/$H$35
BALANCE:                      =B24-B35                  =C24-C35                  =D24-D35               =E24-E35                     =F24-F35           =G24-G35           =AVERAGE(B36:G36)            =H36/$H$35

BALANCE +BANK:                =B36+B15                  =C36+C15                  =D36+D15               =E36+E15                     =F36+F15           =G36+G15           =AVERAGE(B38:G38)
                                                                                                                                                                                                         =IF(OR((D35<1590), AND(D38>2055,G24>1570)),"YES","NO")
                                                                                                                                                                                                         =IF(AND(0,1,1),IF(B10, "True", "False"), IF(OR(IF(B11, 1, 0), TRUE, F
LOAN PAYMENT:                 SCHOOL                    CAR LOAN                  TOTAL                  SCHOOL                       CAR                EXPENSES                     AMOUNT                        MONTH
Total Principle               20123                     5378                      INTEREST               =(B43*B42)*B44               =(C43*C42)*C44     MINIMUM            =MIN(B35:G35)                =IF(H42=$B$35,"Aug",IF(H42=$C$35,"Sep",IF(H42=$D$35,"Oct",IF(H
Annual Interest               0.0689                    0.0689                    COST                   =E42+B42                     =F42+C42           MAXIMUM            =MAX(B35:G35)                =IF(H43=$B$35,"Aug",IF(H43=$C$35,"Sep",IF(H43=$D$35,"Oct",IF(H
Term, Years                   6.25                      6.8
Monthly Loan Payment:         =(PMT(B43,B44,-B42))/12   =(PMT(C43,C44,-C42)/12)




                                                                                                                                                                                                                                       2
                                                                                                                                                                                                                              7/19/2011
                                                                                                                                                                                                                                2:10 AM
                                                                                                                                                                                                bef51350-0a28-4c6f-b7a7-6da8024ac0c2.xls
                                                                                         Kwok Lau
                                                                                  Arturo Camacho
                                                                                     klau@ufl.edu
BUDGET:                   AUG        SEP      OCT      NOV      DEC        JAN     Assignment #3
Bank Balance                    4444 4370.951 5754.331 6616.743 7573.151    8419.707
INCOME:                            0        0        0        0        0           0
Gross Wages                      578     2944     2944 3138.598 3138.598    3138.598
LESS: Income Tax           104.7336 533.4528 533.4528 568.714 568.714        568.714
       Social Security     6.315436 32.1672 32.1672 34.29346 34.29346       34.29346
       Comic Relief                0        0        0        0 66.85215    66.85215
NET WAGES:                  466.951 2378.38 2378.38 2535.591 2468.739       2468.739
Bonus/Extras                     212      265      214      232      247         189
TOTAL INC0ME:                    790     3209     3158 3370.598 3385.598    3327.598
NET INCOME:                 678.951 2643.38 2592.38 2767.591 2715.739       2657.739
                         0         0        0        0        0        0           0
EXPENSES:                          0        0        0        0        0           0
Rent                             454      798      798 840.2142 840.2142    840.2142
Food                             145      178      189      201      255         264
Entertainment                     78      145      154      187      208         192
Credit Card Payment               35       59       67       64       58          71
Publications                      18       26       31       37       42          38
Transportation                    22       54       67       58       42          21
School Loan Payments               0        0 339.215 339.215 339.215        339.215
Car Loan Payments                  0        0 84.7534 84.7534 84.7534        84.7534
TOTAL EXPENSES:                  752     1260 1729.968 1811.183 1869.183    1850.183
BALANCE:                     -73.049 1383.38 862.4116 956.4083 846.5561     807.5561
                         0         0        0        0        0        0           0
BALANCE +BANK:             4370.951 5754.331 6616.743 7573.151 8419.707     9227.263




                                                                                       7/19/2011
                                                                                         2:10 AM
                                                        bef51350-0a28-4c6f-b7a7-6da8024ac0c2.xls
                                                             Kwok Lau
                                                      Arturo Camacho
                                                         klau@ufl.edu
AVERAGE       PERCENT                                  Assignment #3
 6196.480376 2.156448228
            0            0
 2646.965867    0.92117533
  479.630215    0.16691697
 28.92170197 0.010065093
 66.85214592 0.023265335
 2116.129901 0.736438155
        226.5   0.07882467
 2873.465867             1
 2342.629901 0.815262825
            0            0
            0            0
 761.7737667 0.492923653
 205.3333333 0.132865768
 160.6666667    0.10396315
          59 0.038177339
          32 0.020706353
          44 0.028471236
 339.2150199 0.219497066
 84.75340214 0.054841685
 1545.419381             1
 797.2105197 0.515853838
            0            0
 6993.690896             0




                                                            7/19/2011
                                                              2:10 AM
                             bef51350-0a28-4c6f-b7a7-6da8024ac0c2.xls

				
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
views:13
posted:7/19/2011
language:Swedish
pages:4