Purchase Solution

Prepare a Monthly Income and Expense Plan

Not what you're looking for?

Ask Custom Question

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) 9,000
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
2,100
Clothing 1,800
Others $3,900
Total Expenses $51,640

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.

Prepare a monthly income and expense plan for the Terrels in 2010 (be sure to do the readings for the week prior to creating this plan). Also, total the income and expenses to determine their financial standing at the end of each month.
On the basis of the plan you have just prepared, discuss the Terrels expected financial situation in 2010. Explain if you foresee any difficulties, and suggest alternatives to correct them.
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.

Purchase this Solution

Solution Summary

This solution prepares a monthly income and expense plan for this case in an attached Excel file. A discussion is included in a second tab in the same Excel file. One student commented that they did not receive that attachment, but it is included.

Purchase this Solution


Free BrainMass Quizzes
Basics of corporate finance

These questions will test you on your knowledge of finance.

Income Streams

In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.

Motivation

This tests some key elements of major motivation theories.

Cost Concepts: Analyzing Costs in Managerial Accounting

This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.

Understanding Management

This quiz will help you understand the dimensions of employee diversity as well as how to manage a culturally diverse workforce.