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 $385 $365 $341 $389 $389 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 $341. 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 $70 per quarter and that interest on long-term debt is $45 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.)

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 $385 $365 $341 $389 $389 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 $341. 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 $70 per quarter and that interest on long-term debt is $45 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.)

EBK CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 1PROB

See similar textbooks

Similar questions

A companys sales for the coming months are as follows: About 20 percent of sales are cash sales, and the remainder are credit sales. The company finds that typically 10 percent of a months credit sales are paid in the month of sale, 70 percent are paid the next month, and 15 percent are paid in the second month after sale. Expected cash receipts in July are budgeted at what amount? a. 114,520 b. 143,150 c. 145,720 d. 156,000
Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Halifax Shoes has 30% of its sales in cash and the remainder on credit. Of the credit sales, 65% is collected in the month of sale, 25% is collected the month after the sale, and 5% is collected the second month after the sale. How much cash will be collected in August if sales are estimated as $75,000 in June, $65,000 in July, and $90,000 in August?
Barnstormer sells airplane accessories for $20 each. It expects sales of 120,000 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
Navigator sells GPS trackers for $50 each. It expects sales of 5,000 units in quarter 1 and a 5% increase each subsequent quarter for the next 8 quarters. Prepare a sales budget by quarter for the first year.
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 $375 $320 $300 $360 $360 Paymore’s labor and administrative expenses are $66 per quarter and interest on long-term debt is $41 per quarter. Paymore’s cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. Assume that Paymore can borrow up to $300 from a line of credit at an interest rate of 2% per quarter. 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 $300. On average, two-thirds of purchases are paid for in the quarter that they are purchased, and one-third are paid in the following quarter. Prepare a short-term financing plan using…
Paymore Products places orders for goods equal to 75% 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 $420 $342 $346 $394 $394 Calculate Paymore's cash payments to its suppliers assuming that two-thirds of the purchases are paid for in the quarter that they are purchased and one-third are paid in the following quarter. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount.) Quarter Payment 1 2 3 4
Shown below is the sales forecast for Tulip's industry. For the first four Quarter of the coming year. Quarter 1 sales (in units) are 40 000 increases in sequent by the multiple of 20 000 for the rest of quarters except for the last quarter sales are 50 000 units. • Tulip's single product sells for 8$.• Sales collected in the following pattern, 75% in the quarter of sales, and the remaining 25% in the following quarter. The financial statement position (FSP) showed $65 000 balance of account receivables. All of which will be collected in the first quarter.• The company desires an ending finished goods inventory at the end each quarter equal to 30% of the budget sales unit sales for the next quarter. It had 12 000 units in hand on December, 31. Beginning balance of finished goods is 10 000 units• Five pounds of raw materials are required to complete one unit of product. Tulip Company require ending raw materials inventory at the end of each quarter equal to 10% of following quarter's…
Grey Manufacturing Company expects sales to total 18,600 units in the first quarter, 16,000 units in the second quarter, and 23,000 units in the third quarter of the current fiscal year. Company policy is to have on hand at the end of each quarter an amount of inventory equal to 10% of the following quarter’s sales. Given this information, how many units should be scheduled for production in the second quarter?
Your projected sales for the first 3 months of next year are as follows:January, $15,000; February, $20,000; and March, $25,000. Based on lastyear’s data, cash sales are 20 percent of total sales for each month. Of theaccounts receivable, 60 percent are collected in the month after the sale and40 percent are collected in the second month following the sale. Sales forNovember of the current year are $15,000 and for December are $17,000.You have the following estimated payments: January, $4,500; February,$5,500; and March, $5,200.a. Using the format from the pro forma cash budget in Table 6–8, what is yourmonthly cash budget for January, February, and March?b. What will your accounts receivable be for the beginning of April?c. Will your company have any borrowing requirements for any month duringthis 3-month period?
Roque Company has been accumulating operating data in order to prepare an annual profit plan. Details regarding Roque’s sales for the first 6 months of the coming year are as follows: Forecasted sales January P600,000; February P650,000; March P700,000; April P625,000; May P720,000; June P800,000 Types of sales Cash sales 20% Credit sales 80% Collection Pattern for Credit Sales Month of sale 30% One month following sale 40% Second month following sales 25% Roque’s cost of goods sold averages 40% of the sales value. Roque’s objective is to maintain a target inventory equal to 30% of the next month’s sales in units. Purchases of merchandise for resale are paid for in the month following the sale. The variable operating expenses (other tan cost of goods sold) for Roque are 10% of sales and are paid for in the month following the sale. The annual fixed operating expenses are presented below. All of these are incurred uniformly throughout the year and paid monthly except for insurance and…