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 CFIN

6th Edition

ISBN:9781337671743

Author:BESLEY

Publisher:BESLEY

Chapter15: Managing Short-term Assets

Section: Chapter Questions

Problem 1PROB

See similar textbooks

Similar questions

If the sales forecast estimates that 50,000 units of product will be sold during the following year, should the factory plan on manufacturing 50,000 units in the coming year? Explain.
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?
AB has generated $150,000 in sales during the past few months and expected the level of sales willcontinue for the next year. Based on the firm’s past experience, 30% of the sales will be collected in the month of the sale and these customers will take the 4% cash discount offered for early payment. 70% of the remaining sales will becollected one month after the sale. AB normally purchases and pays for raw materials which is 70% of sales, in the same month the finished goods are sold. Wages of AB employees represents 15% of sales and monthly rent is $10,000. At present, the firm has no cash but its target balance is $6,000. ConstructAB'S cash budget for the next three months.
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
Trapp Co. was organized on August 1 of the current year. Projected sales for the first three months are: August - $100,000; September - $185,000; October - $225,000. The company expects to sell 40% of its merchandise for cash. Of the sales on account, one-third is expected to be collected in the month of the sale and the remainder in the following month. 1.) What would be the amount of the cash sales for the month of August? 2.) What would be the amount of the cash sales for the month of September?
Vertical Ladder Company (VLC) forecasts its sales for January through April will be $40,000, $60,000, $100,000, and $90,000, respectively. All sales are made on credit, and it is expected that 40 percent of sales will be collected in the month of the sale and the remainder will be collected the month following the sale. Customers who pay in the month of the sale will take the 2 percent cash discount VLC offers for paying early. VLC normally purchases and pays for raw materials, which cost 45 percent of sales, one month prior to selling the finished products. Employees' wages represent 20 percent of sales and rent is $6,000 per month. At the beginning of February, VLC expects to have $4,000 in cash, which is $1,000 greater than its target cash balance. Using the information provided, construct VLC's cash budget for February and March. Round your answers to the nearest dollar. Use a minus sign to enter a negative value, if any. If your answer is zero, enter "0". February March…
Danner Inc. has projected sales to be $100,000 in June, $90,000 in July, and $70,000 in August. Danner collects 50% of a month's sales in the month of sale, 30% in the month following the sale, and 18% in the second month following the sale. Cash collections in August would be
Nazmi Shah Sdn Bhd wishes to expand its business by opening an additional two more stores and needs to apply a bank loan. Therefore, there is needed to prepare an acceptable three-month financial plan for January until March. The following are sales and purchase information: 40 percent of the sales incurred are cash sales, while the balance are credit sales and will be collected equally for the second and third month after the sales. Nazmi Shah pays 50 percent of its purchase immediately and the balance will be paid in the month after purchases. Additional information: i. Labor expenses are 10 percent of the current month’s sales.ii. Overhead expenses are recorded at RM10,000 per month.iii. Interest payments of RM8,000 are due in January and March.iv. A cash dividend of RM40,000 is scheduled to be paid in February.v. Depreciation expenses are RM10,000 per month.vi. Tax payment of RM25,000 are due in January and April.vii. Purchase a new asset of RM40,000 in January…
Star Company was organized on August 1 of the current year. Projected sales for the next three months are as follows: August $250,000 September 200,000 October 275,000 The company expects to sell 50% of its merchandise for cash. Of the sales on credit, 30% are expected to be collected in the month of the sale and the remainder in the following month. What is Star Company expected cash collection for September?
Gibson 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. Gibson expects sales in January year 1 to total $240,000 and to increase 20 percent per month in February and March. All sales are on account. Gibson expects to collect 65 percent of accounts receivable in the month of sale, 21 percent in the month following the sale, and 14 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 Gibson 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.
J.TOY Inc., was organized on August 1 of the current year. Projected sales for the ا ی و ن ن و ر می و ی و و و و و ی next three months are as follows: -August : $120,000 -September : $200,000 -October : $230,000 The J.TOY expects to sell 40% of its merchandise for cash. Of the sales on account, 25% are expected to be collected in the month of the sale and the remainder in the following month. Prepare a schedule indicating total cash collections for August, September, and October.
UM Berhad has projected sales for the first six months of 2020 as follows: Month RM January 100,000 February 120,000 March 150,000 April 300,000 May 275,000 June 200,000 Of the firm’s sales, 50% is collected in the month of sale, 25% one month after sales and the remaining 25% two months after sales. UMCCED Berhad purchases raw materials equal to 70% of sales and it makes its purchases one month in advance of sales. The supplier is paid one month after the purchases. The firm incurs and pays a monthly rent expense of RM3,000. General and administrative expenses of RM20,000 are recognised and are paid monthly. Tax prepayments of RM22,000 are made each quarter beginning in March. The firm’s ending cash balance as at 28 February 2020 was RM30,000. Required: Prepare a monthly cash budget for March until May 2020.