Explore BrainMass

Explore BrainMass

    Preparing A Personal Cash Budget

    This content was COPIED from BrainMass.com - View the original, and get the already-completed solution here!

    Donna and Sherman Terrel are preparing a budget for 2010. Donna is a systems analyst with an airplane manufacturer, and Sherman is working on a Master's degree in educational psychology. The Terrels do not have any children or other dependents. Donna estimates her salary will be about $45,600 in 2010; Sherman expects to work only during the summer months, doing painting and remodeling work for a building contractor. He anticipates an income from those activities of $3000 a month in June, July, and August. Sherman does have a scholarship that pays his tuition and also provides $3,600 a year of which $2400 is payable in February and $1200 is payable in October. The Terrels don't expect to have any other income in 2010.

    Donna and Sherman have listed their expected total expenses in 2010 as follows:

    Housing (rent)
    $8,640
    Transportation
    6,000
    Food (includes dining out)
    8,100
    Utilities
    3,000
    Payroll taxes:
    Donna
    13,200
    Sherman
    1,500
    Insurance:
    Life - payable in May
    720
    Auto - payable in January
    1,800
    Leisure and entertainment:
    Vacation in May
    1,800
    Clothing
    1,800
    Others
    $3,900
    Total Expenses
    $50,460

    The Terrels will begin 2010 with about $1,000 in liquid assets, and they prefer not to draw this balance below $600 at any time during the year.

    1. Prepare a monthly income and expense plan for the Terrels in 2010.
    2. On the basis of the plan you have just prepared, discuss the Terrels expected financial situation in 2010. Explain if you foresee any difficulties.
    3. During the quarter break in April, Sherman's employer landed a major remodeling project and asked for Sherman's help. Sherman agreed, and he expects to earn $1,500 from the job before taxes but probably won't receive a check until early June. Discuss how this unexpected event might affect the Terrels' activities and their budget for the balance of 2010. It is not necessary to prepare a revised monthly income and expense plan, but do refer to specific accounts and amounts (make appropriate assumptions) in your discussion .

    © BrainMass Inc. brainmass.com June 3, 2020, 11:11 pm ad1c9bdddf
    https://brainmass.com/business/cash-budgeting/preparing-a-personal-cash-budget-267451

    Solution Preview

    1: Please see the attached Excel 97-2003 spreadsheet.

    2. Based upon their expected cash inflow and outflow patterns, the Terrel's can expect to face liquidity problems in January ...

    Solution Summary

    Using an Excel spreadsheet, this solution illustrates how to prepare a personal cash budget. Additionally, in 115 words, this solution prepares two responses analyzing different aspects of this cash budget.

    $2.19

    ADVERTISEMENT