P4-10 Cash budget: Basic Farmers Delight Corporation reported sales of $350,000 in June, $380,000 in July, and $390,000 in August. The forecasts for September, October, and November are $385,000, $418,000, and $429,000, respectively. The initial cash bal- ance on September 1 is $150,000, and a minimum of $8,000 should be kept. Use the given information to compile a cash budget for the months of September, October, and November. (1) Farmers Delight predicts that 5% of its sales will never be collected, 30% of its sales will be cash sales, and the remaining 65% will be collected in the following month. (2) Farmers Delight receives other monthly income of $3,000. (3) The actual or expected purchases are $150,000, $120,000, and $115,000 for the months of September to November, respectively, and 50% are paid in cash while the remainder is paid in the following month. The purchases for August were $120,000. (4) Monthly rent is $3,500 chargeable only in October and November. (5) Wages and salaries are 12% of the previous month's sales. (6) Cash dividends of $4,600 are declared and will be paid in September. (7) Long-term loan repayment of principal and interest of $4,700 is due in October. (8) Additional equipment costing $8,500 is ordered and scheduled to be paid for in cash in November. (9) Taxes of $8,250 are due in November.
P4-10 Cash budget: Basic Farmers Delight Corporation reported sales of $350,000 in June, $380,000 in July, and $390,000 in August. The forecasts for September, October, and November are $385,000, $418,000, and $429,000, respectively. The initial cash bal- ance on September 1 is $150,000, and a minimum of $8,000 should be kept. Use the given information to compile a cash budget for the months of September, October, and November. (1) Farmers Delight predicts that 5% of its sales will never be collected, 30% of its sales will be cash sales, and the remaining 65% will be collected in the following month. (2) Farmers Delight receives other monthly income of $3,000. (3) The actual or expected purchases are $150,000, $120,000, and $115,000 for the months of September to November, respectively, and 50% are paid in cash while the remainder is paid in the following month. The purchases for August were $120,000. (4) Monthly rent is $3,500 chargeable only in October and November. (5) Wages and salaries are 12% of the previous month's sales. (6) Cash dividends of $4,600 are declared and will be paid in September. (7) Long-term loan repayment of principal and interest of $4,700 is due in October. (8) Additional equipment costing $8,500 is ordered and scheduled to be paid for in cash in November. (9) Taxes of $8,250 are due in November.
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
Transcribed Image Text:P4-10 Cash budget: Basic Farmers Delight Corporation reported sales of $350,000 in June,
$380,000 in July, and $390,000 in August. The forecasts for September, October, and
November are $385,000, $418,000, and $429,000, respectively. The initial cash bal-
ance on September 1 is $150,000, and a minimum of $8,000 should be kept. Use the
given information to compile a cash budget for the months of September, October,
and November.
(1) Farmers Delight predicts that 5% of its sales will never be collected, 30% of its sales
will be cash sales, and the remaining 65% will be collected in the following month.
(2) Farmers Delight receives other monthly income of $3,000.
(3) The actual or expected purchases are $150,000, $120,000, and $115,000 for
the months of September to November, respectively, and 50% are paid in cash
while the remainder is paid in the following month. The purchases for August
were $120,000.
(4) Monthly rent is $3,500 chargeable only in October and November.
(5) Wages and salaries are 12% of the previous month's sales.
(6) Cash dividends of $4,600 are declared and will be paid in September.
(7) Long-term loan repayment of principal and interest of $4,700 is due in October.
(8) Additional equipment costing $8,500 is ordered and scheduled to be paid for in
cash in November.
(9) Taxes of $8,250 are due in November.
Expert Solution
This question has been solved!
Explore an expertly crafted, step-by-step solution for a thorough understanding of key concepts.
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