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

0. Swetres Company has the following sales forecast for the selected three-month period in 2018. April, P120,000; May, P70,000; June, P80,000. 70% of sales are collected in the month of sale, and the balance are collected in the following month. Accounts receivable balance in April 1, P100,000. Cash balance in April 1, P60,000. Minimum cash balance required is P50,000. Cash can be borrowed in the multiples of P10,000 from local bank (disregard the interest charges). What is the cash balance at the end of April assuming that cash is received only from customers and that P200,000 is the cash out during April? 11.Selected information from the accounting records of Roleg Co. is as follows: Net accounts receivable at Dec. 31, 2018, P900,000; Net accounts receivable at Dec. 31, 2019, P1,000,000; Inventories at Dec. 31, 2018, P1,100,000; Inventories at Dec. 31, 2019, P1,200,000; Accounts receivable turnover, 5 times; inventory turnover, 4 times. What is Roleg's gross margin for 2019? 12.…
The Runner Antique Mall expects to make purchases in the first quarter of 2021 as follows: January $85,500 February 108,000 March 76,500 Purchases in December 2020 are expected to be $82,600. The company expects that 50 percent of a month's purchases will be paid in the month of purchase and 50 percent will be paid in the following month. Estimate cash disbursements related to purchases for each month of the first quarter of 2021.
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
The income statement for the first quarter of 2019 was as follows: Income Statement For the Quarter Ended March 31, 2019 Sales Cost of goods sold Gross profit Operating expenses ales salaries Rent expense Depreciation Utilities Miscellaneous Total operating expenses Net income $52,000 24,000 12,000 3,600 12,800 $720,000 396,000 324,000 104,400 $219,600 Prepare a budgeted quarterly income statement in tabular form for the first quarter of 2020.
The 2021 income statement of Adrian Express reports sales of $15,960,000, cost of goods sold of $9,600,000, and net income of $1,600,000. Balance sheet information is provided in the following table. ADRIAN EXPRESS Balance Sheets December 31, 2021 and 2020 2021 2020 Assets Current assets: Cash Accounts receivable $ 600,000 $ 760,000 1,400,000 1,800,000 4,800,000 $8,600,000 1,000,000 1,400,000 4,240,000 $7,400,000 Inventory Long-term assets Total assets Liabilities and Stockholders' Equity Current liabilities $2,020,000 2,300,000 2,000,000 2,280,000 $8,600,000 $1,660,000 2,400,000 2,000,000 1,340,000 $7,400,000 Long-term liabilities Common stock Retained earnings Total liabilities and stockholders' equity Industry averages for the following four risk ratios are as follows: Average collection period Average days in inventory Current ratio 25 days 60 days 2 to 1 50% Debt to equity ratio
the second quarter of 2021: Credit sales Credit purchases Cash disbursements Wages, taxes, and expenses Interest Equipment purchases Beginning cash balance Cash receipts Cash collections from credit sales Total cash available Cash disbursements The company predicts that 5 percent of its credit sales will never be collected, 30 percent of its sales will be collected in the month of the sale, and the remaining 65 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. Purchases Wages, taxes, and expenses Interest In March 2021, credit sales were $190,000 and credit purchases were $130,000. Using this information, complete the following cash budget: (Do not round intermediate calculations. Leave no cells blank - be certain to enter "0" wherever required.) Equipment purchases April May June $320,000 $300,000 $360,000 128,000 151,000 176,000 Total cash disbursements 44,000 11,000 80,000 Ending cash balance 11,500 11,000 150,000 $…
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…
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
The table contains the Sales estimates for the next year. The Purchases are 55% of Sales. Purchases are paid in the following month. The administrative expenses of $11,550 are paid each month Tax expenses of $16,458 are paid in March, June, September, and December each year. Rent expenses of $47,735 are paid in June and December. What is the cash outflow for March? Month Sales $ Month Sales $ Jan 87,400 July 21,931 Feb 89,751 Aug 78,038 Mar 78,038 Sep 87,400 Apr 21,931 Oct 78,038 May 87,400 Nov 89,751 June 89,751 Dec 21,931
Here are some important figures from the budget of Cornell, Inc., for the second quarter of 2020: April May June Credit sales $ 312,000 $ 292,000 $ 352,000 Credit purchases 120,000 143,000 168,000 Cash disbursements Wages, taxes, and expenses 43,200 10,700 62,200 Interest 10,200 10,200 10,200 Equipment purchases 72,000 134,000 0 The company predicts that 5 percent of its credit sales will never be collected, 40 percent of its sales will be collected in the month of the sale, and the remaining 55 percent will be collected in the following month. Credit purchases will be paid in the month following the purchase. In March 2020, credit sales were $182,000, and credit purchases were $122,000. Using this information, complete the following cash budget. (Do not round intermediate calculations.)
The following information was taken from the financial statements of Sunland Company: 2021 2020 Gross profit on sales $678,600 $760,000 Income before income taxes 205,400 225,000 Net income 260,000 225,000 Net income as a percentage of net sales 10% 9% Please show steps to finding answer Compute the cost of goods sold in dollars and as a percentage of net sales for each year. (Round percentages to 1 decimal place, e.g. 15.2%) 2021 2020 Cost of goods sold in dollars $enter a dollar amount $enter a dollar amount Cost of goods sold as a percentage of net sales nter percentages rounded to 1 decimal place % nter percentages rounded to 1 decimal place %
Fernando Company developed the following data for the month of August:1. August 1 cash balance P123,000.2. Cash sales in August P800,000.3. Credit sales for August are P300,000; for July P400,000; and for June P400,000. 70% of credit sales are collected in the month of sale, 15% in thefollowing month, and 10% in the second month following the sale. 4. Purchases for July were P500,000 and for August are P400,000. One-fourth of purchases are paid in the month of purchase and the remaining three-quarters in the following month. 5. August salaries are P314,000, utilities are P32,200, and depreciation on the building and equipment is P100,000. Required:1. Anticipated cash receipts from accounts receivable in August.