Scribd Logo
Upload

Welcome to Scribd!

  • 13 views

    Personal Budget Worksheet: Income January February March April May June July

    Uploaded by

    Jake
    The document outlines a personal budget worksheet estimating monthly income and expenses over a 12 month period. Total estimated income for the year is $20,004.98 with the largest sources being wages of $12,003.48 and dividends of $8,001.50. Total estimated expenses are $18,018.16 with the largest being rent of $4,810.68, food of $3,600, and tuition of $3,000. The net balance ranges from a surplus of $3,845.36 to a deficit of $2,155.39 month-to-month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd

    Personal Budget Worksheet: Income January February March April May June July

    Uploaded by

    Jake
    13 views3 pages
    The document outlines a personal budget worksheet estimating monthly income and expenses over a 12 month period. Total estimated income for the year is $20,004.98 with the largest sources being wages of $12,003.48 and dividends of $8,001.50. Total estimated expenses are $18,018.16 with the largest being rent of $4,810.68, food of $3,600, and tuition of $3,000. The net balance ranges from a surplus of $3,845.36 to a deficit of $2,155.39 month-to-month.

    Original Title

    280073321-Excel-Chapter-1-Complete.xlsx

    Copyright

    © © All Rights Reserved

    Available Formats

    XLSX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    The document outlines a personal budget worksheet estimating monthly income and expenses over a 12 month period. Total estimated income for the year is $20,004.98 with the largest sources being wages of $12,003.48 and dividends of $8,001.50. Total estimated expenses are $18,018.16 with the largest being rent of $4,810.68, food of $3,600, and tuition of $3,000. The net balance ranges from a surplus of $3,845.36 to a deficit of $2,155.39 month-to-month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    13 views3 pages

    Personal Budget Worksheet: Income January February March April May June July

    Uploaded by

    Jake
    The document outlines a personal budget worksheet estimating monthly income and expenses over a 12 month period. Total estimated income for the year is $20,004.98 with the largest sources being wages of $12,003.48 and dividends of $8,001.50. Total estimated expenses are $18,018.16 with the largest being rent of $4,810.68, food of $3,600, and tuition of $3,000. The net balance ranges from a surplus of $3,845.36 to a deficit of $2,155.39 month-to-month.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    of 3

    Personal Budget Workshe

    Monthly Estimates
    Income January February March April May June July
    Wages $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29
    Dividends 4,000.75 - - - - - -
    Total $ 5,001.04 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29

    Expenses January February March April May June July


    Rent $ 400.89 $ 400.89 $ 400.89 $ 400.89 $ 400.89 $ 400.89 $ 400.89
    Food 300.00 300.00 300.00 300.00 300.00 300.00 300.00
    Tuition 1,500.00 - - - - - -
    Books 500.00 - - - - - -
    Entertainment 100.00 100.00 100.00 100.00 100.00 100.00 100.00
    Car Payment 154.79 154.79 154.79 154.79 154.79 154.79 154.79
    Gas 100.00 100.00 100.00 100.00 150.00 150.00 150.00
    Miscellaneous 100.00 100.00 100.00 100.00 100.00 100.00 100.00
    Total $ 3,155.68 $ 1,155.68 $ 1,155.68 $ 1,155.68 $ 1,205.68 $ 1,205.68 $ 1,205.68

    Net $ 1,845.36 $ (155.39) $ (155.39) $ (155.39) $ (205.39) $ (205.39) $ (205.39)


    dget Worksheet
    y Estimates
    August September October November December Total
    $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 12,003.48
    - 4,000.75 - - - 8,001.50
    $ 1,000.29 $ 5,001.04 $ 1,000.29 $ 1,000.29 $ 1,000.29 $ 20,004.98

    August September October November December Total


    $ 400.89 $ 400.89 $ 400.89 $ 400.89 $ 400.89 $ 4,810.68
    300.00 300.00 300.00 300.00 300.00 3,600.00
    1,500.00 - - - - 3,000.00
    500.00 - - - - 1,000.00
    100.00 100.00 100.00 100.00 100.00 1,200.00
    154.79 154.79 154.79 154.79 154.79 1,857.48
    100.00 100.00 100.00 100.00 100.00 1,350.00
    100.00 100.00 100.00 100.00 100.00 1,200.00
    $ 3,155.68 $ 1,155.68 $ 1,155.68 $ 1,155.68 $ 1,155.68 $ 18,018.16

    $ (2,155.39) $ 3,845.36 $ (155.39) $ (155.39) $ (155.39) $ 1,986.82


    Monthly Expenses

    6.66%
    7.49%
    26.70%

    10.31% Rent
    Food
    Tuition
    Books
    6.66% Enterta inment
    Ca r Payment
    Ga s
    5.55% Mis cella neous
    19.98%

    16.65%

    You might also like