Question
1. Flounder Corporations management wants to maintain a minimum monthly cash balance of $8,960. At the beginning of September, the cash balance is $13,742, expected
1. Flounder Corporations management wants to maintain a minimum monthly cash balance of $8,960. At the beginning of September, the cash balance is $13,742, expected cash receipts for September are $108,864, and cash disbursements are expected to be $128,800. How much cash, if any, must Flounder borrow to maintain the desired minimum monthly balance? Determine your answer by using the basic form of the cash budget.
FLOUNDER CORPORATION Cash Budget For September | ||
---|---|---|
select an opening cash budget item Ending cash balanceCash disbursements for SeptemberTotal available cashExcess (deficiency) of available cash over cash disbursementsBeginning cash balanceCash receipts for SeptemberBorrowings | $enter a dollar amount | |
select between addition and deduction AddLess: select a cash budget item Ending cash balanceCash receipts for SeptemberCash disbursements for SeptemberExcess (deficiency) of available cash over cash disbursementsBorrowingsBeginning cash balanceTotal available cash | enter a dollar amount | |
select a summarizing line for the first part Excess (deficiency) of available cash over cash disbursementsCash receipts for SeptemberTotal available cashBeginning cash balanceEnding cash balanceCash disbursements for SeptemberBorrowings | enter a total amount for the first part | |
select between addition and deduction AddLess: select a cash budget item Total available cashCash disbursements for SeptemberBeginning cash balanceEnding cash balanceExcess (deficiency) of available cash over cash disbursementsCash receipts for SeptemberBorrowings | enter a dollar amount | |
select a summarizing line for the second part Cash disbursements for SeptemberEnding cash balanceExcess (deficiency) of available cash over cash disbursementsBorrowingsTotal available cashCash receipts for SeptemberBeginning cash balance | enter a total amount for the second part | |
select between addition and deduction AddLess: select a cash budget item Total available cashExcess (deficiency) of available cash over cash disbursementsCash disbursements for SeptemberEnding cash balanceCash receipts for SeptemberBorrowingsBeginning cash balance | enter a dollar amount | |
select a closing cash budget item BorrowingsCash receipts for SeptemberTotal available cashCash disbursements for SeptemberExcess (deficiency) of available cash over cash disbursementsBeginning cash balanceEnding cash balance | $enter a total amount for the cash budget |
2.
Kingbird Company expects to have a cash balance of $65,250 on January 1, 2022. These are the relevant monthly budget data for the first two months of 2022.
1. | Collections from customers: January $90,250, February $165,250. | |
2. | Payments to suppliers: January $59,250, February $94,250. | |
3. | Wages: January $30,780 and February $40,780. Wages are paid in the month they are incurred. | |
4. | Administrative expenses: January $21,780 and February $24,780. These costs include depreciation of $1,000 per month. All other costs are paid as incurred. | |
5. | Selling expenses: January $15,780 and February $20,780. These costs are exclusive of depreciation. They are paid as incurred. | |
6. | Sales of short-term investments in January are expected to realize $12,780 in cash. Kingbird has a line of credit at a local bank that enables it to borrow up to $25,000. The company wants to maintain a minimum monthly cash balance of $39,250. |
Prepare a cash budget for January and February.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started