Personal Finance

Donna and Sherman Terrel are preparing a budget for 2003. 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 $39,996 in 2003; 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 2003.

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

Housing (rent) $6,600
Transportation 5100
Food (includes dining out) 8100
Utilities 3000
Payroll taxes:
Donna
12,000
Sherman
1500
Insurance:
Life - payable in May
720
Auto - payable in January
1,500
Leisure and entertainment:
Vacation in May
1,200
All others
1,800
Clothing 1,500
Others $3,900
Total Expenses $46,920

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

What are the difficulties to this plan?
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 2003.

Can someone help me on these two questions. I can e-mail you the plan I made if it helps.

Donna and Sherman Terrel are preparing a budget for 2003. 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 $39,996 in 2003; 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 2003.

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

Housing (rent) $6,600
Transportation 5100
Food (includes dining out) 8100
Utilities 3000
Payroll taxes:
Donna
12,000
Sherman
1500
Insurance:
Life - payable in May
720
Auto - payable in January
1,500
Leisure and entertainment:
Vacation in May
1,200
All others
1,800
Clothing 1,500
Others $3,900
Total Expenses $46,920

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

Prepare a monthly income and expense plan for the Terrels in 2003.
On the basis of the plan you have just prepared, discuss the Terrels expected financial situation in 2003. Explain if you foresee any difficulties.
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 2003. 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

  1. 👍
  2. 👎
  3. 👁
  1. An excel spreadsheet would be very helpful for this kind of problem.
    Set up a month-by-month income, expenditure, and net savings rows. See if problems arise.

    1. 👍
    2. 👎

Respond to this Question

First Name

Your Response

Similar Questions

  1. Math *fractions*

    Barbara, Donna, Cindy, and Nicole ran in a relay race. Barbara: 3 3/10 Donna: 2 4/5 Cindy: 3 2/5 Nicole: 2 1/10 1. The four girls ran in a relay race as a team. If each girl ran one part of the race, what was the team's total

  2. Math (fractions)

    I am not being lazy, I've tried to get this done several times, but I am VERY bad when it comes to fractions. Barbara, Donna, Cindy, and Nicole ran in a relay race. Barbara: 3 3/10 Donna: 2 4/5 Cindy: 3 2/5 Nicole: 2 1/10 1. The

  3. Math

    Donna will donate up to $460 to charity. The money will be divided between two charities: the City Youth Fund and the Educational Growth Foundation. Donna would like to donate at least $160 to the Educational Growth Foundation.

  4. Mathematics

    Donna deposits $275 into her savings account. She leaves the money in her account, untouched, for 6 years. If the account earns 4.5% simple interest each year, how much simple interest will she have earned by the end of the sixth

  1. Calculus

    The following table shows the percentage of the U.S. Discretionary Budget allocated to education in 2003, 2005, and 2009 (t=0 represents 2000) Year t 3 5 9 Percentage p(t) 6.8 7 6.2 (a) Compute and interpret the average rate of

  2. ALGEBRA

    Donna and Pat bought a used car together for 450. If Donna paid $110 more than Pat,how much did each pay?

  3. Science

    How are the respiratory and circulatory and respiratory systems similar? A) Both systems provide glucose and other substances to cells. B) Both systems regulate blood flow throughout the body. C) Both systems help remove carbon

  4. Chemistry

    Two analysts each made six determinations of the paracetamol content of the same batch of tablets. The results are shown below: Analyst Paracetamol content % (m/m) A 84.32 84.51 84.63 84.61 84.64 84.51 B 84.24 84.25 84.41 84.13

  1. Finance

    A financial analyst tells you that investing in stocks will allow you to triple your money in 15 years. What annual rate of return is the analyst assuming you can earn?

  2. math

    donna took 3hours to row 18 km upstream. her return trip took 1 hour less. find the rate of rowing in still water and the rate of the current. let the speed of her rowing in still water be x km/h, let the speed of the current be y

  3. math

    - Juwan and Jake both have money in their pockets. If Juwan gave Jake 15 cent then they both would have the same amount of money. However, if Jake gave Juwan 15 cent , then Juwan would have 5 times as much money as Jake would

  4. algebra

    Donna must choose a number between and that is a multiple of , , and . Write all the numbers that she could choose. If there is more than one number, separate them with commas.

You can view more similar questions or ask a new question.