ACCT PROBLEMS

profilekdcrte
cartera-acct300-5.zip
Home>Business & Finance homework help>Accounting homework help>ACCT PROBLEMS

P10-02.xls

Pr. 10-2

Problem 10-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: Akia Carter 0
Section: P10-02 " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
74
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 74
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the row immediately to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. Schedule of manufacturing costs incurred during June: Total number of answers = sum of above
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 Steps:
No. 6002 Open this sheet and macro sheet
No. 6003 Open old templated, then change color palet to this sheet's
No. 6004 Insert new header - change problem number and reformat
No. 6005 Copy these formulas (column AD) to new sheet.
No. 6006 Update to new edition's names and numbers
Total =IF(sol.!$C$5="OFF","",IF(AE25=""," ",IF(AE25<>sol.!AE25,"*"," ")))
2. Schedule of cost of jobs finished during June:
For B-Boxes
Direct Direct Factory =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Job Materials Labor Overhead Total
No. 6001 Copy Score formula from this template to new sheet.
No. 6002 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
No. 6003
No. 6005
Total
3. Schedule of cost of goods sold during June:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001
No. 6002
No. 6003
Total
4. Schedule of completed jobs on hand, June 30, 2012:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6005
5. Schedule of unfinished jobs:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6004
No. 6006
Balance of Work in
Process, June 30
6. Gross profit for June based upon the jobs sold:
Jobs shipped and billed:
No. 6001
No. 6002
No. 6003
Total sales
Cost of goods sold (from schedule above)
Gross profit

sol.

Problem 10-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Total SUM(AV13:AV15)
Instructions 0
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the row immediately to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. Schedule of manufacturing costs incurred during June: Total number of answers = sum of above
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800 Steps:
No. 6002 11,500 11,880 6,000 29,380
No. 6003 7,600 5,960 4,800 18,360
No. 6004 25,800 21,840 15,000 62,640
No. 6005 16,400 16,600 6,600 39,600
No. 6006 11,920 10,600 4,000 26,520 Open this sheet and macro sheet
Total $ 198,300 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
Update to new edition's names and numbers
2. Schedule of cost of jobs finished during June: Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800
No. 6002 11,500 11,880 6,000 29,380 For B-Boxes
No. 6003 7,600 5,960 4,800 18,360 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
No. 6005 16,400 16,600 6,600 39,600 Copy Score formula from this template to new sheet.
Total $ 109,140
3. Schedule of cost of goods sold during June:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6001 $ 9,400 $ 8,800 $ 3,600 $ 21,800
No. 6002 11,500 11,880 6,000 29,380
No. 6003 7,600 5,960 4,800 18,360
Total $ 69,540
4. Schedule of completed jobs on hand, June 30, 2012:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6005 $ 16,400 $ 16,600 $ 6,600 $ 39,600
5. Schedule of unfinished jobs:
Direct Direct Factory
Job Materials Labor Overhead Total
No. 6004 $ 25,800 $ 21,840 $ 15,000 $ 62,640
No. 6006 11,920 10,600 4,000 26,520
Balance of Work in
Process, June 30 $ 89,160
6. Gross profit for June based upon the jobs sold:
Jobs shipped and billed:
No. 6001 $ 26,000
No. 6002 36,000
No. 6003 48,000
Total sales $ 110,000
Cost of goods sold (from schedule above) 69,540
Gross profit $ 40,460

P10-04.xls

Pr. 10-4

Problem 10-4 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: Akia Carter 0
Section: P10-04 " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
44
Score: 20% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
*Since some answer boxes are correct when left blank, the beginning score is greater than 0%. 11
Key Code: 2 Total SUM(AV13:AV15)
Instructions 55
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 20%
A red asterisk (*) will appear in the row immediately to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
Supporting calculations: Total number of answers = sum of above
Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
May 1 Cost of
Work in Direct Direct Factory Total Unit Units Goods
Job. No. Quantity Process Materials Labor Overhead Cost Cost Sold Sold Steps:
No. 0521 100 $5,000 $15,000 Open this sheet and macro sheet
No. 0522 200 8,500 26,000 Open old templated, then change color palet to this sheet's
No. 0523 100 3,500 8,000 Insert new header - change problem number and reformat
No. 0524 125 7,500 25,000 Copy these formulas (column AD) to new sheet.
No. 0525 90 5,600 17,500 Update to new edition's names and numbers
No. 0526 70 2,000 4,500 Copy new error check formulas. For N-boxes
Total 685 $32,100 $96,000 =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Materials
May 1 Beginning balance 9,000 Copy Score formula from this template to new sheet.
31 Purchases 40,000 =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
31 Requisitions (A)
31 Ending balance 2. =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.")
Work in Process
May 1 Beginning balance (B)
31 Materialsl (C)
31 Direct labor (D)
31 Factory overhead appl. (E)
31 Completed jobs (F)
31 Ending balance 2.
Finished Goods
May 1 Beginning balance 0
31 Completed jobs (F)
31 Cost of goods sold (G)
31 Ending balance 2.
Wages Payable
May 31 Wages incurred 110,000
Factory Overhead
May 1 Beginning balance (3,000)
31 Indirect labor (H)
31 Indirect materials 2,500
31 Other overhead 102,900
31 Factory overhead appl. (E)
31 Ending balance 2.

sol.

Problem 10-4 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
15
Total SUM(AV13:AV15)
Instructions 15
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
A red asterisk (*) will appear in the row immediately to the right of an incorrect answer. 0
" " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
0
1. Supporting calculations: " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
15
May 1 Cost of Total SUM(AV13:AV15)
Work in Direct Direct Factory Total Unit Units Goods 15
Job. No. Quantity Process Materials Labor Overhead Cost Cost Sold Sold Percentage =AD6/AD8
No. 0521 100 $ 1,500 $5,000 $15,000 $ 18,000 $ 39,500 $395.00 80 $ 31,600 100%
No. 0522 200 4,000 8,500 26,000 31,200 69,700 $348.50 160 55,760 Notes:
No. 0523 100 3,500 8,000 9,600 21,100 0 0 " " represents an unanswered N box - counts as an incorrect.
No. 0524 125 7,500 25,000 30,000 62,500 $500.00 105 52,500 " " represents a correct blank answer or N answer
No. 0525 90 5,600 17,500 21,000 44,100 $490.00 75 36,750 Total number of answers = sum of above
No. 0526 70 2,000 4,500 5,400 11,900 0 0 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Total 685 $ 5,500 $32,100 $96,000 $ 115,200 $ 248,800 $ 176,610
Steps:
Open this sheet and macro sheet
Materials Open old templated, then change color palet to this sheet's
May 1 Beginning balance 9,000 Insert new header - change problem number and reformat
31 Purchases 40,000 Copy these formulas (column AD) to new sheet.
31 Requisitions (A) (34,600) Update to new edition's names and numbers
31 Ending balance 2. 14,400 Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Work in Process
May 1 Beginning balance (B) 5,500
31 Materials (C) 32,100
31 Direct labor (D) 96,000 For B-Boxes
31 Factory overhead appl. (E) 115,200 =IF(sol.!$C$5="OFF","",IF(AC30<>sol.!AC30,"*"," "))
31 Completed jobs (F) (215,800)
31 Ending balance 2. $33,000 Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Finished Goods
May 1 Beginning balance 0 =IF(sol.!$C$5="OFF","","*Since some answer boxes are correct when left blank, the beginning score is greater than 0%.")
31 Completed jobs (F) 215,800
31 Cost of goods sold (G) (176,610)
31 Ending balance 2. 39,190
Wages Payable
May 31 Wages incurred 110,000
Factory Overhead
May 1 Beginning balance (3,000)
31 Indirect labor (H) 14,000
31 Indirect materials 2,500
31 Other overhead 102,900
31 Factory overhead appl. (E) (115,200)
31 Ending balance 2. $1,200

P9-01.xls

Pr. 9-1

Problem 9-1 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: Akia Carter 0
Section: P9-01 " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
27
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 27
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. GREYHOUND TECHNOLOGY COMPANY Total number of answers = sum of above
Comparative Income Statement Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
For the Years Ended December 31, 2012 and 2011
2012 2011 Increase (Decrease)
Amount Amount Amount Percent Steps:
Open this sheet and macro sheet
Sales $ 880,000 $ 800,000 Open old templated, then change color palet to this sheet's
Sales returns and allowances 18,000 15,000
Net sales $ 862,000 $ 785,000
Cost of goods sold 650,000 500,000 Insert new header - change problem number and reformat
Gross profit $ 212,000 $ 285,000 Copy these formulas (column AD) to new sheet.
Selling expenses $ 44,000 $ 40,000 Update to new edition's names and numbers
Administrative expenses 27,000 25,000 Copy new error check formulas. For N-boxes
Total operating expenses $ 71,000 $ 65,000 =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Income from operations $ 141,000 $ 220,000
Other income 2,300 2,000
Income before income tax $ 143,300 $ 222,000
Income tax expense 13,000 20,000 For B-Boxes
Net income $ 130,300 $ 202,000 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Net income decreased because sales increased at a greater percentage rate than did cost of goods sold and operating expenses. Copy Score formula from this template to new sheet.
2. Net income increased because sales increased at a greater percentage rate than did cost of goods sold and operating expenses. =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Net income decreased because sales increased at a smaller percentage rate than did cost of goods sold and operating expenses.

sol.

Problem 9-1 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
1
Total SUM(AV13:AV15)
Instructions 1
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 100%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. GREYHOUND TECHNOLOGY COMPANY Total number of answers = sum of above
Comparative Income Statement Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
For the Years Ended December 31, 2012 and 2011
2012 2011 Increase (Decrease)
Amount Amount Amount Percent Steps:
Open this sheet and macro sheet
Sales $ 880,000 $ 800,000 $ 80,000 10.0% Open old templated, then change color palet to this sheet's
Sales returns and allowances 18,000 15,000 3,000 20.0%
Net sales $ 862,000 $ 785,000 $ 77,000 9.8%
Cost of goods sold 650,000 500,000 150,000 30.0% Insert new header - change problem number and reformat
Gross profit $ 212,000 $ 285,000 $ (73,000) -25.6% Copy these formulas (column AD) to new sheet.
Selling expenses $ 44,000 $ 40,000 $ 4,000 10.0% Update to new edition's names and numbers
Administrative expenses 27,000 25,000 2,000 8.0% Copy new error check formulas. For N-boxes
Total operating expenses $ 71,000 $ 65,000 $ 6,000 9.2% =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Income from operations $ 141,000 $ 220,000 $ (79,000) -35.9%
Other income 2,300 2,000 300 15.0%
Income before income tax $ 143,300 $ 222,000 $ (78,700) -35.5%
Income tax expense 13,000 20,000 (7,000) -35.0% For B-Boxes
Net income $ 130,300 $ 202,000 $ (71,700) -35.5% =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Net income decreased because sales increased at a greater percentage rate than did cost of goods sold and operating expenses. Copy Score formula from this template to new sheet.
2. Net income decreased because sales increased at a smaller percentage rate than did cost of goods sold and operating expenses. Net income increased because sales increased at a greater percentage rate than did cost of goods sold and operating expenses. =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Net income decreased because sales increased at a smaller percentage rate than did cost of goods sold and operating expenses.

P9-02.xls

Pr. 9-2

Problem 9-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: Akia Carter 0
Section: 9-02 " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
27
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 27
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. BLUE BUFFALO COMPANY Total number of answers = sum of above
Comparative Income Statement Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
For the Years Ended December 31, 2012 and 2011
2012 2011 Steps:
Amount Percent Amount Percent Open this sheet and macro sheet
Sales $ 1,545,000 $ 1,224,000 Open old templated, then change color palet to this sheet's
Sales returns and allowances 45,000 24,000
Net sales $ 1,500,000 $ 1,200,000
Cost of goods sold 960,000 780,000 Insert new header - change problem number and reformat
Gross profit $ 540,000 $ 420,000 Copy these formulas (column AD) to new sheet.
Selling expenses $ 285,000 $ 216,000 Update to new edition's names and numbers
Administrative expenses 90,000 96,000 Copy new error check formulas. For N-boxes
Total operating expenses $ 375,000 $ 312,000 =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Income from operations $ 165,000 $ 108,000
Other income 36,000 36,000
Income before income tax $ 201,000 $ 144,000
Income tax expense (benefit) 42,000 28,800 For B-Boxes
Net income (loss) $ 159,000 $ 115,200 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Copy Score formula from this template to new sheet.
2. The analysis indicates that cost of goods sold and operating expenses improved, but net income did not. =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
The analysis indicates that sales, cost of goods sold, selling expenses, and net income all increased as a result of a successful sales promotion.
The analysis indicates that cost of goods sold and selling expenses increased more than net sales, reducing net income.

sol.

Problem 9-2 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
1
Total SUM(AV13:AV15)
Instructions 1
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 100%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
1. BLUE BUFFALO COMPANY Total number of answers = sum of above
Comparative Income Statement Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
For the Years Ended December 31, 2012 and 2011
2012 2011 Steps:
Amount Percent Amount Percent Open this sheet and macro sheet
Sales $ 1,545,000 103.0% $ 1,224,000 102.0% Open old templated, then change color palet to this sheet's
Sales returns and allowances 45,000 3.0% 24,000 2.0%
Net sales $ 1,500,000 100.0% $ 1,200,000 100.0%
Cost of goods sold 960,000 64.0% 780,000 65.0% Insert new header - change problem number and reformat
Gross profit $ 540,000 36.0% $ 420,000 35.0% Copy these formulas (column AD) to new sheet.
Selling expenses $ 285,000 19.0% $ 216,000 18.0% Update to new edition's names and numbers
Administrative expenses 90,000 6.0% 96,000 8.0% Copy new error check formulas. For N-boxes
Total operating expenses $ 375,000 25.0% $ 312,000 26.0% =IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
Income from operations $ 165,000 11.0% $ 108,000 9.0%
Other income 36,000 2.4% 36,000 3.0%
Income before income tax $ 201,000 13.4% $ 144,000 12.0%
Income tax expense (benefit) 42,000 2.8% 28,800 2.4% For B-Boxes
Net income (loss) $ 159,000 10.6% $ 115,200 9.6% =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Copy Score formula from this template to new sheet.
2. The analysis indicates that sales, cost of goods sold, selling expenses, and net income all increased as a result of a successful sales promotion. The analysis indicates that cost of goods sold and operating expenses improved, but net income did not. =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
The analysis indicates that sales, cost of goods sold, selling expenses, and net income all increased as a result of a successful sales promotion.
The analysis indicates that cost of goods sold and selling expenses increased more than net sales, reducing net income.

P9-04.xls

Pr. 9-4

Problem 9-4 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: Akia Carter 0
Section: P9-04 " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
38
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 38
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the row immediately beneath an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
Total number of answers = sum of above
1. Working capital: - = $0 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Calculated
Ratio Numerator ÷ Denominator Value Steps:
Open this sheet and macro sheet
2. Current ratio ÷ = 0.0 Open old templated, then change color palet to this sheet's
Insert new header - change problem number and reformat
3. Quick ratio ÷ = 0.0 Copy these formulas (column AD) to new sheet.
Update to new edition's names and numbers
4. Accounts receivable turnover ÷ = 0.0 Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AE25=""," ",IF(AE25<>sol.!AE25,"*"," ")))
5. Number of days' sales in receivables ÷ = 0.0
6. Inventory turnover ÷ = 0.0
For B-Boxes
7. Number of days' sales in inventory ÷ = 0.0 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
8. Ratio of fixed assets to long-term liabilities ÷ = 0.0 Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
9. Ratio of liabilities to stockholders' equity ÷ = 0.0
10. Number of times interest charges earned ÷ = 0.0
11. Number of times preferred dividends earned ÷ = 0.0
12. Ratio of net sales to assets ÷ = 0.0
13. Rate earned on total assets ÷ = 0.0%
14. Rate earned on stockholders' equity ÷ = 0.0%
15. Rate earned on common stockholders' equity ÷ = 0.0%
16. Earnings per share on common stock ÷ = $0.00
17. Price-earnings ratio ÷ = 0.0
18. Dividends per share of common stock ÷ = $0.00
19. Dividend yield ÷ = 0.0%
The amount of working capital will appear here automatically when the correct amounts are entered in the adjacent cells.
The calculated values will appear automatically when the correct amounts are entered in the adjacent cells.

sol.

Problem 9-4 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: SOLUTION 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
Score: See student sheet for student's score 0
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Total SUM(AV13:AV15)
Instructions 0
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 0%
A red asterisk (*) will appear in the row immediately beneath an incorrect answer. Notes:
" " represents an unanswered N box - counts as an incorrect.
" " represents a correct blank answer or N answer
Total number of answers = sum of above
1. Working capital: $965,000 - $200,000 = $765,000 Conditional formatting might be used but wasn't here, to hide some of the error check return symbols. If A1 = "~*", then font = red, if something else, then font = background color.
Calculated
Ratio Numerator ÷ Denominator Value Steps:
Open this sheet and macro sheet
2. Current ratio $ 965,000 ÷ $ 200,000 = 4.8 Open old templated, then change color palet to this sheet's
Insert new header - change problem number and reformat
3. Quick ratio $ 615,000 ÷ $ 200,000 = 3.1 Copy these formulas (column AD) to new sheet.
Update to new edition's names and numbers
4. Accounts receivable turnover $ 1,925,000 ÷ $ 175,000 = 11.0 Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AE25=""," ",IF(AE25<>sol.!AE25,"*"," ")))
5. Number of days' sales in receivables $ 175,000 ÷ $ 5,274 = 33.2
6. Inventory turnover $ 780,000 ÷ $ 280,000 = 2.8
For B-Boxes
7. Number of days' sales in inventory $ 280,000 ÷ $ 2,137 = 131.0 =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
8. Ratio of fixed assets to long-term liabilities $ 1,135,000 ÷ $ 1,250,000 = 0.9 Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:")
9. Ratio of liabilities to stockholders' equity $ 1,450,000 ÷ $ 1,050,000 = 1.4
=IF(sol.!$C$5="OFF","",AD10)
10. Number of times interest charges earned $ 570,000 ÷ $ 115,000 = 5.0
11. Number of times preferred dividends earned $ 364,000 ÷ $ 5,000 = 72.8
12. Ratio of net sales to assets $ 1,925,000 ÷ $ 1,950,000 = 1.0
13. Rate earned on total assets $ 479,000 ÷ $ 2,200,000 = 21.8%
14. Rate earned on stockholders' equity $ 364,000 ÷ $ 890,500 = 40.9%
15. Rate earned on common stockholders' equity $ 359,000 ÷ $ 790,500 = 45.4%
16. Earnings per share on common stock $ 359,000 ÷ 50,000 = $7.18
17. Price-earnings ratio $ 89.75 ÷ $ 7.18 = 12.5
18. Dividends per share of common stock $ 40,000 ÷ 50,000 = $0.80
19. Dividend yield $ 0.80 ÷ $ 89.75 = 0.9%
The amount of working capital will appear here automatically when the correct amounts are entered in the adjacent cells.
The calculated values will appear automatically when the correct amounts are entered in the adjacent cells.