In: Accounting
|
||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
Solution:
Part 1 --- Schedule of Expected Cash Collection for December
Schedule of Expected Cash Collections |
|
December |
|
Cash Sales (given) |
$83,600 |
Collection from Sales on Account: |
|
October on Account Sales (18% Collection in December $455,000*18%) |
$81,900 |
November on Account Sales (60% Collection in December $550,000*60%) |
$330,000 |
December on Account Sales (20% Collection in December $673,000*20%) |
$134,600 |
Total Collection |
$630,100 |
Part 2 -- Schedule of expected cash disbursements for merchandise purchases for December
Schedule of Expected Cash Disbursements for Merchandise Purchases for December |
|
December |
|
Beginning Accounts Payable |
$177,000 |
December Purchases (30% of $346,000 paid in December) |
$103,800 |
Total |
$280,800 |
Part 3 --- Cash Budget
Ashton Company |
||
Cash Budget |
||
For the Month of December |
||
Beginning cash balance |
$51,200 |
|
Add collections from customers (Refer Part 1) |
$630,100 |
|
Total cash available |
$681,300 |
|
Less cash disbursements: |
||
Payments to suppliers for inventory (refer Part 2) |
$280,800 |
|
Selling and administrative expenses ($473,000 - Deprecation Non Cash Item 75,000) |
$398,000 |
|
New web server |
$72,000 |
|
Dividends paid |
$17,500 |
|
Total cash disbursements |
$768,300 |
|
Excess (deficiency) of cash available over disbursements |
-$87,000 |
|
Financing: |
||
Borrowings |
$107,000 |
|
Repayments |
||
Interest |
||
Total financing |
$107,000 |
|
Ending cash balance |
$20,000 |
Hope the above calculations, working and explanations are clear to you and help you in understanding the concept of question.... please rate my answer...in case any doubt, post a comment and I will try to resolve the doubt ASAP…thank you