Morgan Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $120,000 $78,000 $24,000 February 110,000 66,000 24,200 March 125,000 81,250 27,000 April 130,000 84,500 28,600 Sales are collected 50% in the month of sale, 30% in the month following sale, and 19% in the second month following sale. One percent of sales is uncollectible and expensed at the end of the year. Morgan pays for all purchases in the month following purchase and takes advantage of a 3% discount. The following balances are as of January 1: Cash $88,000 Accounts Receivable* $58,000 Accounts payable $72,000 *Of this balance, $35,000 will be collected in January and the remaining amount will be collected in February. The monthly expense figures include $5,000 of depreciation. The expenses are paid in the month incurred. A. Morgan's expected cash balance at the end of January is: B. Morgan's budgeted cash receipts in February are: C. Morgan's budgeted cash payments in February are:

Morgan Company's budgeted income statement reflects the following amounts: Sales Purchases Expenses January $120,000 $78,000 $24,000 February 110,000 66,000 24,200 March 125,000 81,250 27,000 April 130,000 84,500 28,600 Sales are collected 50% in the month of sale, 30% in the month following sale, and 19% in the second month following sale. One percent of sales is uncollectible and expensed at the end of the year. Morgan pays for all purchases in the month following purchase and takes advantage of a 3% discount. The following balances are as of January 1: Cash $88,000 Accounts Receivable* $58,000 Accounts payable $72,000 *Of this balance, $35,000 will be collected in January and the remaining amount will be collected in February. The monthly expense figures include $5,000 of depreciation. The expenses are paid in the month incurred. A. Morgan's expected cash balance at the end of January is: B. Morgan's budgeted cash receipts in February are: C. Morgan's budgeted cash payments in February are:

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

Cullumber Design provided the following budgeted information for April through July: April May June July Projected sales $133120 $157440 $147200 $168960 Projected merchandise purchases $104960 $117760 $99840 $84480 The cash balance on June 1 is $15360. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $39680 per month of which depreciation is $3840 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $5120 per month of which $768 is interest and the remainder is principal. How much are budgeted cash disbursements for June? O $110592. O $151552. O $131584. O $80896.
page Fraser Company has forecast purchases on account to be $210,000 in March, $270,000 in April, $320,000 in May, and $390,000 in June. Seventy percent of purchases are paid for in the month of purchase, the remaining thirty percent are paid in the following month. What are budgeted cash payments for April? O a. $252,000 O b. $285,000 O c. $126,000 O d. $159,000 irses.open.uwi.edu/mod/quiz/attempt.php?attempt=63242&cmid-99810&page-14 pe here to search S J £ 3 E $ 4 O BI R JU F JU % 5 C T 6 B & H U 8 Time left 0:28:46 W Next page 28°C Mostly
The following data are from the budget of Ritewell Publishers. Half the company's sales are transacted on a cash basis. The other half are paid for with a 1-month delay. The company pays all of its credit purchases with a 1-month delay. Credit purchases in January were $140, and total sales in January were $290. TT February March $ 420 April Total sales $ 440 $ 400 125 135 115 Cash purchases Credit purchases Labor and administrative purchases Taxes, interest, and dividends Capital expenditures 95 85 95 85 85 85 65 65 65 210 Complete the following cash budget. (Leave no cells blank. Enter '0' when necessary. Negative amounts should be indicated by a minus sign.) February March Aprit Sources of cash Collections on current sales Collections on amounts receivable Total sources of cash 0 $ Uses of cash Payments of accounts payable Cash purchases o search
Kingston budgets total sales for June and July of $430,000 and $338,000, respectively. Cash sales are 65% of total sales. Of the credit sales, 25% are collected in the month of sale, 65% are collected during the first month after the sale, and the remaining 10% are collected in the second month after the sale. Determine the amount of accounts receivable reported on the company’s budgeted balance sheet as of July 31. Hint: Determine the percent of June and July sales that are uncollected at July 31. As of July 31 Sales month Total Sales Credit Sales Percent Uncollected Amount Uncollected June $430,000 July 338,000 Total
Assume a company's sales budget for July estimates 17,000 units sold. The variable selling and administrative expense used for budgeting purposes is $4.00 per unit sold. The total budgeted cash disbursements for selling and administrative expenses in July is $139,000. The total fixed selling and administrative expenses included in the selling and administrative expense budget for July is $100,000. What is the amount of depreciation included in the selling and administrative expense budget for July? Multiple Choice O OOO $14,000 $32,000 $29,000 $47,000
Assume the following budgeted information for a merchandising company: Budgeted sales (all on credit) for November, December, and January are $248,000, $218,000, and $209,000, respectively. • Cash collections related to credit sales are expected to be 70% in the month of sale, 30% in the month following the sale. • The cost of goods sold is 70% of sales. • Each month's ending inventory equals 20% of next month's cost of goods sold. • 30% of each month's merchandise purchases are paid in the current month and the remainder is paid in the following month. • Monthly selling and administrative expenses that are paid in cash in the month incurred total $25,000. • Monthly depreciation expense is $9.000. . The budgeted net operating income for December would be: Multiple Choice $40,400 $25,734 $16,734 $31,400
Farm Supply Company's budgeted monthly sales are as follows: April $780,000, May $560,000, and June $900,000. Sales are 60% cash and 40% on account. Farm Supply collects all its accounts receivable in the month following the sale. Cost of goods sold is budgeted at 75% of sales and ending inventory is budgeted at 20% of the next month's cost of goods sold. All inventory purchases are paid 28% in the month of purchase and 72% in the following month. What are Farm Supply's budgeted cash collections for the month of May? O $336,000 O $414,000 O $648,000 O $747,000 O None of the above
Meredith Company has budgeted sales for the upcoming months as follows: $ 452,000 $ 467,000 $ 498,000 $ 516,000 $ 503,000 $ April Мay June July August September $ 478,000 40% of the sales are credit sales, the remainder are made in cash. Credit sales are collected 50% in the month of sale, 35% in the month following the sale, and 8% in the second month following the sale. a. Compute Meredith Company's cash receipts for June. (Do not round intermediate calculations.) Cash Receipts b. Compute Meredith Company's cash receipts for July. (Do not round intermediate calculations.) Cash Receipts c. Compute Meredith Company's cash receipts for August. (Do not round intermediate calculations.) Cash Receipts
Ivanhoe Design provided the following budgeted information for April through July: April May June July Projected sales $112320 $132840 $124200 $142560 Projected merchandise purchases $88560 $99360 $84240 $71280 The cash balance on June 1 is $12960. The company pays 40% of merchandise purchases in the month purchased and 60% in the following month. General operating expenses are budgeted to be $33480 per month of which depreciation is $3240 of this amount. Management pays operating expenses in the month incurred. The company makes loan payments of $4320 per month of which $648 is interest and the remainder is principal. How much are budgeted cash disbursements for June? $111024. $127872. $93312. $68256.
Riverbed Inc. provided the following information: April Projected merchandise purchases $92,500 Calculate budgeted cash disbursements for May. May $82,000 Total budgeted cash disbursements $ June Riverbed pays for 40% of merchandise purchases in the month of the purchase and 60% in the following month. General operating expenses are budgeted to be $34,500 per month of which depreciation is $3,400 of this amount. Riverbed pays operating expenses in the month incurred. Riverbed makes loan payments of $5,000 per month of which $550 is interest and the remainder is principal. $69,000
Jacob Long, the controller of Arvada Corporation, is trying to prepare a sales budget for the coming year. The income statements for the last four quarters follow: Sales revenue Cost of goods sold Gross profit Selling & administrative expenses Net income First Quarter Second Quarter Third Quarter Fourth Quarter $ 174,000 $ 264,000 87,000 132,000 87,000 132,000 $ 214,000 107,000 107,000 21,400 17,400 26,400 $ 69,600 $ 85,600 $ 105,600 Historically, cost of goods sold is about 50 percent of sales revenue. Selling and administrative expenses are about 10 percent of sales revenue. Fred Arvada, the chief executive officer, told Mr. Long that he expected sales next year to be 10 percent for each respective quarter above last year's level. However, Rita Banks, the vice president of sales, told Mr. Long that she believed sales growth would be only 5 percent. Required a. Prepare a pro forma income statement including quarterly budgets for the coming year using Mr. Arvada's estimate. b. Prepare…
Hess Company has $15,000 in cash on hand on January 1 and has collected the following budget data: January February Sales $1,360,000 $640,000 Cash receipts from customers 851,850 871,300 Cash payments for merchandise inventory 561,700 532,416 Assume Hess has cash payments for selling and administrative expenses including salaries of $30,000 plus commissions of 11% of sales, all paid in the month of sale. The company requires a minimum cash balance of $12,500. Prepare a cash budget for January. Hess Company Cash Budget Two Months Ended January 31 and February 28 January Beginning cash balance Cash receipts Cash available Cash payments: Purchases of merchandise inventory Selling and administrative expenses Total cash payments Ending cash balance before financing Minimum cash balance desired Projected cash excess…