Question
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow: Sales are budgeted at $300,000 for
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow:
Sales are budgeted at $300,000 for November, $320,000 for December, and $220,000 for January.
Collections are expected to be 70% in the month of sale and 30% in the month following the sale.
The cost of goods sold is 75% of sales.
The company desires to have an ending merchandise inventory at the end of each month equal to 80% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
Other monthly expenses to be paid in cash are $22,100.
Monthly depreciation is $26,000.
Ignore taxes.
Balance Sheet October 31 | ||||||
Assets | ||||||
Cash | $ | 30,000 | ||||
Accounts receivable | 82,000 | |||||
Merchandise inventory | 180,000 | |||||
Property, plant and equipment, net of $624,000 accumulated depreciation | 1,014,000 | |||||
Total assets | $ | 1,306,000 | ||||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 246,000 | ||||
Common stock | 750,000 | |||||
Retained earnings | 310,000 | |||||
Total liabilities and stockholders' equity | $ | 1,306,000 | ||||
The cost of December merchandise purchases would be:
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow:
Sales are budgeted at $307,000 for November, $327,000 for December, and $227,000 for January.
Collections are expected to be 60% in the month of sale and 40% in the month following the sale.
The cost of goods sold is 75% of sales.
The company desires to have an ending merchandise inventory at the end of each month equal to 90% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
Other monthly expenses to be paid in cash are $22,800.
Monthly depreciation is $29,500.
Ignore taxes.
Balance Sheet October 31 | ||||||
Assets | ||||||
Cash | $ | 35,000 | ||||
Accounts receivable | 85,500 | |||||
Merchandise inventory | 207,225 | |||||
Property, plant and equipment, net of $624,000 accumulated depreciation | 922,000 | |||||
Total assets | $ | 1,249,725 | ||||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 256,000 | ||||
Common stock | 757,000 | |||||
Retained earnings | 236,725 | |||||
Total liabilities and stockholders' equity | $ | 1,249,725 | ||||
The difference between cash receipts and cash disbursements for December would be:
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow:
Sales are budgeted at $281,000 for November, $321,000 for December, and $212,000 for January.
Collections are expected to be 75% in the month of sale and 25% in the month following the sale.
The cost of goods sold is 75% of sales.
The company desires to have an ending merchandise inventory at the end of each month equal to 90% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
Other monthly expenses to be paid in cash are $20,100.
Monthly depreciation is $22,000.
Ignore taxes.
Balance Sheet October 31 | ||||||
Assets | ||||||
Cash | $ | 29,000 | ||||
Accounts receivable | 78,000 | |||||
Merchandise inventory | 189,675 | |||||
Property, plant and equipment, net of $624,000 accumulated depreciation | 1,006,000 | |||||
Total assets | $ | 1,302,675 | ||||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 241,000 | ||||
Common stock | 742,000 | |||||
Retained earnings | 319,675 | |||||
Total liabilities and stockholders' equity | $ | 1,295,400 | ||||
Accounts payable at the end of December would be:
Dilly Farm Supply is located in a small town in the rural west. Data regarding the store's operations follow:
Sales are budgeted at $310,000 for November, $330,000 for December, and $230,000 for January.
Collections are expected to be 60% in the month of sale and 40% in the month following the sale.
The cost of goods sold is 70% of sales.
The company desires to have an ending merchandise inventory at the end of each month equal to 90% of the next month's cost of goods sold. Payment for merchandise is made in the month following the purchase.
Other monthly expenses to be paid in cash are $23,100.
Monthly depreciation is $31,000.
Ignore taxes.
Balance Sheet October 31 | ||||||
Assets | ||||||
Cash | $ | 36,500 | ||||
Accounts receivable | 87,000 | |||||
Merchandise inventory | 195,300 | |||||
Property, plant and equipment, net of $624,000 accumulated depreciation | 925,000 | |||||
Total assets | $ | 1,243,800 | ||||
Liabilities and Stockholders' Equity | ||||||
Accounts payable | $ | 259,000 | ||||
Common stock | 760,000 | |||||
Retained earnings | 224,800 | |||||
Total liabilities and stockholders' equity | $ | 1,243,800 | ||||
Retained earnings at the end of December would be:
BELOW EACH BALANCE SHEET IS THE QUESTION I AM LOOKING AN ANSWER TO. 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