Monette Corporation has found that 70% of its sales in any given month are credit sales, while theremainder are cash sales. Of the credit sales, Monette Corporation has experienced the followingcollection pattern:25% received in the month of the sale50% received in the month after the sale16% received two months after the sale9% of the credit sales are never receivedCash salesCollections on credit sales:25% Month of sale50% Month after16% Two months afterTotal cash collectionsMonette CorporationCash Collections BudgetFor the Months of January through MarchJanuaryCNovember sales for last year were $100,000, while December sales were $115,000.Projected sales for the next three months are as follows:January sales.February salesMarch sales...$ 160,000130,000190,000.$RequirementPrepare a cash collections budget for the first quarter, with a column for each month and forthe quarter. (Round your answers to the nearest whole dollar.)

This budget is prepared to estimate the amount of cash received from customer against sale of goods.…

Answered: Monette Corporation has found that 70%…

FINANCIAL ACCOUNTING

10th Edition

ISBN:9781259964947

Author:Libby

Publisher:Libby

Chapter1: Financial Statements And Business Decisions

Section: Chapter Questions

Problem 1Q

See similar textbooks

Similar questions

A firm has the following monthly pattern of sales: January $ 200 February 300 March 600 April 1,200 May 600 June 300 Sixty percent of the sales are on credit and are collected after a month. The company pays wages each month that are 60 percent of sales and has fixed disbursements (for example, rent) of $150 a month. In March it receives $250 from a bond that matures; in April and June it makes a tax payment of $150. Management maintains a cash balance of $200 at all times. Construct a cash budget that indicates the firm’s monthly needs for short-term financing. Its beginning cash position is $200. Round your answers to the nearest dollar. Enter the disbursements values in Part 2 and desired level of cash in Part 3 as positive values. Use a minus sign to enter cash outflows, shortage of cash values, negative initial and ending cash positions in Part 3, if any. Do not leave any cells blank. If the answer is zero, enter "0". Part 1 January February…
Cost of Trade Credit Grunewald Industries sells on terms of 2/10, net 50. Gross sales last year were $4,526,000 and accounts receivable averaged $434,000. Half of Grunewald's customers paid on the 10th day and took discounts. What are the nominal and effective costs of trade credit to Grunewald's nondiscount customers? (Hint: Calculate daily sales based on a 365-day year, calculate the average receivables for discount customers, and then find the DSO for the nondiscount customers.) Do not round intermediate calculations. Round your answers to two decimal places. Nominal cost of trade credit: % Effective cost of trade credit: %
Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale35 percent of credit sales in the first subsequent month20 percent of credit sales in the second subsequent month5 percent of credit sales in the third subsequent monthThe forecast for both cash and credit sales is as follows. January $185,000 February 184,000 March 193,000 April 195,000 May 200,000 Required: 1. What is the forecasted cash inflow for Ragman Company for May?$fill in the blank 1 2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow related to sales made in April?…
Gilmore Electronics had the following data for a recent year: Cash sales $135,000 Credit sales 512,000 Accounts receivable determined to be uncollectible 9,650 The firm's estimated rate for bad debts is 1.15% of credit sales. Conceptual Connection: If Gilmore's estimate of bad debts is correct (1.15% of credit sales) and the gross margin is 20%, by how much did Gilmore's income from operations increase assuming $150,000 of the sales would have been lost if credit sales were not offered?
Jumbotron Inc. collects its receivables in 15 days and pays its payables in 20 days. All sales and purchases are on credit. All months have 30 days. December purchases were $7,000, January purchases were $8,700, February purchase were $6,600 and March purchases were $6,000. What were Jumbotron's total cash disbursements in February? (To the nearest $) ● ● $7,667 $8,000 $1,867 $6,533 $5,600
On January 1, the Accounts Receivable and the Allowance for Doubtful Accounts carried balances of $40,000 and $1,500 respectively. During the year, the company reported $80,000 of credit sales. There were $500 of receivables written off as uncollected during the year. Cash collections of receivables amounted to $78,200. The company estimates that it will be unable to collect 4% of the year-end accounts receivable balance. The net realizable value of receivables appearing on the balance sheet will amount to
H1.
Historically, Ragman Company has had no significant bad debt experience with its customers. Cash sales have accounted for 20 percent of total sales, and payments for credit sales have been received as follows: 40 percent of credit sales in the month of the sale35 percent of credit sales in the first subsequent month20 percent of credit sales in the second subsequent month5 percent of credit sales in the third subsequent monthThe forecast for both cash and credit sales is as follows. January $185,000 February 185,000 March 193,000 April 196,000 May 210,000 Required: 1. What is the forecasted cash inflow for Ragman Company for May? 2. Due to deteriorating economic conditions, Ragman Company has now decided that its cash forecast should include a bad debt adjustment of 2 percent of credit sales, beginning with sales for the month of April. Because of this policy change, what will happen to the total expected cash inflow related to sales made in April? (CMA adapted) Cash will…
Atlantic Northern Inc. currently has $715,000 in accounts receivable and generated $4,650,000 in sales (all on credit) during the year that just ended. The firm’s days sales outstanding (DSO) is days. Use 365 days as the length of a year in all calculations. Atlantic Northern Inc.’s CFO is unhappy with its DSO and wants to improve collections next year. Sales are expected to grow by 13% next year, and the CFO wants to lower the DSO to the industry average of 30 days. How much accounts receivable is the firm expected to carry? $453,471 $431,877 $410,283 $388,689
Medwig Corporation has a DSO of 17 days. The company averages $8,500 in sales each day (all customers take credit). What is the company's average accounts receivable? Assume a 365-day year. Round your answer to the nearest dollar.
annual sales of $6,000,000. Ninety percent are on credit. The firm has $630,000 in accounts receivable. Compute the value of the average collection period.
Gilmore Electronics had the following data for a recent year: Cash sales $135,000 Credit sales 512,000 Accounts receivable determined to be uncollectible 9,650 The firm's estimated rate for bad debts is 2.85% of credit sales. Conceptual Connection: If Gilmore's estimate of bad debts is correct (2.85% of credit sales) and the gross margin is 20%, by how much did Gilmore's income from operations increase assuming $150,000 of the sales would have been lost if credit sales were not offered?

SEE MORE QUESTIONS

Recommended textbooks for you

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

FINANCIAL ACCOUNTING

Accounting

ISBN:

9781259964947

Author:

Libby

Publisher:

MCG

Accounting

ISBN:

9781337272094

Author:

WARREN, Carl S., Reeve, James M., Duchac, Jonathan E.

Publisher:

Cengage Learning,

Accounting Information Systems

Accounting

ISBN:

9781337619202

Author:

Hall, James A.

Publisher:

Cengage Learning,

Horngren's Cost Accounting: A Managerial Emphasis…

Accounting

ISBN:

9780134475585

Author:

Srikant M. Datar, Madhav V. Rajan

Publisher:

PEARSON

Intermediate Accounting

Accounting

ISBN:

9781259722660

Author:

J. David Spiceland, Mark W. Nelson, Wayne M Thomas

Publisher:

McGraw-Hill Education

Financial and Managerial Accounting

Accounting

ISBN:

9781259726705

Author:

John J Wild, Ken W. Shaw, Barbara Chiappetta Fundamental Accounting Principles

Publisher:

McGraw-Hill Education

SEE MORE TEXTBOOKS