Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Need columns for December and Quarter please with the above answered too. Wildhorse Corp.s accounting team is putting together the cash budget for the fourth
Need columns for December and Quarter please with the above answered too.
Wildhorse Corp.s accounting team is putting together the cash budget for the fourth quarter of the current year. Budgeted cash receipts and cash disbursements for DM are listed below, along with other budgeted costs and additional information. - Beginning cash balance on October 1 is $22,200; minimum required balance is $20,000. - Budgeted MOH cost includes $13,000 of depreciation each month. - Budgeted $G&A cost includes $12,800 of depreciation each month. - A 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 Wildhorse's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. (a) Prepare Wildhorse's cash budget for the fourth quarter, considering only required expenditures. Present amounts for each month and for the quarter overall. Loan Balance Beginning of Month i \begin{tabular}{|r|} \hline 9000 \\ \hline \end{tabular} i 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