Scribd Logo
Upload

Welcome to Scribd!

  • 53 views

    Suarez Jesus Excelmastery

    Uploaded by

    api-377100980
    The document is a monthly budget worksheet tracking income and expenses over a 12 month period for a household of 5 people. Total income for the year was $52,992 while total expenses were $78,080, resulting in no savings. The largest expenses were $7,800 for groceries and $8,700 for the mortgage.

    Copyright:

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

    Suarez Jesus Excelmastery

    Uploaded by

    api-377100980
    53 views12 pages
    The document is a monthly budget worksheet tracking income and expenses over a 12 month period for a household of 5 people. Total income for the year was $52,992 while total expenses were $78,080, resulting in no savings. The largest expenses were $7,800 for groceries and $8,700 for the mortgage.

    Original Title

    suarez jesus excelmastery

    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 is a monthly budget worksheet tracking income and expenses over a 12 month period for a household of 5 people. Total income for the year was $52,992 while total expenses were $78,080, resulting in no savings. The largest expenses were $7,800 for groceries and $8,700 for the mortgage.

    Copyright:

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

    Suarez Jesus Excelmastery

    Uploaded by

    api-377100980
    The document is a monthly budget worksheet tracking income and expenses over a 12 month period for a household of 5 people. Total income for the year was $52,992 while total expenses were $78,080, resulting in no savings. The largest expenses were $7,800 for groceries and $8,700 for the mortgage.

    Copyright:

    © All Rights Reserved
    Download as XLSX, PDF, TXT or read online from Scribd
    Download as xlsx, pdf, or txt
    You are on page 1of 12

    Budget W

    Number of membe

    Actual Jan Actual Feb Actual Mar


    Income
    Wages $4,416.00 ### ### ###
    Gifts $50.00 $50.00 $0.00 $0.00
    Allowance $10.00 $10.00 $10.00 $10.00
    Other $50.00 $0.00 $0.00 $50.00
    TOTAL Income $4,526.00
    Expenses
    Charitable giving
    Faith organization

    Community organization
    Mortgage $725.00 $725.00 $725.00 $725.00
    TOTAL Charitable giving $725.00
    Transportation
    Car payment
    Car insurance
    Gas $144.00 $144.00 $144.00 $144.00
    Car maintenance/repairs
    Other $10.00 $10.00 $10.00 $10.00
    TOTAL Transportation $154.00
    Communication
    Cell phone monthly plan $73.00 $73.00 $73.00 $73.00
    Internet $120.00 $120.00 $120.00 $120.00
    Other $20.00 $20.00 $20.00 $20.00
    TOTAL Communication $213.00
    Monthly Expenses
    Gas Bill $60.00 $60.00 $60.00 $60.00
    Electric Bill $100.00 $100.00 $100.00 $100.00
    Water Bill $30.00 $30.00 $30.00 $30.00
    TV $14.00 $14.00 $14.00 $14.00
    Dining Out $30.00 $30.00 $30.00 $30.00
    Other $10.00 $10.00 $10.00 $10.00
    TOTAL Entertainment $244.00
    Personal Expenses
    Personal products $20.00 $20.00 $20.00 $20.00
    Clothing $100.00 $100.00 $100.00 $100.00
    Salon services $25.00 $25.00 $25.00 $25.00
    Other $10.00 $10.00 $10.00 $10.00
    TOTAL Personal Expenses $155.00
    Food/household expenses
    Groceries $650.00 $650.00 $650.00 $650.00
    Other $15.00 $15.00 $15.00 $15.00
    TOTAL Food/household expenses $665.00
    Gifts
    For friends $50.00 $50.00 $50.00 $50.00
    For family $100.00 $100.00 $100.00 $100.00
    TOTAL Gifts $150.00
    TOTAL Expenses
    Savings
    Long term goals
    Car
    Other
    TOTAL Long term goals
    Short term goals
    Vacation 2136 $164.00 $164.00 $164.00 $164.00
    Other
    TOTAL Short term goals
    TOTAL Savings
    TOTAL BUDGET
    Budget Worksheet
    Number of members in your household = 5
    Actual Actual Actual
    Actual Apr May June Actual July Actual Aug Sept Actual Oct Actual Nov

    ### ### ### ### ### ### ### ###


    $0.00 $0.00 $0.00 $50.00 $0.00 $0.00 $0.00 $0.00
    $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00
    $0.00 $50.00 $0.00 $0.00 $0.00 $0.00 $0.00 $0.00

    $725.00 $725.00 $725.00 $725.00 $725.00 $725.00 $725.00 $725.00


    $144.00 $144.00 $144.00 $144.00 $144.00 $144.00 $144.00 $144.00

    $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00

    $73.00 $73.00 $73.00 $73.00 $73.00 $73.00 $73.00 $73.00


    $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00 $120.00
    $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00

    $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00 $60.00


    $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
    $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
    $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00 $14.00
    $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00 $30.00
    $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00

    $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00 $20.00


    $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00
    $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00 $25.00
    $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00 $10.00

    $650.00 $650.00 $650.00 $650.00 $650.00 $650.00 $650.00 $650.00


    $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00 $15.00

    $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00 $50.00


    $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00 $100.00

    $164.00 $164.00 $164.00 $164.00 $164.00 $164.00 $164.00 $164.00


    Actual Dec Annual Total

    ### $52,992.00
    $0.00 $100.00
    $10.00 $120.00
    $0.00 $100.00

    $725.00 $8,700.00
    $144.00 $1,728.00

    $10.00 $120.00
    $1,848.00

    $73.00
    $120.00
    $20.00

    $60.00 $720.00
    $100.00 $1,200.00
    $30.00 $360.00
    $14.00 $168.00
    $30.00 $360.00
    $10.00 $120.00
    $2,928.00

    $20.00 $240.00
    $100.00 $1,200.00
    $25.00 $300.00
    $10.00 $120.00
    $1,860.00

    $650.00 $7,800.00
    $15.00 $180.00
    $7,980.00

    $50.00 $600.00
    $100.00 $1,200.00
    $1,800.00

    $164.00 $2,132.00
    $78,080.00

    You might also like