The Cannon Ball has projected its first quarter sales at $11,200, second quarter

Question

The Cannon Ball has projected its first quarter sales at $11,200, second quarter sales at $10,900, and third quarter sales at $13,300. The firm's cost of goods sold is equal to 71 percent of the next quarter's sales. The accounts receivable period is 30 days and the accounts payable period is 60 days. At the beginning of the first quarter, the firm has an accounts receivable balance of $2,800 and an accounts payable balance of $6,300. The firm pays $1,500 a month in cash expenses and $200 a month in taxes.

At the beginning of the first quarter, the cash balance is $530 and the short-term loan balance is zero. During the first quarter, the firm is planning on spending $2,600 for some new equipment. The firm maintains a minimum cash balance of $20.

Assume each month has 30 days. What is the cumulative cash surplus (deficit) at the end of the first quarter, prior to any short-term borrowing?

Explanation / Answer

Collections = $2,800+(60/90)*($11,200) = $10,266.67

Payments = $6,300+(30/90)*0.71*$10,900) = $8,879.67

Net Cash flows = $10,266.67-$8,879.67-$1,500-$200-$2,600 = ($2,913)

Cumulative deficit = $530-$2,913-$20 = ($2,403)

Related Questions

Navigate

• Browse (All)
• Browse T
• Subjects

Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.