Walton 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 Walton expects sales in January year 1 to total $260,000 and to Increase 15 percent per month in February and March All sales are on account. Walton expects to collect 67 percen of accounts receivable in the month of sale, 21 percent in the month following the sale, and 12 percent in the second month following the sole Required a. Prepare a sales budget for the first quarter of year 1 b. Determine the amount of sales revenue Walton 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, your 1 Complete this question by entering your answers In Use tabs below. Required A Required B Required C Required D Prepare a cash receipts schedule for the first quarter of year (out road intermediate calculations, Round your final answers to the nearest whole dollar) Schedule of Cash Receipts Receipts from January sales Receipts from February sales Receipts from March sales Total January February March

Walton 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 Walton expects sales in January year 1 to total $260,000 and to Increase 15 percent per month in February and March All sales are on account. Walton expects to collect 67 percen of accounts receivable in the month of sale, 21 percent in the month following the sale, and 12 percent in the second month following the sole Required a. Prepare a sales budget for the first quarter of year 1 b. Determine the amount of sales revenue Walton 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, your 1 Complete this question by entering your answers In Use tabs below. Required A Required B Required C Required D Prepare a cash receipts schedule for the first quarter of year (out road intermediate calculations, Round your final answers to the nearest whole dollar) Schedule of Cash Receipts Receipts from January sales Receipts from February sales Receipts from March sales Total January February March

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

Chapter21: Cash Budgeting (cashbud)

Section: Chapter Questions

Problem 1R: On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is...

See similar textbooks

Similar questions

Earthies Shoes has 55% of its sales in cash and the remainder on credit. Of the credit sales, 70% is collected in the month of sale, 15% is collected the month after the sale, and 10% is collected the second month after the sale. How much cash will be collected in June if sales are estimated as $75,000 in April, $65,000 in May, and $90,000 in June?
Fitbands estimated sales are: What are the balances in accounts receivable for January, February, and March if 65% of sales is collected in the month of sale, 25% is collected the month after the sale, and 10% is second month after the sale?
Gear Up Co. pays 65% of its purchases in the month of purchase, 30% in the month after the purchase, and 5% in the second month following the purchase. What are the cash payments if it made the following purchases in 2018?
Cash collections for Renew Lights found that 65% of sales were collected in the month of sale, 25% was collected the month after the sale, and 10% was collected the second month after the sale. Given the sales shown, how much cash will be collected in March and April?
Negus Enterprises has an inventory conversion period of 50 days, an average collection period of 35 days, and a payables deferral period of 25 days. Assume that cost of goods sold is 80% of sales. What is the length of the firm’s cash conversion cycle? If annual sales are $4,380,000 and all sales are on credit, what is the firm’s investment in accounts receivable? How many times per year does Negus Enterprises turn over its inventory?
My Aunts Closet Store collects 60% of its accounts receivable in the month of sale and 35% in the month after the sale. Given the following sales, how much cash will be collected in March?
Nonnas Re-Appliance Store collects 55% of its accounts receivable in the month of sale and 40% in the month after the sale. Given the following sales, how much cash will be collected in February?
Amusement tickets estimated sales are: What are the balances in accounts receivable for April, May, and June if 60% of sales are collected in the month of sale, 30% are collected the month after the sale, and 10% are collected the second month after the sale?
On January 1, Sweet Pleasures, Inc., begins business. The company has 14,000 cash on hand and is attempting to project cash receipts and disbursements through April 30. On May 1, a note payable of 10,000 will be due. This amount was borrowed on January 1 to carry the company through its first four months of operation. The unit purchase cost of the companys single product, a box of Sweet Pleasures chocolates, is 12. The unit sales price is 28. Projected purchases and sales in units for the first four months are: Sales terms call for a 5% discount if paid within the same month that the sale occurred. It is expected that 50% of the billings will be collected within the discount period, 25% by the end of the month after purchase, 19% in the following month, and 6% will be uncollectible. Approximately 60% of the purchases are paid for in the month purchased. The rest are due and payable in the next month. Total fixed marketing and administrative expenses for each month include cash expenses of 5,000 and depreciation on equipment of 2,000. Variable marketing and administrative expenses total 6 per unit sold. All marketing and administrative expenses are paid as incurred. REQUIREMENT You have been asked to prepare a cash budget for the next four months to see if the loan can be repaid. Review the worksheet CASHBUD that follows these requirements. The problem data have already been entered in the Data Section of the worksheet.
Thornton 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. Thornton expects sales in January year 1 to total $300,000 and to Increase 15 percent per month in February and March. All sales are on account. Thornton expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 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 Thornton 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 Prepare a sales budget for the first quarter of year 1. Sales…
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…
Baird 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. Baird expects sales in January Year 1 to total $340,000 and to increase 20 percent per month in February and March. All sales are on account. Baird expects to collect 66 percent of accounts receivable in the month of sale, 24 percent in the month following the sale, and 10 percent in the second month following the sale. Required Prepare a sales budget for the first quarter of Year 1. Determine the amount of sales revenue Baird will report on the Year 1 first quarterly pro forma income statement. Prepare a cash receipts schedule for the first quarter of Year 1. Determine the amount of accounts receivable as of March 31, Year 1.