Answered step by step
Verified Expert Solution
Question
1 Approved Answer
I need help with part 6 of this problem. Monthly cash budgets. Near the end of 2017, the management of Dimsdale Sports Co., a merchandising
I need help with part 6 of this problem. Monthly cash budgets.
Near the end of 2017, the management of Dimsdale Sports Co., a merchandising company, prepared the following estimated balance sheet for December 31, 2017. DIMSDALE SPORTS COMPANY Estimated Balance Sheet December 31, 2017 Assets $36,000 525,000 150,000 Cash Accounts receivable Inventory Total current assets Equipment Less: accumulated depreciation $ 711,000 540,000 67,500 Equipment, net Total assets 472,500 $1,183,500 Liabilities and Equity $360,000 15,000 90,000 Accounts payable Bank loan payable Taxes payable (due 3/15/2018) Total liabilities Common stock Retained earnings Total stockholders' equity Total liabilities and equity $ 465,000 472,500 246,000 718,500 $1,183,500 Calculation of Cash receipts from customers: January February March Sales in units Selling price per unit Total budgeted sales Cash sales Sales on credit 605,000 30.00 $ 14,850,000 $ 18,150,000 151,250 75% $ 288,750 $ 11,137,500 $ 13,612,500 385,000 495,000 30.00$ 30.00 $ 25% 96,250 123,750 Collected in March 31 TotalJanuary February March Receivable Accounts ReceivableJanuary525,000 Credit sales from January February March 288,750 11,137,500 13,612,500 0 0 Total collection of receivables $125,000$ 400,000 $ 0 Chapter 22 PR 18-8A-50 points tal cash receipts from customers January February March Current month's cash sales Collections of receivables Calculation of payments for merchandise: January February March Desired ending inventory (units) Budgeted sales in units otal units required Beginning inventory (units) Number of units to be purchased Cost per unit Total cost of purchases Paid in March 31 TotalJanuary February March Payable Accounts Payable January 1$360,000$80,000$280,000 Merchandise purchases in January February March 0Step 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