A firm has the following monthly pattern of sales: January $ 200 February 300 March 600 April 1,200 May 600 June 300 Sixty percent of the sales are on credit and are collected after a month. The company pays wages each month that are 60 percent of sales and has fixed disbursements (for example, rent) of $150 a month. In March it receives $250 from a bond that matures; in April and June it makes a tax payment of $150. Management maintains a cash balance of $200 at all times. Construct a cash budget that indicates the firm’s monthly needs for short-term financing. Its beginning cash position is $200. Round your answers to the nearest dollar. Enter the disbursements values in Part 2 and desired level of cash in Part 3 as positive values. Use a minus sign to enter cash outflows, shortage of cash values, negative initial and ending cash positions in Part 3, if any. Do not leave any cells blank. If the answer is zero, enter "0". Part 1 January February March April May June Anticipated sales $ $ $ $ $ $ Cash sales $ $ $ $ $ $ Accounts collected $ $ $ $ $ $ Other receipts $ $ $ $ $ $ Total receipts $ $ $ $ $ $ Part 2 Variable disbursements $ $ $ $ $ $ Fixed disbursements $ $ $ $ $ $ Other disbursements $ $ $ $ $ $ Total cash disbursements $ $ $ $ $ $ Part 3 Net change in cash $ $ $ $ $ $ Initial cash position $ $ $ $ $ $ Ending cash position $ $ $ $ $ $ Desired level of cash $ $ $ $ $ $ Excess (shortage) of cash $ $ $ $ $ $
A firm has the following monthly pattern of sales: January $ 200 February 300 March 600 April 1,200 May 600 June 300 Sixty percent of the sales are on credit and are collected after a month. The company pays wages each month that are 60 percent of sales and has fixed disbursements (for example, rent) of $150 a month. In March it receives $250 from a bond that matures; in April and June it makes a tax payment of $150. Management maintains a cash balance of $200 at all times. Construct a cash budget that indicates the firm’s monthly needs for short-term financing. Its beginning cash position is $200. Round your answers to the nearest dollar. Enter the disbursements values in Part 2 and desired level of cash in Part 3 as positive values. Use a minus sign to enter cash outflows, shortage of cash values, negative initial and ending cash positions in Part 3, if any. Do not leave any cells blank. If the answer is zero, enter "0". Part 1 January February March April May June Anticipated sales $ $ $ $ $ $ Cash sales $ $ $ $ $ $ Accounts collected $ $ $ $ $ $ Other receipts $ $ $ $ $ $ Total receipts $ $ $ $ $ $ Part 2 Variable disbursements $ $ $ $ $ $ Fixed disbursements $ $ $ $ $ $ Other disbursements $ $ $ $ $ $ Total cash disbursements $ $ $ $ $ $ Part 3 Net change in cash $ $ $ $ $ $ Initial cash position $ $ $ $ $ $ Ending cash position $ $ $ $ $ $ Desired level of cash $ $ $ $ $ $ Excess (shortage) of cash $ $ $ $ $ $
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
A firm has the following monthly pattern of sales:
| January | $ | 200 |
| February | 300 | |
| March | 600 | |
| April | 1,200 | |
| May | 600 | |
| June | 300 |
Sixty percent of the sales are on credit and are collected after a month. The company pays wages each month that are 60 percent of sales and has fixed disbursements (for example, rent) of $150 a month. In March it receives $250 from a bond that matures; in April and June it makes a tax payment of $150. Management maintains a cash balance of $200 at all times. Construct a cash budget that indicates the firm’s monthly needs for short-term financing. Its beginning cash position is $200. Round your answers to the nearest dollar. Enter the disbursements values in Part 2 and desired level of cash in Part 3 as positive values. Use a minus sign to enter
| Part 1 | January | February | March | April | May | June |
| Anticipated sales | $ | $ | $ | $ | $ | $ |
| Cash sales | $ | $ | $ | $ | $ | $ |
| Accounts collected | $ | $ | $ | $ | $ | $ |
| Other receipts | $ | $ | $ | $ | $ | $ |
| Total receipts | $ | $ | $ | $ | $ | $ |
| Part 2 | ||||||
| Variable disbursements | $ | $ | $ | $ | $ | $ |
| Fixed disbursements | $ | $ | $ | $ | $ | $ |
| Other disbursements | $ | $ | $ | $ | $ | $ |
| Total cash disbursements | $ | $ | $ | $ | $ | $ |
| Part 3 | ||||||
| Net change in cash | $ | $ | $ | $ | $ | $ |
| Initial cash position | $ | $ | $ | $ | $ | $ |
| Ending cash position | $ | $ | $ | $ | $ | $ |
| Desired level of cash | $ | $ | $ | $ | $ | $ |
| Excess (shortage) of cash | $ | $ | $ | $ | $ | $ |
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 2 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