Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company tha 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.

Munoz Pointers Corporation expects to begin operations on January 1, year 1; it will operate as a specialty sales company tha 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.

Excel Applications for Accounting Principles

4th Edition

ISBN:9781111581565

Author:Gaylord N. Smith

Publisher:Gaylord N. Smith

ChapterC: Cases

Section: Chapter Questions

Problem 1C

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?
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?
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…
Rooney 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. Rooney expects sales in January year 1 to total $380,000 and to increase 15 percent per month in February and March. All sales are on account. Rooney expects to collect 67 percent of accounts receivable in the month of sale, 23 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 Rooney 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 Budget…
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.
Adams 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. Adams expects sales in January year 1 to total $350,000 and to increase 15 percent per month in February and March. All sales are on account. Adams expects to collect 66 percent of accounts receivable in the month of sale, 25 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 Adams 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 cash receipts schedule for the first quarter of year 1. Note: Do…
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.
Fanning 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. Fanning expects sales in January year 1 to total $350,000 and to increase 10 percent per month in February and March. All sales are on account. Fanning expects to collect 69 percent of accounts receivable in the month of sale, 21 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 Fanning 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…
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 $330,000 and to increase 20 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, 21 percent in the month following the sale, and 13 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. 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. January…
Spalding 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. Spalding expects sales in January year 1 to total $120,000 and to increase 5 percent per month in February and March. All sales are on account. Spalding expects to collect 70 percent of accounts receivable in the month of sale, 20 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 Spalding 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. X Answer is complete but not entirely correct. Complete this question by entering your answers in the tabs below. Required A Required B Required C Required D Determine the…
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…