Hello Tunacaocaaron,

This is my final problem. Once again, I have completed most of it but I am having trouble with the remainder. Please view attachment for more details, thanks:

Yukon Bike Corp. manufactures mountain bikes and distributes them through retail outlets in Canada, Montana, Idaho, Oregon, and Washington. Yukon Bike Corp. has declared the following annual dividends over a six-year period ending December 31 ofeach year: 2008, $28,000; 2009, $44,000; 2010, $48,000; 2011, $60,000; 2012, $76,000; and 2013, $140,000. During the entire period, the outstanding stock of the company was composed of 40,000 shares of 2% preferred stock, $65 par, and 50,000 shares of common stock, $1 par.

Instructions

• 1.Determine the total dividends and the per-share dividends declared on each class of stock for each of the six years. Summarize the data in tabular form, using the following column headings:

  Year

  Total Dividends

  Preferred Dividends

  Common Dividends

  Total

  Per Share

  Total

  Per Share

  2008

  $ 28,000

  2009

  44,000

  2010

  48,000

  2011

  60,000

  2012

  76,000

  2013

  140,000

• 2.Calculate the average annual dividend per share for each class of stock for the six-year period.
• 3.Assumingthatthepreferredstockwassoldat$57.50andcommonstockwassoldat$5.00atthebeginningofthesix-yearperiod,calculatetheaverageannualpercentagereturnoninitialshareholders'investment,basedontheaverageannualdividendpershare(a)forpreferredstockand(b)forcommonstock.

Problem 8-5 * represents an incorre 0 " " represents an unan 12 " " represents a correct blan 19 Total SUM(AV13:AV15) Name: Mark Tirona Section: Score: 61% Key Code: 2 Instructions 31 Percentage =AD6/AD8 61% Notes: " " represents an unan Answers are entered in the cells with gray backgrounds. Cells with non-gray backgrounds are protected and cannot be edited. A red asterisk (*) will appear in the column to the right of an incorrect answer. 1. Maximum yearly total preferred dividend: $ Preferred Dividends Year 2008 2009 2010 2011 2012 2013 Total Dividends $ 28,000 44,000 48,000 60,000 76,000 140,000 Total $ 28,000 44,000 48,000 52,000 52,000 52,000 Common Dividends Per Share $0.70 1.10 1.20 52,000 Total $ 8,000 24,000 88,000 Per Share $0.00 0.00 0.00 " " represents a correct Total number of answe Conditional formatting might Steps: Open this sheet and macro Open old templated, then ch Insert new header - change Copy these formulas (colum Update to new edition's nam Copy new error check formu =IF(sol.!$C$5="OFF","" 2. Average annual dividend for preferred: Average annual dividend for common: For B-Boxes =IF(sol.!$C$5="OFF","",IF(A Copy Score formula from thi =IF(sol.!$ =IF(sol.!$C$ 3. a. b. Return on initial investment, preferred: Return on initial investment, common: ect N answer =COUNTIF(A14:H27,"~*") nswered N box - counts as an incorrect. =COUNTIF(A14:H27," ") nk answer or N answer =COUNTIF(A14:H27," ") nswered N box - counts as an incorrect. t blank answer or N answer ers = sum of above ht 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. sheet hange color palet to this sheet's e problem number and reformat mn AD) to new sheet. mes and numbers ulas. For N-boxes "",IF(AC25=""," ",IF(AC25sol.!AC25,"*"," "))) AC29sol.!AC29,"*"," ")) his template to new sheet. C$5="OFF","",AD10)