Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

i would like a detailed explantion of this question? example: equations and understanding how to start this problem. Expected cash collections: March cash collections March

i would like a detailed explantion of this question? example: equations and understanding how to start this problem.
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
image text in transcribed
Expected cash collections: March cash collections March collections on account: January sales February sales March sales Total cash collections Poyments to suppllers: Accounts payable for inventory purchases, beginning balance March purchases Total cash payments S\&P Enterprises Cash Budget For the Month of March Cash balance, March 1 Add cash receipts: Collections from customers Total cash available Less disbursements: Payments to suppliers 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 AI fi 38.P Enterprises needs a cash budget for March. The following information is anilable. d. Data Jonvary tebruary. 4. Actual ianary and Fetharyand epected March rales: S. Cons ales 6. Sales on account 7 Totalsales $1,60025,000$26,600 t 9. Accounts Receivabie Collectons 10 Month of alie 11 Month followivale 12 Second month following sile 1) Unceliectble 14 Accounts mable for incentory purchases, March 1 balance. $10,500 Is Budreted inventory purchases in Murch $23,500 16 inventory parments: 17 Month of purchase 60K 18 Month following wurthase 40K 19 21 Budgeted depreciation in Marcb (included in total selling and admin eip) $3,200 2 23 Oher budated cah dabursenents in March 24 tquigment purchase: $14,000 25 Onidends to be paid $2,000 26 2) Ninimum cash balance to be maintained 21 March 1 cash balance 2) Murch 1 outstanding borrowings 10 March 1 interest due $10,000 $11,500 it 12. The company has a line of credit avalable to boluter the cash balnoce as needed. 50 (3) I4 When preparing budrets, the company muintains their data on a sepante sheet from the actual budeat and schedulas. is Aeguint: 17. Click the Schedvils und Cain Budet tab to prepare the followint: 1. Schedule of expected cash collections for March. 2 schedule of expected cash disbursements for inventory purchases for March. 1 Cas budet for March. indicate in the financing section any borrowing that will be needed in March. Assume that any interest will not be pald unti the following month. monined: Lethedile of epected cach collectlons for Murch

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access with AI-Powered Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image

Step: 3

blur-text-image

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Students also viewed these Accounting questions