The following information is available from the accounting records of Waxford Ltd.:19--JanuaryFebruaryMarchAprilPurchasesR42 00048 00054 00036 000PurchasesTotal salesAdministrative expensesTotal salesR72 00066 000Twenty percent of sales are expected to be for cash. Collections from customers arenormally 70% in the month of sale, 20% in the month following the month of sale, and9% in the second month following the month of sale. Customers paying in the month ofsale get a 5% discount.78 00060 000The corporation pays its creditors in the month following the month of purchase, andqualifies for a 5% discount on all its purchases.Budgeted information for the months of May and June is as follows:MayR45 00072 00014 500JuneR42 00070 00016 600Administrative expenses, which include depreciation of R600 per month, are payable inthe month incurred. Rates for the year, amounting to R1 500, are included in theadministrative expenses for June.The balance per cash book at May 1 was R12 000 (credit).During May a motor vehicle with a cost of R15 000, and on which depreciation of R12000 has been accumulated, will be sold at a profit of R2 000.Required:Draw up a cash budget for the months of May and June 19--, on a month-to-monthbasis.

Cash Budget A money budget is a forecast or schedule of anticipated cash inflows and outflows for…

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 book at May 1 was R12 000 (credit). During May a motor vehicle with a cost of R15 000, and on which depreciation of R12 000 has been accumulated, will be sold at a profit of R2 000. Required: Draw up a cash budget for the months of May and June 19--, on a month-to-month basis.

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 book at May 1 was R12 000 (credit). During May a motor vehicle with a cost of R15 000, and on which depreciation of R12 000 has been accumulated, will be sold at a profit of R2 000. Required: Draw up a cash budget for the months of May and June 19--, on a month-to-month basis.

Managerial Accounting: The Cornerstone of Business Decision-Making

7th Edition

ISBN:9781337115773

Author:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Publisher:Maryanne M. Mowen, Don R. Hansen, Dan L. Heitger

Chapter15: Financial Statement Analysis

Section: Chapter Questions

Problem 56P: The following selected information is taken from the financial statements of Arnn Company for its...

See similar textbooks

Similar questions

The following is select account information for Sunrise Motors. Sales: $256,400; Sales Returns and Allowances: $34,890; COGS: $120,470; Sales Discounts: $44,760. Given this information, what is the Gross Profit Margin Ratio for Sunrise Motors? (Round to the nearest whole percentage.)
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?
The following selected information is taken from the financial statements of Arnn Company for its most recent year of operations: During the year, Arnn had net sales of 2.45 million. The cost of goods sold was 1.3 million. Required: Note: Round all answers to two decimal places. 1. Compute the current ratio. 2. Compute the quick or acid-test ratio. 3. Compute the accounts receivable turnover ratio. 4. Compute the accounts receivable turnover in days. 5. Compute the inventory turnover ratio. 6. Compute the inventory turnover in days.
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
Hoyt Company provides this information for the month of November, 2022: sales on credit $170,000; cash sales $70,000; sales discounts $2,000; and sales returns and allowances $9,000. Prepare the sales revenues section of the income statement based on this information. V: HOYT COMPANY Income Statement (Partial) $ 4
Hoyt Company provides this information for the month of November, 2022: sales on credit $170,000; cash sales $70,000; sales discounts $2,000; and sales returns and allowances $9,000. Prepare the sales revenues section of the income statement based on this information. Salarles and Wages Expense Less Sales Discounts Sales Returns and Allowances Net Sales HOYT COMPANY Income Statement (Partial) November 30, 2022 $ 2,000 i 9,000 i $ $ 240,000 11,000 i 229,000
Alpha Company makes all its sales on account. Accounts receivable payment experience is as follows: Percent paid in the month of sale 35% Percent paid in the month after the sale 54% Percent paid in the second month after the sale 6% Alpha provided information on sales as follows: Мay $150,000 June $125,000 July $136,000 August (expected) $142,000 How much of May's sales are expected to be uncollectible?
Sheridan Company provides the following information for the month ended October 31, 2022: sales on credit $366,100, cash sales $108,300, sales discounts $5,100, and sales returns and allowances $12,900.Prepare the sales section of the income statement based on this information.
Gros s marging The following is select account information for August Sundries. Sales: $850,360; Sales Returns and Allowances: $148,550; COGS: $300,840; Operating Expenses: $45,770; Sales Discounts: $231,820.
Jasper Company has sales on account and for cash. Speclfically, 63% of Its sales are on account and 37% are for cash. Credit sales are collected In full in the month following the sale. The compay forecasts sales of $526.000 for April, $536.,000 for May, and $561,000 for June. The beginning balance of Accounts Recetvable Is S291.600 on Aprll 1. Prepare a schedule of budgeted cash recelpts for Aprl, May, and June.
Tripod Company makes all sales on account. During the current year, Tripod has an average accounts receivable balance of $60,000, an average inventory balance of $96,000, cost of goods sold of $345,000, and net income of $117.000. If Tripod's gross margin percentage is 42.5%, what was its average collection period? Round to one decimal point. O 18.3 days O 24.3 days O 30.4 days O 36.5 days O None of the above
Keep Calm Company provided the following information for the current year: Accounts receivable, January 1 2,100,000 Accounts receivable, December 31 2,700,000 Collections of accounts during the year 9,000,000 Inventory, January 1 4,500,000 Purchases during the year 5,800,000 All sales are made on account. The mark up on cost is 20% What is the estimated inventory. December 31?