1. What is the expected cash collection for May?2. What is the expected cash disbursements in May?3. What is the expected cash balance at May 31? The following data was available from Manteo Corporation's books:2021PurchasesSalesP 42,000JanuaryFebruaryMarchP 72,00066,00060,00048,00036,000April54,00078,000Collections from customers are normally 70% in the month of sale, 20% in the month following the sale,and 9% in the second month following the sale and the balance is uncollectible.Manteo takes fulladvantage of the 2% discount allowed on purchases paid for by the tenth of thefollowing month. Purchases for May are budgeted at P60,000, while sales for May are forecasted atP66,000.Cash disbursements for expenses are expected to be P14,400 for the month of May. Manteo's cashbalance at May 1 was P22,000.

Here in this question, we are required to calculate cash collection, disbursement and expected cash…

Answered: The following data was available from…

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter18: The Management Of Accounts Receivable And Inventories

Section: Chapter Questions

Problem 9P

See similar textbooks

Similar questions

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?
Fitbands' estimated sales are: Ot. $131,973 Nov. 195,705 Dec. 249,291 Jan 124,298 Feb. 124,306 Mar. 124,365 What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale? Round your answers to two decimal places. Ending Balance January February March
Rainbow, Inc began operations on January 1 of the oument year with a $12.000 cash balanoe. Forty percent of sales e collected in the month of sale 00 ae colleded in the month following sale Similarty. 20% of purchases are paid in the month of purhase, and B0 are paid in the morth following purchase. The folowing data apply February January February 66.00 35.00 Sales 30.00 40.00 Purdhases Operating epenses operating experses re paid in the month inoumed and indude monnly deprediation anarges of 52.600. denermine the change in Rainbows cash talane dunng February $7.500 ingrease 7.000 9.000 $2.000 increase 35.000 inrease 4.000 ingrease None of the answen is coned
ABC company's records included the following, assume 365 days in a year: Accounts Receivable, 12/31/20 $ 860,000 Accounts Receivable, 12/31/19 780,000 Merchandise Inventory, 12/31/20 900,000 Merchandise Inventory, 12/31/19 Net Sales during 2020 Cost of Sales during 2020 800,000 8,364,000 5,950,000 What is the average collection period, in days, for Solomon's accounts receivable O 35.8 days O 36.3 days O 34.1 days 37.5 days
Gayagoy Company reported sales from customers of P6,000,000 and purchases of P4,000,000 for the year ended December 31, 2024. Additional information follows: January 1 December 31 Accounts receivable 2,000,000 3,000,000 Allowance for uncollectible accounts (150,000) (200,000) Accounts payable 1,500,000 2,400,000 Inventory 2,300,000 2,600,000 Gayagoy wrote off uncollectible accounts totaling P500,000 during 2024. Under cash basis, what is the gross profit? 3,200,000 1,700,000 2,300,000 2,200,000
From the following information regarding the year to 31 August 20X6, what is the payables' payment period? $ Sales 43,000 Cost of sales 32,500 Opening inventory 6,000 Closing inventory 3,800 Payables at 31 August 20X6 4,750 A 40 days B 50 days C 53 days D 57 days
Utley Co. prepares monthly income statements. Inventory is counted only at year end; thus, month-end inventories must be estimated. All sales are made on account. The rate of mark-up on cost is 20%. The following information relates to the month of May. Accounts receivable, May 1 Accounts receivable, May 31 Collections of accounts during May Inventory, May 1 Purchases during May $21,000 27,000 90,000 45,000 58,000 Answer the following Questions [DO NOT use commas (.) or dollar signs ($) when entering a number. For example, if you want to enter $1.000 simply write 1000]. 1. Sales revenue for the month of May = $ 2. Cost of goods sold for the month of May = $ 3. The gross profit for the month of May = $ 4. The cost of goods available for sale for the month of May = $ 5. The ending inventory to be reported on the balance sheet at the end of May=
D3 Company marks up all merchandise at 25% of gross purchase. All purchases are made on accountwith terms of 1/10, net/60. Purchase discounts which are recorded as miscellaneous income are alwaystaken. Normally, 60% of each month’s purchases are paid for in the month of purchase, while the other40% are paid during the first 10 days of the first month after purchase. Inventories of merchandise atthe end of each month are kept at 30% of the next month’s projected cost of goods sold.Terms for sales on account are 2/10, net/30. Cash sales are not subject to discount. Fifty percent ofeach month;s sales on account are collected during the month of sale, 45% are collected in thesucceeding month and the remainder are usually uncollectible. Seventy percent of the collections in themonth of sale are subject to discount while 10% of the collections in the succeeding month are subjectto discount.Projected sales data for selected month follow:Sales on Account Gross Cash salesDecember P1,900,000…
ABC company's records included the following, assume 365 days in a year: Accounts Receivable, 12/31/20 $ 860,000 Accounts Receivable, 12/31/19 780,000 Merchandise Inventory, 12/31/20 900,000 Merchandise Inventory, 12/31/19 800,000 Net Sales during 2020 8,364,000 Cost of Saless during 2020 5,950,000 Compute the average length of time in days to sell inventory O 52.1 days 55.3 days 49.3 days O 48.7 days
Aston Company reported the following balances at September 30, 2020:Sales Revenue $280,000Sales Returns and Allowances 13,000Sales Discounts 5,000Cost of Goods Sold 160,500Calculate the Net sales for the month.
ABC company's records included the following, assume 365 days in a year: Accounts Receivable, 12/31/20 $ 860,000 Accounts Receivable, 12/31/19 780,000 Merchandise Inventory, 12/31/20 900,000 800,000 Merchandise Inventory, 12/31/19 Net Sales during 2020 8,364,000 Cost of Sales during 2020 5,950,000 Compute Solomon's accounts receivable turnover ratio in 2020 O 9.8 times O 10.7 times O 10.2 times 9.73 times
The following information is available from the accounting records of Waxford Ltd.: 19-- January February March April Purchases R42 000 48 000 54 000 36 000 Purchases Total sales Administrative expenses Total sales R72 000 66 000 Twenty percent of sales are expected to be for cash. Collections from customers are normally 70% in the month of sale, 20% in the month following the month of sale, and 9% in the second month following the month of sale. Customers paying in the month of sale get a 5% discount. 78 000 60 000 The corporation pays its creditors in the month following the month of purchase, and qualifies for a 5% discount on all its purchases. Budgeted information for the months of May and June is as follows: May R45 000 72 000 14 500 June R42 000 70 000 16 600 Administrative expenses, which include depreciation of R600 per month, are payable in the month incurred. Rates for the year, amounting to R1 500, are included in the administrative expenses for June. The balance per cash…

SEE MORE QUESTIONS

Recommended textbooks for you

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

EBK CONTEMPORARY FINANCIAL MANAGEMENT

Finance

ISBN:

9781337514835

Author:

MOYER

Publisher:

CENGAGE LEARNING - CONSIGNMENT

Principles of Accounting Volume 2

Accounting

ISBN:

9781947172609

Author:

OpenStax

Publisher:

OpenStax College

SEE MORE TEXTBOOKS