ACCT Assignment 4

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

Pr. 7-5

Problem 7-5 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
18
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 18
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
a. Loss on impairment of goodwill 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.
b. Amortization of governmental and legal costs:
[Original Cost ¸ Years (Life)] ´ Portion of Year = Amortization Steps:
Open this sheet and macro sheet
Open old templated, then change color palet to this sheet's
c. Depletion of timber rights: Insert new header - change problem number and reformat
Board Feet Copy these formulas (column AD) to new sheet.
(Original Cost ¸ Total Board Feet) ´ Cut and Sold = Depletion Update to new edition's names and numbers
Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC26=""," ",IF(AC26<>sol.!AC26,"*"," ")))
2. Balance Sheet For B-Boxes
Assets = Liabilities + Stockholders' Equity =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Statement of Accumulated Retained Income
Cash Flows Goodwill + Patents - Depletion = + Earnings Statement Copy Score formula from this template to new sheet.
a.
Craig Pence: Record increases by entering a positive amount; record decreases by entering a negative amount.		 Loss on impaired goodwill =IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
b. Amortization expense
c. Depletion expense

sol.

Problem 7-5 * 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," ")
2
Total SUM(AV13:AV15)
Instructions 3
Answers are entered in the cells with gray backgrounds. Percentage =AD6/AD8
Cells with non-gray backgrounds are protected and cannot be edited. 67%
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
a. Loss on impairment of goodwill $ 3,000,000
b. Amortization of governmental and legal costs:
[Original Cost ¸ Years (Life)] ´ Portion of Year = Amortization
$ 920,000 8 1/2 $ 57,500 Steps:
Copy these formulas (column AD) to new sheet.
c. Depletion of timber rights: Update to new edition's names and numbers
Board Feet Copy new error check formulas. For N-boxes
(Original Cost ¸ Total Board Feet) ´ Cut and Sold = Depletion
$ 1,350,000 15,000,000 3,300,000 $ 297,000
For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
2. 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 Goodwill + Patents - Depletion = + Earnings Statement
a. $ (3,000,000)
Craig Pence: Record increases by entering a positive amount; record decreases by entering a negative amount.		 $ (3,000,000) $ (3,000,000) Loss on impaired goodwill
b. $ (57,500) (57,500) (57,500) Amortization expense
c. $ (297,000) (297,000) (297,000) Depletion expense