Make a monthly income and expense plan

Assignment Help Finance Basics
Reference no: EM1352290

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.

Reference no: EM1352290

Questions Cloud

Concepts in organizational behavior : Describe why these challenges are significant to these two organizations - Concepts in Organizational Behavior
What is an angular frequency in of the combination : They then turn together around the spindle with their centers superposed. What is an angular frequency in of the combination.
Natural and open systems organizational paradigms : Organizational Paradigms - Could you please compare and contrast the rational, natural and open systems organizational paradigms?
Global promotional strategies : What are the advantages and disadvantages of global promotional strategies? How would you address some disadvantages or challenges?
Make a monthly income and expense plan : Donna and Sherman Terrel are preparing a budget for 2010. Donna is a systems analyst with an airplane producer, and Sherman is working on a master's degree in educational psychology.
Probability line is executed in nth iteration of for loop : What is the probability that line is executed during the nth iteration of the for loop? What is the exact expected number of executions of line?
What is the angle of incidence of the light entering second : suppose that visible light enters a Plexiglas cube containing water at a 20o angle of incidence, travels through the water and exits the cube.
Elucidate how a temporary decrease in the us money supply : Elucidate how a temporary decrease in the U.S. money supply affects the money and FOREX markets. Label your short-run equilibrium point B and your long-run equilibrium point.
Determine the planning function of management : Question about WorldCom - Determine the planning function of management.

Reviews

Write a Review

Finance Basics Questions & Answers

  Computation of the interest on the loan payable in due

Computation of the interest on the loan payable in due and in advance and What will be the face value of the note assuming that Interest paid when the loan is due

  What is the total annual cost of operating

Assume the firm could earn 10 percent on short term investments; further assume 260 working days, and hence 260 transfers from each lockbox location per year. What is the total annual cost of operating the lockbox system?

  Find what is sales revenue under the worst case scenario

The sales price is estimated at $750 per unit, plus or minus 3 percent and find what is the sales revenue under the worst case scenario?

  Equity financing and debt financing

Explain, using examples, the differences between equity financing and debt financing. Name two types of long-term debt financing and list the relative advantages and disadvantages (to the borrower) of each.

  Expected effective financing rate

Suppose the U.S. interest rate is 7.5%, the New Zealand interest rate is 6.5%, the spot rate of NZ$ is $.52, and the one year forward rate of the NZ$ is $.50. At the end of the year, the spot rate is $.48. Based on this information, what is the ef..

  Information about market structure

Select one of the market structures (monopoly, oligopoly, monopolistic competition, or perfect competition) and identify a company for that market structure.

  Computing present value of a lump-sum

Use present value table to find out the amount of cash that Mr. Gulliver's father should give him. Use algebraic formula to prove that the present value of trust fund (the amount of cash computed in requirement a) is equal to its $60,000 future val..

  Finding present and future values

Find out the future value of investment after one year if it earns 10% per year? What is the present value of this future value discounted at 10%?

  Calculate the present value of a deposit

How much would you have to invest today to receive:

  Financial analysis

Use Microsoft Excel to chart the historical prices (like the one below) based on the monthly data.

  Change in the nature of the chicken contracts

What happened that changed the nature of the chicken contracts.

  Calculate annual rental payment

The Borstal firm has to choose between 2 machines that do the same job but have different lives. The 2 machines have the following costs:

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd