ACCT Assignment 4

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

Pr. 8-5

Problem 8-5 * represents an incorrect N answer =COUNTIF(A14:H27,"~*")
Name: 0
Section: " " represents an unanswered N box - counts as an incorrect. =COUNTIF(A14:H27," ")
31
Score: 0% " " represents a correct blank answer or N answer =COUNTIF(A14:H27," ")
0
Key Code: 2 Total SUM(AV13:AV15)
Instructions 31
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.
1.
Maximum yearly total preferred dividend:
" " represents a correct blank answer or N answer
Preferred Dividends Common Dividends Total number of answers = sum of above
Total
Year Dividends Total Per Share Total Per Share 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.
2008 $ 28,000
2009 44,000 Steps:
2010 48,000 Open this sheet and macro sheet
2011 60,000
Mark Sears: Enter as a formula of total/shares
Mark Sears: Enter a formula of shares x par x percentage 		Open old templated, then change color palet to this sheet's
2012 76,000 Insert new header - change problem number and reformat
2013 140,000 Copy these formulas (column AD) to new sheet.
Update to new edition's names and numbers
Copy new error check formulas. For N-boxes
=IF(sol.!$C$5="OFF","",IF(AC25=""," ",IF(AC25<>sol.!AC25,"*"," ")))
2.
Average annual dividend for preferred: For B-Boxes
Average annual dividend for common: =IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)
3. a. Return on initial investment, preferred:
b. Return on initial investment, common:

sol.

Problem 8-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," ")
0
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. 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.
1.
Maximum yearly total preferred dividend: $ 52,000
Mark Sears: Enter a formula of shares x par x percentage
Preferred Dividends Common Dividends " " represents a correct blank answer or N answer
Total Total number of answers = sum of above
Year Dividends Total Per Share Total Per Share 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.
2008 $ 28,000 $ 28,000 $0.70 $ - $0.00
2009 44,000 44,000 1.10 - 0.00 Steps:
2010 48,000 48,000 1.20 - 0.00 Open this sheet and macro sheet
2011 60,000 52,000 1.30 8,000 0.16
Mark Sears: Enter as a formula of total/shares
Mark Sears: Enter a formula of shares x par x percentage 		Open old templated, then change color palet to this sheet's
2012 76,000 52,000 1.30 24,000 0.48 Insert new header - change problem number and reformat
2013 140,000 52,000 1.30 88,000 1.76 Copy these formulas (column AD) to new sheet.
$6.90 $2.40 Update to new edition's names and numbers
Copy new error check formulas. For N-boxes
2.
Average annual dividend for preferred: $1.15
Average annual dividend for common: $0.40 For B-Boxes
=IF(sol.!$C$5="OFF","",IF(AC29<>sol.!AC29,"*"," "))
3. a. Return on initial investment, preferred: 2.0%
b. Return on initial investment, common: 8.0% Copy Score formula from this template to new sheet.
=IF(sol.!$C$5="OFF","","Score:") =IF(sol.!$C$5="OFF","",AD10)