Question
ZYX is a wholesale distributor. The company's balance sheet as of November 30 is given below: ZYX Balance Sheet November 30, 2015 Assets Cash $91,000
ZYX is a wholesale distributor. The company's balance sheet as of November 30 is given below:
ZYX Balance Sheet November 30, 2015 | |
Assets | |
Cash | $91,000 |
Accounts receivable (net)* | 305,800 |
Inventory | 132,000 |
Buildings and equipment, net of depreciation | 207,000 |
Total assets | $735,800 |
Liabilities and Stockholders' Equity | |
Accounts payable | $125,000 |
Note payable* | 109,000 |
Common stock | 250,000 |
Retained earnings | 251,800 |
Total liabilities and stockholders' equity | $735,800 |
*The allowance for doubtful accounts was $3,000.
*The 6% 6-months note payable will be paid on February 1, 2016.
The company is in the process of preparing a budget through January 31, 2016, and has assembled the following data:
a. All sales are on account. Sales terms are 3/10 with the balance due by the end of the month after sale. Experience has shown that 50% of the billings will be collected within the discount period, 25% by the end of the month after sale, and the remaining in the following month. The average selling price of the company's products is $190 per unit. ZYX estimates that 1% of its credit sales will end up uncollected, and reviews the aging accounts receivable at the end of a year.
b. All purchases are payable within 15 days. Approximately 60% of the purchases in a month are paid that month, and the rest the following month. The average unit purchase cost is $150. Target ending inventories are 590 units plus 10% of the next month's unit sales.
c. Actual and projected sales are as follows:
October actual | $289,000 |
November actual | 741,000 |
December estimated | 665,000 |
January estimated | 722,000 |
February estimated | 399,000 |
Total estimated for year ending June, 2016 | $4,200,000 |
d. Total budgeted marketing, distribution, and customer-service costs for the year are $924,000. Of this amount, $168,000 are considered fixed (and include an annual straight-line depreciation of $80,000). The remainder varies with sales. Both fixed and variable marketing, distribution, and customer-service costs are paid as incurred.
e. New equipment costing $6,500 will be purchased for cash during December.
f. During December, the company will pay $5,000 cash dividends to its shareholders.
g. ZYX reviews its accounts receivable and estimates $3,500 will be uncollectible.
1. Based on the account balances, prepare the following budgeted financial statements for December and January on the OUTPUT worksheet. 1) Budgeted Income Statements using the absorption costing income statement format. 2) Budgeted balance sheet. 3) Budgeted Statement of Cash Flows.
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