Question

In: Accounting

Developing a Master Budget- Please answer the bottom bolded "ANSWERS" at the bottom. for a Merchandising...

Developing a Master Budget- Please answer the bottom bolded "ANSWERS" at the bottom.
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 $2,000

Accounts payable

$26,000
Accounts receivable 25,000

Dividends payable

17,000
Inventory 30,000

Rent payable

1,000
Prepaid Insurance 2,000

Stockholders' equity

40,000
Fixtures 25,000
Total assets $84,000

Total liabilities and equity

$84,000

Actual and forecasted sales for selected months in 2010 are as follows:

Month Sales Revenue
January $80,000
February 50,000
March 40,000
April 50,000
May 60,000
June 70,000
July 90,000
August 80,000

Monthly operating expenses are as follows:

Wages and salaries $27,000
Depreciation 100
Utilities 1,000
Rent 1,000

Cash dividends of $17,000 are declared during the third month of each quarter and are paid during the first month of the following quarter. Operating expenses, except insurance, rent, and depreciation are paid as incurred. Rent is paid during the following month. The prepaid insurance is for five more months. Cost of goods sold is equal to 50 percent of sales. Ending inventories are sufficient for 120 percent of the next month's sales. Purchases during any given month are paid in full during the following month. All sales are on account, with 50 percent collected during the month of sale, 40 percent during the next month, and 10 percent during the month thereafter. Money can be borrowed and repaid in multiples of $1,000 at an interest rate of 12 percent per year. The company desires a minimum cash balance of $2,000 on the first of each month. At the time the principal is repaid, interest is paid on the portion of principal that is repaid. All borrowing is at the beginning of the month, and all repayment is at the end of the month. Money is never repaid at the end of the month it is borrowed.

(a) Prepare a purchases budget for each month of the second quarter ending June 30, 2010.

Peyton Department Store
Monthly Purchase Budget
Quarter Ending June 30, 2010
April May June Total
Budgeted purchases 31,000

36,000

47,000

114,000

(b) Prepare a cash receipts schedule for each month of the second quarter ending June 30, 2010. Do not include borrowings.

Peyton Department Store
Schedule of Monthly Cash Receipts
Quarter Ending June 30, 2010
April May June Total
Total cash receipts 46,000 54,000 64,000 164,000

(c) Prepare a cash disbursements schedule for each month of the second quarter ending June 30, 2010. Do not include repayments of borrowings.

Peyton Department Store
Schedule of Monthly Cash Disbursements
Quarter Ending June 30, 2010
April May June Total
Total cash disbursements 72,000

60,000

65,000 197,000

(d) Prepare a cash budget for each month of the second quarter ending June 30, 2010. Include budgeted borrowings and repayments.

Only use negative signs, if needed, for: excess receipts over disbursements, balance before borrowings and cash balances (beginning and ending).

Peyton Department Store
Monthly Cash Budget
Quarter Ending June 30, 2010
April May June Total
Cash balance, beginning 2000

2000

2000

6000

Receipts 46,000

54,000

64,000

164,000

Disbursements 72,000

60,000

65,00

197,000

Excess receipts over disb. -26,000

-6000

1000

-33000

Balance before borrowings -24000

-4000

1000

31000

Borrowings 26,000

6000

1000

33000

Loan repayments 0

0

0

0

Cash balance, ending 2000

2000

2000

2000

(e) Prepare an income statement for each month of the second quarter ending June 30, 2010.

Only use negative signs to show net losses in income.

Peyton Department Store
Budgeted Monthly Income Statements
Quarter Ending June 30, 2010
April May June Total
Sales 50000

60000

70000

180000

cost of sales 25000

30,000

35,000

90,000

Gross profit 25,000

30000

35,000

90,000

Operating expenses:
Wages and salaries 27000

27000

27000

81,000

Depreciation 100

100

100

300

Utilities 1000

1000

1000

3000

Rent

1000

1000

1000

3000

Insurance 400

400

400

1200

Interest Answer Answer Answer Answer
Total expenses Answer Answer Answer Answer
Net income Answer Answer Answer Answer

(f) Prepare a budgeted balance sheet as of June 30, 2010.

Peyton Department Store
Budgeted Balance Sheet
June 30, 2010
Assets Liabilities and Equity
Cash 2000 Merchandise payable 47,000
Accounts receivable 41000 Dividend payable 17000
Inventory 54000 Rent payable 1000
Prepaid insurance 800 Loans payable 33,000
Fixtures 24,700 Interest payable Answer
Total assets 122500 Stockholders' equity Answer
Total liab. & equity 122500

i cant figure out answers at the bottom including interest, stockholders equity, total liabilities, etc.

the answers i need assistance with are filled in with the word answer and are bolded

Solutions

Expert Solution

If there is any doubt with the answer please comment & give positive rating

(e)

Peyton Department Store
Budgeted Monthly Income Statements
Quarter Ending June 30, 2010
April May June Total
Sales $        50,000.00 $          60,000.00 $        70,000.00 $               180,000.00
cost of sales $        25,000.00 $          30,000.00 $        35,000.00 $                 90,000.00
Gross profit $        25,000.00 $          30,000.00 $        35,000.00 $                 90,000.00
Operating expenses:
Wages and salaries $        27,000.00 $          27,000.00 $        27,000.00 $            81,000.00
Depreciation $              100.00 $               100.00 $              100.00 $                 300.00
Utilities $          1,000.00 $            1,000.00 $          1,000.00 $              3,000.00
Rent $          1,000.00 $            1,000.00 $          1,000.00 $              3,000.00
Insurance (2000/5 = 400 per month $              400.00 $               400.00 $              400.00 $              1,200.00
Interest

$              260.00

(26000 x 12% /12 months)

$               320.00

(32000 x 12%/12 )

$              330.00

(33000 x 12%/12)

$                 910.00
Total expenses $        29,760.00 $          29,820.00 $        29,830.00 $                 89,410.00
Net income $        (4,760.00) $               180.00 $          5,170.00 $                       590.00

(f)

Peyton Department Store
Budgeted Balance Sheet
30-Jun-10
Assets Liabilities and Equity
Cash $          2,000.00 Merchandise payable $        47,000.00
Accounts receivable $        41,000.00 Dividend payable $        17,000.00
Inventory $        54,000.00 Rent payable $          1,000.00
Prepaid insurance $              800.00 Loans payable $        33,000.00
Fixtures $        24,700.00 Interest payable $              910.00
Total assets $      122,500.00

Stockholders' equity

(40,000+590-17000)

$        23,590.00
Total liabilities & equity $      122,500.00

Related Solutions

THE BOLDED LETTER AND NUMBER IS THE GIVEN ANSWER. ONE OF THE BOLDED ANSWERS ARE INCORRECT,...
THE BOLDED LETTER AND NUMBER IS THE GIVEN ANSWER. ONE OF THE BOLDED ANSWERS ARE INCORRECT, WHICH ONE IS INCORRECT AND WHAT IS THE CORRECT ANSWER? Your company manufactures hot water heaters. The life spans of your product are known to be normally distributed with a mean of 13 years and a standard deviation of 1.5 years. You want to set the warranty on your product so that you do not have to replace more than 5% of the hot...
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...
Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The...
Developing a Master Budget for a Merchandising Organization Dils Brother Department Store prepares budgets quarterly. The following information is available for use in planning the second quarter budgets for 2017. Dils Brother Department Store Balance Sheet March 31, 2017 Assets    Liabilities and Stockholders' Equity Cash $ 4,000    Accounts payable $31,000 Accounts receivable 31,000    Dividends payable 15,000 Inventory 36,000    Rent payable 3,000 Prepaid Insurance 3,000    Stockholders' equity 50,000 Fixtures 25,000 Total assets $99,000    Total liabilities...
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...
Budgeted Income Statement Pendleton Company, a merchandising company, is developing its master budget for 2015. The...
Budgeted Income Statement Pendleton Company, a merchandising company, is developing its master budget for 2015. The income statement for 2014 is as follows: Pendleton Company Income Statement For Year Ending December 31, 2014 Gross sales $1,500,000 Less: Estimated uncollectible accounts (30,000) Net sales 1,470,000 Cost of goods sold (825,000) Gross profit 645,000 Operating expenses (including $25,000 depreciation) (375,000) Net income $270,000 The following are management’s goals and forecasts for 2015: 1. Selling prices will increase by 6 percent, and sales...
Please answer this question in details . this lecture is about The master budget is a...
Please answer this question in details . this lecture is about The master budget is a picture of the strategic plan’s projected results in financial terms. you will learn the purpose of the master budget and how it is compiled from functional area budgets within an organization. In different textbooks praise the benefits of participative budgeting. Is it wise to involve multiple parties at multiple levels in the organization in the budget preparation process? Why or why not? Embed course...
The correct answers are already bolded, but please show your work/explain how you get the answer....
The correct answers are already bolded, but please show your work/explain how you get the answer. 1. Rick can cut 6 pieces of wood or catch 6 fish per day. Timmy can cut 9 pieces of wood or catch 18 fish per day. Which one of the following points is not on the Timmy’s production possibility frontier fish is on the horizontal axis and pieces of wood is on the vertical axis? a. (0, 9) b. (18, 0) c. (8,...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 74,000 Accounts receivable 143,000 Inventory 73,500 Plant and equipment, net of depreciation 224,000 Total assets $ 514,500 Liabilities and Stockholders’ Equity Accounts payable $ 85,000 Common stock 310,000 Retained earnings 119,500 Total liabilities and stockholders’ equity $ 514,500 Beech’s managers...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter...
Beech Corporation is a merchandising company that is preparing a master budget for the third quarter of the calendar year. The company’s balance sheet as of June 30th is shown below: Beech Corporation Balance Sheet June 30 Assets Cash $ 74,000 Accounts receivable 143,000 Inventory 73,500 Plant and equipment, net of depreciation 224,000 Total assets $ 514,500 Liabilities and Stockholders’ Equity Accounts payable $ 85,000 Common stock 310,000 Retained earnings 119,500 Total liabilities and stockholders’ equity $ 514,500 Beech’s managers...
ADVERTISEMENT
ADVERTISEMENT
ADVERTISEMENT