The Portfolio Project requires you to write a memorandum to a decision maker, such as the President of the United States, a member of Congress, a chairperson of the SEC, or a state governor, on how to reform corporate ethics in American business today. As we have seen, legislation such as Sarbanes-Oxley has received considerable media attention but has not prevented significant catastrophes such as the global economic meltdown of 2008. You should be prepared to propose policies that might help to ameliorate or to prevent corporate ethics lapses that might occur in the future. You have the freedom to select any policy avenues that you think might help to strengthen and fortify corporate ethics. Your memo should cover the following:

• Set forth why your chosen policy pathway is important
• Compare and contrast with the policy it replaces
• Articulate your ideas on how to remedy the issue of corporate malfeasance
• Proffer some recommendations to the decision-maker about how to improve overall corporate governance.

Please note that your prescription for change is not nearly as important as your ability to forecast potential challenges to the corporate boardroom and to predict possible ways the government could intervene to assist not only solid corporate governance but also the interests of individual shareholders. It is recommended that you suggest at least two methods and/or policy proposals that critically address the public policy concern. Bring in facts and other data to support the policy issue addressed and make sure each fact is cited to relevant authority. Demonstrate critical thinking by analyzing, evaluating, and interpreting appropriate policy to provide original perspectives to enhance corporate legal and ethical environs.

You are expected to convey complex ideas in a clear, concise, and organized fashion, using the required and recommended readings from the course for analytical support. Although you are encouraged to cite from your textbook, you are required to cite a minimum of four scholarly sources (beyond the textbook) to support your statements. The CSU-Global Library is a good place to find these sources.

Your well-written paper should be 8-10 pages in length, not including the title or references pages. Review the Portfolio grading rubric, which can be accessed from the Course Information page, and make sure to follow the CSU-Global Guide to Writing and APA Requirements. Please be sure to reach out to your instructor at any point in the course if you have any questions about the assignment

Good Morning,

 

I need someone with a good writing skills to write a 10 pages personal finance essay. the essay is based on the McGraw Hill’s Personal Finance textbook which all the chapters om PowerPoint I will email them to you. i will send the slybus too which has all the instructions you need  follow. I will attach my monthly spending diary. You will use the spending diary and relate to the chapters in the book.  BASED ON PERFORMANCE I WILL GIVE OUT BONUS TOO.

 

 

14-2 Unrelated Business Income Tax Dan Smith is a certified human resource manager who serves on the board of a local professional association of human resource managers. The association outs on an annual conference for its members at which there are educational workshops, keynote speakers, and a display of vendors that serve the needs of human resource managers. This year, the association has decided to allow vendors to advertise in the annual meeting publications for a fee. Mr. Smith is unsure whether the benefits of allowing this advertising outweigh the potential costs if this income is subject to unrelated business income tax. As a result, Mr. Smith has asked your assistance, as an accounting student, in analyzing the costs and benefits of this proposal. a. Create a list of questions to pose to the executive director of the association about the proposed advertising so that the board has all he relevant facts on hand. b. What resources are available to investigate whether income from advertising is subject to unrelated business income tax? c. Prepare a memo to Mr. Smith that outlines the key issues involved in the proposal and suggest an approach to analyzing whether the proposal is in the best interest of the professional association.

SPREAD SHEET 1

Excel has the ability to import data from the Internet. This week’s individual work gives you an opportunity to use Web Queries to retrieve stock data from the Internet.

For this week’s individual work, please complete the following:

• In the Lab 3: Stock Club Investment Analysis, EX 132.

Lab 3: Stock Club Investment Analysis Problem: Several years ago, you and a large group of friends started a stock club. Each year every member invests more money per month. You have decided to create a portfolio worksheet ( Figure 2– 80) that summarizes the club’s current stock holdings so that you can share the information with your group of friends. The club’s portfolio is summarized in Table 2– 8. Table 2– 8 also shows the general layout of the worksheet to be created.

Instructions: Perform the following tasks:

1. Start Excel. Enter the worksheet titles Sock- It- Away Stock Club in cell A1 and Summary of Investments in cell A2. 2. Enter the column titles and data in Table 2– 8 beginning in row 3.

3. Change the column widths and row heights as follows: column A — 11.78; column C — 10.00; columns E and G — 7.44; columns F, H, and I — 13.00; column J — 8.22; row 3 — 56.25 points; row 14 — 27.00 points.

4. Enter the following formulas in row 4 and then copy them down through row 12: a. Enter Formula A in cell F4: Initial Cost = Shares × Initial Price per Share b. Enter Formula B in cell H4: Current Value = Shares × Current Price Per Share c. Enter Formula C in cell I4: Gain/ Loss = Current Value – Initial Cost d. Enter Formula D in cell J4: Percent Gain/ Loss = Gain/ Loss / Initial Cost

5. Compute the totals for initial cost, current value, gain/ loss, and percent gain loss. For the percent gain/ loss in cell J13, copy cell J12 to J13 using the fi ll handle.

6. In cells D14, D15, and D16, enter Formulas E, F, and G using the AVERAGE, MAX, and MIN functions. Copy the three functions across through the range J14: J16. Delete the invalid formula in cell J14. 7. Format the worksheet as follows:

a. Apply the Trek theme to the worksheet.

b. Format the worksheet title with Title cell style. Merge and center across columns A through J.

c. Format the worksheet subtitle with Franklin Gothic Book font, 16 point font size, Black, Text 1 theme font color. Merge and Center across columns A through J.

d. Format the worksheet title and subtitle background with Orange, Accent 1, Lighter 60% theme color and a thick box border.

e. Format row 3 with the Heading 3 cell style and row 13 with the Total cell style.

f. Format the data in rows 4 through 12: center data in column B; format dates in column C to the mm/ dd/ yy date format; range E4: I4 — Accounting number format style with fi xed dollar sign; range E5: I12 — Comma style; range J4: J13 — Percent style with two decimal places; cells F13, H13, and I13 — Accounting Number format with fi xed dollar sign.

g. Format E14: I16 — Currency format with fl oating decimal places; J15: J16 — Percent style with two decimal places.

h. Format J4: J12 — apply conditional formatting so that if a cell in range is less than 0, then cell appears with a pink background color. 8. Spell check the worksheet. Change the name of the sheet tab to Summary of Investments and apply the Orange, Accent 1, Darker 25% theme color to the sheet tab. Update the document properties, and save the workbook using the fi le name, Lab 2- 3 Sock- It- Away Stock Club Summary of Investments.

 

SPREAD SHEET 2

use Excel’s sorting capabilities to analyze data.

For this week’s lab work, please complete the following: 

• “In the Lab” Lab 2: Sorting, Finding, and Advanced Filtering, EX 354 – 357.

• There are 3 parts to this assignment
  • Part 1 – Sorting
  • Part 2 – Finding
    
  • Part 3 – Extracting
    
• Save a separate file for each part of the Lab after completing the final exercise for that section (e.g. Part 2, #4.  Find all the records that have locations in CA and that are drugstores), and use a filename that is descriptive Georgie Hollenbeck_CGS 2510-12 Lab Work 6 Sort.xlsx

Lab 2: Sorting, Finding, and Advanced Filtering Problem: Cornelli’s Inc. has many stores across the nation. Depending on the store classifi cation, there are different departments available at the location; however, they do not have to have all the same de-partments. The company uses a table ( Figure 5 – 69) that shows what departments are at each location as well as the store classifi cation. The CEO, Juniper Alvarez, has asked you to sort, query, and determine some statistics from the table. Carefully label each required printout by using the part number and step. If a step results in multiple printouts, label them a, b, c, and so on. Instructions

Part 1: Start Excel and perform the following tasks.

1. Open the workbook Lab 5- 2 Cornelli’s Department Availability Table from the Data Files for Students. See the inside back cover of this book for instructions for downloading the Data Files for Students or see your instructor for information on accessing the fi les required in this book. Do not save the workbook in this part.

2. Complete the following tasks:

a. Sort the records in the table into ascending sequence by location. Austin, TX should appear fi rst in the table. Seattle, WA should appear last. Print the table. Undo the sort.

b. Sort the records in the table by Classifi cation within Location. Select descending sequence for the Classifi cation and ascending sequence for Location. Austin, TX should be the fi rst record. Print the table. Undo the sort.

c. Sort the table by Home within Furniture within Bath within Auto. Apply sort descending for all four fi elds. Sort the table fi rst on Home, then Furniture, then Bath, and fi nally Auto. Those locations with all four departments will rise to the top of the table. Orlando, FL should be the first record.

 

Instructions Part 2:

Open the workbook Lab 5- 2 Cornelli’s Department Availability Table from the Data Files for Students. Do not save the workbook in this part. Select a cell within the table. If the column heading arrows do not appear, then click the Filter button ( Data tab | Sort & Filter group).

Use the column heading arrows to fi nd the records that meet the criteria in items 1 through 4 below. Use the Show All command on the Filter submenu before starting items 2, 3, and 4. Print the table for each query. You should end up with the following number of records for items 1 through 4: item 1 should have 7; item 2 should have 3; item 3 should have 4; and item 4 should have 1. Close the workbook without saving the changes. Submit the assignment as requested by your instructor.

 

 

1. Find all records that have a pharmacy and a grocery department.

2. Find all records that represent locations with more than 7 departments that have a pharmacy and a clothing department.

3. Find all records that have a location in TX using search.

4. Find all records that have a location in CA using search and that are drugstores.

 

Instructions Part 3:

Open the workbook Lab 5- 2 Cornelli’s Department Availability Table from the Data Files for Students and then save the workbook using the fi le name, Lab 5- 2 Cornelli’s Department Availability Table Final. Perform the following tasks:

 

1. Add a criteria range by copying the table title and fi eld names ( range A9: M10) to the range A2: M3 ( Figure 5 – 70 on the following page). Change cell A2 to Criteria Area and then color the title area as shown in Figure 5– 70. Use the Name box in the formula bar to name the criteria range ( A3: M4) Criteria.

 

2. Add an extract range by copying the table title and fi eld names ( range A9: M10) to the range A34: M35 ( Figure 5 – 71). Change cell A34 to Extract Area and then color the title area as shown in Figure 5 – 71. Use the Name box in the formula bar to name the extract range ( range A35: M35) Extract.

 

3. With the table active, use the Advanced button ( Data tab | Sort & Filter group) to extract records that pass the tests listed below in a through d. Print the worksheet in landscape orientation using the ‘ Fit Sheet on One Page’ option for each extract.

a. Extract the records that represent locations that have all of the departments. You should extract two records.

b. Extract the records that represent superstores that have a pharmacy but not an auto department. You should extract one record.

c. Extract the records that represent locations that have an auto department and have less than 7 departments total. The fi eld Count in column M uses the COUNTIF function to count the number of Ys in a record. A count of 4 means the record represents a location with four departments. You should extract seven records.

d. Extract the records that represent locations with less than three departments. You should extract 4 records.

 

 

Read through the list of research topics (located in the Appendix), or by clicking the link here, on which to write a research paper. Select three (3) topics that interest you most and identify two (2) credible sources for each topic. Note: This is one (1) of several parts that will build toward a final draft of your persuasive writing research paper.

Write a one to two (1-2) page paper in which you:

1. Explain the reason for selecting topic one (1), identify the audience, and provide a preliminary thesis statement. 
2. Explain the reason for selecting topic two (2), identify the audience, and provide a preliminary thesis statement. 
3. Explain the reason for selecting topic three (3), identify the audience, and provide a preliminary thesis statement. 
4. Identify and document six (6) credible sources (two (2) for each topic) that you would expect to use. Note: Wikipedia and other Websites do not qualify as academic resources.

Your assignment must follow these formatting guidelines:

• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required page length. 

The specific course learning outcomes associated with this assignment are:

• Recognize the elements and correct use of a thesis statement. 
• Associate the features of audience, purpose, and text with various genres.
• Recognize correct APA documentation and reasons to document and avoid plagiarism.  
• Write clearly and concisely about selected topics using proper writing mechanics.  
• Use technology and information resources to research selected issues for this course.