Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Can you help me with October, November, and December and quarter. Coronado Corp.'s accounting team is putting together the cash budget for the fourth quarter
Can you help me with October, November, and December and quarter.
Coronado Corp.'s accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash eceipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. - Beginning cash balance on October 1 is $22,500; minimum required balance is $20,000. - Budgeted MOH cost includes $10,900 of depreciation each month. - Budgeted SG\&A cost includes $11,800 of depreciation each month. - line of credit is available from the bank, subject to a 4% annual interest rate; withdrawals must be made on the first of the month, and repayments must be made on the last day of the month. The withdrawals and repayments must be in $500 increments. - If excess cash is available, the following spending priorities have been identified (in order of priority). 1. Equipment purchase of $30,000 (must be made at some point during this quarter with available cash or loan from the bank). 2. Research and development of $10,000 per month (could be made for any number of months or none at all). 3. Advertising of $5,000 per month (could be made for any number of months or none at all). (a) Prepare Coronado's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. \begin{tabular}{l|l|l|} Add & Additional Funds Available/(Needed) \\ \hline \end{tabular} Minimum Balance Requirement Loan Balance Beginning of Month Loan Draws/(Payments) Loan Balance end of Month Interest Ending Cash BalanceStep 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