The budget director of Heather's Florist has prepared the following sales budget. The company had $124,600 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required a. Complete the schedule of cash receipts by filling in the missing amounts. . Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Complete the schedule of cash receipts by filling in the missing amounts. July Sales Budget Cub 50.000 August September C 75.000 C 00.000

The budget director of Heather's Florist has prepared the following sales budget. The company had $124,600 in accounts receivable on July 1. Heather's Florist normally collects 100 percent of accounts receivable in the month following the month of sale. Required a. Complete the schedule of cash receipts by filling in the missing amounts. . Determine the amount of accounts receivable the company will report on its third quarter pro forma balance sheet. Complete this question by entering your answers in the tabs below. Required A Required B Complete the schedule of cash receipts by filling in the missing amounts. July Sales Budget Cub 50.000 August September C 75.000 C 00.000

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

On March 1 of the current year, Spicer Corporation compiled information to prepare a cash budget for March, April, and May. All of the company's sales are made on account. The following information has been provided by Spicer's management. Month Credit Sales January $ 300,000 (actual) February 400,000 (actual) March 629,000 (estimated) April 571,000 (estimated) May 800,000 (estimated) The company's collection activity on credit sales historically has been as follows. Collections in the month of the sale 50 % Collections one month after the sale 30 Collections two months after the sale 15 Uncollectible accounts 5 Spicer's total cash expenditures for March, April, and May have been estimated at $1,200,000 (an average of $400, 000 per month). Its cash balance on March 1 of the current year is $500,000. No financing or investing activities are anticipated during the second quarter. Compute Spicer's budgeted cash balance at the ends of March, April, and May.
The management accountant at Miller Merchandising & More, Odail Russell is in the process of preparing the cash budget for the business for the fourth quarter of 2021. It is customary for the business to borrow money during this quarter. Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales on Account Purchases August $ 85,000.00 $ 640,000.00 $ 420,000.00 September $ 70,000.00 $ 550,000.00 $ 550,000.00 October $ 88,550.00 $ 600,000.00 $ 500,000.00 November $ 77,160.00 $ 800,000.00 $ 600,000.00 December $ 174,870.00 $ 500,000.00 $ 450,000.00 i) An analysis of the records shows that trade receivables are settled according to the following credit pattern, in accordance with the credit terms 4/30, n90:50% in the month of sale 30% in the first month following the sale20% in the second month following the saleii) Expected purchases include monthly cash purchases of…
2
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 40,000 Accounts receivable 200,000 Inventory 57,750 Buildings and equipment (net) 350,000 Accounts payable $ 85,125 Common stock 500,000 Retained earnings 62,625 $ 647,750 $ 647,750 Actual sales for December and budgeted sales for the next four months are as follows: December(actual) $ 250,000 January $ 385,000 February $ 582,000 March $ 296,000 April $ 193,000 Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. The company’s gross margin is…
Western Company is preparing a cash budget for June. The company has $10,400 in cash at the beginning of June and anticipates $31,600 in cash receipts and $37,700 in cash payments during June. Western Company has an agreement with its bank to maintain a minimum cash balance of $10,000. As of May 31, the company has no loans outstanding. To maintain the $10,000 required balance, during June the company must:
A Company is preparing a cash budget for June The company has $83,750 cash at the beginning of June and anticipates $102,930 in cash receipts and $116,870 in cash disbursements during June. This company has an agreement with its bank to maintain a cash balance of at least $81 250. As of May 31. the company owes $30,000 to the bank To maintain the $81.250 required balance, during June the company must O Borrow $11 440 O Repay $13,940 O Borrow $30 000 Repay $30,000 O Repay $11,440
1. Prepare a budgeted income statement for the month ended July 31st. Use an absorption format. a. Calculate the estimated operating cycle for the month of July. (Hint: Use 30 days in the numerator to calculate the average collection period and the average sales period.)
The budget director for Rundle Cleaning Services prepared the following list of expected selling and administrative expenses. All expenses requiring cash payments are paid for in the month incurred except salary expense and insurance. Salary is paid in the month following the month in which it is incurred. The insurance premium for six months is paid on October 1. October is the first month of operations, accordingly, there are no beginning account balances. Required a. Complete the schedule of cash payments for S&A expenses by filling in the missing amounts. b. Determine the amount of salaries payable the company will report on its pro forma balance sheet at the end of the fourth quarter. c. Determine the amount of prepaid insurance the company will report on its pro forma balance sheet at the end of the fourth quarter. Complete this question by entering your answers in the tabs below. Req A Complete the schedule of cash payments for S&A expenses by filling in the missing amounts.…
Old Antique Store prepared the following budget information for the month of May: Sales are budgeted at $303,000. All sales are on account and a provision for bad debts is made for each month at three percent of sales for the month. Inventory was $91,000 on April 30; an inventory increase of $17,000 is planned for May 31. All inventory is marked to sell at cost plus 50 percent. Estimated cash disbursements for selling and administrative expenses for the month are $55,000. Depreciation for May is projected at $6,700. Old Antique's budgeted cost of inventory purchases for May is:Multiple Choice $101,000. $151,500. $203,200. $219,000. $202,000.
Glamor Household Furnishings & Appliances is a family-owned furniture store. You are the management accountant of the concern and have been given the task of preparing the cash budget for the business for the quarter ending September 30, 2018. Your data collection has yielded the following: i) Extracts from the sales and purchases budgets are as follows: Month Cash Sales Sales On Account Purchases On Account May $50,000 $480,000 $390,000 June $65,000 $600,000 $360,000 July $43,400 $720,000 $450,000 August $52,800 $640,000 $400,000 September $56,750 $800,000 $500,000 ii) An analysis of the records shows that trade receivables (accounts receivable) for sales on account are settled according to the following credit pattern, in accordance with the credit terms 5/30, n90: 50% in the month of sale 35% in the first month following the sale 15% in the second month following the sale iii) Accounts payable are settled as follows, in accordance with the credit terms – 4/30, n60: 70% in the…
Haresh
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debits Credits Cash $ 44,000 Accounts receivable 203,200 Inventory 58,350 Buildings and equipment (net) 354,000 Accounts payable $ 86,325 Common stock 500,000 Retained earnings 73,225 $ 659,550 $ 659,550 Actual sales for December and budgeted sales for the next four months are as follows: December(actual) $ 254,000 January $ 389,000 February $ 586,000 March $ 300,000 April $ 197,000 Sales are 20% for cash and 80% on credit. All payments on credit sales are collected in the month following sale. The accounts receivable at December 31 are a result of December credit sales. The…