Question

Romona Company expects its November sales to be 20​% higher than its October sales of $ 240 comma 000. All sales are on credit and are collected as​ follows: 25​% in the month of the sale and 70​% in the following month. Purchases were $ 70 comma 000 in October and are expected to be $ 150 comma 000 in November. Purchases are paid 35​% in the month of purchase and 65​% in the following month. The cash balance on November 1 is $ 13 comma 700. The cash balance on November 30 will be

Answer 1

The cash balance on November 30 amounts to $155,700

Step-by-step explanation:

Cash balance on November 30 = Beginning balance + Collection of cash from October sales + Collection of cash from November sales - Payments for October Purchases - Payments for November Purchases

where

Beginning balance is $13,700

Collection of cash from October sales = October Sales × % amount collected

= $240,000 × 70%

= $168,000

Collection of cash from November sales = November Sales × % amount collected

= $240,000 × 1.20 × 25%

= $72,000

Payments for October Purchases = October Purchases × % amount paid

= $70,000 × 65%

= $45,500

Payments for November Purchases = November Purchases × % amount paid

= $150,000 × 35%

= $52,500

Putting the values in the above formula

Cash balance on November 30 = $13,700 + $168,000 + $72,000 - $45,500 - $52,500

= $155,700