Grenoble Enterprises had sales of $50,000 in March and $60,300 in April. Forecast sales for May, June, and July are $69,700, $80,300, and $99,900, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 16% of sales for cash, 60% are collected in the next month, and the remaining 24% are collected in the second month following sale. (2) The firm receives other income of $1,500 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $69,700, and $79,800 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $3,400 will be paid in June. (7) Payment of principal and interest of $3,900 is due in June.
Grenoble Enterprises had sales of $50,000 in March and $60,300 in April. Forecast sales for May, June, and July are $69,700, $80,300, and $99,900, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July. (1) The firm makes 16% of sales for cash, 60% are collected in the next month, and the remaining 24% are collected in the second month following sale. (2) The firm receives other income of $1,500 per month. (3) The firm's actual or expected purchases, all made for cash, are $49,700, $69,700, and $79,800 for the months of May through July, respectively. (4) Rent is $2,500 per month. (5) Wages and salaries are 8% of the previous month's sales. (6) Cash dividends of $3,400 will be paid in June. (7) Payment of principal and interest of $3,900 is due in June.
Essentials Of Investments
11th Edition
ISBN:9781260013924
Author:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Chapter1: Investments: Background And Issues
Section: Chapter Questions
Problem 1PS
Related questions
Question
Grenoble Enterprises had sales of $50,000 in March and $60,300 in April. Forecast sales for May, June, and July are $69,700, $80,300, and $99,900, respectively. The firm has a cash balance of $4,800 on May 1 and wishes to maintain a minimum cash balance of $4,800. Given the following data, prepare and interpret a cash budget for the months of May, June, and July.
(1) The firm makes 16% of sales for cash, 60% are collected in the next month, and the remaining 24% are collected in the second month following sale.
(2) The firm receives other income of $1,500 per month.
(3) The firm's actual or expected purchases, all made for cash, are $49,700, $69,700, and $79,800 for the months of May through July, respectively.
(4) Rent is $2,500 per month.
(5) Wages and salaries are 8% of the previous month's sales.
(6) Cash dividends of $3,400 will be paid in June.
(7) Payment of principal and interest of $3,900 is due in June.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
This is a popular solution!
Trending now
This is a popular solution!
Step by step
Solved in 3 steps
Recommended textbooks for you
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
Fundamentals of Financial Management (MindTap Cou…
Finance
ISBN:
9781337395250
Author:
Eugene F. Brigham, Joel F. Houston
Publisher:
Cengage Learning
Corporate Finance (The Mcgraw-hill/Irwin Series i…
Finance
ISBN:
9780077861759
Author:
Stephen A. Ross Franco Modigliani Professor of Financial Economics Professor, Randolph W Westerfield Robert R. Dockson Deans Chair in Bus. Admin., Jeffrey Jaffe, Bradford D Jordan Professor
Publisher:
McGraw-Hill Education