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

On July 1 Wiggins Associates enters into a contract to provide consulting services to Pennsylvania University (PU). The contract is anticipated to last four months and is intended to achieve significant cost savings at the university. The contract stipulates that PU will pay Wiggins $30.000 at the end of each month, and, if total cost savings reach a specific target. PU will pay an additional $25,000 to Wiggins at the end of the contract Wiggins estimates a 80% chance that cost savings will reach the target Assume that Wiggins estimates uncertain consideration as the most likely amount. Required: Do the following for Wiggins a. Prepare the journal entry on July 31 to record the first month of revenue under the contract b. Assuming total cost savings exceed the target, prepare the journal entry, if any, on October 31 to record receipt of the $25,000 bonus ignore the normal October payment of $30.0001 c. Assuming total cost savings do not reach the target, prepare the journal entry, if…
Bha
Neat Logos buys logo-imprinted merchandise and then sells it to university bookstores. Sales are expected to be $2,009,000 in September, $2,250,000 in October, $2,378,000 in November, and $2,560,000 in December. Neat Logos sets its prices to earn an average 30% gross profit on sales revenue. The company does not want inventory to fall below $440,000 plus 10% of the next month's cost of goods sold. Prepare a cost of goods sold, inventory, and purchases budget for the months of October and November.
Eddie's Bar and Restaurant Supplies expects its revenues and payments for the first part of the year to be: Sales Purchases January $14,000 $18,000 February 20,000 21,300 March 26,000 19,100 April 22,000 22,400 May 18,000 14,700 Seventy percent of the firm's sales are on credit. Past experience shows that 40 percent of accounts receivable are collected in the month after sale, and the remainder is collected in the second month after sale. Prepare a schedule of cash receipts for March, April and May. Eddie's pays its payments in the following month. Eddie's had a cash balance of $2,000 on March 1, which is also its minimum required cash balance. There is an outstanding loan of $2,000 on March 1. Prepare a cash budget for March, April, and May. Can you provide the excel formulas used so then I can do it myself and learn as well, please.
In the coming year, Urayse, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive-motion injuries. The brace will be sold for $11.25 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30 % in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows Budgeted sales units 1st Quarter: 25,000 2nd Quarter: 40,000 Prepare Urayse, Inc.'s, cash receipts budget for the coming year. 3rd Quarter:50,000 4th Quarter: 80,000
Belvedere Bricks manufactures bricks for the construction industry. It estimates that in June, it will sell 70,000 bricks at a retail price of $6.40 per brick. All sales are cash sales. Each brick costs $4.40 to produce. In addition, Belvedere Bricks estimates it will pay in cash $19,000 of general and administrative expenses. The opening cash balance on 1 June is $48,000.Calculate the ending cash balance for Belvedere Brick's cash budget for the month of June. Group of answer choices $121,000 $73,000 $140,000 $169,000 None of the other options
Alpesh
Benson Company, which sells electric razors, had $300,000 of cost of goods sold during the month of June. The company projects a 6 percent increase in cost of goods sold during July. The inventory balance as of June 30 is $19,000, and the desired ending inventory balance for July is $20,000. Benson pays cash to settle 75 percent of its purchases on account during the month of purchase and pays the remaining 25 percent in the month following the purchase. The accounts payable balance as of June 30 was $34,000. Required a. Determine the amount of purchases budgeted for July. b. Determine the amount of cash payments budgeted for inventory purchases in July. a. Budgeted purchases b. Cash payments
The Milton Company currently purchases an average of $18,000 per day in raw materials on credit terms of "net 25." The company expects sales to increase substantially next year and anticipates that its raw material purchases will increase to an average of $22,000 per day. Milton feels that it may need to finance part of this sales expansion by stretching accounts payable. Round your answers to the nearest dollar. Assuming that Milton currently waits until the end of the credit period to pay its raw material suppliers, what is its current level of trade credit? $ If Milton stretches its accounts payable an extra 5 days beyond the due date next year, how much additional short-term funds (that is, trade credit) will be generated? $ solution is incorrect
Medwig Corporation has a DSO of 25 days. The company averages $7,750 in sales each day (all customers take credit). What is the company's average accounts receivable? Assume a 365-day year. Round your answer to the nearest dollar.
In the coming year, Concord, Inc. will be introducing its first product, a wrist brace that protects serious video gamers from repetitive- motion injuries. The brace will be sold for $13.00 to retailers throughout the country. All sales will be made on account. An expected 65% of sales will be collected within the quarter of the sale, and another 30% in the quarter following the sale. The remaining 5% of credit sales are expected to be uncollectible. The sales budget for the coming year is as follows: 1st Quarter 2nd Quarter 3rd Quarter 4th Quarter Budgeted sales units 29,000 41,000 57,000 77,000 Prepare Concord, Inc's cash receipts budget for the coming year. (Enter answers in necessary fields only. Leave other fields blank. Do not enter 0. Round "Budgeted sale price" and "Cash Receipts Budgets" answers to 2 decimal places, eg. 52.75 and all other answers to 0 decimal places, e.g. 5,275.)
A. What are the expected revenues for S2BU for each month, April through September? Revenues are recorded in the month of the occasion. B. What are the expected cash receipts for each month, April through July?