Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the table below. Following Quarter in Coming Year Second $343 Year First Third Fourth First Quarter $404 Sales forecast $500 $356 $404 Paymore's labor and administrative expenses are $85 per quarter and interest on long-term debt is $60 per quarter. Suppose that Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. 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 $356. 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. Work out the short-term financing requirements for the firm in the coming year using the above table. The firm pays no dividends. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount. Negative amounts should be indicated by a minus sign.)

Paymore Products places orders for goods equal to 75% of its sales forecast in the next quarter which has been provided in the table below. Following Quarter in Coming Year Second $343 Year First Third Fourth First Quarter $404 Sales forecast $500 $356 $404 Paymore's labor and administrative expenses are $85 per quarter and interest on long-term debt is $60 per quarter. Suppose that Paymore's cash balance at the start of the first quarter is $40 and its minimum acceptable cash balance is $30. 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 $356. 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. Work out the short-term financing requirements for the firm in the coming year using the above table. The firm pays no dividends. (Do not round intermediate calculations. Round your answers to the nearest whole dollar amount. Negative amounts should be indicated by a minus sign.)

Intermediate Financial Management (MindTap Course List)

13th Edition

ISBN:9781337395083

Author:Eugene F. Brigham, Phillip R. Daves

Publisher:Eugene F. Brigham, Phillip R. Daves

Chapter22: Providing And Obtaining Credit

Section: Chapter Questions

Problem 4MC

See similar textbooks

Similar questions

All That Remains Products has projected sales for next year of: Q1 Q2 03 Q4 Sales $ 76,700 $ 80,300 $ 86,850 $ 94,320 The company places orders each quarter that are 59 percent of the following quarter's sales and has a 60-day payables period. What is the accounts payable balance at the end of the third quarter? Multiple Choice $15,792 $27,090 $18,550 $17,081 $37,099
Keeds Products has projected the following sales for the coming year 01 02 Sales $14,600 $13,750 Multiple Choice The company places orders each quarter that are 35 percent of the following quarter's sales and has a 60-day payables period. What is the payment of accounts for the second quarter? $4,812.50 $4.90875 $3,400 83 03 $14,575 $5,005 00 04 $15,625
JNT Store expets to generate the following sales for the next three months: August September October Expected sales 460,000 580,000 620,000 JNT's cost of goods sold is 60% of sales dollars. At the end of each month, BW wants a merchandise inventory balance equal to 20% of the following month's expected cost of goods sold. What dollar amount of desired ending merchandise inventory ojnt in September?
1. A company has a sales plan for 2020 based on the estimated end of the month as follows: Month Total sales July Rp 28.000,00 August 35.000,00 September 42.000,00 Payment terms are set: 3/20/net 30. Based on the experience of the customer's payment method as follows: 60% of sales every month is collected at 20 days after the month of pend. 30% accumulated in the time after 20 days in the same month, i.e. in the first month after the month of Dec. 10% collected in the second month after the month of Dec. Required: prepare a schedule/budget for collection of receivables (receivables collection budget)
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
8 After clicking the Sales Dollars field in the PivotTable shown below, which of the following will open the Value Field Settings dialog box? Year A 1 2 3 Row Labels 4 January 5 February 6 March 7 April 8 May June 10 July 11 August 12 September 13 October 14 November 15 December 16 Grand Total 17 (All) B Sales Dollars $122,890 $113,055 $132,655 $99,370 $105,270 $43,485 $38,480 $103,170 $159,960 $201,950 $213,940 $232,425 $1,566,650 с
I. Cost Behavior and Estimation (HP 6) The owners of Mormont Co., Jorah and Lyanna, are expecting sales for August, 2019 to be 250,000 units. Information about Mormont's Sales and costs over the past three months, are as follows: Units Sold Sales Cost of Goods Sold Wage & Salary Expense Admin Expense May O 200,000 300,000 $3,450,000 $5,175,000 $1,575,000 $2,312,500 $950,000 $975,000 $1,300,000 $1,600,000 June July 500,000 $8,625,000 $3,787,500 $1,925,000 $2,500,000 Required: Based on the information provided, provide a projected income statement, using the contribution margin format. 5
Sales Forecast using Weighted Moving Average 1. Given the following, determine the expected sales on September 18th and September 19th, using a 3-day weighted moving average. 2. Is your weighted moving average result higher or lower than if you had simply done a 3-day moving average? What caused it to be higher or lower? MONTH DATE ACTUAL SALES IN DOLLARS W1 = 10 W2 = 25 W3 = 30 SEPTEMBER 12 13 14 15 16 17 18 19 $1,500 $2,500 $2.500 $3,500 $3.000 $4,500
The marketing department of Jessi Corporation has submitted the following sales forecast for the upcoming fiscal year (all sales are on account):1st Quarter 2nd Quarter 3rd Quarter 4th QuarterBudgeted unit sales ............................ 11,000 12,000 14,000 13,000The selling price of the company’s product is $18.00 per unit. Management expects to collect 65% of salesin the quarter in which the sales are made, 30% in the following quarter, and 5% of sales are expected to beuncollectible. The beginning balance of accounts receivable, all of which is expected to be collected in thefi rst quarter, is $70,200.The company expects to start the first quarter with 1,650 units in finished goods inventory. Management desires an ending finished goods inventory in each quarter equal to 15% of the next quarter’s budgeted sales. The desired ending finished goods inventory for the fourth quarter is 1,850 units.Required:1. Prepare the company’s sales budget and schedule of expected cash…
Shown below is the sales forecast for Cooper Inc. for the first four months of the coming year Apr $14,000 S70.000 Feb Cash sales Credit sales On average, 50% of credit sales are paid for in the month of the sale. 30% in the month following sale, and the remainder are paid two Jan $15.000 $100,000 $24,000 $120.000 Mar $20,000 $90,000 months after the month of the sale Assuming there are no bad debts, the expected cash intlow in March is:
entory Management - Spring21 Time left 1:06:07 on A company has 52 week per year operation. The weekly demand is for product it needs is 20 units and it costs OMR 2500 per unit to purchased. The cost of reordering is OMR 50 each order. The annual holding cost is OMR 660 per unit. Which economic order quantity policy, either round-up or round-down for inventory ordering to be used here to minimize total The corresponding order quantity will be ventory cost per year? of a. None is correct O b. 12 O C. 13 d. 14 O e. 15 FINISH ATTEMPT ...
QUESTION & 6 The following are estimated the estimated sales of a company for eight month Navember 30.2020 Escimated Sales (Units) Manth 12,000 April 13,000 May 9,000 June 8,000 July 10,000 August September 12,000 October 14,000 November 12,000 As a matter of policy, the company maintains the closing balance of finished goods and raw materials as follows Inventory Items Finished goods Ending Balance -50% of estimated sales of next month Raw materials --Estimated consumption for next month Every unit of production requires 2 kgs of raw materials costing Br, 5 per kg Prepare: Production budget company for the half year ending September 30,2020 (units) and raw material budget in (units and cost) of the QUESTION #-7 Financial ratios are the symptoms like the blood pressure, the pulse or the temperature of an individual. Explain. also name and explain in brief the common types of ratios used by business companies.