Questions
See last 2 tables 1) budgeted mthly income statements. where i have added comments are the...

See last 2 tables

1) budgeted mthly income statements. where i have added comments are the items i need . i have put answers that are not correct for june and total column last 3 items for each column

2) for budgedted balance sheet I have added comments on answer section . I have put answers that are not correct for interest payable and stockholders'equity.  

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 months in 2010 are as follows:

Month Sales Revenue
January $50,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 2,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 $3,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 $Answer $Answer $Answer $Answer

(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 $Answer $Answer $Answer $Answer

(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 $Answer $Answer $Answer $Answer

(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 $Answer $Answer $Answer $Answer
Receipts Answer Answer Answer Answer
Disbursements Answer Answer Answer Answer
Excess receipts over disb. Answer Answer Answer Answer
Balance before borrowings Answer Answer Answer Answer
Borrowings Answer Answer Answer Answer
Loan repayments Answer Answer Answer Answer
Cash balance, ending $Answer $Answer $Answer $Answer

(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 $Answer $Answer $Answer $Answer
Cost of sales Answer Answer Answer Answer
Gross profit Answer Answer Answer Answer
Operating expenses:
Wages and salaries Answer Answer Answer Answer
Depreciation Answer Answer Answer Answer
Utilities Answer Answer Answer Answer
Rent Answer Answer Answer Answer
Insurance Answer Answer Answer Answer
Interest Answer Answer Answer(not 630) Answer(not 1,240)
Total expenses Answer Answer Answer(not 31,130) Answer(not 92,740)
Net income $Answer $Answer $Answer(not 3,870) $Answer(not 2,740)

(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 $Answer Merchandise payable $Answer
Accounts receivable Answer Dividend payable Answer
Inventory Answer Rent payable Answer
Prepaid insurance Answer Loans payable Answer
Fixtures Answer Interest payable Answer(not 1,240)
Total assets $Answer Stockholders' equity Answer(not 20,260)
Total liab. & equity $Answer(yes 123,500)

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

In: Accounting

The balance sheet for Tactex Controls Inc., provincially incorporated in 2018, reported the following components of...

The balance sheet for Tactex Controls Inc., provincially incorporated in 2018, reported the following components of equity on December 31, 2019.

Tactex Controls Inc.
Equity Section of the Balance Sheet
December 31, 2019
Contributed capital:
Preferred shares, $1.4 cumulative, unlimited shares authorized; 13,000 shares issued and outstanding $ 385,000
Common shares, unlimited shares authorized; 68,000 shares issued and outstanding 728,000
Total contributed capital $ 1,113,000
Retained earnings 371,000
Total equity $ 1,484,000


In 2020 and 2021, the company had the following transactions affecting shareholders and the equity accounts:

2020
Jan. 1 Sold 23,000 common shares at $9.94 per share.
5 The directors declared a total cash dividend of $224,000 payable on Feb. 28 to the Feb. 5 shareholders of record. Dividends had not been declared for the years 2018 and 2019. All of the preferred shares had been issued during 2018.
Feb. 28 Paid the dividends declared on January 5.
July 1 Sold preferred shares for a total of $156,100. The average issue price was $20 per share.
Dec. 31 Closed the dividend accounts along with the $576,100 credit balance in the Income Summary account.
2021
Sept. 5 The directors declared the required cash dividend on the preferred shares and a $0.7 per common share cash dividend payable on October 28 to the October 5 shareholders of record.
Oct. 28 Paid the dividends declared on September 5.
Dec. 31 Closed the Cash Dividends account along with the $542,500 credit balance in the Income Summary account.


Required:
1. Prepare journal entries to record the transactions and closings for 2020 and 2021. The company uses a cash dividends account to record declared dividends.




2. Prepare a statement of changes in equity for the year ended December 31, 2021. (Amounts to be deducted should be indicated by a minus sign.)



3. Prepare the equity section of the company’s balance sheet as of December 31, 2021.

In: Accounting

My goal is to be a NC-programmer of CNC machinist. "Describe/illustrate if all conditions were ideal...

My goal is to be a NC-programmer of CNC machinist.

"Describe/illustrate if all conditions were ideal and you believed that all things were possible, what would you seek to achieve as your life's work or major accomplishment?"

Please write the answer at least 200 words. Thanks.

In: Mechanical Engineering

Who do you think is “right": the SEDA paper or the “Events are a Bad Idea"...

  • Who do you think is “right": the SEDA paper or the “Events are a Bad Idea" paper and why? Justify your answer.
  • What is the difference between Mesa and Hoare Monitor semantics?
    • Which is simpler from the perspective of the application programmer?
    • Which is simpler from the perspective of the OS developer? Why?

In: Computer Science

1. An entrepreneur starts a small firm with one machine, and a small factory space and...

1. An entrepreneur starts a small firm with one machine, and a small factory space and employs one person initially. With the aid of appropriate diagrams/table and theory, explain the process of production as he increases his output. Indicate clearly what law governs this process of production, the variable and the fixed factors used by this entrepreneur.

2. Discuss the effect of covid-19 on the level of unemployment in Ghana.

3. In March 2020 Ghana recorded its first case of Covid-19 and which subsequently led to a lock down in Kumasi and Accra. Using appropriate diagrams explain the effect of the covid-19 pandemic on equilibrium price and quantity of sanitizers on the market:

  1. Before the lock down

b. After the lock down.

In: Economics

1. An entrepreneur starts a small firm with one machine, and a small factory space and...

1. An entrepreneur starts a small firm with one machine, and a small factory space and employs one person initially. With the aid of appropriate diagrams/table and theory, explain the process of production as he increases his output. Indicate clearly what law governs this process of production, the variable and the fixed factors used by this entrepreneur.
2. Discuss the effect of covid-19 on the level of unemployment in Ghana.
3. In March 2020 Ghana recorded its first case of Covid-19 and which subsequently led to a lock down in Kumasi and Accra. Using appropriate diagrams explain the effect of the covid-19 pandemic on equilibrium price and quantity of sanitizers on the market:
a. Before the lock down
b. After the lock down.

In: Economics

Sara’s Ice Cream Shop is closed for six months out of the year but has had...

Sara’s Ice Cream Shop is closed for six months out of the year but has had the monthly sales amounts listed below for the last four years.

Year: 2017 2018 2019 2020
May $ 436,033 $ 928,871 $ 535,489 $ 851,191
June 743,438 1,084,328 597,962 741,114
July 1,450,963 1,250,431 1,564,817 1,580,619
August 1,429,245 1,795,341 1,851,460 1,590,258
September 1,179,072 1,023,971 683,804 724,065
October 370,097 466,349 484,744 653,776

Asssuming that there is both seasonality and a trend, estimate monthly sales for each month of the coming year.

2021
MAY
JUNE
JULY
AUGUST
SEPTEMBER
OCTOBER

In: Operations Management

To start a three-phase motor, three switches (A, B and C) are required in such a...

To start a three-phase motor, three switches (A, B and C) are required in such a way that its operation occurs only under the following conditions: • When closed only B • When closed only C • When A and B are simultaneously closed and C is not closed • When A and C are simultaneously closed and B is not closed

In: Mechanical Engineering

11- Clampett, Inc., has been an S corporation since its inception. On July 15, 2020, Clampett,...

11-

Clampett, Inc., has been an S corporation since its inception. On July 15, 2020, Clampett, Inc., distributed $53,000 to J.D. His basis in his Clampett, Inc., stock on January 1, 2020, was $46,000. For 2020, J.D. was allocated $6,000 of ordinary income from Clampett, Inc., and no separately stated items. What is J.D.'s basis in his Clampett, Inc., stock after all transactions in 2020?

Multiple Choice

  • $52,000.

  • None of the choices are correct.

  • ($6,000).

  • $46,000.

  • $40,000.

In: Accounting