Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: June July August Sales Manufacturing costs Selling and administrative expenses Capital expenditures $160,000 $185,000 $200,000 66,000 82,000 105,000 40,000 46,000 51,000 120,000 < The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of $42,000, marketable securities of $25,000, and accounts receivable of $198,000 ($150,000 from May sales and $48,000 from April sales). Sales on account in April and May were $120,000 and $150,000, respectively. Current liabilities as of June 1 include $13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $24,000 will be made in July. Mercury Shoes' regular quarterly dividend of $15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of $40,000. Required: 1. Prepare a monthly cash budget and supporting schedules for June, July, and August. Mercury Shoes Inc. Cash Budget For the Three Months Ending August 31 Line Item Description Estimated cash receipts from: Total cash receipts Less estimated cash payments for: June July August Cash budget The controller of Mercury Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: June July August Sales Manufacturing costs Selling and administrative expenses Capital expenditures $160,000 $185,000 $200,000 66,000 82,000 105,000 40,000 46,000 51,000 120,000 < The company expects to sell about 10% of its merchandise for cash. Of sales on account, 60% are expected to be collected in the month following the sale and the remainder the following month (second month after sale). Depreciation, insurance, and property tax expense represent $12,000 of the estimated monthly manufacturing costs. The annual insurance premium is paid in February, and the annual property taxes are paid in November. Of the remainder of the manufacturing costs, 80% are expected to be paid in the month in which they are incurred and the balance in the following month. Current assets as of June 1 include cash of $42,000, marketable securities of $25,000, and accounts receivable of $198,000 ($150,000 from May sales and $48,000 from April sales). Sales on account in April and May were $120,000 and $150,000, respectively. Current liabilities as of June 1 include $13,000 of accounts payable incurred in May for manufacturing costs. All selling and administrative expenses are paid in cash in the period they are incurred. An estimated income tax payment of $24,000 will be made in July. Mercury Shoes' regular quarterly dividend of $15,000 is expected to be declared in July and paid in August. Management desires to maintain a minimum cash balance of $40,000. Required: 1. Prepare a monthly cash budget and supporting schedules for June, July, and August. Mercury Shoes Inc. Cash Budget For the Three Months Ending August 31 Line Item Description Estimated cash receipts from: Total cash receipts Less estimated cash payments for: June July August
Expert Answer:
Related Book For
Financial and Managerial Accounting
ISBN: 978-1285078571
12th edition
Authors: Carl S. Warren, James M. Reeve, Jonathan Duchac
Posted Date:
Students also viewed these accounting questions
-
The controller of Dash Shoes Inc. instructs you to prepare a monthly cash budget for the next three months. You are presented with the following budget information: The company expects to sell about...
-
1. If net profit is $47,025; depreciation is $2,200; accounts receivable increases $5,056; accounts payable increases $4,673; and inventory declines $850; what is the operating cash flow for the...
-
Options listed for Krispy Kreme were used in the text as an example of option price estimation using implicit variance. The implicit variance from the August 35 option resulted in estimated call...
-
Which of the following is not a feature that Access uses to demonstrate and leverage the power of one-to-many relationships? a. Subdatasheets b. Lookup properties c. Automatically refreshing related...
-
When the University of Maryland Medical System Corporation learned that one of its surgeons was HIV positive, the university offered him transfers to positions that did not involve surgery. The...
-
Starlite Company manufactures office products. Last year, it sold 45,000 electric staplers for $10 per unit. The company estimates that this volume represents a 30 percent share of the current...
-
16. The area (in sq. units) of the part of the circle x + y=36, which is outside the parabola y = 9x is: (a) 24+33 (b) 24-33 (c) 12+33 (d) 12-33
-
Mound Company expects to sell 90000 units annually of a new product at 15 Unit variable cost is 9 To make the product Mound needs machinery costing 600000 The machinery has a 10year life with no...
-
The CFO of Amazon.com Inc. is thinking of borrowing Japanese yen because of its low interest rate, currently at 1%. The current interest rate on U.S. dollars is 3%. What is your advice to the CFO?
-
Suppose Lufthansa buys $400 million worth of Boeing jets in 2018 and is financed by the U.S. Eximbank with a five-year loan that has no principal or interest payments due until 2019. What is the net...
-
Carrier Air Conditioner, a division of United Technologies, is thinking of shifting virtually all the labor-intensive portion of its production from Indiana to Mexico. What risks is Carrier likely to...
-
In early 2018, the short-term interest rate in the Japan was 0.1%, and forecast Japanese inflation was 1.2%. At the same time, the short-term South Korean interest rate was 1.68% and forecast South...
-
Lothar Drake wishes to estimate the value of an asset expected to provide cash inflows of $4,000 at the end of years 1 and 2, $5,000 at the end of years 3 and 4, and $4,500 at the end of year 5. His...
-
Write the Triangular Arbitrage Suppose you are given the following three quotes: BankQuote Citibank...$2.0/ UBSSF 1.20/$ Deutsche Bank.SF 2.5/ 1) Is there any opportunity to make risk-free profit?...
-
Several months have passed and the Managing Partner approved and properly filed the Complaint and properly submitted the Request for Production of Documents that you drafted. In fact, it has been 75...
-
The treatment of outflows on account of dividend and interest is highly debatable as to their activity classification. Give a serious thought to the issue and express your opinion about the best...
-
Consider the same setting as Problem 18, but suppose instead 80% of the shareholders redeem their shares, and no warrants are exercised. Data from problem 18 a. What is the amount of cash per share...
-
Form a small group. Concentrate on BSE Sensex companies and compile the voluntary disclosures made by each of them. Draft a crisp research paper highlighting your findings and use thereof to various...
Study smarter with the SolutionInn App