Cash budget-Basic Grenoble Enterprises had sales of $50,100 in March and $60,300 in April. Forecast sales...
Fantastic news! We've Found the answer you've been seeking!
Question:
Transcribed Image Text:
Cash budget-Basic Grenoble Enterprises had sales of $50,100 in March and $60,300 in April. Forecast sales for May, June, and July are $70,400, $80,400, and $100,200, respectively. The firm has a cash balance of $5,100 on May 1 and wishes to maintain a minimum cash balance of $5,100. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 17% of sales for cash, 58% are collected in the next month, and the remaining 25% are collected in the second month following sale. (2) The firm receives other income of $2,300 per month. (3) The firm's actual or expected purchases, all made for cash, are $50,500, $69,500, and $79,500 for the months of May through July, respectively. (4) Rent is $3,200 per month. (5) Wages and salaries are 10% of the previous month's sales. (6) Cash dividends of $2,600 will be paid in June. (7) Payment of principal and interest of $3,500 is due in June. (8) A cash purchase of equipment costing $5,500 is scheduled in July. (9) Taxes of $6,400 are due in June. Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar. Please input all the values in the table before checking your answers.) April 60,300 $ 10,251 $ $ Sales Cash sales Lag 1 month Lag 2 months Other income Total cash receipts $ March 50,100 $ 8,517 SA May 70,400 Cash budget-Basic Grenoble Enterprises had sales of $50,100 in March and $60,300 in April. Forecast sales for May, June, and July are $70,400, $80,400, and $100,200, respectively. The firm has a cash balance of $5,100 on May 1 and wishes to maintain a minimum cash balance of $5,100. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 17% of sales for cash, 58% are collected in the next month, and the remaining 25% are collected in the second month following sale. (2) The firm receives other income of $2,300 per month. (3) The firm's actual or expected purchases, all made for cash, are $50,500, $69,500, and $79,500 for the months of May through July, respectively. (4) Rent is $3,200 per month. (5) Wages and salaries are 10% of the previous month's sales. (6) Cash dividends of $2,600 will be paid in June. (7) Payment of principal and interest of $3,500 is due in June. (8) A cash purchase of equipment costing $5,500 is scheduled in July. (9) Taxes of $6,400 are due in June. Complete the first month of the cash budget for Grenoble Enterprises below: (Round to the nearest dollar. Please input all the values in the table before checking your answers.) April 60,300 $ 10,251 $ $ Sales Cash sales Lag 1 month Lag 2 months Other income Total cash receipts $ March 50,100 $ 8,517 SA May 70,400
Expert Answer:
Answer rating: 100% (QA)
cash budget Particular march april may Sales 50100 60300 70400 Cash sales 8517 ... View the full answer
Related Book For
Posted Date:
Students also viewed these finance questions
-
You're the vice president of a large company that makes outdoorfurniture for decks, patios, and pools. Each product line and the firm itself have grown substantially in recent years. Unfortunately,...
-
You are the marketing vice president of a large soft-drink company. Your companys advertising agency is in the process of negotiating a contract to employ a superstar female singer to promote your...
-
You are the portfolio manager of a large company that invests in many securities including corporate bonds. You have been assigned the task of bond portfolio management. You are provided with the...
-
Two experienced managers at Wilson Boat, Inc. are resisting the introduction of a computerized exponential smoothing system, claiming that their judgmental forecasts are much better than any computer...
-
A company pays its insurance policy for the calendar year of 78,000 on 1st January. On 31st March, what is the impact on the Income Statement, Balance Sheet and Cash Flow?
-
What are some common SITE challenges and issues?
-
Suppose Apex Electrical Supplys Inventory account showed a balance of \($43,000.\) A physical count showed \($41,800\) of goods on hand. To adjust the inventory account, Apex Electrical Supply, Inc.,...
-
Michelle Gutierrez, manager of the Components Division of FX Corporation, is considering a new investment for her division. The division has an investment base of $4,000,000 and operating income of...
-
Tibor is an investment manager who focuses on buying small to medium size companies that are listed on the NASDAQ exchange. He believes these companies will outperform in earnings. What type of...
-
Today is May 17, 2023, and you, CPA, are a Senior Tax Associate at Borden & Laurier LLP. Sylvie Condurache, Tax Manager, has called you into her office to discuss a long-time client: "I just got out...
-
Olter, Inc. is starting its risk management program for the company and has asked for your help in determining critical risk measurements for the firm. The company has identified several factors in...
-
True or False: When a firm repurchases its own shares, the price rises due to the decrease in the supply of shares outstanding.
-
With corporate taxes as the only market imperfection, how does the value of the firm with leverage differ from its value without leverage?
-
Do you believe that sustainable development should be part of an entrepreneurship course, or did the textbook authors just include a section on it to be politically correct?
-
What is the optimal dividend policy when the dividend tax rate exceeds the capital gains tax rate?
-
Interview three employees that have worked on projects that were terminated. Ask them how they felt about the project, how they felt after it was terminated, and how they feel today. How did they...
-
Day Vision Inc. produces sunglasses. The company uses $1.28 in materials and $1.92 in labor to construct each pair. Over the course of one year, Day Vision incurs fixed costs of $580,000. Day Vision...
-
A bar of length = 1 has one fixed and one free end and stiffness function c(x) = 1 - x. Find the displacement when subjected to a unit force. Pay careful attention to the boundary condition at the...
-
Toyota Motor Corporation uses target costing. Assume that Toyota marketing personnel estimate that the competitive selling price for the Camry in the upcoming model year will need to be $22,000....
-
If fixed costs increase, what would be the impact on the (a) Contribution margin ? (b) Income from operations? Discuss.
-
Provide an example of a transaction that affects (a) Only one element of the accounting equation, (b) Two elements of the accounting equation, (c) Three elements of the accounting equation.
-
An axial flow fan balanced at one speed often exhibits substantial vibrational effects when operated at other speeds, mainly due to (a) primary critical speed effect (b) secondary critical speed...
-
In the case of an involute toothed gear, involute starts from (a) addendum circle (b) dedundum circle (c) pitch circle (d) base circle.
-
In the epicyclic gear train shown in the given Fig. \(33, A\) is fixed. \(A\) has 100 teeth and \(B\) has 20 teeth. If the arm \(C\) makes three revolutions, the number of revolutions made by \(B\)...
Study smarter with the SolutionInn App