80.2K

Verified Solution

Link Copied!

please help, and please it is important to use the grading policy (=A3+B3) type formula for it to be counted as correct. thank you so much!

S\&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. other bodgeted canh disbursenents in Haroh Iqulpest purehases bividende to be paid 5,14,000 52,000 The company has o line of credit available to bolster the cash balance as needed. Required: Click the Schedules and Cash Budget tab to prepare the following: a. Schedule of expected cash collections for March. b. Schedule of expected cash disbursements for inventory purchases for March. c. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be poid until the following month. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 A1 A. B c. D E S5 P Enterprises needs a cash budget for March. The following informabon is available. 10 Accounts Receivabie Collections: 11 Month of sale 12. Nanth following sale 13 Second month following sale. 14 Uncollectible 15 Accounts payable for inventory purchases, March 1 balance 16 budeeted inventory purchases in March 17. inventory payments 18 Month of purchare 19 Alanth following purchase 20 21. Total buseeted selline 8 adiminitrattve eroentes in March findudine deareclation! 512.500 Requlred: cick the Schedules and Canh Budeet tab 1o prepare the followine: 1. Schedule of eipected cash collections for March 2. Schedule of expected canh dibursements for imwentory purchases for March. 1. Caih budeet for March. Incicate in the firancing secbon any borrowing that will be needed in March. Assume that any interest will not be pald until the following Kquifer Click the Schedulesand Cash fudget tab to prepafe the following: 1. Schedule of expected cash collections for March. 2. Schedule of expected carh disbursements foe inventory purchases for March. 3. Cash bodeet for March. indicate in the financing section any borrowing that will be needed in March. Assume that amy interest will not be paid until the following menth (Use cells A4 to B31 from the given information to complete this question.) SsP Enterprises Cath Budget For the Month of March 6. Cuhb babince, March 1 63. Add cash recript: G4 Collections from customers 65 Total ash avaluble Less dibbursements: Parments to suppliers Seling and administrative expenses Eovipment purchases Dividendy paid Total dibursements 72. Preliminary aash balance 73. Pinancine Additional loan Loan repoyments Intereat Total firancing Gash balance. March 31 S\&P Enterprises has provided data from the first three months of the year. The Controller has asked you to prepare the Cash Budget and the related Schedules for Expected cash collections and Payments to suppliers. other bodgeted canh disbursenents in Haroh Iqulpest purehases bividende to be paid 5,14,000 52,000 The company has o line of credit available to bolster the cash balance as needed. Required: Click the Schedules and Cash Budget tab to prepare the following: a. Schedule of expected cash collections for March. b. Schedule of expected cash disbursements for inventory purchases for March. c. Cash budget for March. Indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be poid until the following month. Navigation: 1. Use the Open Excel in New Tab button to launch this question. 2. When finished in Excel, use the Save and Return to Assignment button in the lower right to return to Connect. For an answer to be graded as correct, you must use an Excel formula: 1. Begin each formula with an = sign. 2. Reference cells, instead of entering values. Example: =B3+C3 A1 A. B c. D E S5 P Enterprises needs a cash budget for March. The following informabon is available. 10 Accounts Receivabie Collections: 11 Month of sale 12. Nanth following sale 13 Second month following sale. 14 Uncollectible 15 Accounts payable for inventory purchases, March 1 balance 16 budeeted inventory purchases in March 17. inventory payments 18 Month of purchare 19 Alanth following purchase 20 21. Total buseeted selline 8 adiminitrattve eroentes in March findudine deareclation! 512.500 Requlred: cick the Schedules and Canh Budeet tab 1o prepare the followine: 1. Schedule of eipected cash collections for March 2. Schedule of expected canh dibursements for imwentory purchases for March. 1. Caih budeet for March. Incicate in the firancing secbon any borrowing that will be needed in March. Assume that any interest will not be pald until the following Kquifer Click the Schedulesand Cash fudget tab to prepafe the following: 1. Schedule of expected cash collections for March. 2. Schedule of expected carh disbursements foe inventory purchases for March. 3. Cash bodeet for March. indicate in the financing section any borrowing that will be needed in March. Assume that amy interest will not be paid until the following menth (Use cells A4 to B31 from the given information to complete this question.) SsP Enterprises Cath Budget For the Month of March 6. Cuhb babince, March 1 63. Add cash recript: G4 Collections from customers 65 Total ash avaluble Less dibbursements: Parments to suppliers Seling and administrative expenses Eovipment purchases Dividendy paid Total dibursements 72. Preliminary aash balance 73. Pinancine Additional loan Loan repoyments Intereat Total firancing Gash balance. March 31

Answer & Explanation Solved by verified expert

See Answer