In the im division sheet in cell b4, enter a formula with a 3-d reference to bonnet’s professional membership dues. in cell c4, enter a formula with a 3-d reference to hoffman’s professional membership dues. in cell d4, enter a formula with a 3-d reference to myeong’s professional membership dues. in cell e4, enter a formula with a 3-d reference to stathopoulos professional membership dues.

Lipman auto parts, a family-owned auto parts store, began january with $10,300.00 in cash. management forecasts that collections from credit customers will be $11,400.00 in january and $14,800.00 in february. the store is scheduled to receive $5,000.00 in cash on a business note receivable in january. projected cash payments include inventory purchases ($13,000.00 in january and $13,600.00 in february) and operating expenses ($2,700.00 each month). lipman auto parts' bank requires a $10,000.00 minimum balance in the store's checking account. at the end of any month when the account balance dips below $10,000.00, the bank automatically extends credit to the store in multiples of $1,000.00. lipman auto parts borrows as little as possible and pays back loans in quarterly installments of $2,000.00, plus 4 percent interest on the entire unpaid principal. the first payment occurs three months after the loan.