Zap Power, a family-owned battery store, began October with $11,200 cash.
Management forecasts that collections from credit customers will be $11,400 in October and $14.600 in November. The store is scheduled to receive $7,000 cash on a business note receivable in October. Projected cash payments include inventory purchases ($13,900 in October and $14,500 in November) and operating expenses ($3,200 each month).
Zap Power's bank requires a $10,000 minimum balance in the store's chequing account. At the end of any month when the account balance dips below $10,000, the bank automatically extends credit to the store in multiples of $1,000. Zap Power borrows as little as possible and pays back loans in quarterly installments of $2,000 plus 4% interest on the entire unpaid principal. The first payment occurs 3 months after the loan.
Requirement
1. Prepare Zap Power's cash budget for October and November.
Prepare the cash budget beginning with October. (For amounts with a zero balance, make sure to enter "0" in the appropriate cell. Use parentheses or a minus sign when entering any deficiency.)
Zap Power | Calculation | ||||
Cash Budget | October | November | October | November | |
Beginning Cash balance | 11,200 | 12,500 | |||
Cash collections from customers | 11,400 | 14,600 | |||
Collection of note receivable | 7,000 | - | |||
Cash Available before Financing | 29,600 | 27,100 | |||
Cash Payments | |||||
Purchases of Inventory | 13,900 | 14,500 | |||
Operating expenses | 3,200 | 3,200 | |||
Ending Cash balance before Financing | 12,500 | 9,400 | |||
Minimum Cash balance desired | 10,000 | 10,000 | |||
Cash excess (deficiency) | 2,500 | (600) | |||
Total effect of financing | - | 1,000 | Round $600 to $1,000 for borrowings | ||
Ending Cash balance after Financing | 12,500 | 10,400 |
Zap Power, a family-owned battery store, began October with $11,200 cash.
Northern Auto Parts, a family-owned auto parts store, began January with $10,300 cash. Management forecasts that collections from credit customers will be $11,900 in January and $15,300 in February. The store is scheduled to receive $4,000 cash on a business note receivable in January. Projected cash payments include inventory purchases ($11,200 in January and $13,600 in February) and selling and administrative expenses ($3,500 each month). Northern Auto Parts's bank requires a $10,000 minimum balance in the store's checking account. At the...
Lipman Auto Parts, a family-owned auto parts store, began January with $10,100 cash. Management forecasts that collections from credit customers will be $11,600 in January and $15,200 in February. The store is scheduled to receive $6,500 cash on a business note receivable in January. Projected cash payments include inventory purchases ($14,400 in January and $13,500 in February) and selling and administrative expenses ($2,800 each month). Lipman Auto Parts's bank requires a $10,000 minimum balance in the store's checking account. At...
Lipman Auto Parts, a family-owned auto parts store, began January with $10,700 cash. Management forecasts that collections from credit customers will be $11,300 in January and $14,800 in February. The store is scheduled to receive $4,000 cash on a business note receivable in January. Projected cash payments include inventory purchases ($12,600 in January and $13,300 in February) and selling and administrative expenses ($3,000 each month). (Click the icon to view additional information about Lipman Auto Parts.) Read the requirements Requirement...
Discount Plus Store is a local discount store with the following information: Data Table • October sales are projected to be $390,000. Sales are projected to increase by 10% in November and another 25% in December and then return to the October level in January. 20% of sales are made in cash while the remaining 80% are paid by credit or debit cards. The credit card companies and banks (debit card issuers) charge a 1% transaction fee, and deposit the...
Discount Plus Store is a local discount store with the following information: (Click the icon to view the information.) Read the requirements. Requirement 1. Prepare the sales budget for November and December. Discount Plus Store Sales Budget For the Months of November and December November December Cash sales Credit sales Total sales f Requirements Prepare the following budgets for November and December: 1. Sales budget 2. Cost of goods sold, inventory, and purchases budget 3. Operating expense budget 4. Budgeted...
Cash Budget Friendly Freddie’s is an independently owned major appliance and electronics discount chain with seven stores located in a Midwestern metropolitan area. Rapid expansion has created the need for careful planning of cash requirements to ensure that the chain is able to replenish stock adequately and meet payment schedules to creditors. Fred Ferguson, founder of the chain, has established a banking relationship that provides a $200,000 line of credit to Friendly Freddie’s. The bank requires that a minimum balance...
Check my work During the last week of August, Oneida Company's owner approaches the bank for a $110,000 loan to be made on September 2 and repaid on November 30 with annual interest of 17%, for an interest cost of $4,675. 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...
Slate Corner Shoppe is a local convenience store with the following information: (Click the icon to view the information.) Read the requirements. Requirement 1. Prepare the sales budget for November and December. Slate Corner Shoppe Sales Budget For the Months of November and December November December Cash sales Credit sales Total sales • October sales were $220,000. Sales are projected to go up by 15% in November (from the October sales) and another 30% in December (from the November sales)...
E22A-35 (similar to) Northem Auto Parts, a famly-owned auto parts store, began January wih $10 100 cash. Management forecasts thatl collections om oredi custiomers will be $11,800 in January and $14.900 in February. The stone is scheduled to receive $4 50 cash on abusiness noie fecer atienJanuary Prgeeted caih pay meres ndude inventory purchases ($12.200 i, January and $12300 in Febrary) and Ming and Sdnatab gexpenses 200 oach moti Northern Auto Parts bank as-ttle as poss ble and pays back...
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...