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

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

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