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 ending cash balance on September 30 would be:
September Sales = 170000*1.25 = 212500
Collection from customer = (212500*35%+170000*65%) = 184875
Cash paid to supplier = (140000*25%+120000*75%) = 125000
Beginning Cash balance on September | 7300 |
Add: Collection from customer | 184875 |
Less: Cash paid to supplier | -125000 |
Ending Cash balance on September | 67175 |
Walter Enterprises expects its September sales to be 25% higher than its August sales of $170,000....
Walter Enterprises expects its September sales to be 20 % higher than its August sales of $195,000 Purchases were $145,000 in August and are expected to be $165,00C in September. All sales are on credit and are collected as follows: 30 % in the month of the sale and 70 % in the following month. Merchandise purchases are paid as follow 20% in the month of purchase and 80 % in the following month. The beginning cash balance on September...
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...
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...
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
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...
During the last week of August, Oneida Company's owner approaches the bank for a $98,500 loan to be made on September 2 and repaid on November 30 with annual interest of 15%, for an interest cost of $3,694. The owner plans to increase the store's inventory by $60,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...
Question 8 0.6 points Save Ans Romona Company expects its November sales to be 15% higher than its October sales of $220,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 $150,000 in October and are expected to be $100,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...
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...
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...
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