Companies i selected are 

1.walt Disney 

2. comcast 

3. discovery. 

ALL OF THEIR INCOME STATEMENTS, BALANCE SHEETS AND CASH FLOWS ARE FROM 2018, 2019 AND 2020. PLEASE LINK ANSWERS TO PREVIOUS TABS. 

CAN YOU PLEASE FOLLOW ALL INSTRUCTIONS AND ANSWER ALL QUESTIONS? THANK YOU!

Excel Project: Part III Instructions

Common Sized Balance Sheets (Tabs 12), Common Sized Income Statements (Tab 13), Horizontal Analysis Balance Sheets (Tab 14), Horizontal Analysis Income Statements (Tab 15), and Projected Financial Statements (Tabs 16-18) 

· Continue in the same Excel workbook prepared in Week 4, adding the following tabs:

o The 12th tab in your Financial Statement Analysis Template must be labeled Common Sized Balance Sheets.

§ Set-up like the Historical Balance Sheets (Tab 3), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Balance Sheets for the calculations. “Total Assets” should be used as the base for all common sized calculations on the Balance Sheets. Common sized percentages should be calculated for all three historical years presented.

§ See Exhibit A for a partial example of this tab.

o The 13th tab in your Financial Statement Analysis Template must be labeled Common Sized Income Statements.

§ Set-up like the Historical Income Statements (Tab 2), this worksheet should use formulas to calculate the common sized percentages, linking to the Historical Income Statements for the calculations. “Revenue” or “Total Revenue” (depending on your company) should be used as the base for all common sized calculations on the Income Statements. Common sized percentages should be calculated for all three historical years presented.

o The 14th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Balance Sheets.

§ Start by copying and pasting the Historical Balance Sheets from Tab 3 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years.

§ See Exhibit B for an example of this tab.

o The 15th tab in your Financial Statement Analysis Template must be labeled Horizontal Analysis of Income Statements.

§ Start by copying and pasting the Historical Income Statements from Tab 2 to this worksheet. Then, add dollar and percentage change columns between each of the set of historical years.

o The 16th tab in your Financial Statement Analysis Template must be labeled Projected Income Statements. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report. 

o The 17th tab in your Financial Statement Analysis Template must be labeled Projected Balance Sheets. Three years of projected statements should be included. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report. 

o The 18th tab in your Financial Statement Analysis Template must be labeled Projected Statement of Cash Flows. Three years of projected statements should be included, starting with the most recent year after the company’s last issued report. 

§ Other information relating to projected tabs:

§ Projections should be based on research performed on your company and its industry. Use historical, trend, ratio data and current and future economic projections as well as information from the company’s MD&A to aid in preparing projections.

§ Clearly state your assumptions in a text box at the bottom of each tab. Cite sources for assumptions based on research. 

§ The statements should be consistent, reasonable, and accurate. Areas that will be checked for accuracy include:

· The Balance Sheets should balance for all years presented.

· Retained earnings should be properly calculated using the prior year’s balance, net income, and dividends.

· The Ending Cash Balance on the Statement of Cash Flows should agree to the Cash Balance shown on the Balance Sheet for the same year.

· Net Income on the Income Statements should match what is reported on the top of the Statement of Cash Flows (if indirect method is used).

o Other instructions:

§ The Excel workbook should be professionally formatted. Professional formatting includes:

· All numbers are formatted similarly. The use of decimals, commas for thousands, and other formatting is consistent.

· Dollar signs are included in the first and last numbers of each column.

· Subtotals and totals are preceded by a single underline. Totals are followed by a double underline.

· Line descriptions are indented/bolded in a manner that makes the spreadsheet easy to read. 

§ All common sized, horizontal analysis, and projection items should be calculated using formulas. Totals and subtotals should also be calculated using formulas.  For an example of which cells may need formulas, please see Exhibits A & B.

This assignment is due by 11:59 p.m. (ET) on Monday of Module/Week 6.

Week 7 Project

Hypothesis Testing is the use of statistics to determine the probability that a given claim is true.

In Part II of this project, you will choose a data set, review claims and perform hypothesis testing and make a decision. You will then complete a write-up that includes the calculations.

The government logs the number of documented births, deaths, marriages and divorces however it is possible to have undocumented cases. In part II of this project, you are going to test claims about total births, deaths, marriages and divorces.

1. Choose a Data Set.
2. Go to https://www.cdc.gov/nchs/products/nvsr.htm (Links to an external site.)
3. In the search bar type: Births, Marriages, Divorces, and Deaths

   

4. Pick a DataSet and download the PDF document and make note of the volume, number, and date.  For example,
   
5. Pick the same month/year combination for each data set. For example, choosing September of 2009. 

   

6. Preliminary Calculations
7. Create a summary table for 1. Live Births, 2. Deaths, 3. Marriages, and 4. Divorces highlighting the mean, median, sample/population standard deviation, n = number of states that submitted data for each the data sets. You will have FOUR tables using the list of values of each state, the District of Columbia and Puerto Rico (You could have 52 numbers for each data set. You may have less data numbers if not all states/territories submitted data values.)

Summary Table for _________Mean Median Standard Deviation n (Number of States who submitted Data) 

1. Hypothesis Testing

With the information that you gather from the summary tables, test the following (you can use excel when appropriate):

1. Determine if there is sufficient evidence to conclude the average amount of births is over 5000 in the United States and territories at the 0.05 level of significance.
2. Determine if there is sufficient evidence to conclude the average amount of deaths is equal to 6000 in the United States and territories at the 0.10 level of significance.
3. Determine if there is sufficient evidence to conclude the average amount of marriages is greater or equal to 2500 in the United States and territories at the .05 level of significance.
4. Determine if there is sufficient evidence to conclude the average amount of divorces is less than or equal to 4000 in the United States and territories at the 0.10 level of significance.

For each of the tests above, in your report, be sure to—

1. Clearly state a null and alternative hypothesis
2. Give the value of the test statistic
3. Report the P-Value
4. Clearly state your conclusion (Reject the Null or Fail to Reject the Null)
5. Explain what your conclusion means in context of the data.

4. Make your OWN Claim (You are completing ONE more Hypothesis Test)

Lastly, propose and conduct your own test of hypothesis.

a) Pick one data set: Births, Deaths, Marriages OR Divorces.

b) Write a claim about the data set.

c) For your claim—

1. Clearly state a null and alternative hypothesis
2. Give the value of the test statistic
3. Report the P-Value
4. Clearly state your conclusion (Reject the Null or Fail to Reject the Null)
5. Explain what your conclusion means in context of the data.

Rubric

Week 7 Project: Part IIWeek 7 Project: Part IICriteriaRatingsPtsThis criterion is linked to a Learning OutcomePart II: Choose a Data Set & Preliminary Data5 ptsProficient. Student correctly computes all 4 Preliminary Data Tables.4 ptsAbove Average. Student correctly computes 3 Preliminary Data Tables.3 ptsAverage. Student correctly computes 2 Preliminary Data Tables1 ptsNeeds Improvement. Student correctly computes 1 Preliminary Data Tables.0 ptsNo Effort. No Preliminary Data Tables were completed are all are incorrect.5 pts
This criterion is linked to a Learning OutcomePart II: Hypothesis Testing20 ptsProficient. Correctly completes 4 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and reports the p-value.16 ptsAbove Average. Correctly completes 3 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and report p-value.14 ptsAverage. Correctly completes 2 Hypothesis Tests highlighting the null/alternate hypothesis, value of test statistic, and report p-value.10 ptsNeeds Improvement: Correctly completes 1 Hypothesis Test highlighting the null/alternate hypothesis, value of test statistic, and report p-value.0 ptsNo Effort. No Hypothesis Tests were completed or none were completed correctly.20 pts
This criterion is linked to a Learning OutcomePart II: Hypothesis Testing Analysis10 ptsProficient. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for ALL 4 Problems.8 ptsAbove Average. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 3 Problems.7 ptsAverage. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 2 Problems.5 ptsNeeds Improvement. State correct conclusion (Reject/Fail to Reject) and valid explanations in context of the data for 1 Problem0 ptsNo Effort. No conclusion/explanations were given or all were incorrect.10 pts
This criterion is linked to a Learning OutcomePart II: Proposal and computations for new hypothesis test10 ptsProficient. Student correctly creates an original Hypothesis Test based on one of the data sets highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.8 ptsProficient. Student correctly creates an original Hypothesis Test based on one of the data sets and has MOST of the content: highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.7 ptsAverage. Student creates an original Hypothesis Test based on one of the data sets and MISSING MOST of the content: highlighting the null/alternate hypothesis, value of test statistic, report p-value, conclusion and explanation.5 ptsNeeds Improvement. Student creates an original Hypothesis Test based on one of the data sets but there are multiple mistakes and/or conclusions are not valid.0 ptsNo Effort. The student did not propose/compute a new hypothesis test.10 pts
Total Points: 45

 

Instructions

Improving Organizational Culture: Acceptance of Religion and Orientation

Fig Technologies has identified concerns at several of their offices globally. Division has been noted on key teams based upon religion and sexual orientation. Several team members have complained that the non-Christian holidays and LGBT celebrations are not recognized by the established company celebrations or paid time off for observance. There have been complaints with regard to coworkers making harassing comments to this effect. The Executive Leadership Council has asked for you to draft an assessment of these concerns and then to propose a plan of action for addressing these concerns. Further, include a preliminary draft of policy to be included as an addendum to the organizational policy on discrimination and harassment. In your report, be sure to address the following:

• Compare the impact of different religious beliefs and practices (choose three to four different religions) and how these affect the organizational culture, and describe how your new plan and policy will improve organizational culture through inclusion of different religious beliefs and practices.
• Compare how belief systems of different gender orientations and sexual orientations may impact the organizational culture, and describe the effects of discrimination against any of these. In your plan of action, address how inclusion and assimilation of different orientations will improve organizational culture.

Support your recommendation through the use of at least two sources, one of which can be the textbook. Content should be two to three pages in length. Length does not include an assessment tool, if used, though it may be added as an addendum (recommended, not required). All sources used, including the textbook, must be referenced; paraphrased and quoted material must have accompanying citations. All references and citations used must be in APA style.

Have some fun with the assignment. Use your creative thinking along with your critical thinking to include your perspective of the findings and how to address the issue.

 

To Prepare

• Review the Resources for this module and consider the legal and ethical implications of prescribing prescription drugs, disclosure, and nondisclosure.
• Review the scenario assigned by your Instructor for this Assignment.
• Search specific laws and standards for prescribing prescription drugs and for addressing medication errors for your state or region, and reflect on these as you review the scenario assigned by your Instructor.
• Consider the ethical and legal implications of the scenario for all stakeholders involved, such as the prescriber, pharmacist, patient, and patient’s family.
• Think about two strategies that you, as an advanced practice nurse, would use to guide your ethically and legally responsible decision-making in this scenario, including whether you would disclose any medication errors.

By Day 7 of Week 1

Write a 2- to 3-page paper that addresses the following:

• Explain the ethical and legal implications of the scenario you selected on all stakeholders involved, such as the prescriber, pharmacist, patient, and patient’s family.
• Describe strategies to address disclosure and nondisclosure as identified in the scenario you selected. Be sure to reference laws specific to your state.
• Explain two strategies that you, as an advanced practice nurse, would use to guide your decision making in this scenario, including whether you would disclose your error. Be sure to justify your explanation. 
• Explain the process of writing prescriptions, including strategies to minimize medication errors.

  

homework is due in 5 hours from now ( 120 words or more)

• All discussion boards should be submitted in APA style (7th      edition).  
• discussion board response posts      require at least one outside­­­­      and peer-reviewed article as a reference in your      posts. Please choose a reliable source, sources such as Wikipedia are      unacceptable.  

Guidelines for your response posts:

• Respond to at least one classmates’ posts      prior to Sunday midnight.
• Response posts must      be at least 100 words (equivalent to at least 1/4-page of      double-spaced 12-pt. font text) or more.

Here is the post to rely to below (support the paper or refute with respect)

Medication Errors

Nurses and physicians are affected immensely by medication errors. Kim Hiatt was affected so much that she ended up committing suicide (Saavedra, 2015). Secondly, experience does not shield nurses or physicians from making medication errors. An experienced nurse made a calculation error simply because she was involved in a conversation when calculating calcium chloride calculations.

The principle of beneficence can apply to these cases when analyzing the actions of the nurses from an ethical lens. Were the actions of the nurses aimed at the good of the patients? In both cases, it is apparent that the nurses did not intend adverse outcomes. Julie Thao committed the error partly because of her efforts to lower the patient’s anxiety levels. Thus, beneficence and benevolence should be considered when investigating and assessing the culpability of the nurses. The administrator handled the situations legally in both cases. However, their actions could be deemed lacking from an ethical perspective.

Compassion is a virtue that may have helped Thao and Hiatt. Had their colleagues and employers shown them compassion instead of treating them as criminals and incompetent nurses, the adverse outcomes that the nurses suffered would have been avoided. Prudence, by the colleagues of the two nurses, the investigators, and the administrators, would have afforded them greater mental flexibility to accept that errors can happen in clinical settings and consider the weight or burden it placed on the two nurses.

The personal virtues that may have helped the second victims navigate the grieving process include honesty and reverence. Honesty would have helped the second victims accept that medication errors can occur. It may have also helped them be more accepting of their role in the adverse outcomes. Reverence could have helped them see their negative experiences as means to making them better nurses. It would have helped them generate some positives out of their negative experiences.