Problem 8-5 * represents an incorre 0 " " represents


Question Description:

35

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 of each 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.Assuming that the preferred stock was sold at $57.50 and common stock was sold at $5.00 at the beginning of the six-year period, calculate the average annual percentage return on initial shareholders’ investment, based on the average annual dividend per share (a) for preferred stock and (b) for common stock. ATTACHMENT PREVIEW Download attachment 08-05Pr_6e.xls 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(AC25<>sol.!AC25,"*"," "))) AC29<>sol.!AC29,"*"," ")) his template to new sheet. C$5="OFF","",AD10) Read more countsteubenville
posted a question · Jan 03, 2016 at 7:14pm

Answer

35