ACCT Assignment 4

profileMrJinx29
acct300_07-04.xlsx
Home>Business & Finance homework help>Accounting homework help>ACCT Assignment 4

Pr. 7-4

Problem 7-4 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " 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 column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
" " represents an unanswered N box - counts as an incorrect.
1. " " represents a correct blank answer or N answer
Accumulated Total number of answers = sum of above
Depreciation Depreciation, Book Value, 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.
Year Expense End of Year End of Year
a. 1 Steps:
2 Open this sheet and macro sheet
3 Open old templated, then change color palet to this sheet's
4 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
b. 1 Update to new edition's names and numbers
2 Copy new error check formulas. For N-boxes
3 =IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
4
Peggy Hussey: Remember, accumulated depreciation cannot exceed cost - residual value.
Peggy Hussey: Cost - accumulated depreciation
For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Balance Sheet
Assets = Liabilities + Stockholders' Equity Copy Score formula from this template to new sheet.
Statement of Accumulated Retained Income =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Cash Flows Cash + Equipment - Depreciation = + Earnings Statement
2.
Craig Pence: Record increases by entering a positive amount; record decreases by entering a negative amount.
Peggy Hussey: Enter as a formula of =(Cost - Residual value)/life in years
Mark Sears: Enter as a positive
Peggy Hussey: Cost - Accumulated depreciation
Peggy Hussey: Book value x (straight-line rate x 2)
3.

sol.

Problem 7-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 1
Scoring: ON " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
4
Total SUM(AV13:AV15)
Instructions 5
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 80%
A red asterisk (*) will appear in the column to the right of an incorrect answer. Notes:
* represents an incorrect N answer
" " represents an unanswered N box - counts as an incorrect.
1. " " represents a correct blank answer or N answer
Accumulated Total number of answers = sum of above
Depreciation Depreciation, Book Value, 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.
Year Expense End of Year End of Year
a. 1 $ 32,500
Peggy Hussey: Cost - residual value Useful life 		$ 32,500 $ 107,500
Peggy Hussey: Cost - accumulated depreciation 		Steps:
2 32,500 65,000 75,000 Open this sheet and macro sheet
3 32,500 97,500 42,500 Open old templated, then change color palet to this sheet's
4 32,500 130,000 10,000 Insert new header - change problem number and reformat
Copy these formulas (column AD) to new sheet.
b. 1 $ 70,000
Peggy Hussey: Book value x (straight-line rate x 2)		 $ 70,000 $ 70,000
Peggy Hussey: Cost - accumulated depreciation 		Update to new edition's names and numbers
2 35,000 105,000 35,000 Copy new error check formulas. For N-boxes
3 17,500 122,500 17,500
4 7,500
Peggy Hussey: Remember, accumulated depreciation cannot exceed cost - residual value.
Peggy Hussey: Cost - accumulated depreciation 		130,000 10,000
For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Balance Sheet
Assets = Liabilities + Stockholders' Equity Copy Score formula from this template to new sheet.
Statement of Accumulated Retained Income =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
Cash Flows Cash + Equipment - Depreciation = + Earnings Statement
2. O $ 23,300 $ 23,300
Craig Pence: Record increases by entering a positive amount; record decreases by entering a negative amount.
Peggy Hussey: Cost - residual value Useful life
Peggy Hussey: Cost - accumulated depreciation
Peggy Hussey: Book value x (straight-line rate x 2)		 $ (140,000) $ 122,500 $ 5,800 $ 5,800 Gain
3. O 15,250 15,250 (140,000) 122,500 (2,250) (2,250) Loss