finance help needed 0
Paymore Products places orders for goods equal to 80% of its sales forecast in the next quarter. The sales forecasts for the next five quarters are as follows: |
Quarter in Coming Year
|
Following Year
|
|||||
First | Second | Third | Fourth | First Quarter | ||
Sales forecast | $550 | $540 | $520 | $560 | $560 | |
|
The firm pays for its goods with a 1 month delay. Therefore, on average, three fourths of purchases are paid for in the quarter that they are purchased, and one fourth are paid in the following quarter. |
Paymore’s customers pay their bills with a 2 month delay. Therefore, on average, two fourths of sales are collected in the quarter that they are sold, and two fourths are collected in the following quarter. Assume that sales in the last quarter of the previous year were $520. |
Paymore’s labor and administrative expenses are $60 per quarter and that interest on long term debt is $58 per quarter. |
Suppose that Paymore’s cash balance at the start of the first quarter is $35 and its minimum acceptable cash balance is $60. Work out the short term financing requirements for the firm in the coming year. The firm pays no dividends. (Negative amounts should be indicated by a minus sign. Do not round intermediate calculations.) |
Quarter
|
||||
First | Second | Third | Fourth | |
Sources of cash | ||||
Cash at start of period | $ [removed] | $ [removed] | $ [removed] | $ [removed] |
Net cash inflow | [removed] | [removed] | [removed] | [removed] |
|
|
|
|
|
Cash at end of period | [removed] | [removed] | [removed] | $ [removed] |
Minimum operating cash balance | [removed] | [removed] | [removed] | [removed] |
|
|
|
|
|
Cumulative financing required | $ [removed] | $ [removed] | $ [removed] | $ |