Income and Expense Example: Monthly Personal Budget (Excel)
Not what you're looking for?
Details: 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 provides an example of an income and expense report (in Excel) in the form of a monthly budget. This solution addresses irregular income, non-monthly expenses, liquid assets (savings) and budget balancing.
Solution Preview
Attached you will find a spreadsheet with two workbooks: 1- Monthly budget and 2- calculations (used to get monthly figures).
You will need to reformat this document to meet your teacher's requirements based on the prior week's readings.
The Terrels will end 2010 positively with a $5,540 balance, however due to Sherman's inconsistent income and periodic large buckets of spending, there are some periods were they are negative. The Terrels start the year negatively driven by the large Auto payment (and no income from Sherman). They will need to access and utilize all of the liquid assets in January and will still be negative $795. They can return the liquid assets in February as they will receive ...
Purchase this Solution
Free BrainMass Quizzes
Paradigms and Frameworks of Management Research
This quiz evaluates your understanding of the paradigm-based and epistimological frameworks of research. It is intended for advanced students.
Lean your Process
This quiz will help you understand the basic concepts of Lean.
Balance Sheet
The Fundamental Classified Balance Sheet. What to know to make it easy.
Marketing Research and Forecasting
The following quiz will assess your ability to identify steps in the marketing research process. Understanding this information will provide fundamental knowledge related to marketing research.
Organizational Leadership Quiz
This quiz prepares a person to do well when it comes to studying organizational leadership in their studies.