From the following data, Forecast the cash position at the endOctober, November and December 2020MonthSales(RO)Purchases (RO)SalariesMiscellancotAugust60,00042,0005,0003,500September65,00050,0006,0004,000October40,00052,0004,0003,000November58,00053,0005,0006,000December44,00040,0004,0003,000Additional Information1. Sales: 10% realized in the month of sales, balance realised equally in twosubsequent months.2. Purchases are paid in the month following the month of supply.3. 10% of the wages are paid in the following month.4. Miscellaneous expenses paid a month in arrears.5. Rent of RO 500 per month paid quarterly in advance due in October.6. First Instalment of Income Tax of RO 15,000 due on or before 15 December.7. Income from Investment RO 3,000 received quarterly in October 2020 and Janu:2021.8. Cash in hand RO 3,000 on 1" October 2020.

Cash budget is forecast that estimates the future cash outlays and receipts.

From the following data, Forecast the cash position at the end October, November and December 2020 Sales(RO) Purchases (RO) Salaries Miscellancot Month August 60,000 42,000 5,000 3,500 September 65,000 50,000 6,000 4,000 October 40,000 52,000 4,000 3,000 November 58,000 53,000 5,000 6,000 December 44,000 40,000 4,000 3,000 Additional Information 1. Sales: 10% realized in the month of sales, balance realsed equally in two subsequent months. 2. Purchases are pald in the month following the month of supply. 3. 10% of the wages are paid in the following month. 4. Miscellaneous expenses paid a month in arrears. 5. Rent of RO 500 per month paid quarterly in advance due in October. 6. First Instalment of Income Tax of RO 15,000 due on or before 15 December. 7. Income from Investment RO 3,000 received quarterly in October 2020 and Janu: 2021. 8. Cash in hand RO 3,000 on 1" October 2020.

From the following data, Forecast the cash position at the end October, November and December 2020 Sales(RO) Purchases (RO) Salaries Miscellancot Month August 60,000 42,000 5,000 3,500 September 65,000 50,000 6,000 4,000 October 40,000 52,000 4,000 3,000 November 58,000 53,000 5,000 6,000 December 44,000 40,000 4,000 3,000 Additional Information 1. Sales: 10% realized in the month of sales, balance realsed equally in two subsequent months. 2. Purchases are pald in the month following the month of supply. 3. 10% of the wages are paid in the following month. 4. Miscellaneous expenses paid a month in arrears. 5. Rent of RO 500 per month paid quarterly in advance due in October. 6. First Instalment of Income Tax of RO 15,000 due on or before 15 December. 7. Income from Investment RO 3,000 received quarterly in October 2020 and Janu: 2021. 8. Cash in hand RO 3,000 on 1" October 2020.

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

What are the estimated cash disbursements for inventories in April?
Please help me with show all Calculation thanku
Schedule of Cash Payments Select Physical Therapy Inc. is planning its cash payments for operations for the third quarter (July-September), 2017. The Accrued Expenses Payable balance on July 1 is $31,700. The budgeted expenses for the next three months are as follows: July August September Salaries $72,900 $88,800 $98,300 Utilities 6,000 6,700 7,900 Other operating expenses 55,400 60,400 66,500 Total $134,300 $155,900 $172,700 Other operating expenses include $4,000 of monthly depreciation expense and $900 of monthly insurance expense that was prepaid for the year on March 1 of the current year. Of the remaining expenses, 75% are paid in the month in which they are incurred, with the remainder paid in the following month. The Accrued Expenses Payable balance on July 1 relates to the expenses incurred in June. Prepare a schedule of cash payments for operations for July, August, and September. Select Physical Therapy Inc. Schedule of Cash Payments for Operations For the Three Months…
Consider the following information for a given company: Month Cash Sales Credit Sales Jan $80.000 $350,000 Feb $60,000 $200,000 Mar $50.000 $145,000 Apr $45,000 $130,000 May $55,000 $170,000 Jun $50,000 $150,000 The firm's collection pattern is as follows: 60% in the month of sale 30% one month following sale 10% two months following sale The accounts receivable balance on 1 Jan is $70,000. Of this amount, $60,000 represents uncollected Dec sales and $10,000 represents uncollected Nov sales. Required: Determine the total cash collected during Jan. (INPUT YOUR ANSWER IN THOUSANDS USING A COMMA SEPARATOR. NO ROUNDING REQUIRED. FOR EXAMPLE: 100,000)
Schedule of Cash Collections of Accounts Receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 20% pay their accounts in the month of sale, while the remaining 80% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $127,000 November 159,000 December 232,000 The Accounts Receivable balance on September 30 was $85,000. Prepare a schedule of cash collections from sales for October, November, and December. Round all calculations to the nearest whole dollar. OfficeMart Inc.Schedule of Cash Collections from SalesFor the Three Months Ending December 31 October November December Receipts from cash sales: Cash sales $fill in the blank 1 $fill in the blank 2 $fill in the blank 3 September sales on account:…
The table contains the Sales estimates for the next year. Sales are collected as follows:In the month of Sales: 43%In the next month: 23%After 2 months: 14%After 3 months: remainder is collected What is the cash collection for November? Month Sales $ Month Sales $ Jan 28,555 July 36,215 Feb 21,027 Aug 19,907 Mar 19,907 Sep 28,555 Apr 36,215 Oct 19,907 May 28,555 Nov 21,027 June 21,027 Dec 36,215
A company is preparing its cash buget for the month of May. Below is A/R information: Actual credit sale for March $130,000 Actual credit sale for April $160,000 Estimated credit sales for May $210,000 Estimated collections in the month of sale 25% Estimated collections in the first month after the month of sale 60% Estimated collections in the second month after the month of sale 10% Estimated provision of bad debts (made in month of sale) 5% ** Firm writes off all UNCOLLECTIBLE account receievables at the end of second month after the month of sale. Required: For the month of May, calculate the following: 1. Estimated cash receipts from account recievable collections. 2. The gross amount of A/R at the end of the month (after appropriate write off of uncollectiable amounts). 3. The net amount of A/R at the end of the month 4. Recalculate the requirement 1 & 2 under the assumption that estimated collections in the month of sale equal 60% and in the first…
Schedule of Cash Payments Tadpole Learning Systems Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March $184,900 April 172,000 May 156,500 Depreciation, insurance, and property taxes represent $39,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taves for the year will be paid in November. 71% of the remainder of the expenses are expected to be paid in the month in which they are incurred, with the balance to be paid in the following month. Prepare a schedule indicating cash payments for selling and administrative expenses for March, Apri, and May. Enter all amounts as positive numbers. TADPOLE LEARNING SYSTEMS INC. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March Apr May March expenses Paid in March Paid in April Apri expenses Paidin April Pad in May May expenses Prepare a…
acc
November December January February March Actual Actual Forecast Forecast Forecast 80 000 150 000 180 000 240 000 300 000 • The cash from sales are received as follows: o 30% in the month of sale o 40% 1 month after sale o 30% 2 months after sale • Purchases are 65% of sales • Cash purchases are made in the following manner: o 20% cash in the month of purchase o 40% 1 month after purchase o 40% 2 months after purchase • Cash dividends of R15 000 was received in January • Rentals of R7 500 are due and paid at the end of each month • The company has 1 salaried employee who is paid each month • Wages incurred and paid equate to 8% of the previous months sales • The company bought a new machine in March for R250 000. Only a deposit of R130 000 was due and payable in March • A provisional tax payment of R30 000 was made at the end the February • R15 000 interest was paid against the company’s bank account in February • Dividends declared at the end of March amounted to R20 000. A 1st payment…
Schedule of cash collections of accounts receivable OfficeMart Inc. has "cash and carry" customers and credit customers. OfficeMart estimates that 25% of monthly sales are to cash customers, while the remaining sales are to credit customers. Of the credit customers, 30% pay their accounts in the month of sale, while the remaining 70% pay their accounts in the month following the month of sale. Projected sales for the next three months are as follows: October $58,000 November 65,000 December 72,000 The Accounts Receivable balance on September 30 was $35,000. Prepare a schedule of cash collections from sales for October, November, and December. Enter all amounts as positive numbers. OfficeMart Inc. Schedule of Cash Collections from Sales For the Three Months Ending December 31 Line Item Description Receipts from cash sales: Cash sales September sales on account: Collected in October October sales on account: Collected in October Collected in November November sales on account: Collected…
How many percent was the increase in gross sales? For year 2020, cash is composed of how many percent compared to its total asset?