In: Finance
Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the below table.
Quarter in Coming Year | Following Year | |||||
First | Second | Third | Fourth | First Quarter | ||
Sales forecast | $444 | $351 | $349 | $397 | $397 | |
On average, one-third of sales are collected in the quarter that they are sold, and two-thirds are collected in the following quarter. Assume that sales in the last quarter of the previous year were $349. Also, one third of the orders are paid for in the current month and then two thirds of the next quarter's orders are paid in advance. Assuming that Paymore’s labor and administrative expenses are $78 per quarter and that interest on long-term debt is $53 per quarter, work out the net cash flow for Paymore for the coming year using the below table. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.)
ONLY NEED PART WITH QUESTION MARK
Quarter | ||||
First | Second | Third | Fourth | |
Sources of cash: | ||||
Collections on accounts receivable | $381 | $413 | $350 | $365 |
Uses of cash: | ||||
Payments of accounts payable | ? | 262 | ? | 298 |
Labor and administrative expenses | 78 | 78 | 78 | 78 |
Interest on long-term debt | 53 | 53 | 53 | 53 |
Total uses of cash | $131 | $393 | $131 | $429 |
Net cash inflow/(outflow) | $250 | $20 | $219 | $(64) |
Calculation of Net Cash flows:
Working Notes :
1) Accounts receivable Collection
Formulas:
2)Payables Payments
Formulas: