finance help needed
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] | $ |