Jones Ltd. is trying to decide whether it is going to need to take a loan...

Transcribed Image Text:

Jones Ltd. is trying to decide whether it is going to need to take a loan in coming January to buy a new microcomputer system. The microcomputer will cost $9,360. The president, Michael Jones, has collected the following information about her operations as at December 31: 1. Balance of selected ledger accounts: Cash $3,120 Accounts payable 6,200 2. Sales history and forecast (unit selling price, $10): October (actual) $46,800 November (actual) 35,360 December (actual) 46,800 January (forecast) 62,400 All sales are on credit and are due 30 days after the sale. 4. Cash payments for purchases are as follows: two-thirds in the month of purchase; one-third in the month after that. 5. Jones Ltd. collects 50% of a month's sales one month after the sale and 45% two months after the sale; 5% are uncollectible. The company purchases inventory as required under terms of 2/10, net 30. It always takes the 2% discount, but records purchases at gross cost. 6. 7. Inventory costs $5 per unit, gross. 8. Other expenses, all paid in cash as incurred, average about 30% of the sales dollar amount. Depreciation is part of these expenses and costs $3,120 per month. Jones Ltd. keeps a minimum cash balance of $4,200. 9. Prepare a cash budget for January, indicating whether Jones Ltd. will need a loan to finance its computer acquisition. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45). Round answers to O decimal places, e.g. 5,275.) 3. JONES LTD. Cash Budget For the Month Ended January 31 Beginning cash balance $ Add Cash receipts Collections from November Total cash receipts > Total cash receipts Total available cash Less Disbursements Repayment Ending cash balance 2$ Jones Ltd. is trying to decide whether it is going to need to take a loan in coming January to buy a new microcomputer system. The microcomputer will cost $9,360. The president, Michael Jones, has collected the following information about her operations as at December 31: 1. Balance of selected ledger accounts: Cash $3,120 Accounts payable 6,200 2. Sales history and forecast (unit selling price, $10): October (actual) $46,800 November (actual) 35,360 December (actual) 46,800 January (forecast) 62,400 All sales are on credit and are due 30 days after the sale. 4. Cash payments for purchases are as follows: two-thirds in the month of purchase; one-third in the month after that. 5. Jones Ltd. collects 50% of a month's sales one month after the sale and 45% two months after the sale; 5% are uncollectible. The company purchases inventory as required under terms of 2/10, net 30. It always takes the 2% discount, but records purchases at gross cost. 6. 7. Inventory costs $5 per unit, gross. 8. Other expenses, all paid in cash as incurred, average about 30% of the sales dollar amount. Depreciation is part of these expenses and costs $3,120 per month. Jones Ltd. keeps a minimum cash balance of $4,200. 9. Prepare a cash budget for January, indicating whether Jones Ltd. will need a loan to finance its computer acquisition. (Enter negative amounts using either a negative sign preceding the number e.g. -45 or parentheses e.g. (45). Round answers to O decimal places, e.g. 5,275.) 3. JONES LTD. Cash Budget For the Month Ended January 31 Beginning cash balance $ Add Cash receipts Collections from November Total cash receipts > Total cash receipts Total available cash Less Disbursements Repayment Ending cash balance 2$

Answer rating: 100% (QA)

JONES LTD Cash Budget For the Month Ended January 31 Beginning Cash B... View the full answer