View the step-by-step solution to:

# Pinnacle Manufacturing Company Income Statement For the Year ended December 31 2011 Net sales Cost of goods sold Gross profit Operating expenses...

I need help finding these answers. I am attaching my current solutions in an excel format.

f.Explain whether you believe the information in requirement d or e provides the most useful data for evaluating the potential for misstatements. Explain why.

g.Analyze the account balances for accounts receivable, inventory, and short/current long-term debt. Describe any observations about those accounts and discuss additional information you want to consider during the current year audit.

h. Based on your calculations, assess the likelihood (high, medium, or low) that Pinnacle is likely to fail financially in the next 12 months. (Arens 247)
Arens, Alvin A, Randal J Elder, and Mark Beasley. Auditing and Assurance Services, VitalSource for DeVry University, 14th Edition. Pearson Learning Solutions, 12/2012.

Pinnacle Manufacturing Company
Income Statement
For the Year ended December 31
2011
Net sales
Cost of goods sold
Gross profit
Operating expenses
Income from operations
Other revenues and gains
Other expenses and losses
Income before income tax
Income tax
Net income for the year
Earnings per share \$150,737,628
109,284,780
41,452,848
37,177,738
4,275,110

2,181,948
2,093,162
883,437
1,209,725
\$1.21 % Change
101.45%
102.85%
97.93%
97.49%
101.87%
94.90%
110.32%
102.85%
116.50%
116.50% 2010
\$148,586,037
106,255,499
42,330,538
38,133,969
4,196,569

2,299,217
1,897,352
858,941
1,038,411
\$1.04 % Change
102.70%
104.18%
99.14%
102.40%
76.90%
95.88%
62.02%
64.03%
60.46%
60.46% 2009
\$144,686,413
101,988,165
42,698,248
37,241,108
5,457,140

2,397,953
3,059,187
1,341,536
1,717,651
\$1.72 Pinnacle Manufacturing Company
Balance Sheet
As of December 31
Assets
Current assets
Cash and cash equivalents
Net receivables
Inventory
Other current assets
Total current assets
Property, plant and equipment
Total assets \$7,721,279
13,042,165
32,236,021
172,278
53,171,743
62,263,047
\$115,434,790 105.41%
151.30%
126.23%
120.30%
127.74%
101.02%
111.79% \$7,324,846
8,619,857
25,537,198
143,206
41,625,107
61,635,530
\$103,260,637 90.81%
108.61%
101.05%
108.70%
100.53%
105.78%
103.60% \$8,066,545
7,936,409
25,271,503
131,742
41,406,199
58,268,732
\$99,674,931 Liabilities
Current liabilities
Accounts payable
Short/current long-term debt
Other current liabilities
Total current liabilities
Long-term debt
Total liabilities \$12,969,686
15,375,819
2,067,643
30,413,148
24,420,090
54,833,238 137.09%
149.30%
116.99%
141.28%
109.30%
124.99% \$9,460,776
10,298,668
1,767,360
21,526,804
22,342,006
43,868,810 124.71%
106.47%
105.04%
113.65%
99.83%
106.16% \$7,586,374
9,672,670
1,682,551
18,941,595
22,379,920
41,321,515 1,000,000
15,717,645
43,883,907
60,601,552
\$115,434,790 100.00%
100.00%
102.83%
102.04%
111.79% 1,000,000
15,717,645
42,674,182
59,391,827
\$103,260,637 100.00%
100.00%
102.49%
101.78%
103.60% 1,000,000
15,717,645
41,635,771
58,353,416
\$99,674,931 Stockholders’ equity
Common stock
Retained earnings
Total stockholders’ equity
Total liabilities &amp; stockholders’ equity A)
Account Balance
Net Sales
Cost of Goods Sold
Gross Profit
Accounts Payable
Total Assets B)
Ratio
Current Ratio
Gross Profit Ratio
Net Income Ratio
Quick Ratio
Asset Turnover 2011 % Change % Change
2010-2011
101.45%
102.85%
97.93%
137.09%
111.79% 2011
174.8%
27.5%
0.8%
68.8%
130.6% 2010 % Change
2009-2010
102.70%
104.18%
99.14%
124.71%
103.60% 2010
193.4%
28.5%
0.7%
74.7%
143.9% 2009
218.6%
29.5%
1.2%
85.2%
145.2% % Change 2009 Pinnacle Manufacturing Company
Balance Sheet - All Divisions
As of December 31 ASSETS
CURRENT ASSETS
Cash and cash equivalents
Inventory
Prepaid expenses
Deposits
Total current assets
PROPERTY, PLANT, AND EQUIPMENT
Land
Automobiles
Accum. depreciation: Automobiles
Office equipment
Accum.depreciation: Office equipment
Manufacturing equipment
Accum. depreciation: Manufacturing equipment
Manufacturing building
Accum. depreciation: Manufacturing building
Office building
Accum.depreciation: Office building
Total property, plant, and equipment
TOTAL ASSETS 2011
Dollar Value 2010
Dollar Value 2009
Dollar Value \$7,721,279
14,008,633
(966,468)
32,236,021
119,081
53,197
53,171,743 \$7,324,846
9,586,325
(966,468)
25,537,198
106,353
36,853
41,625,107 \$8,066,545
8,879,352
(942,943)
25,271,503
102,650
29,092
41,406,199 11,490,036
266,071
(198,218)
5,494,707
(2,962,472)
13,918,820
(3,319,983)
41,106,800
(11,098,836)
13,262,479
(5,696,357)
62,263,047
\$115,434,790 11,490,036
220,313
(166,835)
5,238,368
(2,136,395)
11,543,824
(2,796,754)
38,056,625
(8,410,681)
13,025,447
(4,428,418)
61,635,530
\$103,260,637 4,159,580
220,313
(122,769)
4,924,055
(1,417,025)
11,179,813
(2,429,272)
38,056,625
(7,074,110)
13,025,447
(2,253,925)
58,268,732
\$99,674,931 LIABILITIES AND STOCKHOLDERS' EQUITY
- - CURRENT LIABILITIES
Note payable: Bank
Current portion of long-term debt
Accrued payroll and withholding taxes
Accrued interest
Federal income taxes payable
Total current liabilities \$11,459,080
12,969,686
3,916,739
1,593,276
229,575
244,792
30,413,148 \$10,257,598
9,460,776
41,070
1,263,461
196,545
307,354
21,526,804 \$9,631,600
7,586,374
41,070
1,238,454
178,478
265,619
18,941,595 LONG-TERM DEBT 24,420,090 22,342,006 22,379,920 STOCKHOLDERS' EQUITY
Common stock: \$1 par value
Authorized: 1,500,000 shares
Issued and outstanding: 1,000,000 shares
Retained earnings
Total stockholders' equity 1,000,000
15,717,645
43,883,907
60,601,552 1,000,000
15,717,645
42,674,182
59,391,827
\$103,260,637 1,000,000
15,717,645
41,635,771
58,353,416
\$99,674,931 TOTAL LIABILITIES AND STOCKHOLDERS' EQUITY \$115,434,790 Pinnacle Manufacturing Company
Income Statement - All Divisions
For the Year Ended December 31
2011
Dollar Value
Sales
Sales Returns and Allowances
Cost of Sales*
Gross Profit
OPERATING EXPENSES-Allocated
Salaries-Management
Salaries-Office
Licensing and certification fees
Security
Insurance
Medical benefits
Property taxes
Depreciation expense
Accounting fees
Total operating expenses-Allocated
OPERATING EXPENSES-Direct
Salaries-Sales
Wages Rental
Wages-Mechanics
Wages-Warehouse
Garbage collection
Payroll benefits
Rent- Warehouse
Telephone
Utilities
Postage
Linen service
Repairs and maintenance
Cleaning service
Legal service
Fuel
Travel and entertainment
Pension expense
Office supplies
Miscellaneous
Total operating expenses-Direct
Total Operating Expenses
Operating Income
Other Expense-Interest
Income Before Taxes
Federal Income Taxes
Net Income
* Details of manufacturing expenses are not
included in this schedule. 2010
Dollar Value 2009
Dollar Value 150,918,731
181,103
109,284,780
41,452,848 148,764,555
178,518
106,255,499
42,330,538 144,860,245
173,832
101,988,165
42,698,248 2,281,266
315,169
190,650
550,603
93,197
23,721
162,512
6,989
22,585
841,699
5,336,783
273,956
10,099,130 2,387,993
296,681
172,883
637,580
103,842
29,453
178,009
5,555
178,009
1,034,060
4,641,982
297,777
9,963,824 2,295,081
306,856
162,279
630,353
108,491
28,810
165,678
774
175,692
992,094
4,367,565
299,789
9,533,462 14,970,669
491,794
1,113,539
4,891,065
27,649
2,657,889
802,855
32,402
262,393
89,763
17,282
166,985
89,800
396,016
286,547
103,389
228,555
149,828
300,188
27,078,608
37,177,738
4,275,110
2,181,948
2,093,162
883,437
1,209,725 15,327,777
595,389
1,339,626
5,340,271
29,771
2,937,730
764,346
45,173
267,005
133,518
12,350
168,405
81,589
190,540
341,192
103,842
237,350
148,340
105,931
28,170,145
38,133,969
4,196,569
2,299,217
1,897,352
858,941
1,038,411 14,904,392
575,725
1,333,411
5,473,249
37,969
2,894,300
758,345
57,867
274,365
151,278
16,083
178,213
78,088
152,238
279,512
100,479
127,011
171,109
144,012
27,707,646
37,241,108
5,457,140
2,397,953
3,059,187
1,341,536
1,717,651 Pinnacle Manufacturing Company
Common-Size Income Statement - All Divisions
For the Year Ended December 31
2011 2010 (000)
Preliminary (000) Audited 2009 % of Net Sales (000) Audited % of Net
Sales Sales
Less: Sales Returns and Allowances % of Net Sales
150,918,731
100.12%
181,103
0.12% 148,764,555
178,518 100.12%
0.12% 144,860,245
173,832 100.12%
0.12% Net Sales
Cost of Sales*
Gross Profit 150,737,628
109,284,780
41,452,848 100.00%
72.50%
27.50% 148,586,037
106,255,499
42,330,538 100.00%
71.51%
28.49% 144,686,413
101,988,165
42,698,248 100.00%
70.49%
29.51% 2,281,266
315,169
190,650
550,603
93,197
23,721
162,512
6,989
22,585
841,699
5,336,783
273,956
10,099,130 1.51%
0.21%
0.13%
0.37%
0.06%
0.02%
0.11%
0.00%
0.01%
0.56%
3.54%
0.18%
6.70% 2,387,993
296,681
172,883
637,580
103,842
29,453
178,009
5,555
178,009
1,034,060
4,641,982
297,777
9,963,824 1.61%
0.20%
0.12%
0.43%
0.07%
0.02%
0.12%
0.00%
0.12%
0.70%
3.12%
0.20%
6.71% 2,295,081
306,856
162,279
630,353
108,491
28,810
165,678
774
175,692
992,094
4,367,565
299,789
9,533,462 1.59%
0.21%
0.11%
0.44%
0.07%
0.02%
0.11%
0.00%
0.12%
0.69%
3.02%
0.21%
6.59% 14,970,669
491,794
1,113,539
4,891,065
27,649
2,657,889
802,855
32,402
262,393
89,763
17,282
166,985
89,800
396,016
286,547
103,389
228,555
149,828
300,188
27,078,608
37,177,738
4,275,110
2,181,948
2,093,162
883,437
1,209,725 9.93%
0.33%
0.74%
3.24%
0.02%
1.76%
0.53%
0.02%
0.17%
0.06%
0.01%
0.11%
0.06%
0.26%
0.19%
0.07%
0.15%
0.10%
0.20%
17.96%
24.66%
2.84%
44.61%
1.39%
0.59%
0.80% 15,327,777
595,389
1,339,626
5,340,271
29,771
2,937,730
764,346
45,173
267,005
133,518
12,350
168,405
81,589
190,540
341,192
103,842
237,350
148,340
105,931
28,170,145
38,133,969
4,196,569
2,299,217
1,897,352
858,941
1,038,411 10.32%
12.83%
0.90%
3.59%
0.02%
1.98%
0.51%
0.03%
0.18%
0.09%
0.01%
0.11%
0.05%
0.13%
0.23%
0.07%
0.16%
0.10%
0.07%
18.96%
25.66%
2.82%
1.55%
1.28%
0.58%
0.70% 14,904,392
575,725
1,333,411
5,473,249
37,969
2,894,300
758,345
57,867
274,365
151,278
16,083
178,213
78,088
152,238
279,512
100,479
127,011
171,109
144,012
27,707,646
37,241,108
5,457,140
2,397,953
3,059,187
1,341,536
1,717,651 10.30%
0.40%
0.92%
3.78%
0.03%
2.00%
0.52%
0.04%
0.19%
0.10%
0.01%
0.12%
0.05%
0.11%
0.19%
0.07%
0.09%
0.12%
0.10%
19.15%
25.74%
3.77%
1.66%
2.11%
0.93%
1.19% OPERATING EXPENSES-Allocated
Salaries-Management
Salaries-Office
Licensing and certification fees
Security
Insurance
Medical benefits
Property taxes
Depreciation expense
Accounting fees
Total operating expenses-Allocated
OPERATING EXPENSES-Direct
Salaries-Sales
Wages Rental
Wages-Mechanics
Wages-Warehouse
Garbage collection
Payroll benefits
Rent- Warehouse
Telephone
Utilities
Postage
Linen service
Repairs and maintenance
Cleaning service
Legal service
Fuel
Travel and entertainment
Pension expense
Office supplies
Miscellaneous
Total operating expenses-Direct
Total Operating Expenses
Operating Income
Other Expense-Interest
Income Before Taxes
Federal Income Taxes
Net Income
* Details of manufacturing expenses are not
included in this schedule. Pinncacle Manufacturing Company
Income Statement - Welburn Division
For the Year Ended December 31 Sales
Sales Returns and Allowances
Cost of Sales*
Gross Profit
OPERATING EXPENSES-Allocated
Salaries-Management
Salaries-Office
Licensing and certification fees
Security
Insurance
Medical benefits
Property taxes
Depreciation expense
Accounting fees
Total operating expenses-Allocated
OPERATING EXPENSES-Direct
Salaries-Sales
Wages Rental
Wages-Mechanics
Wages-Warehouse
Garbage collection
Payroll benefits
Rent- Warehouse
Telephone
Utilities
Postage
Linen service
Repairs and maintenance
Cleaning service
Legal service
Fuel
Travel and entertainment
Pension expense
Office supplies
Miscellaneous
Total operating expenses-Direct
Total operating expenses
OPERATING INCOME
* Details of manufacturing expenses are not
included in this schedule. 2011
\$ Value
122,585,513
127,673
90,373,709
32,084,131 2010
\$ Value
120,830,903
124,975
87,905,900
32,800,028 2009
\$ Value
117,639,471
121,694
84,375,503
33,142,274 1,851,775
255,833
139,951
446,938
75,647
19,389
131,917
4,213
17,873
687,885
4,206,533
223,534
8,061,488 1,934,168
240,298
127,659
516,406
84,103
24,032
144,181
2,981
144,181
831,572
3,759,789
240,196
8,049,566 1,858,914
248,539
119,829
510,552
87,868
23,507
134,193
415
142,304
797,823
3,537,525
241,817
7,703,286 12,579,213
4,006,809
2,039,389
670,746
25,901
194,700
77,924
14,126
123,450
65,853
115,735
217,964
80,265
187,891
121,617
57,147
20,578,730
28,640,218
3,443,913 12,694,443
4,325,377
2,379,426
623,389
36,045
216,266
108,136
10,510
117,538
66,085
131,334
276,343
84,103
192,240
120,149
57,910
21,439,294
29,488,860
3,311,168 12,343,793
4,433,082
2,344,248
618,494
46,175
222,226
122,519
13,685
124,383
63,250
104,934
226,387
81,380
102,872
138,590
78,729
21,064,747
28,768,033
4,374,241 Pinnacle Manufacturing Company
Income Statement - Solar-Electro Division
For the Year Ended December 31 Sales
Sales Returns and Allowances
Cost of Sales*
Gross Profit
OPERATING EXPENSES-Allocated
Salaries-Management
Salaries-Office
Licensing and certification fees
Security
Insurance
Medical benefits
Property taxes
Depreciation expense
Accounting fees
Total operating expenses-Allocated
OPERATING EXPENSES-Direct
Salaries-Sales
Wages Rental
Wages-Mechanics
Wages-Warehouse
Garbage collection
Payroll benefits
Rent- Warehouse
Telephone
Utilities
Postage
Linen service
Repairs and maintenance
Cleaning service
Legal service
Fuel
Travel and entertainment
Pension expense
Office supplies
Miscellaneous
Total operating expenses-Direct
Total operating expenses
OPERATING INCOME
* Details of manufacturing expenses are not
included in this schedule. 2011
\$ Value
22,605,731
43,825
17,008,377
5,553,529 2010
\$ Value
21,680,289
38,773
16,156,496
5,485,020 2009
\$ Value
21,126,896
37,756
15,507,635
5,581,505 338,015
46,697
19,303
81,580
13,808
3,537
24,078
874
3,264
120,493
889,483
39,666
1,580,798 352,230
43,759
15,287
94,046
15,319
4,376
26,255
542
26,255
157,730
684,667
44,689
1,465,155 338,525
45,259
14,350
92,980
16,005
4,280
24,436
76
25,913
151,328
644,192
44,992
1,402,336 2,192,482
695,918
478,669
103,983
4,730
53,278
7,131
2,578
34,121
20,694
268,954
53,975
18,196
34,297
22,199
234,892
4,226,097
5,806,895
-253,366 2,402,414
787,698
433,321
109,403
6,567
39,383
19,695
1,490
39,383
12,033
45,950
50,326
15,319
33,988
21,880
42,982
4,061,832
5,526,987
-41,967 2,336,053
807,312
426,916
108,544
8,412
40,468
22,315
1,941
41,677
11,516
36,714
41,229
14,822
18,187
25,238
58,433
3,999,777
5,402,113
179,392 Pinnacle Manufacturing Company
Income Statement - Machine-Tech Division
For the Year Ended December 31 Sales
Sales Returns and Allowances
Cost of Sales*
Gross Profit
OPERATING EXPENSES-Allocated
Salaries-Management
Salaries-Office
Licensing and certification fees
Security
Insurance
Medical benefits
Property taxes
Depreciation expense
Accounting fees
Total operating expenses-Allocated
OPERATING EXPENSES-Direct
Salaries-Sales
Wages Rental
Wages-Mechanics
Wages-Warehouse
Garbage collection
Payroll benefits
Rent- Warehouse
Telephone
Utilities
Postage
Linen service
Repairs and maintenance
Cleaning service
Legal service
Fuel
Travel and entertainment
Pension expense
Office supplies
Miscellaneous
Total operating expenses-Direct
Total operating expenses
OPERATING INCOME
* Details of manufacturing expenses are not
included in this schedule. 2011
\$ Value
5,727,487
9,605
1,902,694
3,815,188 2010
\$ Value
6,253,363
14,770
2,193,103
4,045,490 2009
\$ Value
6,093,878
14,382
2,105,027
3,974,469 91,476
12,638
31,396
22,086
3,742
795
6,517
1,902
1,448
33,321
240,767
10,756
456,844 101,595
12,624
29,937
27,128
4,420
1044
7,573
2,032
7,573
44,759
197,527
12,891
449,103 97,642
13,057
28,100
26,820
4,618
1022
7,048
283
7,475
42,942
185,850
12,983
427,840 198,978
491,794
1,113,539
188,339
27,649
139,832
28,126
1,771
14,415
4,708
579
9,414
3,253
11,327
14,608
4,928
6,368
6,012
8,141
2,273,781
2,730,625
1,084,563 230,922
595,389
1,339,627
227,196
29,771
124,984
31,554
2,560
11,357
5,688
350
11,484
3,472
13,255
14,522
4,420
11,121
6,312
5,035
2,669,019
3,118,122
927,368 224,543
575,724
1,333,411
232,853
37,970
123,136
31,306
3,280
11,670
6,445
457
12,153
3,322
10,590
11,897
4,277
5,951
7,281
6,856
2,643,122
3,070,962
903,507

## This question was asked on Sep 18, 2013.

### Why Join Course Hero?

Course Hero has all the homework and study help you need to succeed! We’ve got course-specific notes, study guides, and practice tests along with expert tutors and customizable flashcards—available anywhere, anytime.

### -

Educational Resources
• ### -

Study Documents

Find the best study resources around, tagged to your specific courses. Share your own to gain free Course Hero access or to earn money with our Marketplace.

Browse Documents