Preparation of cash budget Sam and Suzy Sizeman need to prepare a cash budget for the...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Preparation of cash budget Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2016 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 nor- mally run 5% of monthly take-home pay). The information in the following table can be used to create their fourth-quarter budget for 2016. Income Monthly take-home pay Expenses Housing Utilities $4,900 30% 5% Food 10% Transportation 7% Medical/dental .5% Clothing for October and November Clothing for December Property taxes (November only) Appliances 3% $440 11.5% 1% Personal care 2% Entertainment for October and November 6% Entertainment for December $1,500 Savings Other 7.5% 5% Excess cash 4.5% a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016? Preparation of cash budget Sam and Suzy Sizeman need to prepare a cash budget for the last quarter of 2016 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 nor- mally run 5% of monthly take-home pay). The information in the following table can be used to create their fourth-quarter budget for 2016. Income Monthly take-home pay Expenses Housing Utilities $4,900 30% 5% Food 10% Transportation 7% Medical/dental .5% Clothing for October and November Clothing for December Property taxes (November only) Appliances 3% $440 11.5% 1% Personal care 2% Entertainment for October and November 6% Entertainment for December $1,500 Savings Other 7.5% 5% Excess cash 4.5% a. Prepare a quarterly cash budget for Sam and Suzy covering the months October through December 2016. b. Are there individual months that incur a deficit? c. What is the cumulative cash surplus or deficit by the end of December 2016?
Expert Answer:
Answer rating: 100% (QA)
Cash budget is the budget that prepares to estimate the expected rec... View the full answer
Related Book For
Posted Date:
Students also viewed these accounting questions
-
Financial information related to Abbys Interiors for October and November of 2013 is as follows: a. Prepare balance sheets for Abbys Interiors as of October 31 and November 30, 2013. b. Determine the...
-
Financial information related to Montana Interiors for October and November 20Y8 is as follows: a. Prepare balance sheets for Montana Interiors as of October 31 and as of November 30, 20Y8. b....
-
Financial information related to Abby's Interiors for October and November of 20Y6 is as follows: a. Prepare balance sheets for Abby's Interiors as of October 31 and November 30, 20Y6. b. Determine...
-
Posting the entries from the sales journal to the accounts receivable subsidiary ledger should be done ______. a). at the end of each month b). on a weekly basis c). on a daily basis d). only at the...
-
Using the same information as the previous question, draw payoff and profit diagrams for a short position in the stock. Verify that profit is 0 at a price in 1 year of $55. Discuss.
-
Absolute Corporation currently has $50 million in liabilities and common equity in combination. The firm has no preferred stock. After careful evaluation, the CFO constructed the following table to...
-
How can the auditor estimate the expected popu!ation occurrence rate?
-
The Scent of Money makes three products that can be sold at split-off or processed further and then sold. The joint cost for April 2010 is $1,080,000. The number of ounces in a bottle of each product...
-
The following information pertains to Mason Company for Year 2. Beginning inventory Units purchased 160 units @ $52 446 units $78 Ending inventory consisted of 64 units. Mason sold 542 units at $156...
-
Forrest runs Y Not Flowers, Inc. (YNF), a wholesale flower distributor with stores in several major metropolitan areas of the U.S. He is considering expanding his business, but he thinks his current...
-
Alfred, married with 2 children, is a concreter, whom the ATO happened to audit. In the tax year in question Alfred had declared taxable income of $21,000. Alfred had also taken the family back to...
-
How would you determine if a firm has too many brands?
-
The sixth formers at the Broadway School run a tuck shop business. They began trading on 1 December 2012 and sell two types of chocolate bar, Break and Brunch. Their starting capital was a 200 loan...
-
The data which follows was extracted from the books of account of H. Kirk, an engineer, on 31 March 2012, his financial year end. (a) Purchase of extra milling machine (includes 300 for repair of an...
-
What is the difference between a simple hypothesis and a composite hypothesis? Why might economists choose one over another?
-
Consider a hypothetical three-stage screening test for a cancer with the following rates of detection and costs: (a) Calculate the average cost per cancer detected in the three stages. (b) Calculate...
-
What sophisticated considerations are required to go beyond the simple partitioning of data into tables and delve into the intricacies of normalization?
-
Avatar Financials, Inc., located on Madison Avenue, New York City, is a company that provides financial advice to individuals and small- to mid-sized businesses. Its primary operations are in wealth...
-
The charges to Work in ProcessBaking Department for a period as well as information concerning production are as follows. The Baking Department uses the weighted average cost method, and all direct...
-
The following data were summarized from the accounting records for Statham Construction Company for the year ended November 30, 2012. Prepare divisional income statements for Statham...
-
Rehab Physical Therapy Inc. is planning its cash payments for operations for the second quarter (MarchMay), 2013. The Accrued Expenses Payable balance on March 1 is $36,000. The budgeted expenses for...
-
Explain the procedure for drawing Mohrs circle under complex stresses.
-
Derive and expression for principal stresses in a body subjected to complex state of stress.
-
Defined principal stresses and principal planes.
Study smarter with the SolutionInn App