Lee Verly will be opening his company called LV Company in January of the next year. He predicts that January, February and March will generate $105,000, $140,000 and $105,000 worth of sales respectively. The company expects to sell 40% of its products for cash. 55% of the sales on account are expected to be collected in the month of the sale, 25% in the month following the sale and the remainder in the following month. Prepare the cash receipts section of the cash budget. Do not enter dollar signs or commas in the input boxes. Round your answers to the nearest whole number. LV Company Cash Receipts For January, February and March January Cash sales 42000 Collections from credit customers $34650 Total Cash Receipts 76650 February $56000 March ✓ $42000 x x

Lee Verly will be opening his company called LV Company in January of the next year. He predicts that January, February and March will generate $105,000, $140,000 and $105,000 worth of sales respectively. The company expects to sell 40% of its products for cash. 55% of the sales on account are expected to be collected in the month of the sale, 25% in the month following the sale and the remainder in the following month. Prepare the cash receipts section of the cash budget. Do not enter dollar signs or commas in the input boxes. Round your answers to the nearest whole number. LV Company Cash Receipts For January, February and March January Cash sales 42000 Collections from credit customers $34650 Total Cash Receipts 76650 February $56000 March ✓ $42000 x x

EBK CONTEMPORARY FINANCIAL MANAGEMENT

14th Edition

ISBN:9781337514835

Author:MOYER

Publisher:MOYER

Chapter16: Working Capital Policy And Short-term Financing

Section: Chapter Questions

Problem 13P

See similar textbooks

Similar questions

Lee Verly will be opening his company called LV Catering in January of the next year. He predicts that January, February and March will generate $170,000, $120,000 and $190,000 worth of sales respectively. The company expects to sell 15% of its products for cash. Of the sales on account, 50% are expected to be collected in the month of the sale, 25% in the month following the sale and the remainder in the following month. Prepare the cash receipts section of the cash budget. Do not enter dollar signs or commas in the input boxes. Round your answers to the nearest whole number. LV Catering Cash Receipts For January, February and March January February March Cash sales $Answer $Answer $Answer Collections from credit customers $Answer $Answer $Answer Total Cash Receipts $Answer $Answer $Answer Please don't provide answer in image format thank you
Chatsworth Company Month Expected Sales July $40,000 August $50.000 September $30,000
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…
A company is launching a new sales initiative and expects sales of $446,838 during the first year, and the gross profit margin to be 25%. To prepare for this, they plan to acquire 49 days worth of inventory. Their vendor will allow 48 days to pay its invoices. The company plans to sell only on account to its customers, so sales will be entirely credit based, and the average invoice is expected to take 44 days to collect. What amount of net working capital should be included in the initial investment? Enter your answer as a monetary amount rounded to four decimal places, but without the currency symbol. For example, if your answer is $90.1234, enter 90.1234 Type your answer...
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…
Betta Jets, a toy wholesaler, is hoping to expand into manufacturing its own products. The business owners have provided you with the following information: All sales are on credit. The company collects 70% in the month following the sale and 30% two months following the sale. All purchases of stock are paid for one month after the purchase. Equipment costing $250,000 is expected to be acquired and paid for in July. The selling and distribution expenses are $48 000 each month. Administrative expenses are $42 000 per month. This includes $5 000 of depreciation expense. Selling Expenses and Administrative Expenses are paid in the month they are incurred. The cash balance on 1 July 2022 is $28 000. The following sales and purchases data in 2022 have been compiled for the preparation of the budget: April May June July $ $ $ $ Purchases 300 000 360 000 340 000 400 000 Sales 800 000 860 000 840 000 880 000 REQUIRED: Prepare…
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…
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 $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.
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.
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