Prepare a cash collections budget for the first quarter

Assignment Help Financial Management

Reference no: EM131967473

LaChutt Corporation has found that 80?% of its sales in any given month are credit sales, while the remainder are cash sales. Of the credit sales, LaChut Corporation has experienced the following collection? pattern:

20% received in the month of the sale

40% received in the month after the sale

22% received two months after the sale

18% of the credit sales are never received.

November sales for last year were 85,000?, while December sales were $110,000.

Projected sales for the next three months are as? follows:

January sales. . . . . . . . . . . . . .	$150,000
February sales. . . . . . . . . . . . .	$115,000
March sales. . . . . . . . . . . . . . .	$190,000

Requirement

Prepare a cash collections budget for the first quarter, with a column for each month and for the quarter. (Round your answers to the nearest whole dollar.

Reference no: EM131967473

Questions Cloud

What is meant by comprehensive income : What is meant by Comprehensive Income? How should Comprehensive Income be presented in the financial statements?

What is the required return : If the stock currently sells for $50 per share, what is the required return?

What is the current price : (a) If investors require a 10 percent return on The Jackson-Timberlake Wardrobe Co. stock, what is the current price?

What amount should willem report as current liabilities : Willem Co. reported the following liabilities at December 31, 20X1: What amount should Willem report as current liabilities at December 31, 20X1?

Prepare a cash collections budget for the first quarter : LaChutt Corporation has found that 80?% of its sales in any given month are credit sales, while the remainder are cash sales.

What was the most recent dividend per share paid : If the company maintains a constant 3.7 percent growth rate in dividends, what was the most recent dividend per share paid on the stock?

How many units must be sold to break even for the month : How many units must be sold to break even for the month? How many units must be sold to earn a profit of $240,000 for the month?

What is the current share price : Required: If the required return on this stock is 10 percent, what is the current share price?

How much will be in the account at the end of 12 months : You are a landlord and have decided for your tenants to contribute $1,000 a month towards rent payable on the first day of each month.

User Account

All Pages