answer highlighted sections

Excel McGraw Hill Excel Question - Saved P Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing B. General A1 fx S\&P Enterprises needs a cash budget for March. The following information is available. A 8 C D E F SEP Enterprises needs a cash budget for March. The following information is available, 3 4 Dctual January and February and expected March sales: Cash sales Sales on account Total Sales \begin{tabular}{|r|r|r|} $,600 & $3,750 & $5,100 \\ \hline 25,000 & 30,000 & 40,000 \\ \hline$26,600 & $33,750 & $45,100 \\ \hline \end{tabular} Accounts Recelvable Collections: 10 Month of sale 11 Month following sale 12. Second month following sale 13 Uncollectible 14 Accounts payable for imventory purchases, March 1 balance 15 Budgeted inventory purchases in March 16 inventory payments: 17 18 19 \begin{tabular}{l|l} \hline Month of purchase & 60% \\ \hline Month following purchase & 40% \end{tabular} Total budgeted selling \& administrative expenses Budgeted depreciation in March (included in to Other budgeted cash disbuyzsments in March Equipment purchases $12,500 $3,200 Equipment purchases Dividends to be paid Minimum cash bolance to be maintained 28 March 1 cash balance 29 March 1 outstanding borrowings 30 March 1 interest due $14,000 $2,000 $10,000 $11,500 $0 $0 31. B Budget Data A schedules and Cash Budget + Citibtion viste Automatis Wortook Staticise Excel McGraw Hill Excel Question - Sived Search (Option + Q) File Home insert Draw Formulas Data Review View Help foriting 8 General A1 fi. ssp Enterprises needs a cash budget for March. The following information it avallable. A 31 32. The company has a line of credt waibble to bolstec the cash balance as needed. 133 34. When preparing budeets, the comgamy maintains their data on a separate sheet from the actual budget and schedules. 35 36 Required: 37. Cick the Schedules and Cash Budget tab to prepare the following: 38 I. Schiedule of expected cath collections for March. 19.2 schedule of exected cash ditbursemvents for inventory parthases for March. 40. 3. Cash budget for March. Indicate in the financing yection ary borrowing that will be needed in March. Assume that any interest will not be paid until the following 4. month. Whe cells A4 to O and A10 to B0 from the siven information, ai weil as A3 to C4 from the Shedules and Cuch Gludget to 43 complete this question) 44 46 47 Stulert: The sorithoad area is for you to do awy additional work vou need to solve this question or can be used to show your work. 40. Nothing in thic arta wal be eraded, but at anll be submitted wath your asignmient. Expected cosh collections: March cash collections March collections on account: January sales February sales March sales Total cash collections Poyments to suppliers: 11 Accounts payable for inventory purchases, beginning balance 12 March purchases 13 Total cash payments 14 15 S\&P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available 22 Less disbursements: 23 Payments to suppliers 24 Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest Total financing Cash balance, March 31 Excel McGraw Hill Excel Question - Saved P Search (Option + Q) File Home Insert Draw Formulas Data Review View Help Editing B. General A1 fx S\&P Enterprises needs a cash budget for March. The following information is available. A 8 C D E F SEP Enterprises needs a cash budget for March. The following information is available, 3 4 Dctual January and February and expected March sales: Cash sales Sales on account Total Sales \begin{tabular}{|r|r|r|} $,600 & $3,750 & $5,100 \\ \hline 25,000 & 30,000 & 40,000 \\ \hline$26,600 & $33,750 & $45,100 \\ \hline \end{tabular} Accounts Recelvable Collections: 10 Month of sale 11 Month following sale 12. Second month following sale 13 Uncollectible 14 Accounts payable for imventory purchases, March 1 balance 15 Budgeted inventory purchases in March 16 inventory payments: 17 18 19 \begin{tabular}{l|l} \hline Month of purchase & 60% \\ \hline Month following purchase & 40% \end{tabular} Total budgeted selling \& administrative expenses Budgeted depreciation in March (included in to Other budgeted cash disbuyzsments in March Equipment purchases $12,500 $3,200 Equipment purchases Dividends to be paid Minimum cash bolance to be maintained 28 March 1 cash balance 29 March 1 outstanding borrowings 30 March 1 interest due $14,000 $2,000 $10,000 $11,500 $0 $0 31. B Budget Data A schedules and Cash Budget + Citibtion viste Automatis Wortook Staticise Excel McGraw Hill Excel Question - Sived Search (Option + Q) File Home insert Draw Formulas Data Review View Help foriting 8 General A1 fi. ssp Enterprises needs a cash budget for March. The following information it avallable. A 31 32. The company has a line of credt waibble to bolstec the cash balance as needed. 133 34. When preparing budeets, the comgamy maintains their data on a separate sheet from the actual budget and schedules. 35 36 Required: 37. Cick the Schedules and Cash Budget tab to prepare the following: 38 I. Schiedule of expected cath collections for March. 19.2 schedule of exected cash ditbursemvents for inventory parthases for March. 40. 3. Cash budget for March. Indicate in the financing yection ary borrowing that will be needed in March. Assume that any interest will not be paid until the following 4. month. Whe cells A4 to O and A10 to B0 from the siven information, ai weil as A3 to C4 from the Shedules and Cuch Gludget to 43 complete this question) 44 46 47 Stulert: The sorithoad area is for you to do awy additional work vou need to solve this question or can be used to show your work. 40. Nothing in thic arta wal be eraded, but at anll be submitted wath your asignmient. Expected cosh collections: March cash collections March collections on account: January sales February sales March sales Total cash collections Poyments to suppliers: 11 Accounts payable for inventory purchases, beginning balance 12 March purchases 13 Total cash payments 14 15 S\&P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available 22 Less disbursements: 23 Payments to suppliers 24 Selling and administrative expenses Equipment purchases Dividends paid Total disbursements Preliminary cash balance Financing: Additional loan Loan repayments Interest Total financing Cash balance, March 31