Answer: $65,500
.
.
Working note - Computation of ending cash balance | ||
Beginning cash balance on September 1 | $7,800 | |
Add: Cash collections in September | ||
From the sales made in August (Following month) [$195,000 x 70%] | $136,500 | |
From the sales made in September (Same month) [($195,000 x 120%) x 30%] | $70,200 | |
Total cash collections | $206,700 | |
Less: Cash payments in September | ||
For the purchases made in August (Following month) [$145,000 x 80%] | ($116,000) | |
For the purchases made in September (Same month) [$165,000 x 20%] | ($33,000) | |
Total cash payments | ($149,000) | |
Ending cash balance on September 30 [Beginning cash balance + Total cash collections - Total cash payments] | $65,500 |
Walter Enterprises expects its September sales to be 20 % higher than its August sales of...
Walter Enterprises expects its September sales to be 25% higher than its August sales of $170,000. Purchases were $120,000 in August and are expected to be $140,000 in September. All sales are on credit and are collected as follows: 35% in the month of the sale and 65% in the following month. Merchandise purchases are paid as follows: 25% in the month of purchase and 75% in the following month. The beginning cash balance on September 1 is $7,300. The...
Worton Distributing expects its September sales to be 20% higher than its August sales of $168,000. Purchases were $118,000 in August and are expected to be $138,000 in September. All sales are on credit and are expected to be collected as follows: 40% in the month of the sale and 60% in the following month. Purchases are paid 20% in the month of purchase and 80% in the following month. The cash balance on September 1 is $28,000. The ending...
Garda purchased $570,000 of merchandise in August and expects to purchase $790,000 in September. Merchandise purchases are paid as follows: 20% in the month of purchase and 80% in the following month. Compute cash payments for merchandise for September. GARDA Cash payments for Merchandise (Budgeted) For Month Ended September 30 Cash payments for September purchases Cash payments for August purchases Total budgeted cash payments $ 0
Garda purchased $570,000 of merchandise in August and expects to purchase $790,000 in September. Merchandise purchases are paid as follows: 20% in the month of purchase and 80% in the following month. Compute cash payments for merchandise for September. GARDA Cash payments for Merchandise (Budgeted) For Month Ended September 30 Cash payments for September purchases Cash payments for August purchases Total budgeted cash payments Foyert Corp. requires a minimum $6,300 cash balance. If necessary, loans are taken to meet this...
During the last week of August, Oneida Company's owner approaches the bank for a $100,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,000. The owner plans to increase the store's inventory by $80,000 during September and needs the loan to pay for inventory acquisitions. The bank's loan officer needs more information about Oneida's ability to repay the loan and asks the owner to forecast the...
Garda purchased $680,000 of merchandise in August and expects to purchase $620,000 in September Merchandise purchases are paid as follows: 25% in the month of purchase and 75% in the following month. Compute cash payments for merchandise for September. GARDA Cash payments for Merchandise (Budgeted) For Month Ended September 30 Cash payments for September purchases Cash payments for August purchases Total budgeted cash payments
Romona Company expects its November sales to be 15% higher than its October sales of $210,000. Al sales are on credit and are collected as follows: 30% in the month of the sale and 65% in the following month. Purchases were $100,000 in October and are expected to be $190,000 in November. Purchases are paid 30% in the month of purchase and 70% in the following month. The cash balance on November 1 is $13,100. The cash balance on November...
Enterprises was organized on July 1, 2019. Projected Sales for each of the first four months of operations are as follows: July August September October Sales (in dollars) 120,000 160,000 200,000 210,000 The company expects to sell 20% of its merchandise for cash. Of sales on account, 30% are expected to be collected in the month of the sale, 50% in the month following the sale, and the remainder in the second month following the sale. Compute the budgeted amount...
Kelsey is preparing its master budget for the quarter ended September 30. Budgeted sales and cash payments for merchandise for the next three months follow. Budgeted July 562,450 43.600 August $81,500 32.009 September $49,609 3 2.30 Cash payments for nerchandise Sales are 20% cash and 80% on credit. All credit sales are collected in the month following the sale. The June 30 balance sheet Includes balances of $13.900 in cash, $51,100 in accounts receivable; $6,100 in accounts payable, and a...
Required: 1. Prepare a schedule of expected cash collections for July August, and September 2-a. Prepare a merchandise purchases budget for July August, and September. Also compute total merchandise purchases for the quarter ended September 30. 2.b. Prepare a schedule of expected cash disbursements for merchandise purchases for July, August, and September 3. Prepare an income statement that computes net operating income for the quarter ended September 30, 4. Prepare a balance sheet as of September 30, Complete this question...