60.1K

Verified Solution

Link Copied!

1 S \& P Enterprises needs a cash budget for March. The following infotmation is available. 9 Accounts Receivable Collections: \begin{tabular}{|r|l|r|} \hline 10 & Month of sale & 15% \\ \hline 11 & Month following sale & 60% \\ \hline 12 & Second month following sale & 22% \\ \hline 13 & Uncollectible & 3% \\ \hline 14 & & Accounts Receivable Collections: \\ \hline \end{tabular} \begin{tabular}{|l|l|l|} \hline 15 & Accounts payable for inventory purchases, March 1 balance & $10,500 \\ \hline 16 & Budgeted inventory purchases in March & $23,500 \\ \hline 17 & Inventory payments: \end{tabular} 17 Inventory payments: \begin{tabular}{|r|l|r|} \hline 18 & Month of purchase & 60% \\ \hline 19 & Month following purchase & 40% \\ \hline 20 & & \\ \hline 21 & Total budgeted selling \& administrative expenses in March & $12,500 \\ \hline 22 & Budgeted selling \& administrative depreciation in March & $3,200 \\ \hline 23 & & \end{tabular} \begin{tabular}{|r|lr|} \hline 21 & Total budgeted selling \& administrative expenses in March & $12,500 \\ \hline 22 & Budgeted selling \& administrative depreciation in March & $3,200 \\ \hline 23 & & \end{tabular} Other budgeted cash disbursements in March \begin{tabular}{|r|lr|} \hline 25 & Equipment purchases & $14,000 \\ \hline 26 & Dividends to be paid & $2,000 \\ \hline 27 & & \\ \hline 28 & Minimum cash balance to be maintained & $10,000 \\ \hline 29 & March 1 cash balance & $11,500 \\ \hline 30 & March 1 outstanding borrowings & $0 \\ \hline 31 & March 1 interest due & $0 \\ \hline 32 & & \end{tabular} The company has a line of credit available to bolster the cash balance as needed. When preparing budgets, the company maintains their data on a separate sheet from the actual budget and schedules. Click the Schedules and Cash Budget tab to prepare the following: 1. Schedule of expected cash collections for March. 2. Schedule of expected cash disbursements for inventory purchases for March. 3. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be paid until the following month. \begin{tabular}{lll|l} Clipboard 5x & Font & 5 & Styles \end{tabular} Al fx Expectd cash collections: A B C D E Cash Budget For the Month of March 8 Cash balance, March 1 19 Add cash receipts: 20 Collections from customers 21 Total cash available before current financing 22 Less disbursements: 23 Payments to suppliers 24 Selling and administrative expenses 25 Equipment purchases 26 Dividends paid 27 Total disbursements 28 Excess (deficiency) of cash available over disbursements 29 Financing: 30 Borrowings 31 Repayments 32 Interest 33 Total financing 34 Cash balance, March 31 \begin{tabular}{l} 35 \\ 36 \\ 37 \\ 38 \\ \hline \end{tabular}

Answer & Explanation Solved by verified expert

See Answer