Ch 4 Prob Fin 410
Carmen Yost
Feburary 9th 2015
Fin 410
Chapter 4 Problems
Dr. Terry Dowdy
Resource: Ch. 4 of Foundations of Financial Management
Complete Problems 16, 19, & 25 in Ch. 4 of Foundations of Financial Management
16.
J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year as:
September (actual)
$70,000
Fourth Quarter
October
$60,000
November
55,000
December
80,000
Schedule of cash receipts (LO2)
Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected.
Prepare a schedule of cash receipts for J. Lo’s Clothiers covering the fourth quarter (October through December).
Oct
30% same month 18,000
60% next month 36,000
Total for month 54,000
Nov
30% same month 16,500
60% next month 33,000
Total for month 49,500
Dec
30% same month 24,000
60% next month 48,000
Total for month 72,000
19. The Elliot Corporation has forecast the following sales for the first seven months of the year:
January
$12,000 May
$12,000
February
16,000
June
20,000
March
18,000
July
22,000
April
24,000
Schedule of cash payments (LO2)
Monthly material purchases are set equal to 20 percent of forecasted sales for the next month. Of the total material costs, 40 percent are paid in the month of purchase and 60 percent in the following month. Labor costs will run $6,000 per month, and fixed overhead is $3,000 per month. Interest payments on the debt will be $4,500 for both March and June. Finally, Elliot’s salesforce will receive a 3 percent commission on total sales for the first six months of the year, to be paid on June 30.
Prepare a monthly summary of cash payments for the six-month period from January through June. (Note: Compute prior December purchases to help get total material payments for January.)
Jan 2,720 6,000 3,000 0 0 11,720
Feb 3,360 6,000 3,000 0 0 12,360
Mar 4,080 6,000 3,000 4,500 0 17,580
Apr 3,840 6,000 3,000
Feburary 9th 2015
Fin 410
Chapter 4 Problems
Dr. Terry Dowdy
Resource: Ch. 4 of Foundations of Financial Management
Complete Problems 16, 19, & 25 in Ch. 4 of Foundations of Financial Management
16.
J. Lo’s Clothiers has forecast credit sales for the fourth quarter of the year as:
September (actual)
$70,000
Fourth Quarter
October
$60,000
November
55,000
December
80,000
Schedule of cash receipts (LO2)
Experience has shown that 30 percent of sales are collected in the month of sale, 60 percent in the following month, and 10 percent are never collected.
Prepare a schedule of cash receipts for J. Lo’s Clothiers covering the fourth quarter (October through December).
Oct
30% same month 18,000
60% next month 36,000
Total for month 54,000
Nov
30% same month 16,500
60% next month 33,000
Total for month 49,500
Dec
30% same month 24,000
60% next month 48,000
Total for month 72,000
19. The Elliot Corporation has forecast the following sales for the first seven months of the year:
January
$12,000 May
$12,000
February
16,000
June
20,000
March
18,000
July
22,000
April
24,000
Schedule of cash payments (LO2)
Monthly material purchases are set equal to 20 percent of forecasted sales for the next month. Of the total material costs, 40 percent are paid in the month of purchase and 60 percent in the following month. Labor costs will run $6,000 per month, and fixed overhead is $3,000 per month. Interest payments on the debt will be $4,500 for both March and June. Finally, Elliot’s salesforce will receive a 3 percent commission on total sales for the first six months of the year, to be paid on June 30.
Prepare a monthly summary of cash payments for the six-month period from January through June. (Note: Compute prior December purchases to help get total material payments for January.)
Jan 2,720 6,000 3,000 0 0 11,720
Feb 3,360 6,000 3,000 0 0 12,360
Mar 4,080 6,000 3,000 4,500 0 17,580
Apr 3,840 6,000 3,000