Widmer Corp. requires a minimum $10,000 cash balance. If necessary, loans are taken to meet this requirement at a cost of 1% interest per month (paid monthly). If the ending cash balance exceeds the minimum, the excess will be applied to repaying any outstanding loan balance. The cash balance on July 1 is $10,400. Cash receipts other than for loans received for July, August, and September are forecasted as $24,000, $32,000, and $40,000, respectively. Payments other than for loan or interest payments for the same period are planned at $28,000, $30,000, and $32,000, respectively at July 1, there are no outstanding loans.Required:Prepare a cash budget for July, August, and September.
What will be an ideal response?
| ? | July | August | September |
| Cash Balance: | ? | ? | ? |
| Balance (Beginning) …………… | $10,400 | $10,000 | $10,000 |
| Cash Receipts …………………… | 24,000 | 32,000 | 40,000 |
| Cash Payments ………………… | (28,000) | (30,000) | (32,000) |
| Interest paid ……………………… | 0 | (36)* | (16)** |
| Preliminary Balance ……………… | $ 6,400 | $11,964 | $17,984 |
| Loan ……………………………… | 3,600 | 0 | 0 |
| Repaid …………………………… | 0 | (1,964) | (1,636) |
| Balance (Ending) ………………… | $10,000 | $10,000 | $16,348 |
** ($3,600 - $1,964) ? 1% = $16
You might also like to view...
The Consumer Product Safety Act of 1972 established the Consumer Product Safety Commission, which has the authority to ban or seize potentially harmful products and set severe penalties for violation of the law
Indicate whether the statement is true or false
On a consignment sale, the payment risk is
A. covered by the bank issuing the L/C. B. covered by insurance. C. assumed to be equally shared. D. assumed by the buyer. E. carried by the seller.
The structure of a living network is ______.
A. inotropic B. the embodiment of the systems physical components C. the network of a virtual system D. a closed nature
Marketers often employ a combination of segmentation methods, using ________ to identify and target their customers, and ________ to design products and messages to appeal to them.
A. demographics and geography; lifestyle or benefit segmentation B. lifestyle segmentation; geographic segmentation C. undifferentiated targeting; differentiated targeting D. loyalty segmentation; geodemographics E. loyalty segmentation; demographics