15-10 CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 June $180,000 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 June $90,000 90,000 July 126,000 August 882,000 September 306,000 October November December 234,000 162,000 90,000 General and administrative salaries are approximately $27,000 a month. Lease payments under long-term leases are $9,000 a month. Depreciation charges are $36,000 a month. Miscellaneous expenses are $2,700 a month. Income tax payments of $63,000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest. ?
15-10 CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the following sales forecasts for the firm for parts of 2016 and 2017. May 2016 June $180,000 180,000 July 360,000 August 540,000 September 720,000 October 360,000 November 360,000 December 90,000 January 2017 180,000 Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were provided. Here are the estimated costs of labor plus raw materials: May 2016 June $90,000 90,000 July 126,000 August 882,000 September 306,000 October November December 234,000 162,000 90,000 General and administrative salaries are approximately $27,000 a month. Lease payments under long-term leases are $9,000 a month. Depreciation charges are $36,000 a month. Miscellaneous expenses are $2,700 a month. Income tax payments of $63,000 are due in September and December. A progress payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000 should be maintained throughout the cash budget period. a. Prepare a monthly cash budget for the last 6 months of 2016. b. Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to invest. ?
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
![15-10 CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the
following sales forecasts for the firm for parts of 2016 and 2017.
May 2016
June
$180,000
180,000
July
360,000
August
540,000
September
720,000
October
360,000
November
360,000
December
90,000
January 2017
180,000](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F982de8da-3b41-45f4-a9f4-4d63584cd0b4%2F51fd246e-f54c-41d4-8d1e-c361e0339ee9%2Fpnupm1a_processed.png&w=3840&q=75)
Transcribed Image Text:15-10 CASH BUDGETING Helen Bowers, owner of Helen's Fashion Designs, is planning to request a line of credit from her bank. She has estimated the
following sales forecasts for the firm for parts of 2016 and 2017.
May 2016
June
$180,000
180,000
July
360,000
August
540,000
September
720,000
October
360,000
November
360,000
December
90,000
January 2017
180,000
![Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following
the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were
provided. Here are the estimated costs of labor plus raw materials:
May 2016
June
$90,000
90,000
July
126,000
August
882,000
September
306,000
October
November
December
234,000
162,000
90,000
General and administrative salaries are approximately $27,000 a month. Lease payments under long-term leases are $9,000 a month. Depreciation charges
are $36,000 a month. Miscellaneous expenses are $2,700 a month. Income tax payments of $63,000 are due in September and December. A progress
payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000
should be maintained throughout the cash budget period.
a. Prepare a monthly cash budget for the last 6 months of 2016.
b. Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to
invest.
?](/v2/_next/image?url=https%3A%2F%2Fcontent.bartleby.com%2Fqna-images%2Fquestion%2F982de8da-3b41-45f4-a9f4-4d63584cd0b4%2F51fd246e-f54c-41d4-8d1e-c361e0339ee9%2Fsawxaqi_processed.png&w=3840&q=75)
Transcribed Image Text:Estimates regarding payments obtained from the credit department are as follows: collected within the month of sale, 10%; collected the month following
the sale, 75%; collected the second month following the sale, 15%. Payments for labor and raw materials are made the month after these services were
provided. Here are the estimated costs of labor plus raw materials:
May 2016
June
$90,000
90,000
July
126,000
August
882,000
September
306,000
October
November
December
234,000
162,000
90,000
General and administrative salaries are approximately $27,000 a month. Lease payments under long-term leases are $9,000 a month. Depreciation charges
are $36,000 a month. Miscellaneous expenses are $2,700 a month. Income tax payments of $63,000 are due in September and December. A progress
payment of $180,000 on a new design studio must be paid in October. Cash on hand on July 1 will be $132,000, and a minimum cash balance of $90,000
should be maintained throughout the cash budget period.
a. Prepare a monthly cash budget for the last 6 months of 2016.
b. Prepare monthly estimates of the required financing or excess funds-that is, the amount of money Bowers will need to borrow or will have available to
invest.
?
Expert Solution
![](/static/compass_v2/shared-icons/check-mark.png)
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 2 steps
![Blurred answer](/static/compass_v2/solution-images/blurred-answer.jpg)
Recommended textbooks for you
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Essentials Of Investments](https://compass-isbn-assets.s3.amazonaws.com/isbn_cover_images/9781260013924/9781260013924_smallCoverImage.jpg)
Essentials Of Investments
Finance
ISBN:
9781260013924
Author:
Bodie, Zvi, Kane, Alex, MARCUS, Alan J.
Publisher:
Mcgraw-hill Education,
![FUNDAMENTALS OF CORPORATE FINANCE](https://www.bartleby.com/isbn_cover_images/9781260013962/9781260013962_smallCoverImage.gif)
![Financial Management: Theory & Practice](https://www.bartleby.com/isbn_cover_images/9781337909730/9781337909730_smallCoverImage.gif)
![Foundations Of Finance](https://www.bartleby.com/isbn_cover_images/9780134897264/9780134897264_smallCoverImage.gif)
Foundations Of Finance
Finance
ISBN:
9780134897264
Author:
KEOWN, Arthur J., Martin, John D., PETTY, J. William
Publisher:
Pearson,
![Fundamentals of Financial Management (MindTap Cou…](https://www.bartleby.com/isbn_cover_images/9781337395250/9781337395250_smallCoverImage.gif)
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…](https://www.bartleby.com/isbn_cover_images/9780077861759/9780077861759_smallCoverImage.gif)
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