Answered step by step
Verified Expert Solution
Question
1 Approved Answer
A. Schedule of Expected Cash Collections July August September Quarter Account Receivable( June 30) $ 29,250 $ 29,250 July Sales $ 13,520 $ 38,480 $
A. | Schedule of Expected Cash Collections | ||||
July | August | September | Quarter | ||
Account Receivable( June 30) | $ 29,250 | $ 29,250 | |||
July Sales | $ 13,520 | $ 38,480 | $ 52,000 | ||
August Sales | $ 14,560 | $ 41,440 | $ 56,000 | ||
September | $ 15,600 | $ 15,600 | |||
Total Cash Collections | $ 42,770 | $ 53,040 | $ 57,040 | $ 152,850 | |
B. | Merchandise Purchase Budget | ||||
July | August | September | Quarter | ||
Budgeted Sales Revenue | $ 52,000 | $ 56,000 | $ 60,000 | $ 168,000 | |
Cost of Goods Sold (.77) | $ 40,040 | $ 43,120 | $ 46,200 | $ 129,360 | |
Plus: Desired Ending Inventory(.35) | $ 14,014 | $ 15,092 | $ 16,170 | $ 45,276 | |
Total Inventory Necessary | $ 54,054 | $ 58,212 | $ 62,370 | $ 174,636 | |
Minus: Beginning Inventory | $ (7,100) | $ (14,014) | $ (15,092) | $ (36,206) | |
Inventory to Purchase | $ 46,954 | $ 44,198 | $ 47,278 | $ 138,430 | |
C. | Schedule of Expected Cash Disbursments - Merchandise Purchases | ||||
July | August | September | Quarter | ||
Acct. Payable(June30) | $ 22,400 | $ 22,400 | |||
July Purchases | $ 22,538 | $ 24,416 | $ 46,954 | ||
August Purchases | $ 21,215 | $ 22,983 | $ 44,198 | ||
September Purchases | $ 22,693 | $ 22,693 | |||
Total Cash Disbursements | $ 44,938 | $ 45,631 | $ 45,676 | $ 136,245 | |
D. | Schedule of Expected Cash Disbursments - Selling and Administrative Expenses | ||||
July | August | September | Quarter | ||
Commissions | $ 9,000 | $ 9,000 | $ 9,000 | ||
Rent | $ 1,200 | $ 1,200 | $ 1,200 | ||
Other Expenses(8%) | $ 4,160 | $ 4,480 | $ 4,800 | ||
Total Cash for Expenses | $ 14,360 | $ 14,680 | $ 15,000 | $ 44,040 | |
E. | Cash Budget | ||||
July | August | September | Quarter | ||
Beginning Balance | $ 4,000 | $ 3,372 | $ 3,101 | ||
Plus Cash Collections | $ 42,770 | $ 53,040 | $ 57,040 | $ 152,850 | |
Total Cash Available | $ 46,770 | $ 56,412 | $ 60,141 | ||
Minus Cash Disbursement | |||||
Merchandise Purchase | $ 44,938 | $ 45,631 | $ 45,676 | $ 136,245 | |
Other Expenses | $ 4,160 | $ 4,480 | $ 4,800 | $ 13,440 | |
Commissions & rent | $ 10,200 | $ 10,200 | $ 10,200 | $ 30,600 | |
Equipment | $ 2,100 | $ 3,000 | $ 5,100 | ||
Total Disbursements | $ 61,398 | $ 63,311 | $ 60,676 | $ 185,385 | |
Deficiancy | $ (14,628) | $ (6,899) | $ (535) | ||
Borrowed | $ 18,000 | $ 10,000 | $ 2,000 | $ 30,000 | |
Financing | $ 18,000 | $ 10,000 | $ 2,000 | $ 30,000 | |
End Cash Balance | $ 3,372 | $ 3,101 | $ 1,465 | $ 1,465 |
F. | Sunny and Clear, Inc. | |
Absorbtion Costing Income Statement | ||
For the Quarter Ended September 30, 2020 | ||
Sales | $ 168,000 | |
Minus: Cost of Goods Sold | $ 129,360 | |
Gross Margin | $ 38,640 | |
Total Expenses | $ 44,040 | |
Depreciation | $ 1,300 | |
Net Income | $ (6,700) | |
G. | ||
Sunny and Clear, Inc. | ||
Balance Sheet | ||
September 30, 2020 | ||
Assets | ||
Cash | $ 1,465 | |
Account Receivable | $ 44,400 | |
Ending Inventory | $ 16,170 | |
Building And Equipment | $ 107,650 | |
Depreciation | $ (1,300) | |
Total Assets | $ 168,385 | |
Liability and Stockholder Equity | ||
Accounts Payable | ||
Note Payable | $ 30,000 | |
Capital Stock | $ 99,000 | |
Retained Earnings | ||
Total Liabilities and Stockholders Equity |
I'm struggling to find my accounts payable value and my retained earnings value. If you can help clarify that for me it would help a lot.
Current assets as of June 30: | |
Cash | $4,000 |
Accounts receivable | $29,250 |
Inventory | $7,100 |
Buildings and equipment, net | $102,550 |
Accounts payable | $22,400 |
Capital stock | $99,000 |
Retained earnings | $21,500 |
These were the assets they gave me to begin the quarter. If you need any other information let me know. Thank you.
Step by Step Solution
There are 3 Steps involved in it
Step: 1
Get Instant Access to Expert-Tailored Solutions
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started