Answered step by step
Verified Expert Solution
Link Copied!

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

image text in transcribed

image text in transcribed

image text in transcribed

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 Balance

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

College Accounting Chapters 1-15

Authors: James A Heintz, Robert W Parry

19th Edition

0324376162, 978-0324376166

More Books

Students also viewed these Accounting questions