Carver Lumber: cash balance at the end of December would be?
Not what you're looking for?
Carver Lumber sells lumber and general building supplies to building contractors in a medium-sized town in Montana. Data regarding the store's operations follow:
- Sales are budgeted at $450,000 for November, $380,000 for December, and $280,000 for January.
- Collections are expected to be 87% in the month of sale, 8% in the month following the sale, and 5% uncollectible.
- The cost of goods sold is 69% of sales.
- The company purchases 60% of its merchandise in the month prior to the month of sale and 40% in the month of sale. Payment for merchandise is made in the month following the purchase.
- Other monthly expenses to be paid in cash are $14,700.
- Monthly depreciation is $10,000.
- Ignore taxes.
Statement of Financial Position
October 31
Assets:
Cash $ 15,000
Accounts receivable (net of allowance for uncollectible accounts) 85,000
Inventory 157,500
Property, plant and equipment (net of $512,000 accumulated depreciation) 1,012,000
Total assets $1,269,500
Liabilities and Stockholders' Equity:
Accounts payable $ 262,000
Common stock 680,000
Retained earnings 327,500
Total liabilities and stockholders' equity $1,007,500
The cash balance at the end of December would be:
$461,880
$245,800
$284,800
$285,180
Purchase this Solution
Solution Summary
The solution provides a detail accounting for how to come to a projected cash balance at the end of December. It is summarized in an Excel spreadsheet.
Solution Preview
See Excel file attached.
Carver Lumber
Cash Projection
12/31/2008 October November December Totals
Cash balance 15,000 15,000
October sales collections 85,000 ...
Purchase this Solution
Free BrainMass Quizzes
Employee Orientation
Test your knowledge of employee orientation with this fun and informative quiz. This quiz is meant for beginner and advanced students as well as professionals already working in the HR field.
Basics of corporate finance
These questions will test you on your knowledge of finance.
Cost Concepts: Analyzing Costs in Managerial Accounting
This quiz gives students the opportunity to assess their knowledge of cost concepts used in managerial accounting such as opportunity costs, marginal costs, relevant costs and the benefits and relationships that derive from them.
Income Streams
In our ever changing world, developing secondary income streams is becoming more important. This quiz provides a brief overview of income sources.
Social Media: Pinterest
This quiz introduces basic concepts of Pinterest social media