cash collections and Payments to suppliers. Use the the formula would output the
ID: 2400657 • Letter: C
Question
cash collections and Payments to suppliers. Use the the formula would output the result from cell B5, or 1,600 in this example. looks different than a normal cell reference, since it includes the tab name and Cash Budget tab"-Budget Data'IC7 was Allows you to use the basic math symbols to perform to edd).-[minus sign to subtract), (asterisk sign to and / (forward slash to divide) From the Excel Simulation below, if in a blank cell on was entered, the formula would add the values from those cells and output the result, or 34,000 in this example was entered the formula would output the result of adding those 812) was entered, the formula would output the same result of adding those cels, except they are expressed as a range in the formula, and the result would be 97% in this example. Cord Format as Cel Formatting Table Styles for March. TheExplanation / Answer
1. Schedule of expected cash collections for march
$
Collections on account
Month of sale (40000*15%)
6000
Month following sale (30000*60%)
18000
Second Month following sale (25000*22%)
5500
29500
Cash sales
5100
Total expected cash collections
34600
2. schedule of expected cash disbursement for the inventory purchases for march
$
Accounts Payable
10500
Month of purchase (23500*60%)
14100
24600
3
S&P CASH BUDGET
FOR THE MONTH OF DECEMBER
$
$
Cash balance, beginning
11500
Add: cash receipts, collections from customer
34600
Total cash available before current financing
46100
Less disbursements
Payments to suppliers for inventory
24600
Selling and administrative expenses (12500-3200)
9300
Equipment purchase
14000
Dividend paid
2000
Total disbursements
49900
Excess(deficiecy) of cash available over dusbursements
-3800
Financing:
Borrowings
14300
Repayments
0
Interest
0
Total financing
14300
Cash balance ending
10500
1. Schedule of expected cash collections for march
$
Collections on account
Month of sale (40000*15%)
6000
Month following sale (30000*60%)
18000
Second Month following sale (25000*22%)
5500
29500
Cash sales
5100
Total expected cash collections
34600
2. schedule of expected cash disbursement for the inventory purchases for march
$
Accounts Payable
10500
Month of purchase (23500*60%)
14100
24600
3
S&P CASH BUDGET
FOR THE MONTH OF DECEMBER
$
$
Cash balance, beginning
11500
Add: cash receipts, collections from customer
34600
Total cash available before current financing
46100
Less disbursements
Payments to suppliers for inventory
24600
Selling and administrative expenses (12500-3200)
9300
Equipment purchase
14000
Dividend paid
2000
Total disbursements
49900
Excess(deficiecy) of cash available over dusbursements
-3800
Financing:
Borrowings
14300
Repayments
0
Interest
0
Total financing
14300
Cash balance ending
10500
Related Questions
Navigate
Integrity-first tutoring: explanations and feedback only — we do not complete graded work. Learn more.