Ling Auto Parts, a family-owned auto parts store, began January with $10,200 cash. Management forecasts that collections from credit customers will be $11,700 in January and $15,000 in February. The store is scheduled to receive $7,000 cash on a business note receivable in January. Projected cash payments include inventory purchases ($14,500 in January and $13,900 in February) and operating expenses ($2,900 each month).
Ling Auto Parts’ bank requires a $10,000 minimum balance in the store’s checking 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. Ling Auto Parts borrows as little as possible and pays back loans in quarterly installments of $2,500, plus 5% interest on the entire unpaid principal. The first payment occurs three months after the loan. (Note: We recommend you use the Excel work papers provided at myaccountinglab.com.)
Requirements
1. Prepare Ling Auto Parts’ cash budget for January and February.
2. How much cash will Ling Auto Parts borrow in February if collections from customers that month total $14,000 instead of $15,000?