Please follow the instrutions excatly as mentioned

Anonymous
timer Asked: Oct 19th, 2018
account_balance_wallet $15

Question Description

The file is already under my name. Please just follow the instructions exactly as mentioned in the isntrcutions file.

Unformatted Attachment Preview

Office 2016 – myitlab:grader – Instructions Excel Project YO_Excel16_Ch02_PS1_v2 Project Description: One method that people use to provide income during their retirement years is investing in dividend-paying stocks. The dividends allow investors to make withdrawals from their retirement account without having to reduce their invested principal. Michael Malley, president and chief investment officer of your new employer, Excellent Wealth Management, has developed a worksheet to show how a portfolio of stocks can create an additional income stream for his clients. You are asked to determine how much income the current portfolio is generating in order to assist with future investments decisions in the form of adding to current investments or diversifying and adding other dividend-paying investments. Instructions: For the purpose of grading the project you are required to perform the following tasks: Step Points Possible Instructions 1 Start Excel. Open the downloaded file named e01ch02_grader_h1_Portfolio.xlsx. Save it as e01ch02_grader_h1_Portfolio_LastFirst using your last and first name. 0 2 On the DividendPortfolio worksheet, center and bold cell range B2:F3. 4 3 Merge & Center cell range A1:N1. In cell A1, apply the Title cell Style and bold the title. 8 4 Select cell range N12:N16 and N20:N24, and then calculate row totals using the SUM function. 7 5 In cell G8, calculate the average of Total Dividends Received. 6 6 Apply cell style Heading 3 to cells G7, B10, and B18. 6 7 Apply the Currency format to cell ranges B4:F4, B6:F6, B8:G8, B12:N16, and B20:N25. 6 8 In B7, calculate the yield of Prime Steel - the annual dividends per share divided by the price per share. Copy the formulas to cell range C7:F7. Format the yield figures as Percent Style with two decimal places. 8 9 Hide rows 10:17. 5 Updated: 05/23/2018 1 Current_Instruction.docx Office 2016 – myitlab:grader – Instructions Excel Project Step Instructions Points Possible 10 Format cell range A19:N24 as a table with headers. Apply Table Style Light 11. Sort by STOCK from A-Z, and then turn off Filters. Note, depending upon the version of Office being used, the table style name may be White, Table Style Light 11. 12 11 Add a Total Row to the table, and calculate the sum of columns B:N. 6 12 Apply a top border to cell range A25:N25. 4 13 Apply cell style 40% - Accent3 to cell ranges A20:A25, B25:N25, and N20:N24. 4 14 Apply Conditional Formatting to cell range B20:M24. Display the Top 10 items as Green Fill with Dark Green Text. 6 15 Turn off gridlines in the DividendPortfolio worksheet. 4 16 In the Documentation worksheet, enter 12/15/2018 into cell A8. In cell B8, type your name in the Firstname Lastname format. In cell C8, type Completed Mr. Malley's monthly dividend income worksheet and then make cell A1 the active cell. 4 17 Spell check the entire workbook and correct the one misspelling. Insert the file name on the left page footer on all worksheets. 4 18 For the DividendPortfolio and Documentation worksheets, set the Orientation to Landscape, and then set the Width to 1 page. Change the Print Setting to Print Entire Workbook. 6 19 Save the workbook, exit Excel, and then submit your file as directed by your instructor. 0 Total Points Updated: 05/23/2018 2 100 Current_Instruction.docx Excellent Wealth Management Company Ticker Price Shares Owned Annual Dividends / Share Yield Total Dividends Recieved PRIME PULSE FIVE WOOD TEN STOCK PRIME PULSE FIVE WOOD TEN Prime Steel PRIME Heartland Diamond 2x4 Lumber HiTENd Healthcare Five LLP Co. Security PULSE FIVE WOOD TEN 41 60 5 24 10 243.90 166.67 2000.00 416.67 1000.00 0 0 0 0 0 Average Annual Incom 0 0 0 0 0 JAN 0.37 0 0 0.1 0 FEB 0 0 0.04 0.09 0.12 MAR 0 0.37 0 0.1 0 APR 0.37 0 0 0.07 0 MAY 0 0 0.04 0.09 0.12 Dividends / Share by Mont JUN 0.00 0.37 0 0.1 0 JAN 90.243 0 0 41.667 0 FEB 0 0 80 37.5003 120 MAR 0 61.6679 0 41.667 0 APR 90.243 0 0 29.1669 0 MAY 0 0 80 37.5003 120 Total Dividends by Month JUN 0 61.6679 0 41.667 0 Average Annual Income Per Stock Dividends / Share by Month JUL AUG 0.37 0 0 0 0 0.04 0.09 0.1 0 0.12 Total Dividends by Month JUL AUG 90.243 0 0 0 0 80 37.5003 41.667 0 120 SEP 0 0.37 0 0.095 0 OCT 0.37 0 0 0.095 0 NOV 0 0 0.04 0.1 0.12 DEC 0 0.37 0 0.1 0 Total SEP OCT 0 90.243 61.6679 0 0 0 39.58365 39.58365 0 0 NOV 0 0 80 41.667 120 DEC 0 61.6679 0 41.667 0 Total Excellent Wealth Management Create Date By Whom 12/15/2018 Michael Malley Mod. Date By Whom Description Stock Portfolio Monthly Dividend Analysis Mod. Description Create Date Sheet Name 12/15/2018 DividendPortfolio Creator Michael Malley Workbook Name 20181019203939e01ch02_grader_h1_portfolio_carrascoyenisel.xlsx Last Version Backup Name Purpose Monthly Dividend Income from Stock Portfolio ...
Purchase answer to see full attachment

Tutor Answer

uoscar
School: Cornell University

The solution is attached.Please include your FirstName and LastName in cell B8 of the Documentation sheet of the Excel.Please, give me feedback.

Excellent Wealth Management
Company
Ticker
Price
Shares Owned
Annual Dividends / Share
Yield
Total Dividends Received

STOCK
FIVE
PRIME
PULSE
TEN
WOOD
Total

Prime
Heartland Diamond 2x4 Lumber HiTENd
Steel
Healthca...

flag Report DMCA
Review

Anonymous
awesome work thanks

Similar Questions
Hot Questions
Related Tags
Study Guides

Brown University





1271 Tutors

California Institute of Technology




2131 Tutors

Carnegie Mellon University




982 Tutors

Columbia University





1256 Tutors

Dartmouth University





2113 Tutors

Emory University





2279 Tutors

Harvard University





599 Tutors

Massachusetts Institute of Technology



2319 Tutors

New York University





1645 Tutors

Notre Dam University





1911 Tutors

Oklahoma University





2122 Tutors

Pennsylvania State University





932 Tutors

Princeton University





1211 Tutors

Stanford University





983 Tutors

University of California





1282 Tutors

Oxford University





123 Tutors

Yale University





2325 Tutors