Question

Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data...

Nadia Company, a merchandising company, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master budget for the second quarter.

a. As of March 31 (the end of the prior quarter), the company’s balance sheet showed the following account balances:

Cash $9,000
Acct Receviable 48,000
Inventory 12,6000
Buildings & Equip. (net) 214,100
Acct. Payable 18,300
Common Stock 190,000
Retained Earnings 75,400
Totals 283,700 283,700

b. Sales for March total 10,000 units. Each month’s sales are expected to exceed the prior month’s results by 5%. The product selling price is $25.00 per unit.

c. Sales are 20% for the cash and 80% on credit. All payments on credit sales are collected in the month following the sale. The accounts receivable at March 31 are a result of March credit sales.

d. Company’s policy calls for a given month’s ending inventory to equal 80% of the next month’s expected unit sales. The March 31 inventory is 8,400 units, which complies with the policy. The purchase price is $15.

e. Monthly selling and administrative expenses are budgeted as follows: salaries and wages, $7500 per month; shipping 6% of sales; advertising, $6,000 per month; other expenses, 4% of sales. Depreciation including depreciation on new assets acquired during the quarter, will be $6,000 for the quarter. Sales representatives’ commissions are 12.5 % of sales and are paid in the month of the sales. The sales manager’s salary will be $3,500 in April and $4,000 per month thereafter.

f. Half a month’s inventory purchases are paid in the month of purchase and half in the following month.

g. Equipment purchases during the quarter will be as follows: April, $11,500; and May, $3,000.

h. Dividends totaling $3,500 will be declared and paid in June.

j. No cash payment for income taxes are to be made during the second calendar quarter. Income taxes will be assessed at 35% for the quarter.

k. Management wants to maintain a minimum cash balance of $8,000. The company has an agreement with a local bank that allows the company to borrow in increments of $1,000 at the beginning of each month, up to a total balance of $20,000. The interest rate of these loans is 1% per month, and for simplicity, we will assume that the interest is not compounded. The company would as far as it is able, repay the loan plus accumulated interest at the end of the quarter.

Required: Using the above data, complete the following statements for the second quarter.

A. Budgeted Income Statement

B. Budgeted Statement of Retained Earnings

C. Budgeted Balance Sheet

Homework Answers

Answer #1

A. Budgeted Income Statement -

B. Budgeted Statement of Retained Earnings -

C. Budgeted Balance Sheet -

Cash Budget -

Working Notes -

Know the answer?
Your Answer:

Post as a guest

Your Name:

What's your source?

Earn Coins

Coins can be redeemed for fabulous gifts.

Not the answer you're looking for?
Ask your own homework help question
Similar Questions
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has...
ABC Company, a retailer, prepares its master budget on a quarterly basis. The following data has been assembled to assist in preparation of the master for the first quarter. a. As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances. ASSETS LIABILITIES AND EQUITY Cash $ 47,000 Accounts Payable $ 92,000 Accounts Receivable 224,000 Capital Stock 500,000 Inventory 60,000 Retained Earnings 109,000 Buildings and Equipment (net of depreciation) 370,000 TOTAL ASSETS...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Cash $ 47,000 Accounts receivable 205,600 Inventory 58,800 Buildings and equipment (net) 357,000 Accounts payable $ 87,225 Common stock 500,000 Retained earnings 81,175 $ 668,400 $ 668,400 Actual sales...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The...
Hillyard Company, an office supplies specialty store, prepares its master budget on a quarterly basis. The following data have been assembled to assist in preparing the master budget for the first quarter: As of December 31 (the end of the prior quarter), the company’s general ledger showed the following account balances: Debit Credit Cash $ 46,000 Accounts receivable 204,800 Inventory 58,650 Buildings and equipment (net) 356,000 Accounts payable $ 86,925 Common stock 500,000 Retained earnings 78,525 $ 665,450 $ 665,450...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information...
Developing a Master Budget for a Merchandising Organization Assume Nordstrom prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for one of its stores (in thousands). NORDSTROM Balance Sheet March 31 Assets Liabilities and Stockholders' Equity Cash $ 2,525 Merchandise purchases payable $2,400 Accounts receivable 2,040 Dividends payable 710 Inventory 3,400 Stockholders' equity 8,005 Prepaid Insurance 150 Fixtures 3,000 Total assets $11,115 Total liabilities and equity $11,115 Actual and forecasted sales for selected...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 55,000 Accounts receivable 36,000 Inventory 40,000 Buildings and equipment, net of depreciation 100,000 Total assets $ 231,000 Liabilities and Stockholders’ Equity Accounts payable $ 51,300 Common stock 70,000 Retained earnings 109,700 Total liabilities and stockholders’ equity $ 231,000 Budgeted Income Statements April May June Sales $ 100,000 $...
Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following...
Developing a Master Budget for a Merchandising Organization Peyton Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2010. PEYTON DEPARTMENT STORE Balance Sheet March 31, 2010 Assets Liabilities and Stockholders' Equity Cash $3,000 Accounts payable $26,000 Accounts receivable 25,000 Dividends payable 17,000 Inventory 30,000 Rent payable 2,000 Prepaid Insurance 2,000 Stockholders' equity 40,000 Fixtures 25,000 Total assets $85,000 Total liabilities and equity $85,000 Actual and forecasted sales for selected...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate...
Problem 8-29 Completing a Master Budget [LO8-2, LO8-4, LO8-7, LO8-8, LO8-9, LO8-10] The following data relate to the operations of Shilow Company, a wholesale distributor of consumer goods: Current assets as of March 31: Cash $ 8,800 Accounts receivable $ 25,200 Inventory $ 47,400 Building and equipment, net $ 114,000 Accounts payable $ 28,425 Common stock $ 150,000 Retained earnings $ 16,975 The gross margin is 25% of sales. Actual and budgeted sales data: March (actual) $ 63,000 April $...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended...
Deacon Company is a merchandising company that is preparing a budget for the three-month period ended June 30th. The following information is available Deacon Company Balance Sheet March 31 Assets Cash $ 60,000 Accounts receivable 30,000 Inventory 43,900 Buildings and equipment, net of depreciation 131,000 Total assets $ 264,900 Liabilities and Stockholders’ Equity Accounts payable $ 72,000 Common stock 70,000 Retained earnings 122,900 Total liabilities and stockholders’ equity $ 264,900 Budgeted Income Statements April May June Sales $ 113,000 $...
To prepare a master budget for April, May, and June of 2019, management gathers the following...
To prepare a master budget for April, May, and June of 2019, management gathers the following information. ZIGBY MANUFACTURING Estimated Balance Sheet March 31, 2019 Assets Cash $ 54,000 Accounts receivable 354,375 Raw materials inventory 100,495 Finished goods inventory 333,000 Total current assets 841,870 Equipment 628,000 Accumulated depreciation (164,000 ) Equipment, net 464,000 Total assets $ 1,305,870 Liabilities and Equity Accounts payable $ 212,195 Short-term notes payable 26,000 Total current liabilities 238,195 Long-term note payable 514,000 Total liabilities 752,195 Common...
ADVERTISEMENT
Need Online Homework Help?

Get Answers For Free
Most questions answered within 1 hours.

Ask a Question
ADVERTISEMENT