Hobart Company manufactures attaché cases and suitcases. It has
five manufacturing departments. The Molding, Component, and
Assembly departments convert raw materials into finished goods;
hence, they are treated as operating departments. The Power and
Maintenance departments are treated as service departments because
they support the three operating departments.
Hobart has always used a plantwide predetermined overhead rate with
direct labor-hours as the allocation base for product costing
purposes. The overhead rate is computed by dividing the company’s
total estimated overhead cost (across the five manufacturing
departments) by the total estimated direct labor-hours to be worked
in the three operating departments.
The company has been experiencing declining profits; therefore, it
is considering switching from plantwide overhead allocation to a
departmental approach. Under the departmental approach, the service
department costs would be allocated to the three operating
departments. Then each operating department would compute its own
overhead rate. The overhead rate in Molding would be based on
machine-hours and the rates in Component and Assembly would be
based on direct labor-hours.
The service departments’ estimated costs for the coming year are as
follows:
| Service Departments | ||||||
| Power | Maintenance | |||||
| Variable overhead cost | $ | 640,000 | $ | 25,000 | ||
| Fixed overhead cost | 1,200,000 | 375,000 | ||||
| Total overhead cost | $ | 1,840,000 | $ | 400,000 | ||
The Power Department would allocate its variable costs to the
operating departments based on estimated kilowatt hours used and it
would allocate its fixed costs based on the percentage of
peak-period capacity required. The Maintenance Department would
allocate its variable costs to the operating departments based on
estimated maintenance hours used and it would allocate its fixed
costs based on the percentage of peak-period capacity
required.
The corresponding data for allocating service department costs to
operating departments are as follows:
| Operating Departments | ||||||||
| Molding | Component | Assembly | ||||||
| Power department: | ||||||||
| Estimated kilowatt hours used | 36,000 | 32,000 | 12,000 | |||||
| Percentage of peak-period capacity | 50 | % | 35 | % | 15 | % | ||
| Maintenance Department: | ||||||||
| Estimated maintenance hours used | 9,000 | 2,500 | 1,000 | |||||
| Percentage of peak-period capacity | 70 | % | 20 | % | 10 | % | ||
The company also provided the following estimated data for its
three operating departments:
| Operating Departments | ||||||||||
| Molding | Component | Assembly | ||||||||
| Departmental costs: | ||||||||||
| Direct materials | $ | 1,630,000 | $ | 3,000,000 | $ | 25,000 | ||||
| Direct labor | 350,000 | 2,000,000 | 1,300,000 | |||||||
| Manufacturing overhead | 1,960,500 | 1,620,000 | 2,399,500 | |||||||
| Total departmental costs | $ | 3,940,500 | $ | 6,620,000 | $ | 3,724,500 | ||||
| Allocation bases: | ||||||||||
| Direct labor-hours | 50,000 | 200,000 | 150,000 | |||||||
| Machine-hours | 87,500 | 12,500 | 0 | |||||||
1. Compute the company’s predetermined plantwide overhead rate.
2. Assume the company decides to use departmental overhead rates.
a. Using the direct method, allocate the variable and fixed service department costs to the operating departments.
b. Calculate the predetermined departmental overhead rates for each of the three operating departments.
3. One of Hobart’s products is a small attaché
case that uses the following machine-hours and direct labor-hours
in the three operating departments:
| Machine-Hours | Direct Labor-Hours | |||||||
| Molding Department | 3,000 | 1,000 | ||||||
| Component Department | 800 | 2,500 | ||||||
| Assembly Department | 0 | 4,000 | ||||||
| Total hours | 3,800 | 7,500 | ||||||
a. Calculate the amount of overhead that would be
applied to this attaché case using the plantwide approach.
b. Calculate the amount of overhead that would be applied to this attaché case using the departmental approach.
4a. Is the plantwide approach overcosting or undercosting the attaché case compared to the departmental approach?
In: Accounting
Cost is classified on the basis of behaviour as fixed cost, variable cost and semi-variable cost. You are required to explain these 3 elements of cost with an example in an engineering organization
In: Accounting
what are the fixed cost variable cost, semi variable cost and sunk cost for oil and refinery sector companies like HPCL, IOL etc?
In: Accounting
Assignment Exercise 23–1: Cost of Owning and Cost of Leasing Cost of owning and cost of leasing tables are reproduced below.
Required Using the appropriate table from the Chapter 13 Time Value of Money Appendices appearing as 13-A, 13-B, and 13-C, record the present-value factor at 10% for each year and compute the present-value cost of owning and the present value of leasing. Which alternative is more desirable at this interest rate? Do you think your answer would change if the interest rate was 6% instead of 10%?
|
Cost of Owning—Anywhere Clinic—Comparative Present Value |
||||||
|
For-Profit Cost of Owning: |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Net Cash Flow |
(48,750) |
2,500 |
2,500 |
2,500 |
2,500 |
5,000 |
|
Present value factor |
||||||
|
Present value answers = |
||||||
|
Present value cost of owning = |
||||||
|
Cost of Leasing—Anywhere Clinic—Comparative Present Value |
||||||
|
For-Profit Cost of Leasing: |
Year 0 |
Year 1 |
Year 2 |
Year 3 |
Year 4 |
Year 5 |
|
Net Cash Flow |
(8,250) |
(8,250) |
(8,250) |
(8,250) |
(8,250) |
— |
|
Present value factor |
— |
|||||
|
Present value answers = |
||||||
|
Present value cost of leasing = |
||||||
In: Finance
Question 9 options:
Levi-Strauss Co manufactures clothing. The quality control department measures weekly values of different suppliers for the percentage difference of waste between the layout on the computer and the actual waste when the clothing is made (called run-up). The data is in the following table, and there are some negative values because sometimes the supplier is able to layout the pattern better than the computer ("Waste run up," 2013).
Table #11.3.3: Run-ups for Different Plants Making Levi Strauss Clothing
|
Plant 1 |
Plant 2 |
Plant 3 |
Plant 4 |
Plant 5 |
|
1.2 |
16.4 |
12.1 |
11.5 |
24 |
|
10.1 |
-6 |
9.7 |
10.2 |
-3.7 |
|
-2 |
-11.6 |
7.4 |
3.8 |
8.2 |
|
1.5 |
-1.3 |
-2.1 |
8.3 |
9.2 |
|
-3 |
4 |
10.1 |
6.6 |
-9.3 |
|
-0.7 |
17 |
4.7 |
10.2 |
8 |
|
3.2 |
3.8 |
4.6 |
8.8 |
15.8 |
|
2.7 |
4.3 |
3.9 |
2.7 |
22.3 |
|
-3.2 |
10.4 |
3.6 |
5.1 |
3.1 |
|
-1.7 |
4.2 |
9.6 |
11.2 |
16.8 |
|
2.4 |
8.5 |
9.8 |
5.9 |
11.3 |
|
0.3 |
6.3 |
6.5 |
13 |
12.3 |
|
3.5 |
9 |
5.7 |
6.8 |
16.9 |
|
-0.8 |
7.1 |
5.1 |
14.5 |
|
|
19.4 |
4.3 |
3.4 |
5.2 |
|
|
2.8 |
19.7 |
-0.8 |
7.3 |
|
|
13 |
3 |
-3.9 |
7.1 |
|
|
42.7 |
7.6 |
0.9 |
3.4 |
|
|
1.4 |
70.2 |
1.5 |
0.7 |
|
|
3 |
8.5 |
|||
|
2.4 |
6 |
|||
|
1.3 |
2.9 |
Do the data show that there is a difference between some of the suppliers? Test at the 1% level
**********************************************************************
Let x1 = percentage difference of waste between the layout on the computer and the actual waste when the clothing is made (called run-up) from plant 1
Let x2 = percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 2
Let x3 = percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 3
Let x4 = percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 4
Let x5 = percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 5
Let ?1 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 1
Let ?2 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 2
Let ?3 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 3
Let ?4 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 4
Let ?5 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 5
(i) Which of the following statements correctly defines the null hypothesis HO?
A. All five mean percentage differences are equal
B. Two of the mean percentage differences are not equal
C. At least four of the mean percentage differences are equal
D. At least two of the mean percentage differences are not equal
Enter letter corresponding to correct answer
Let ?1 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 1
Let ?2 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 2
Let ?3 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 3
Let ?4 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 4
Let ?5 = mean percentage difference of waste between the layout on the computer and the actual waste of run-up from plant 5
(ii) Which of the following statements correctly defines the alternate hypothesis HA?
A. All five mean percentage differences are equal
B. Two of the mean percentage differences are not equal
C. At least four of the mean percentage differences are equal
D. At least two of the mean percentage differences are not equal
Enter letter corresponding to correct answer
(iii) Enter the level of significance ? used for this test:
Enter in decimal form. Examples of correctly entered answers: 0.01 0.02 0.05 0.10
(iii) Calculate sample mean and sample standard deviation for Plant 1 sample
Enter sample mean in decimal form to nearest hundredth, then comma, then sample standard deviation in decimal form to nearest hundredth. Examples of correctly entered answers:
13.27,2.31
0.27,0.06
-10.30,0.79
(v) Calculate sample mean and sample standard deviation for Plant 2 sample
Enter sample mean in decimal form to nearest hundredth, then comma, then sample standard deviation in decimal form to nearest hundredth. Examples of correctly entered answers:
13.27,2.31
0.27,0.06
-10.30,0.79
(vi) Calculate sample mean and sample standard deviation for Plant 3 sample
Enter sample mean in decimal form to nearest hundredth, then comma, then sample standard deviation in decimal form to nearest hundredth. Examples of correctly entered answers:
13.27,2.31
0.27,0.06
-10.30,0.79
(vii) Calculate sample mean and sample standard deviation for Plant 4 sample
Enter sample mean in decimal form to nearest hundredth, then comma, then sample standard deviation in decimal form to nearest hundredth. Examples of correctly entered answers:
13.27,2.31
0.27,0.06
-10.30,0.79
(viii) Calculate sample mean and sample standard deviation for Plant 5 sample
Enter sample mean in decimal form to nearest hundredth, then comma, then sample standard deviation in decimal form to nearest hundredth. Examples of correctly entered answers:
13.27,2.31
0.27,0.06
-10.30,0.79
(ix) Using technology, determine F ratio test statistic and corresponding p-value.
Use "CTRL-click" to access link. Enter test statistic to nearest hundredth, then enter comma, then enter p-value to nearest thousandth. Examples of correctly entered responses:
12.33,0.004
7.50,0.000
6.77,0.504
(x) Comparing p-value and ? value, which is the correct decision to make for this hypothesis test?
A. Reject Ho
B. Fail to reject Ho
C. Accept Ho
D. Accept HA
In: Statistics and Probability
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 970,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the end of the year was $26. All of the company’s sales are on account.
| Weller Corporation Comparative Balance Sheet (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Assets | ||||||
| Current assets: | ||||||
| Cash | $ | 3,302 | $ | 4,230 | ||
| Accounts receivable, net | 16,100 | 9,100 | ||||
| Inventory | 10,550 | 8,880 | ||||
| Prepaid expenses | 1,970 | 2,440 | ||||
| Total current assets | 31,922 | 24,650 | ||||
| Property and equipment: | ||||||
| Land | 7,700 | 7,700 | ||||
| Buildings and equipment, net | 20,900 | 20,700 | ||||
| Total property and equipment | 28,600 | 28,400 | ||||
| Total assets | $ | 60,522 | $ | 53,050 | ||
| Liabilities and Stockholders' Equity | ||||||
| Current liabilities: | ||||||
| Accounts payable | $ | 11,200 | $ | 9,150 | ||
| Accrued liabilities | 940 | 1,550 | ||||
| Notes payable, short term | 470 | 470 | ||||
| Total current liabilities | 12,610 | 11,170 | ||||
| Long-term liabilities: | ||||||
| Bonds payable | 7,500 | 7,500 | ||||
| Total liabilities | 20,110 | 18,670 | ||||
| Stockholders' equity: | ||||||
| Common stock | 970 | 970 | ||||
| Additional paid-in capital | 5,050 | 5,050 | ||||
| Total paid-in capital | 6,020 | 6,020 | ||||
| Retained earnings | 34,392 | 28,360 | ||||
| Total stockholders' equity | 40,412 | 34,380 | ||||
| Total liabilities and stockholders' equity | $ | 60,522 | $ | 53,050 | ||
| Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Sales | $ | 96,000 | $ | 91,000 | ||
| Cost of goods sold | 60,500 | 56,500 | ||||
| Gross margin | 35,500 | 34,500 | ||||
| Selling and administrative expenses: | ||||||
| Selling expenses | 10,200 | 9,700 | ||||
| Administrative expenses | 13,700 | 12,700 | ||||
| Total selling and administrative expenses | 23,900 | 22,400 | ||||
| Net operating income | 11,600 | 12,100 | ||||
| Interest expense | 900 | 900 | ||||
| Net income before taxes | 10,700 | 11,200 | ||||
| Income taxes | 4,280 | 4,480 | ||||
| Net income | 6,420 | 6,720 | ||||
| Dividends to common stockholders | 388 | 776 | ||||
| Net income added to retained earnings | 6,032 | 5,944 | ||||
| Beginning retained earnings | 28,360 | 22,416 | ||||
| Ending retained earnings | $ | 34,392 | $ | 28,360 | ||
Required:
Compute the following financial data for this year:
1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
3. Return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
4. Return on equity. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)
In: Accounting
Exercise 14-5 Financial Ratios for Assessing Profitability [LO14-5] Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 820,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the end of the year was $19. All of the company’s sales are on account. Weller Corporation Comparative Balance Sheet (dollars in thousands) This Year Last Year Assets Current assets: Cash $ 3,812 $ 3,980 Accounts receivable, net 12,500 9,200 Inventory 9,800 8,280 Prepaid expenses 1,820 2,140 Total current assets 27,932 23,600 Property and equipment: Land 6,200 6,200 Buildings and equipment, net 19,400 19,200 Total property and equipment 25,600 25,400 Total assets $ 53,532 $ 49,000 Liabilities and Stockholders' Equity Current liabilities: Accounts payable $ 9,700 $ 8,400 Accrued liabilities 640 800 Notes payable, short term 320 320 Total current liabilities 10,660 9,520 Long-term liabilities: Bonds payable 7,500 7,500 Total liabilities 18,160 17,020 Stockholders' equity: Common stock 820 820 Additional paid-in capital 4,300 4,300 Total paid-in capital 5,120 5,120 Retained earnings 30,252 26,860 Total stockholders' equity 35,372 31,980 Total liabilities and stockholders' equity $ 53,532 $ 49,000 Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) This Year Last Year Sales $ 81,000 $ 76,000 Cost of goods sold 53,000 49,000 Gross margin 28,000 27,000 Selling and administrative expenses: Selling expenses 8,700 8,200 Administrative expenses 12,200 11,200 Total selling and administrative expenses 20,900 19,400 Net operating income 7,100 7,600 Interest expense 900 900 Net income before taxes 6,200 6,700 Income taxes 2,480 2,680 Net income 3,720 4,020 Dividends to common stockholders 328 656 Net income added to retained earnings 3,392 3,364 Beginning retained earnings 26,860 23,496 Ending retained earnings $ 30,252 $ 26,860 Required: Compute the following financial data for this year: 1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 3. Return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).) 4. Return on equity. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)
In: Accounting
Cuneo Company’s income statements for the last 3 years are as follows:
|
Cuneo Company |
|
Income Statements |
|
For the Years 1, 2, and 3 |
|
1 |
Year 1 |
Year 2 |
Year 3 |
|
|
2 |
Sales |
$1,000,000.00 |
$1,200,000.00 |
$1,700,000.00 |
|
3 |
Less: Cost of goods sold |
(700,000.00) |
(700,000.00) |
(1,000,000.00) |
|
4 |
Gross margin |
$300,000.00 |
$500,000.00 |
$700,000.00 |
|
5 |
Less operating expenses: |
|||
|
6 |
Selling expenses |
(150,000.00) |
(220,000.00) |
(250,000.00) |
|
7 |
Administrative expenses |
(50,000.00) |
(60,000.00) |
(120,000.00) |
|
8 |
Operating income |
$100,000.00 |
$220,000.00 |
$330,000.00 |
|
9 |
Less: |
|||
|
10 |
Interest expense |
(25,000.00) |
(25,000.00) |
(25,000.00) |
|
11 |
Income before taxes |
$75,000.00 |
$195,000.00 |
$305,000.00 |
| Required: | |
| 1. | Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
| 2. | Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
| 3. | Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Round percentages to the nearest tenth of a percent.) |
1. Prepare a common-size income statement for Year 1 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 1 |
|
1 |
Year 1 |
Percent of Sales in Year 1 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
2. Prepare a common-size income statement for Year 2 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 2 |
|
1 |
Year 2 |
Percent of Sales in Year 2 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
3. Prepare a common-size income statement for Year 3 by expressing each line item as a percentage of sales revenue. (Note: Enter all amounts as positive numbers. Round answers to the nearest tenth of a percent. Refer to the Labels and Amount Descriptions list provided for the exact wording of the answer choices for text entries.)
|
Cuneo Company |
|
Income Statement |
|
For Year 3 |
|
1 |
Year 3 |
Percent of Sales in Year 3 |
|
|
2 |
|||
|
3 |
|||
|
4 |
|||
|
5 |
|||
|
6 |
|||
|
7 |
|||
|
8 |
|||
|
9 |
|||
|
10 |
|||
|
11 |
In: Accounting
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 800,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the end of this year was $18. All of the company’s sales are on account.
| Weller Corporation Comparative Balance Sheet (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Assets | ||||||
| Current assets: | ||||||
| Cash | $ | 1,280 | $ | 1,560 | ||
| Accounts receivable, net | 12,300 | 9,100 | ||||
| Inventory | 9,700 | 8,200 | ||||
| Prepaid expenses | 1,800 | 2,100 | ||||
| Total current assets | 25,080 | 20,960 | ||||
| Property and equipment: | ||||||
| Land | 6,000 | 6,000 | ||||
| Buildings and equipment, net | 19,200 | 19,000 | ||||
| Total property and equipment | 25,200 | 25,000 | ||||
| Total assets | $ | 50,280 | $ | 45,960 | ||
| Liabilities and Stockholders' Equity | ||||||
| Current liabilities: | ||||||
| Accounts payable | $ | 9,500 | $ | 8,300 | ||
| Accrued liabilities | 600 | 700 | ||||
| Notes payable, short term | 300 | 300 | ||||
| Total current liabilities | 10,400 | 9,300 | ||||
| Long-term liabilities: | ||||||
| Bonds payable | 5,000 | 5,000 | ||||
| Total liabilities | 15,400 | 14,300 | ||||
| Stockholders' equity: | ||||||
| Common stock | 800 | 800 | ||||
| Additional paid-in capital | 4,200 | 4,200 | ||||
| Total paid-in capital | 5,000 | 5,000 | ||||
| Retained earnings | 29,880 | 26,660 | ||||
| Total stockholders' equity | 34,880 | 31,660 | ||||
| Total liabilities and stockholders' equity | $ | 50,280 | $ | 45,960 | ||
| Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Sales | $ | 79,000 | $ | 74,000 | ||
| Cost of goods sold | 52,000 | 48,000 | ||||
| Gross margin | 27,000 | 26,000 | ||||
| Selling and administrative expenses: | ||||||
| Selling expenses | 8,500 | 8,000 | ||||
| Administrative expenses | 12,000 | 11,000 | ||||
| Total selling and administrative expenses | 20,500 | 19,000 | ||||
| Net operating income | 6,500 | 7,000 | ||||
| Interest expense | 600 | 600 | ||||
| Net income before taxes | 5,900 | 6,400 | ||||
| Income taxes | 2,360 | 2,560 | ||||
| Net income | 3,540 | 3,840 | ||||
| Dividends to common stockholders | 320 | 600 | ||||
| Net income added to retained earnings | 3,220 | 3,240 | ||||
| Beginning retained earnings | 26,660 | 23,420 | ||||
| Ending retained earnings | $ | 29,880 | $ | 26,660 | ||
Required:
Compute the following financial data for this year:
1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
3. Return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
4. Return on equity. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)
In: Accounting
Exercise 14-5 Financial Ratios for Assessing Profitability [LO14-5]
Comparative financial statements for Weller Corporation, a merchandising company, for the year ending December 31 appear below. The company did not issue any new common stock during the year. A total of 800,000 shares of common stock were outstanding. The interest rate on the bond payable was 12%, the income tax rate was 40%, and the dividend per share of common stock was $0.75 last year and $0.40 this year. The market value of the company’s common stock at the end of this year was $18. All of the company’s sales are on account.
|
Weller Corporation Comparative Balance Sheet (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Assets | ||||||
| Current assets: | ||||||
| Cash | $ | 1,280 | $ | 1,560 | ||
| Accounts receivable, net | 12,300 | 9,100 | ||||
| Inventory | 9,700 | 8,200 | ||||
| Prepaid expenses | 1,800 | 2,100 | ||||
| Total current assets | 25,080 | 20,960 | ||||
| Property and equipment: | ||||||
| Land | 6,000 | 6,000 | ||||
| Buildings and equipment, net | 19,200 | 19,000 | ||||
| Total property and equipment | 25,200 | 25,000 | ||||
| Total assets | $ | 50,280 | $ | 45,960 | ||
| Liabilities and Stockholders' Equity | ||||||
| Current liabilities: | ||||||
| Accounts payable | $ | 9,500 | $ | 8,300 | ||
| Accrued liabilities | 600 | 700 | ||||
| Notes payable, short term | 300 | 300 | ||||
| Total current liabilities | 10,400 | 9,300 | ||||
| Long-term liabilities: | ||||||
| Bonds payable | 5,000 | 5,000 | ||||
| Total liabilities | 15,400 | 14,300 | ||||
| Stockholders' equity: | ||||||
| Common stock | 800 | 800 | ||||
| Additional paid-in capital | 4,200 | 4,200 | ||||
| Total paid-in capital | 5,000 | 5,000 | ||||
| Retained earnings | 29,880 | 26,660 | ||||
| Total stockholders' equity | 34,880 | 31,660 | ||||
| Total liabilities and stockholders' equity | $ | 50,280 | $ | 45,960 | ||
|
Weller Corporation Comparative Income Statement and Reconciliation (dollars in thousands) |
||||||
| This Year | Last Year | |||||
| Sales | $ | 79,000 | $ | 74,000 | ||
| Cost of goods sold | 52,000 | 48,000 | ||||
| Gross margin | 27,000 | 26,000 | ||||
| Selling and administrative expenses: | ||||||
| Selling expenses | 8,500 | 8,000 | ||||
| Administrative expenses | 12,000 | 11,000 | ||||
| Total selling and administrative expenses | 20,500 | 19,000 | ||||
| Net operating income | 6,500 | 7,000 | ||||
| Interest expense | 600 | 600 | ||||
| Net income before taxes | 5,900 | 6,400 | ||||
| Income taxes | 2,360 | 2,560 | ||||
| Net income | 3,540 | 3,840 | ||||
| Dividends to common stockholders | 320 | 600 | ||||
| Net income added to retained earnings | 3,220 | 3,240 | ||||
| Beginning retained earnings | 26,660 | 23,420 | ||||
| Ending retained earnings | $ | 29,880 | $ | 26,660 | ||
Required:
Compute the following financial data for this year:
1. Gross margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
2. Net profit margin percentage. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
3. Return on total assets. (Round your percentage answer to 1 decimal place (i.e., 0.1234 should be entered as 12.3).)
4. Return on equity. (Round your percentage answer to 2 decimal places (i.e., 0.1234 should be entered as 12.34).)
In: Accounting