Campbell Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Campbell expects sales in January year 1 to total $360,000 and to increase 10 percent per month in February and March. All sales are on account. Campbell expects to collect 66 percent of accounts receivable in the month of sale, 22 percent in the month following the sale, and 12 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Campbell will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1.

Campbell Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Campbell expects sales in January year 1 to total $360,000 and to increase 10 percent per month in February and March. All sales are on account. Campbell expects to collect 66 percent of accounts receivable in the month of sale, 22 percent in the month following the sale, and 12 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Campbell will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1.

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

Dick's Draperies has gross sales $15,000 per month, half of which are on credit (paid with 30 days). Monthly expenses are as follows: wages, $3,000; utilities and rent, $2,000; advertising, $300; and miscellaneous, $500, inventory is purchased every three months and totals $30,000 for each order. Yearly expenses paid for in advance are insurance of $1,000 and a rent deposit of $700. Prepare a six-month cash flow statement for Dick's Draperies. What advice would you give this business based on the cash flow statement?
69) Western Company expects the following credit sales for the first five months of the year: January, $43,000; February, $58,000; March, $48,000; April, $54,000, May $58,000. Experience has shown that payment for the credit sales is received as follows: 60% in the month of sale, 25% in the first month after sale, 10% in the second month after sale, and the remainder is uncollectible. How much cash can Western Company expect to collect in March as a result of credit sales (current and past)? A) $28,800. B) $42,600. C) $48,000. D) $47,600. E) $41,100.
Sara is considering whether to open a gadgets shop. She provided you, as a consultant, the following information: Sales of $60,000 and $72,000 are expected for July and August, respectively. All goods are sold on account. The collection pattern for Accounts Receivable is 80 percent in the month of sale and 20 percent in the month following the sale. Purchases of $40,000 and $54,000 are expected for July and August. The payment pattern for purchases is 70 percent in the month of purchase, 30 percent in the month following the purchase. Other monthly expenses are $8,000, which includes $2000 of depreciation. All operating expenses are paid in the month of their incurrence. $2,000 of cash is available on August 1, 2021. Required: Prepare the cash collection budget for the two months ending August 31, 2021 Prepare the cash budget for the two months ending August 31, 2021
Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Munoz expects sales in January year 1 to total $270,000 and to increase 15 percent per month in February and March. All sales are on account. Munoz expects to collect 69 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 7 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Munoz will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the amount of accounts receivable as of March 31, year 1. (Do not…
Sherman Company provides services in the retail flooring industry. The following information is available for 20x5: Twenty percent of the firm's services are for cash and the remaining 80% are on account. Of the credit services, 40% are collected in the month that the service is provided, with the remaining 60% collected in the following month. Services provided in January are expected to total $250,000 and grow at the rate of 5% per month thereafter. January's cash collections are expected to be $240,400, and month-end receivables are forecast at $120,000. Monthly cash operating costs and depreciation during the first quarter of the year are approximated at $250,000 and $15,000, respectively. Sherman's December 31, 20x4 balance sheet revealed accounts payable balances of $28,000. This amount is related to the company's operating costs and is expected to grow to $36,000 by the end of 20x5's first quarter. All operating costs are paid within 30 days of incurrence. Company policy…
Lakeside Components wishes to purchase parts in one month f although sales for June are estimated to total 11,000 parts. Total Parts are purchased at a wholesale price of $15. The supplier ha percent of the purchase price in the month when the parts are 15,000 parts in May. Required: a. Estimate purchases (in units) for June and July. b. Estimate the cash required to make purchases in June and Ju Complete this question by entering your answers in the ta Required A Required B Estimate purchases (in units) for June and July. Merchandise to be purchased in units June July 15,000
Thnks sir help
ABC Company manufactures and sells lighting fixtures. Estimated sales for the next three months are; September – $350,000 October – $500,000 November – $400,000 Sales for August were $400,000. All sales are on account, ABC Company estimates that 60% of the accounts receivable are collected in the month of sale with the remaining 40% collected the following month. The units sell for $30 each. The cash balance for September 1 is $100,000. Generally, 60% of purchases are due and payable in the month of purchase with the remainder due the following month. Purchase cost per unit for materials is $18. The company maintains an end-of-the-month inventory of 1,000 units plus 10% of next month's unit sales. In addition to the information given, selling and administrative expenses paid in cash are $120,000 per month. Requirement: Prepare a monthly cash budget for September and October for ABC Company.
Navigator sells GPS trackers for $33 each. It expects sales of 3,387 units in quarter 1 and a 7% increase each subsequent quarter for the next 8 quarters. Calculate the total sales for the first four quarters (year 1). Round to the nearest penny, two decimal places.
Miggy Co. projects the following monthly revenues for next year: 250,000 January February March 100,000 500,000 July August September October 275,000 300,000 350,000 452,000 450,000 Аpril May 557,000 300,000 November 400,000 525,000 June December Miggy's terms are net 30 days. The company typically receives payment on 80% of sales the month following the sale and 17% is collected two months after the sale. Approximately 3% of sales are deemed bad debt. What amount represents the expected cash collection in the second calendar quarter of next year? a. 1,405,540 b. 1,293,630 c. 1,320,540 d. 1,234,250
Schedule of cash payments for a service company Horizon Financial Inc. was organized on February 28. Projected selling and administrative expenses for each of the first three months of operations are as follows: March April May Depreciation, insurance, and property taxes represent $19,000 of the estimated monthly expenses. The annual insurance premium was paid on February 28, and property taxes for the year will be paid in June. 61% 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. $88,600 82,400 75,000 Prepare a schedule of cash payments for selling and administrative expenses for March, April, and May. Horizon Financial Inc. Schedule of Cash Payments for Selling and Administrative Expenses For the Three Months Ending May 31 March April March expenses: Paid in March Paid in April April expenses: Paid in April Paid in May May expenses: Paid in May Total cash payments May
9 Rundle Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company that sells laser pointers over the Internet. Rundle expects sales in January year 1 to total $370,000 and to increase 10 percent per month in February and March. All sales are on account. Rundle expects to collect 70 percent of accounts receivable in the month of sale, 21 percent in the month following the sale, and 9 percent in the second month following the sale. Required a. Prepare a sales budget for the first quarter of year 1. b. Determine the amount of sales revenue Rundle will report on the year 1 first quarterly pro forma income statement. c. Prepare a cash receipts schedule for the first quarter of year 1. d. Determine the amount of accounts receivable as of March 31, year 1. Complete this question by entering your answers in the tabs below. Required Required Required A B Required D с Prepare a sales budget for the first quarter of year 1. Sales Budget…