need help creating a cash budget with the following informstion. itnwould be very helpful if you could show where and how you get each piece of information as i missed the class we learned about this.

e

Capital expenditures budget calls for the cash purchase of $130,000 of store fixtures. The fixture were Hampton has a line of cridt of 500,000 S from WECU under which it can borrow or repay principle in Hampton desires to keep an ending cash balance of at least 10,000 each month. The Bank charges an interest Hampton Hams Company Sales Budget Section 1: Projected Sales Sales Month Cash Sales Gales on Accourt Tolat Eudgeted Sales 2. Section 2. Schedule of Cash Receipts Curent Cash tales Plus Colections from Accounts Rectivatie Total Eudgeted Collected \begin{tabular}{rrr} 40,000 & 48,000 & 57,600 \\ \hline 0 & 120,000 & 144,000 \\ \hline 4000 & 168000 & 201600 \\ \hline \end{tabular} 4. Hampton Hams Company. 5. Purchases Budget 14 Section 2 Sechedule of Cash Payments for inventory Purchase 15 Payment of Current Months' Accts Pay 16. Payment of Prior Month's Acets Pay. Total Audgeted Diabursements for Inventory \begin{tabular}{|rrr|} \hline 17,360 & 84,672 & 9,576 \\ \hline & 58,240 & 56,441 \\ \hline 87,360 & 142,912 & 130,024 \\ \hline \end{tabular} 6 Selling and Adminstrative (S\&A) Expense Budget. 18. Section 2: Schedule of Cavh Payments for S.A froenses 19. Salary Expense 20.100% of prior month's sales commisions. 21 Supplies Expenses, 16 of sales 22. 100 sol prior month's utility expenses 22. Rent expenses 24 Miscellaneous expenses 25 Total Pavments for SEA Expenses Capital expenditures budget calls for the cash purchase of $130,000 of store fixtures. The fixture were Hampton has a line of cridt of 500,000 S from WECU under which it can borrow or repay principle in Hampton desires to keep an ending cash balance of at least 10,000 each month. The Bank charges an interest Hampton Hams Company Sales Budget Section 1: Projected Sales Sales Month Cash Sales Gales on Accourt Tolat Eudgeted Sales 2. Section 2. Schedule of Cash Receipts Curent Cash tales Plus Colections from Accounts Rectivatie Total Eudgeted Collected \begin{tabular}{rrr} 40,000 & 48,000 & 57,600 \\ \hline 0 & 120,000 & 144,000 \\ \hline 4000 & 168000 & 201600 \\ \hline \end{tabular} 4. Hampton Hams Company. 5. Purchases Budget 14 Section 2 Sechedule of Cash Payments for inventory Purchase 15 Payment of Current Months' Accts Pay 16. Payment of Prior Month's Acets Pay. Total Audgeted Diabursements for Inventory \begin{tabular}{|rrr|} \hline 17,360 & 84,672 & 9,576 \\ \hline & 58,240 & 56,441 \\ \hline 87,360 & 142,912 & 130,024 \\ \hline \end{tabular} 6 Selling and Adminstrative (S\&A) Expense Budget. 18. Section 2: Schedule of Cavh Payments for S.A froenses 19. Salary Expense 20.100% of prior month's sales commisions. 21 Supplies Expenses, 16 of sales 22. 100 sol prior month's utility expenses 22. Rent expenses 24 Miscellaneous expenses 25 Total Pavments for SEA Expenses