Calculation of cash receipts from sales | |||||||
Collected in | Nov. 30 | ||||||
Total sales | Uncollectible | August | September | October | November | Accounts receivable | |
Credit sales from: | |||||||
August | $ 180,000 | $ 7,200 | $ 41,400 | $ 84,600 | $ 34,200 | $ 12,600 | |
September | $ 230,000 | $ 52,900 | $ 108,100 | $ 43,700 | $ 25,300 | ||
October | $ 435,000 | $ 100,050 | $ 204,450 | $ 130,500 | |||
November | $ 450,000 | $ 103,500 | $ 346,500 | ||||
Totals | $ 1,295,000 | $ 7,200 | $ 41,400 | $ 137,500 | $ 242,350 | $ 364,250 | $ 502,300 |
Calculation of cash payments for merchandise | |||||||
Paid in | Nov. 30 | ||||||
Total purchases | August | September | October | November | Accounts payable | ||
Purchases from: | |||||||
August | $ 115,000 | $ 46,000 | $ 69,000 | ||||
September | $ 225,000 | $ 90,000 | $ 135,000 | ||||
October | $ 210,000 | $ 84,000 | $ 126,000 | ||||
November | $ 196,000 | $ 196,000 | |||||
Totals | $ 746,000 | $ 46,000 | $ 159,000 | $ 219,000 | $ 322,000 |
Cash budget:
ONEIDA COMPANY | |||
Cash Budget | |||
For September, October, and November | |||
September | October | November | |
Beginning cash balance | $ 4,000 | $ 141,500 | $ 162,200 |
Cash receipts: | |||
Receipts from bank loan | $ 110,000 | ||
Collection on accounts receivable | $ 137,500 | $ 242,350 | $ 364,250 |
Total cash available (A) | $ 251,500 | $ 383,850 | $ 526,450 |
Cash payments: | |||
Payment on accounts payable | $ 46,000 | $ 159,000 | $ 219,000 |
Payroll | $ 19,600 | $ 22,050 | $ 23,900 |
Rent | $ 10,000 | $ 10,000 | $ 10,000 |
Other cash expenses | $ 34,400 | $ 30,600 | $ 20,150 |
Repayment of bank loan | $ 110,000 | ||
Interest on bank loan | $ 4,675 | ||
Total cash payments (B) | $ 110,000 | $ 221,650 | $ 387,725 |
Ending cash balance (A) - (B) | $ 141,500 | $ 162,200 | $ 138,725 |
Explanations:
Given that
Allocated as per the above.
Note:
Nov.30 Accounts receivable = Sales - Total collections
Nov.30 Accounts payable = Purchases - Total payments
Check my work During the last week of August, Oneida Company's owner approaches the bank for...
During the last week of August, Oneida Company's owner approaches the bank for a $108,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,240. 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...
During the last week of August, Oneida Company's owner approaches the bank for a $105,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3150. 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...
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...
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 10%, for an interest cost of $2,463. 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...
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...
During the last week of August, Oneida Company’s owner approaches the bank for a $102,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $3,060. 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...
During the last week of August, Apache Arts Company's owner approaches the bank for an $80,000 loan to be made on September 2 and repaid on November 30 with annual interest of 12%, for an interest cost of $2,400. 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 Apache Arts' ability to repay the loan and asks the owner to...
During the last week of August, Apache Arts Company’s owner approaches the bank for an $104,500 loan to be made on September 2 and repaid on November 30 with annual interest of 16%, for an interest cost of $4,180. 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 Apache Arts’ ability to repay the loan and asks the owner to...
just need the rest of the uncollectibles Problem 20-6AA Merchandising: Preparation of cash budgets (for three periods) LO P4 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...
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...