Wolford Department Store is located in midtown Metropolis. During the past several years, net income has been declining because suburban shopping centers have been attracting business away from city areas. At the end of the company’s fiscal year on November 30, 2017, these accounts appeared in its adjusted trial balance.
Accounts Payable $ 26,800
Accounts Receivable 17,200
Accumulated Depreciation—
Equipment 68,000
Cash 8,000
Common Stock 35,000
Cost of Goods Sold 614,300
Freight-Out 6,200
Equipment 157,000
Depreciation Expense 13,500
Dividends 12,000
Gain on Disposal of Plant Assets 2,000
Income Tax Expense 10,000
Insurance Expense 9,000
Interest Expense 5,000
Inventory 26,200
Notes Payable 43,500
Prepaid Insurance 6,000
Advertising Expense 33,500
Rent Expense 34,000
Retained Earnings 14,200
Salaries and Wages Expense 117,000
Sales Revenue 904,000
Salaries and Wages Payable 6,000
Sales Returns and Allowances 20,000
Utilities Expense 10,600

Respuesta :

Answer:

                Wolford Department Store

                     Income Statement

      For the Year Ended November 30,2017

Sales Revenue                                      $904,000

Sales Returns and Allowances             ($20,000 )

Net Sales                                               $884,000

Cost of Goods Sold                              ($614,300)

Gross profit                                           $269,700

Operating expenses:

  • Wages Expense $117,000
  • Advertising Expense $33,500
  • Rent Expense $34,000
  • Depreciation Expense $13,500
  • Insurance Expense $9,000
  • Utilities Expense $10,600
  • Freight-Out $6,200

Total operating expenses                   ($223,800)

Income from operations                         $45,900

Other revenues:

Gain on Disposal of Plant Assets            $2,000  

Other expenses:

Interest Expense                                     ($5,000 )

Income before income taxes                 $42,900

Income Tax Expense                             ($10,000)

Net income after taxes                         $32,900

                Wolford Department Store

                         Balance Sheet

      For the Year Ended November 30,2017

Assets:

Cash $8,000

Accounts Receivable $17,200

Prepaid Insurance $6,000

Inventory $26,200

Equipment $157,000

Accumulated Depreciation - Equipment (68,000)

Total Assets: $146,400

Liabilities and Stockholders' Equity:

Accounts Payable $26,800

Wages Payable $6,000

Notes Payable $43,500

Common Stock $35,000

Retained Earnings $35,100

Total Liabilities and Stockholders' Equity: $146,400

                Wolford Department Store

           Statement of Retained Earnings

      For the Year Ended November 30,2017

Retained earnings at the beginning of the period: $14,200

Net income after taxes:                                             $32,900

Dividends                                                                  ($12,000)

Retained earnings at he end of the period:           $35,100

a. The Wolford Department Store's Multi-level Income Statement, Balance Sheet, and Statement of Retained Earnings as of November 30, 2017 are as follows:

Wolford Department Store

Income Statement

For the Year Ended November 30,2017

Sales Revenue                                      $904,000

Sales Returns and Allowances             ($20,000)

Net Sales                                              $884,000

Cost of Goods Sold                              ($614,300)

Gross profit                                          $269,700

Operating expenses:

Wages Expense                $117,000

Advertising Expense           33,500

Rent Expense                      34,000

Depreciation Expense        13,500

Insurance Expense              9,000

Utilities Expense                10,600

Freight-out                          6,200

Total operating expenses                 ($223,800)

Income from operations                         $45,900

Other revenues:

Gain from Disposal of Plant Assets         $2,000  

Other expenses:

Interest Expense                                     ($5,000)

Income before Income Taxes              $42,900

Income Tax Expense                             ($10,000)

Net Income After Taxes                       $32,900

Wolford Department Store

Balance Sheet

As of November 30,2017

Assets:

Current Assets:

Cash                                                                         $8,000

Accounts Receivable                                               17,200

Prepaid Insurance                                                    6,000

Inventory                                                                 26,200

Current assets                                                     $57,400

Long-term assets:

Equipment                           $157,000

Accumulated Depreciation  (68,000)               $89,000

Total Assets                                                      $146,400

Liabilities and Stockholders' Equity:

Current Liabilities:

Accounts Payable                                             $26,800

Wages Payable                                                     6,000

Current liabilities                                            $32,800

Long-term liabilities  

Notes Payable                                                $43,500

Total liabilities                                                $76,300

Equity:

Common Stock                                              $35,000

Retained Earnings                                            35,100

Total Equity                                                    $70,100

Total Liabilities & Stockholders' Equity  $146,400

Wolford Department Store

Statement of Retained Earnings

As of November 30,2017

Retained earnings 1 Dec. 2016         $14,200

Net income after taxes                       32,900

Dividends                                         ($12,000)

Retained earnings, Nov. 30, 2017 $35,100

b) The profitability ratios are computed as follows:

1. Profit Margin = (Net Income/Net Sales x 100)

= $32,900/$884,000 x 100

= 3.72%

2. Gross Profit rate = Gross Profit/Net Sales x 100)

= $269,700/$884,000 x 100

= 30.51%

c. If the net sales increases by 15%, the Net sales = $1,016,600 ($884,000 x 1.15)

If Gross profit increases by $40,443, the Gross profit = $310,143 ($269,700 + $40,443)

If Expenses increase by $58,600, the total operating Expenses = $282,400 ($223,800 + $58,600)

Revised Net Income:

Gross Profit                                              $310,143

Total operating expenses                     (282,400)

Income from operations                          $27,743

Other revenues:

Gain from Disposal of Plant Assets         $2,000  

Other expenses:

Interest Expense                                     ($5,000)

Income before Income Taxes               $24,743

Income Tax Expense                            ($10,000)

Net Income After Taxes                        $14,743

b) The profitability ratios are computed as follows:

1. Profit Margin = (Net Income/Net Sales x 100)

= $14,743/$1,016,600 x 100

= 1.45%

2. Gross Profit rate = Gross Profit/Net Sales x 100)

= $310,143/$1,016,600 x 100

= 30.51%

d. With the proposed changes, the gross profit rate remains the same (without any impact) because the net sales increased by the same rate (15%) as the cost of goods sold and the gross profit.

However, the net income reduced drastically, especially with the income tax remaining the same amount.

Thus, without the income tax effect, there is no merit in this proposal as it reduced the net income margin from 3.72% to 1.45%.

Learn more: https://brainly.com/question/24127784