Answered step by step
Verified Expert Solution
Question
1 Approved Answer
Prepare a cash budget for March and April. begin{tabular}{|l|l|l|} hline multicolumn{2}{|c|}{ Cash Budget for March and April } hline & multicolumn{1}{|c|}{ March } &
Prepare a cash budget for March and April. \begin{tabular}{|l|l|l|} \hline \multicolumn{2}{|c|}{ Cash Budget for March and April } \\ \hline & \multicolumn{1}{|c|}{ March } & April \\ \hline Opening Cash Balance & $ & $ \\ \hline Receipts: & $ & $ \\ \hline Cash from sales & $ & $ \\ \hline Collection from customers & $ & $ \\ \hline Total cash available & $ & $ \\ \hline Disbursements: & & $ \\ \hline Inventory costs & $ & $ \\ \hline General and admin. costs & $ & $ \\ \hline Capital Expenditures & $ & $ \\ \hline Dividend Payment & $ & $ \\ \hline Total Cash Payments & $ & $ \\ \hline \hline Cash Excess (Deficit) & $ & \\ \hline \hline Financing Requirements: & & \\ \hline Notes Payable & $ & \\ \hline Loan Repayment & & $ \\ \hline Ending Cash Balance & $ & \\ \hline \end{tabular} Take me to the text Jessica Inc. provides you with the following budgeted information for two months in the current year. Expectations: - Cash sales represent 10% of total sales - All sales on account are collected in the following month - 60% of March's $110,000 worth of capital expenditures is to be paid at the end of March. The remainder is to be paid in the following month. April's capital expenditure will be paid in May. - Monthly amortization represents 20% of general and administration costs - Inventory costs and general and administration costs are to be paid in the month in which they are incurred - Dividends of $5,000 are expected to be declared in March and paid in April - Jessica Inc, obtains the minimum financing needed to ensure at least a $7,000 cash balance at the end of the month through a note payable. Assume that any amount taken out of the bank loan may be repaid only at year end
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