Management wants to know if there will be a need for short-term
financing in February. Essential information is as follows:
- Estimated sales for January and February are $1 million and
$700,000, respectively.
- Fifty percent of sales are for cash and 50 percent are credit
sales that are collected the next month.
- Cash disbursements that vary with sales are 30 percent of
sales.
- Fixed operating disbursements are $300,000 a month.
- Depreciation expense is $60,000 a month.
- A tax payment of $80,000 is due in January.
- A bond payment of $250,000 is owed and will be due in
February.
- The cash balance at the beginning of January is $16,000.
- Management seeks a minimum cash balance of $13,000.
- December credit sales were $110,000.
Round your answers to the nearest dollar. Use a minus sign to
enter shortage of cash, if any.
|
January |
February |
Excess (shortage) of cash |
$ |
$ |
The firm will or will not need short-term funds in February.