Dan Barnes, financial manager of SKI casts, is requesting a line of credit from the company’s bank. The company has produced the following sales estimates: $71,218 in November, $68,212 in De
Dan Barnes, financial manager of SKI casts, is requesting a line of credit from the company’s bank. The
company has produced the following sales estimates: $71,218 in November, $68,212 in December,
$65,213 in January, $52,475 in February, $42,909 in March, $30,524 in April, $44,567 in May,
$54,590 in June, $62,341 in July, and $70,132 in August. Collection estimates are as follows: 20
percent within the month of sale, 70 percent in the month following the sale, and 10 percent in the
second month following the sale. The company allows a 2 percent discount on payments made
during the month of sales. Plaster supplies expense is estimated as 85 percent of sales two months
from now. Other relevant information is as follows:
– Payments for plaster supplies is made during the month following the one in which these costs
have been incurred.
– Wages and salaries will amount to approximately $6,691 in January, $5,471 in February, $4,316
in March, $3,126 in April, $4,511 in May, and $5,629 in June.
– Lease payments under long-term lease contracts will be $2,500 a month.
– Depreciation charges will be $600 a month.
– Income tax payments of $8,000 will be due in March and June;
– A progress payment of $10,000 on a new building must be paid in April.
– Cash on hand on January 1 will amount to $3,000, and a minimum cash balance of $1,500 will be
maintained throughout the cash budget period.
a. What is the maximum loan that the company will require between January and June?