What is the cumulative cash surplus or deficit by the end

Assignment Help Finance Basics
Reference no: EM131110856

Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2013 to make sure they can cover their expenditures during the period. Sam and Suzy have been preparing budgets for the past several years and have been able to establish specific percentages for most of their cash outflows. These percentages are based on their take-home pay (that is, monthly utilities normally run 5% of monthly take-home pay). The information in the following table can be used to create their fourth-quarter budget for 2013.

1065_3.jpg

a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2013.

b. Are there individual months that incur a deficit?

c. What is the cumulative cash surplus or deficit by the end of December2013?

Reference no: EM131110856

Questions Cloud

Explain how the percent of sales method could result : Use the percent-of-sales method, the income statement for December 31, 2012, and the sales revenue estimates to develop pessimistic, most likely, and optimistic pro forma income statements for the coming year. Explain how the percent-of-sales method ..
Compare and contrast the statements developed : Use the percent-of-sales method to prepare a pro forma income statement for the year ended December 31, 2013. Use fixed and variable cost data to develop a pro forma income statement for the year ended December 31, 2013. Compare and contrast the stat..
Discuss how knowledge of the timing and amounts involved : Prepare a scenario analysis of Trotter's cash budget using -$20,000 as the beginning cash balance for October and a minimum required cash balance of $18,000. Use the analysis prepared in part a to predict Trotter's financing needs and investment oppo..
Check statements that will be affected immediately : The following represent financial transactions that Johnsfield & Co. will be undertaking in the next planning period. For each transaction, check the statement or statements that will be affected immediately.
What is the cumulative cash surplus or deficit by the end : Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2013. Are there individual months that incur a deficit? What is the cumulative cash surplus or deficit by the end of December2013?
Prepare and interpret a cash budget for the months of may : he firm has a cash balance of $5,000 on May 1 and wishes to maintain a minimum cash balance of $5,000. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. The firm makes 20% of sales for cash, 60% are ..
Cash disbursement schedule for the months of april : Maris Brothers, Inc., needs a cash disbursement schedule for the months of April, May, and June. Use the format of Table 4.9 (on page 130) and the following information in its preparation.
Explain the impact that depreciation : Use the relevant data to determine the operating cash flow (see Equation 4.2) for the current year. Explain the impact that depreciation, as well as any other noncash charges, has on a firm's cash flows.
What amount should be reported ascash : Kraft Enterprises owns the following assets at December 31, 2010. What amount should be reported ascash?

Reviews

Write a Review

Finance Basics Questions & Answers

  How many shares will be outstanding after the dividend

Assume the company issues a 10 percent stock dividend. How many shares will be outstanding after the dividend?

  Foreign projects

Foreign Projects

  At what rate of interest would you need to invest

At what rate of interest would you need to invest in order for a savings of $20,000 per year to be worth one million dollars after 25 years?

  Determine key reasons why a multinational corporation

Determine key reasons why a multinational corporation

  What do you think about the dilemma facing mark miller

what do you think about the dilemma facing mark miller? Does this case present an ethical issue? if so, to which party or parties? if you could act as the ultimate authority in this situation, what would you do?

  Evaluation of projected balance sheet

Calculation of Projected Balance Sheet - If the bank decided to require the company to maintain a current ratio of 2.0 as a condition of its loan, how will the projected balance sheet for 1992 change?

  What would the future and present values

What would the future and present values be if it was an annuity due?

  How much money will you need to have saved up in your 401k

how much money will you need to have saved up in your 401k plan at the begining of your retirement so that you can

  Create a line graph of the actual and predicted percentage

1.allow the user to input the current price of the bond as a percentage of par with 3 decimal places usewhole numbers

  Maintenance and bottling costs are paid at the end of each

Purchase a new, more advanced machine for $250,000. This machine will require $15,000 per year in ongoing maintenance expenses and will lower bottling costs by $10,000 per year.

  Determine the net present value of the laser

Determine the Net present Value of a machine that takes little plastic boxes to hold a variety of playing cards. The machine requires an initial investment of $750,000 and will return $200,000 in cash flow per year for exactly five years. The rele..

  Determine how the firm is financing investment in assets lon

The discussion activity for Module 4 entails visiting a firm's Web site, reviewing its balance sheet, and reporting on how the firm is financing investments in assets: preferred stock, common stock, and long-term debt. Here are the steps to follow: C..

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