Sharon is a true accountant: she not only likes knowing where every dollar is going, she...

Transcribed Image Text:

Sharon is a true accountant: she not only likes knowing where every dollar is going, she is obsessed with it. So she is happy to take on the cash budget for this small company. She wants to go back through the fourth-quarter plan with a fine-toothed comb before working on the following calendar year's cash budget. After reviewing many notes from the management team, she has the following information. October November December Cash receipts $54,200 $56,100 $56,400 Cash disbursements 51,800 61,800 53,800 Addition information: Line of credit withdrawals must be made on the first of the month in $1,000 increments. Line of credit payments must be made on the last day of the month in $1,000 increments. . Credit line balance, September 30, $2,000. . Annual loan interest rate, 6%, with monthly interest payments required. Minimum monthly cash account balance, $10,000. Cash balance, September 30, $10,500. Beginning Balance Add : Cash Receipts Cash Available Less : Cash Disbursements Cash Surplus/(Deficiency) October $ 10500 $ 54200 64700 November 56100 51800 61800 Less : Minimum Balance Requirement 10000 10000 Additional Funds Available/(Needed) Loan Balance Beginning of Period Loan Draws/(Payments) Loan Balance End of Period Interest Payment Ending Cash Balance > > > $ $ $ +A $ October $ 10500 54200 November 56100 December 56400 Quarter 10500 166700 51800 61800 53800 167400 64700 10000 10000 10000 10000 GA A A Sharon is a true accountant: she not only likes knowing where every dollar is going, she is obsessed with it. So she is happy to take on the cash budget for this small company. She wants to go back through the fourth-quarter plan with a fine-toothed comb before working on the following calendar year's cash budget. After reviewing many notes from the management team, she has the following information. October November December Cash receipts $54,200 $56,100 $56,400 Cash disbursements 51,800 61,800 53,800 Addition information: Line of credit withdrawals must be made on the first of the month in $1,000 increments. Line of credit payments must be made on the last day of the month in $1,000 increments. . Credit line balance, September 30, $2,000. . Annual loan interest rate, 6%, with monthly interest payments required. Minimum monthly cash account balance, $10,000. Cash balance, September 30, $10,500. Beginning Balance Add : Cash Receipts Cash Available Less : Cash Disbursements Cash Surplus/(Deficiency) October $ 10500 $ 54200 64700 November 56100 51800 61800 Less : Minimum Balance Requirement 10000 10000 Additional Funds Available/(Needed) Loan Balance Beginning of Period Loan Draws/(Payments) Loan Balance End of Period Interest Payment Ending Cash Balance > > > $ $ $ +A $ October $ 10500 54200 November 56100 December 56400 Quarter 10500 166700 51800 61800 53800 167400 64700 10000 10000 10000 10000 GA A A