Problem 15-19
This Year
1. a. Net income.
$280,000
Average number of common
shares (b).
Last Year
$196,000
$280,000/50,00
Earnings per share (a) (b). 0 = $5.60
$196,000/50,000
= $3.92
$2.20/$40.00*1 $1.90/$36.00*100
b. Dividends per share (a). 00= 5.5%
=5
This is a word doc and NOT a spreadsheet. The publisher
removed the spreadsheet therefore, I created this document. I
left a lot of the figures in the document as check figures to help
you through this one.
Problem 14-14
1. Prepare a statement of cash flo
Q15.Defineacorporatestakeholder.Whichgroupsareconsideredstakeholders?Wouldshareholders
alsobeconsideredstakeholders?Compare,intermsofeconomicsystems,theprincipleofmaximizing
shareholderwealthwiththeprincipleofsatisfyingstakeholderclaims
Shareholders are t
Exercise 17-9
Your answer is correct.
Danny Badens Verde Vineyards in Oakville, California, produces three
varieties of wine: Merlot, Viognier, and Pinot Noir. His winemaster, Russel
Hansen, has identified the following activities as cost pools for accumu
Select the statement that best distinguishes between a favorable variance and an unfavorable
variance.
A.
A favorable variance has a result of increasing sales revenue relative to the budgeted amount. An
unfavorable variance has a result of decreasing var
Chapter 5: Applying Excel
Data
Unit sales
Selling price per unit
Variable expenses per unit
Fixed expenses
20,000 units
$60 per unit
$45 per unit
$240,000
Enter a formula into each of the cells marked with a ? below
Review Problem: CVP Relationships
Compu
Exercise 17-1 (Part Level Submission)
Wilkins Inc. has two types of handbags: standard and custom. The
controller has decided to use a plantwide overhead rate based on direct
labor costs. The president has heard of activity-based costing and wants
to see
b3e217b3c44dae88ea5b9772d6fea7d483806f15.xls
Chapter 12: Applying Excel
Data
Exhibit 12-6 Santa Maria Wool Cooperative
Cost of wool
Cost of separation process
Sales value of intermediate products at split-off point:
Undyed coarse wool
Undyed fine wool
Und
b235ed7e37179ea663047d78e68e6732814f2702.xls
Chapter 5: Applying Excel
Data
Unit sales
Selling price per unit
Variable expenses per unit
Fixed expenses
20,000 units
$60 per unit
$45 per unit
$240,000
Enter a formula into each of the cells marked with a ?
Chapter 3: Applying Excel
Data
Allocation base
Estimated manufacturing overhead cost
Estimated total amount of the allocation base
Actual manufacturing overhead cost
Actual total amount of the allocation base
Machine-hours
$300,000
75,000
$290,000
68,000
Chapter 2: Applying Excel
Data
Sales
Variable costs:
Cost of goods sold
Variable selling
Variable administrative
Fixed costs:
Fixed selling
Fixed administrative
$12,000
$6,000
$600
$400
$2,500
$1,500
Enter a formula into each of the cells marked with a ?
Student Name:
Class:
Problem 14-8
1. and 2.
Calculation of depreciation to add back to Net Income:
Accumulated Depreciation, beginning balance
Accumulated Depreciation, ending balance
Debits to Accumulated Depreciation
Credits to Accumulated Depreciation
Student Name:
Class:
Problem 15-11
1.
MODERN BUILDING SUPPLY
Ratios
This Year
Working capital
Current ratio
Acid-test ratio
Accounts receivable turnover
Average collection period
Inventory turnover ratio
Average sales period
Debt-to-equity ratio
Times int
6fe4f509b0cd56bf2776d3ddb001dad6c01979bf.xls
Chapter 7: Applying Excel
Data
Manufacturing overhead
Selling and administrative overhead
Manufacturing overhead
Selling and administrative overhead
Total activity
OfficeMart orders:
Customers
Orders
Number of
bcc8a3e0dfaea3f4b4558378aa25482ee072a6cb.xls
Chapter 8: Applying Excel
Data
Budgeted unit sales
Selling price per unit
Accounts receivable, beginning balance
Sales collected in the quarter sales are made
Sales collected in the quarter after sales are
aa40f33675223cf44efc2ffa4310ff53307273e5.xls
Chapter 6: Applying Excel
Data
Selling price per unit
Manufacturing costs:
Variable per unit produced:
Direct materials
Direct labor
Variable manufacturing overhead
Fixed manufacturing overhead per year
Selling
ff1db4c886f054ca3306d78b653721e0f41e05c2.xls
Chapter 4: Applying Excel
Data
Work in process, beginning:
Units in process
Completion with respect to materials
Completion with respect to conversion
Costs in the beginning inventory:
Materials cost
Conversion
5d880875f576ef1eb8389f8230a41cc191016c0b.xls
Chapter 10: Applying Excel
Data
Exhibit 10-2: Standard Cost Card
Inputs
Direct materials
Direct labor
Variable manufacturing overhead
Actual results:
Actual output
Actual variable manufacturing overhead cost
Ac
b67c4287feaf2f38dd469da3fa9de22b78337e3f.xlsx
Chapter 13: Applying Excel
Data
Example C
Cost of equipment needed
Working capital needed
Overhaul of equipment in
Salvage value of the equipment in
Annual revenues and costs:
Sales revenues
Cost of goods sold
639563c5857c56ef38f1a628a500f791461fc8df.xlsx
Chapter 11: Applying Excel
Data
Sales
Net operating income
Average operating assets
Minimum required rate of return
$25,000,000
$3,000,000
$10,000,000
25%
Enter a formula into each of the cells marked with a ?
Problem 15-19
This
Last
Year
Year
$280,00 $196,00
1. a. Net income.
0
0
Average number of common
shares (b).
Earnings per share (a) (b).
b. Dividends per share (a).
Market price per share (b).
Dividend yield ratio (a) (b).
c. Dividends per share (a).
Earn
Chapter 3: Applying Excel
Data
Allocation base
Estimated manufacturing overhead cost
Estimated total amount of the allocation base
Actual manufacturing overhead cost
Actual total amount of the allocation base
Machine-hours
$300,000
75,000 machine-hours
$2
GROUP FINANCIAL STATEMENT ANALYSIS PROJECT
The objective is to prepare a report comparing two firms that are competitors in the
same industry to determine which company appears to be a better investment from the
viewpoint of a potential shareholder. The t
Chapter 2: Applying Excel
Data
Sales
Variable costs:
Cost of goods sold
Variable selling
Variable administrative
Fixed costs:
Fixed selling
Fixed administrative
$12,000
$6,000
$600
$400
$2,500
$1,500
Enter a formula into each of the cells marked with a ?
8dc147a14744ee6ac5e79ef8257034334b196634.xls
Chapter 4: Applying Excel
Data
Work in process, beginning:
Units in process
Completion with respect to materials
Completion with respect to conversion
Costs in the beginning inventory:
Materials cost
Conversion
8bc2263b0ef444d113db622e317ba581f2a1e276.xls
Chapter 8: Applying Excel
Data
Budgeted unit sales
Selling price per unit
Accounts receivable, beginning balance
Sales collected in the quarter sales are made
Sales collected in the quarter after sales are
Cognizant, which posted $10.3 billion in revenue last year, is still small
compared with consulting heavyweights Accenture ($30 billion) and IBMs
services division ($51 billion). But Cognizants shift toward consulting
appears to be paying off: Profit is e
Chapter 3: Applying Excel
Data
Allocation base
Estimated manufacturing overhead cost
Estimated total amount of the allocation base
Actual manufacturing overhead cost
Actual total amount of the allocation base
Machine-hours
$300,000
75,000
$290,000
68,000
63bfdee324dd0fbf9b6e5b163072023bb72853e4.xls
Chapter 6: Applying Excel
Data
Selling price per unit
Manufacturing costs:
Variable per unit produced:
Direct materials
Direct labor
Variable manufacturing overhead
Fixed manufacturing overhead per year
Selling