Posts

Determine the capital structure of the firm: Determine the market value of the firm’s debt and equity. Explain the approach and procedure you used and use these values to determine the weights for the WACC.

This is a copy of the full assignment. At this time I am only requesting parts I,II,III

Will request the rest in the future

The firm it Marriott

Must use textbook as a reference

Text book: Vitalsource.com (corporate finance)

Ask support for logins

Book: Corporate Finance found under the “my bookshelf” tab

 

Part I: Firm History and Overview (due Week 4)

Develop an overview/history of the firm that you have chosen, as well as the industry your firm operates in. You should include information that describes the market structure and competition in the industry, along with the position of your firm within this industry – i.e., is the firm one of the leaders or is it a niche player? Is the firm one of the medium-size firms in the industry? Part I will be worth 30 points.

Part II: End-Point Financial Analysis (due Week 4)

Using historical financial statements (income statements and balance sheets) for the firm, analyze the financial performance and changes to the firm over a ten-year time period using an end-point analysis framework similar to that used in the analysis of Coca-Cola (Week 1 dropbox assignment). You should calculate the same ratios and financial measures as were provided for the Coca-Cola case.

Next, you will identify the major changes in the firm’s financial performance over this time period. Include an analysis of: 1) overall changes/growth in the firm’s revenues, assets, and liabilities; 2) common-size statements; 3) ratio analysis; and 4) analysis using the DuPont model.

You will be required to provide the conclusions regarding which way the major ratio categories are trending. An acceptable conclusion might be, for example: “profitability has increased over the last five years as evidenced by increasing net margin and gross margin ratios. This is the result of a decrease in cost of goods sold, higher margins because of increased market share, etc.” You should also research the notes to your company’s 10K to determine the probable causes of these changes (“Leverage increased because the company issued $50M in bonds to pay for a plant expansion.”). Part II will be worth 70 points.

Part III: Working Capital Analysis (due Week 4)

Using the same financial statements from your Financial Analysis (Part II), provide an analysis of the firm’s working capital policy and changes to this policy over a ten-year period. Your working capital analysis should include the following: 1) overall level and change in WC over the time period and the factors that caused these changes; 2) calculation of the Cash Conversion Cycle for the beginning and ending period and a discussion of causal factors and implication of these changes; 3) overall assessment of the firm’s working capital policy (i.e., is it conservative, moderate, or aggressive?). Compare your results to the firm’s industry averages. Part III will be worth 40 points.

Part IV: Determination of WACC (due Week 7)

Using the principles and tools outlined in the textbook, form an estimate of the Weighted Average Cost of Capital (WACC) for the firm. In order to complete this task, you will need to do the following:

  • Determine the cost of debt: Using information from the firm’s website, annual report, the website Investing in Bonds (link available in the Content area), and the library database sources, determine the ‘average’ rating of your firm’s bonds and the current YTM on a composite of these bonds. Based on this information, estimate the current cost of debt for the firm. Explain the approach and procedure you used to make your determination and what this number means.
  • Determine the cost of equity: Determine the required rate of return for your firm using the CAPM. Explain the approach and procedure you used (and justification for the sources of inputs used for your model) to make your determination and the meaning of this required rate of return.
  • Determine the capital structure of the firm: Determine the market value of the firm’s debt and equity. Explain the approach and procedure you used and use these values to determine the weights for the WACC.

Finally, provide an overall explanation for your results and how the firm will use this WACC. There are resources available in the Content area that will help guide your determination of WACC. Part IV will be worth 80 points.

Part V: Stock Valuation (due Week 7)

In chapter 9, we learned how the dividend-discount model can be used to determine the value of a firm’s equity, or the current price of a share of stock. Use this model to estimate the value of a share of your firm’s stock and compare this estimate to the current market value. To do this, you will need to do the following:

  1. Estimate the firm’s stock price using the dividend-discount model: Use an investment source (some have been provided in the Content area) and find: 1) the current dividend; 2) analyst’s estimate growth rate for the next five to ten years; 3) an alternative growth estimate using the firm’s historical growth rate or the formula “g=ROE x b”.
  2. Use your estimate of the cost of equity in the WACC for the rE part of your formula: Combine the above information into the dividend-discount model (DDM).
  3. Compare your result to the current market price of your firm’s stock. Provide analysis and an explanation of how they compare and explain any differences you observe.

Part V will be worth 50 points.

Part VI: Capital Budgeting Analysis, Capital Structure Analysis and Funding Growth Strategies, and Bibliography and Data (due Week 8)

Capital Budgeting Analysis (30 points): You have been asked to evaluate a potential acquisition of a smaller privately owned competitor. The acquisition candidate produces an EBITDA of 10% of your current EBITDA and is offered to your firm at a price of multiple of 8 times EBITDA. Assume the following:

  • Current debt costs you 8% and you can raise additional debt at this rate today. The loan is to be amortized over 7 years.
  • Current return on equity is 15%
  • Current WACC is 10%
  • Tax rate is 30% (constant)
  • 80% of the purchase price is considered depreciable assets – to be depreciated over ten years on a straight-line basis with no residual values.
  • Residual value for this operation is to be 2x current EBITDA in year ten.

Create an after-tax cash flow analysis to answer the following:

  • Economic analysis: is this a fundamentally sound investment?
  • Using the tax cash flows and no debt (pure equity), is the prospect a positive NPV using ROE as the hurdle rate?
  • Using the after tax cash flows and the firm’s WACC, is this project desirable? Explain how you came to this conclusion.

Capital Structure Analysis and Funding Growth Strategies (80 points): Imagine your firm has some attractive investment opportunities that it is considering. The capital budgeting process has been completed and found that these projects have a positive NPV and are desirable. The firm must raise financing for the projects in the amount equal to 5% of the current level of its total assets. As you know, these funds can come from a number of sources: operations, short-term debt, long-term debt (new bond issues), or equity (new stock issues).

Your task is to decide where funds for these projects should come from based on your knowledge of the firm and your knowledge of the current state of the economy (i.e., level of interest rates, state of the stock market, future prospects for the economy/firm). This section is worth 80 points. Your analysis should answer the following questions:

  1. How much must your firm raise for the investments to be undertaken?
  2. How will you determine where the funds should come from? Provide analysis for the following areas:
    • Current capital structure of the firm, specifically, you must cite how some of the ratios you calculated in Part II will influence your decision.
    • Federal Reserve policy and interest rates, meaning what are current borrowing interest rates and what direction do you believe these will trend in the near future?
    • Stock price and state of the stock market, meaning are current stock prices high? Low? How could a firm’s financing choice(s) be impacted?
    • Working capital policy
    • Profit/loss situation and operating cash flows
Sources and Formatting: (20 points) – Due Week 8, along with your Completed Project
  1. Remember to include a properly formatted APA bibliography page. All direct and paraphrased quotations within your paper are to be properly notated. All sources of information are to be properly identified.  (5 points)
  2. As an appendix to your paper, copy and paste the financial statements from which you derived all your ratios, percentages, and any other quantitative data. Do not just provide a link. (5 points)
  3. The paper will be prepared in APA format and is to be double-spaced. Composition is an important part of your paper. Multiple grammar, spelling and/or punctuation errors will decrease your ability to communicate clearly your ideas to your audience. (10 points)
  4. Your final project should be formatted as a MS Word (.doc/.docx) file that has been edited carefully for grammar and style, and include a cover page and a complete bibliography and index of data.

 

Coca-Cola case assignment as referred to in Section II

 Coca-Cola Analysis

Below you will find financial data for Coca-Cola for the years 2006 and 2016. This data includes the following:

  1. Raw numbers for the balance sheet and income statements
  2. Common-size balance sheets (all entries expressed as a percent of Total Assets)
  3. Common-size income statement (all entries expressed as a percent of Total Sales)
  4. Ratios—including liquidity, profitability, leverage, asset management, and market ratios
  5. DuPont equations
  6. Working Capital
  7. Cash Conversion Cycle

Your assignment is to analyze this data. Your analysis should include the following:

  1. An ‘eye-ball’ assessment of  the changes in Coke’s financial statements between 2006 and  2016—e.g., overall growth in assets, revenues, equity, debt, etc.
  2. Analysis of the Common-size statements—i.e., what changed and why. That is, describe the  changes in these statements and analyze the cause of the changes. Include: a) mix of assets, b) split between current assets and  fixed assets, c) mix of debt, d) split between current liabilities  and LT liabilities, capital structure (i.e., debt and equity), e) profitability at all levels, f) changes in expenses, etc. This section must include evidence of research indicating what events had substantive effects on Coke’s financial profile during the 10 year In other words, profitability may have increased due to  introduction of new product lines, leverage may have increased due to the issuance of bonds, and assets may have increased due to acquisitions. These are offered as examples, and your research should indicate what occurred and how it affected Coke from a           financial perspective.
  3. Analysis of the ratios by category—include in this an explanation of the cause of the   change—e.g., liquidity increased due to the increase in CAs and decrease in CLs. In addition to discussing each of the individual  ratios, this section must include an overall conclusion regarding the direction of the four major categories of ratios. In other      words, you must draw conclusions regarding the overall trends in 1)liquidity, 2) efficiency, profitability, and 4) leverage over the 10 year period. You must also provide industry averages where available  so that you can compare Coke’s ratios to those of its industry
  4. Analysis of the DuPont equation and discussion of the underlying reasons for the changes in ROI             (ROA) and ROE.
  5. Analysis of working capital and discussion of the implication of a positive or negative WC level. Is             Coke’s WC policy conservative, moderate, aggressive? Why?
  6. Analysis of the Cash Conversion Cycle and discussion of its implications.
  7. Summary and conclusion concerning the major changes in Coke’s financial situation.

Coca-Cola Common-Size Statements of Income and Retained Earnings for December 2006 and 2016

All Amounts in Millions

  2006 % 2016  
Revenue 24,088         100% $ 41,863        100%
Cost and Expenses        
      Cost of Sales $8,164 34% $16,465 39%
Gross Profit $15,924 66% $ 25,398 61%
 

S, G, and A

$9,616 40% $16,772 40%
      Interest Charges $220 1% $ 733 2%
      Other Income/Expenses (net) ($490) -2% ($243) -.5%
           Total Cost and Expenses $17,510 73% $ 33,727 81%
Income before Income Taxes $6,578 27% $ 8,136 19.4%
 

Provision of Income Taxes

$1,498 6% $ 1,586 4%
Other Income     ($23) -0.4%
Net Income 5,080 21% $ 6,527 15.6%
Dividends (% of NI)               57%              83.6%
Adjustments to Retained Earnings $0   $0  
Retained Earnings, Beginning Balance $28,388   $ 65,018
Retained Earnings, Ending Balance $33,468   $ 65,502

 

Coca-Cola Common Size Balance Sheets for December 2006 and 2016

All amounts in Millions

  2006 % 2016 %
Assets        
Current Assets        
     Cash and Equivalents $2,440 8% $22,201 25.4%
     Receivables $2,704 9% $3,856 4.4%
     Inventory $1,641      5.5% $2,675 3.1%
     Other $1,656       5.5% $5,278 6.1%
Total Current Assets $8,441 28% $34,010 39.0%
Productive Assets        
     Property, Plant, and Equipment (net) $6,903   $10,635  
         
Net Productive Assets $6,903 23% $10,635 12.2%
Other Assets $14,619 49% $42,625 48.8%
Total non-current assets $21,522     71.8% $53,260      61.0%
Total Assets $29,963    100% $87,270      100%
Liabilities And Shareholders’ Equity        
Liabilities        
     Current Liabilities        
          Accounts Payable $5,622 19% $2,682 3.1%
          Current Debt Due $3,268 11% $16,025 18.4%
          Other $0 0% $7,825 9.0%
Total Current Liabilities $8,890 30% $26,532 30.5%
Long-Term Liabilities        
     LT Debt $1,314 4% $29,684 34.0%
     Other LT Liabilities $2,231 7% $3,753    4.3%
     Deferred Income Taxes $ 608 2% $4,239    4.9%
          Total LT Liabilities $4,153 13% $37,676    43.2%
Total Liabilities $13,043 43% $64,208 73.6 %
Shareholders’ Equity        
     Common Stock $878 3% $1,760 2.0%
     Treasury Stock ($22,118) -74% ($47,988)    -55.0%
     Retained Earnings $33,468 112% $65,502  75.1%
     Equity Adjustments ($1,291) -5% ($11,205) -12.8%
Capital Surplus   $  5,983         20% $14,993 17.2%
Total Shareholders’ Equity $16,920 57% $23,062 26.5%

Total Equity + Liabilities           $29,963                   100%     $87,270         100%

Ratio Analysis for Coco-Cola:  2006 and 2016

Ratio Definition 2006

2016

Liquidity      
1. Current ratio current assets

current liabilities

.9 1.28
     
2. Quick ratio (acid test) current assets – inventories

current liabilities

        .76 1.18
     
Asset Management      
3. Average collection period accounts receivables

credits sales/ 365

41 33.6
Total Rev. = Cr. Sales    
 

4. Inventory turnover

cost of sales

average inventory

5 5.64
INO = AVE INV    
 

5. Fixed asset turnover

sales

fixed assets

3.5 3.94
FIXED ASSETS = NET    
6. Total asset turnover sales

total assets

.8 0.48
     
Financial Leverage Management    
7. Debt Ratio total debt

total assets

       .44 0.735
ST+LT= Total Debt    
8, Debt-to-equity total debt

total equity

.77 2.78
ST+LT    
Profitability      
9. Gross profit margin sales – cost of sales

sales

66.1 60.7
     
10. Net profit margin earnings after taxes (EAT)

sales

21.1 15.6
     
11. Return on investment earnings after taxes (EAT)

total assets

      17.0 7.5
     
12. Return on Stockholders’ equity earnings after taxes (EAT)

stockholders’ equity

30.0 28.3
     

 

Dividend Payout                                                                                                         57%               83.6%

 

 

Du Pont Model

ROI or ROA:

ROI = Profit Margin x Asset Turnover = Net Profit x Net Sales
Net Sales Total Assets
                     
ROI (2006) = $5,080 x $24,088 = 21.1% x ,80 = 17%
$24,088 $29,963
ROI (2016) = $6,527 x $41,863 = 15.6% x 0.48 = 7.5%
$41,863 $87,270
                     
ROE:

 

                   
ROE = Profit Margin x Asset Turnover x Leverage        
 

Where Leverage = Total Assets/Equity

 

 

           

ROE (2006)  =  21.1% X  .8      X       1.77      =        29.9%

ROE (2016)  =  15.6% X  0.48     X    3.78      =        28.3%

Working Capital

Working Capital = Current Assets – Current Liabilities

2006 Working Capital:          8441 –     8890 =    -449

2016 Working Capital:                      34,010 – 26,532 = +7478

 

 Cash Conversion Cycle

                                                                       2006                                       2016 

Accounts Receivable Days:                          41                                           33.6

Inventory Days:                                            73                                           59.4

Accounts Payable Days:                             251                                           59.5

CCC                                                             -137                                         33.6

Describe the parent theory. Identify the key constructs and relational statements. Include a diagram of the parent theory.

Background, Significance & Theoretical Background of the  Phenomenon
a. Use the feedback from the Review of Theoretical Perspectives paper
b. summarize the background, significance and theoretical background of the phenomenon including modifications, and add the following new content.
→ my proposition statement (about my phenomenon, population of interest, and outcome of interest) is → Cancer Patients and Post-Operative Venous Thromboembolism
Develop a theoretical or conceptual model that can be used to guide  practice on your topic.
a. From the major theoretical approaches that you described  in your initial paper, choose one theoretical orientation, or theory → The Theory of Unpleasant Symptoms in Practice (TOUS), that you would like to apply to your chosen phenomenon and assigned population and outcome of interest. You may use an existing middle-range theory, you may derive a theory from a grand theory, or you may synthesize one or more theories to create a new middle
-range theory. Provide a brief rationale for your choice of theory.
b. Describe the parent theory. Identify the key constructs and relational statements. Include a diagram of the parent theory.
c. Derive a theoretical model that can be used to guide your research. Clearly identify the conceptual, theoretical, and empirical levels of the model. Include the C-T-E diagram as a Table in your paper.
3. Describe your proposed theoretical model.
a. Identify and explain the key concepts in your model and provide conceptual definitions.
b. Identify and explain the relationships between your concepts.
Include a visual model (diagram) of your theory.
Using your theory as a guide, develop three possible quality clinical questions that you could answer from your conceptual model. Instructor stated: Continue to work on making links between the population, outcome of interest, and the phenomenon. Also, continue to think about what types of clinical questions could be answered with this information.
Write clearly and succinctly. Pay particular attention to integrating and critically evaluating the literature. Present your ideas logically. Use transitions. Include an introduction and summary. Adhere to APA style (7thedition), including heading and subheading structure, reference format, and table/figure format, titles, and placement.
Use subheadings. The total page length should be approximately
16 pages, excluding cover page with changes, references and appendices.

Briefly explain the key strategy and industry  of your company –using Porter’s forces. You can use PESTLE analysis as alternative framework too.

Coursework Task: PART 2

The coursework is an ongoing project where you will receive instructions each week. The final objective is to use all the financial analysis tools and write a professional debt and equity report on a company of your choice.

PART 2: Weeks 2-3 (introduction section in final report).

AIM : get to know your industry and peers.

  • Introduce your company – points to consider: products, markets, countries, peers, management team, key events to name a few
  • Briefly explain the key strategy and industry  of your company –using Porter’s forces. You can use PESTLE analysis as alternative framework too.

FAQs

  1. You can choose any framework to describe your industry and competitive forces
  2. The peers do not have to be from the same country.

Coursework Tasks PART 3

AIM: Get to know the accounting policies 

PART 3: Weeks 3-5

  • Familiarize yourself with the annual reports and identify main (3-5 as a guideline) accounting policies of your company.
  • Flag up any potential problems/red flags in the accounting practices.
  • Think about how these policies may impact ratios and subsequent financial analysis .

PART 4: Financial Analysis: Weeks 4 -6

Aim: Get to know the financials

  • Comment on the performance of your company using ratio and cash flow analysis.
  • Calculate and comment on the overall profitability and sustainable growth rate of your firm.

FAQs.

  • Students may choose to compare performance of their company with previous years (time series), with a suitable competitor (cross-sectional), industry as a whole or a benchmark they may deem suitable.
  • The emphasis of the report should be on analyzing ratios and linking them to company strategy and relevant news (NOT on calculating ratios).
  • You can calculate your own ratios or use ratios from Bloomberg or Thomson Reuters (must indicate source in your reports and show any own calculations). +++
  • Remember to select ratios which are most relevant to your company and link them to your strategy and accounting analysis (copying and pasting all the ratios will not fetch you marks).
  • Tables and graphs DO NOT count towards word count.
  • Spend time, effort and thought into creating your own peer set using qualitative and quantitative criteria.

PART 5: Weeks 5-8 (Credit analysis)

  • Comment on the capital structure (proportion of debt and equity) and type of debt financing of your firm.
  • Propose a suitable debt rating for your firm based on your earlier industry, accounting and financial analysis.

NOTE

  • You may refer to Moody’s or S&P debt ratings for their firm (if it exists). However, you need to calculate your own debt rating and comment on it.

PART 6 : Prospective analysis (final part)

AIM: RATE THE EQUITY

Forecasting

  • Based on your strategy, accounting and financial analysis -forecast sales and earnings for your company for the next two years.

Valuation

  • Value your firm using comparable multiples. (Not DCF)

Recommendation

  • Based on your valuation and financial analysis issue a recommendation for the firm (Sell/Hold/Buy). You could use the current share price as a benchmark.

Note

Clearly indicate the assumptions underlying your forecasts.

It’s the logic of the forecasts not the accuracy of numbers that will get you marks.

All your calculations for forecasted sales and earnings must be attached as an appendix.

The emphasis should be on deriving your own forecast based on the news and historical share price that you have been following and analysis in weeks 1-9. *

All calculations for comparable multiple valuation must be attached as an appendix. – Clearly stating the comparable firms, the price multiple for the comparables and the method by which you calculated the share value for your firm.

A large proportion of your analysis will have been for fiscal year ending 2018 as 2019 annual reports may not be publicly available yet. You can do your financial analysis till 2018 and then based on semi-annual or quarterly reports, unaudited reports,  share price performance of the company and current events in 2019-202 you should aim to forecast figures for the next two fiscal years (2020, 2021). Therefore, in some/most cases 2019 is a ‘missing’ year.

*The marks will be based on the strength of your assumptions. Bloomberg and other data providers provide their forecasts – there are no marks for copying and pasting Bloomberg forecasts.

Are other countries wanting to invest in your chosen country? Why or why not? Support your answer with research.

Include the following in either the upper left- or right-hand corner of the first page of your paper:
• Your full name
• MGMT 338
• Date of the Paper
• Paper Title
Part I: Information about
Research and provide the following information about your chosen country in bulleted form. Include the country you selected in the heading. For each piece of information, cite the sources used as well as the complete direct URL where the information was found. A complete bibliography of the sources must be included at the end of your paper.
a. What was the total value of U.S. imports from this country in the most recent year available? Of U.S. exports to this country?
Information citation with URL
b. Top 3 imports for this country
Information citation with URL
c. Top 3 exports for this country
Information citation with URL
d. Corporate tax rate
Information citation with URL
e. GDP
Information citation with URL
f. Per capita income?
Information citation with URL
g. Low context or high context
Information citation with URL
h. Average years of schooling of adults (male and female)
Information citation with URL
i. % of population below poverty line
Information citation with URL
j. Rate of population growth
Information citation with URL
k. Life expectancy (male and female)
Information citation with URL
l. Retirement Age (required or not and age when required or average age of retirement—specify which it is in the paper)
Information citation with URL
m. Individual tax rate
Information citation with URL
n. Current inflation rate
Information citation with URL
o. World Bank rank on ease of doing business
Information citation with URL
p. Most recent unemployment level
Information citation with URL
q. Cell phone usage per 1000 people
Information citation with URL
r. Internet usage per 1000 people
Information citation with URL
s. Average # of vacation days per year
Information citation with URL
t. Average # of leave (leave, sick, maternity, paternity) days per year
Information citation with URL
u. Your country’s Hofstede uncertainty score and the U. S. uncertainty score
Information citation with URL

v. Your country’s Hofstede power distance score and the U. S. power distance score
Information citation with URL

w. Your country’s Hofstede individualism score and the U. S. individualism score
Information citation with URL

x. Your country’s Hofstede M/F score and the U. S. M/F score
Information citation with URL

y. Your country’s Hofstede LT/ST score and the U. S. LT/STscore
Information citation with URL
Part II: Evaluation of current status of .
Answer the following questions about your chosen country in narrative form. For each of the questions, you must write a minimum of a two paragraph analysis.
a. What is the current status of your chosen country in the world marketplace? Support your answer with research.
Information must include in-text citations.
b. What is the ease of doing business in your chosen country? Support your answer with research.
Information must include in-text citations.
c. Are other countries wanting to invest in your chosen country? Why or why not? Support your answer with research.
Information must include in-text citations.
d. What do you see as the future of your country in the world marketplace? Support your answer with research.
Information must include in-text citations.
Bibliography
Cite all sources referenced in part I and II of your paper in MLA format.

Provide a step-by-step detailed account of how you accomplished one of your PowerBI or Excel visuals (choose the one you found most challenging).

Assessment Task You are required to take two datasets from https://www.who.int/data/gho and create a dashboard that will be useful to Dublin Business School.
Part 1: Power BI and/or MS Excel

1. Create a well-designed dashboard, adhering to principles of good dashboard design. Your  dashboard should include a minimum of:
a. 3 Charts b. At least 2 cards and c. A map based upon what will add the most value to a business. There is a map option in  MS Excel which you can try.

d. Marks will be awarded for complexity, e.g. heat maps or multiple datasets.
(50 marks)
Notes: Due to the unforeseen circumstances students now have the option to create the dashboard using either Power BI or MS Excel, or a combination of both.  For Power BI – use the online version – instructions are now on Moodle.  For MS Excel – students may use Pivot charts.
B8IS100 (Maria Barry)

 For the map…either create a map in PowerBI or there is a feature in Excel called ‘3D Map’. Follow the instructions on Excel/Microsoft.
 If using a combination of both, ensure you copy the Power BI visuals into Excel and submit the Excel file along with the written report.
Part 2: Written Report 3. Prepare a written report in Word format containing the following details: a. Outline any data cleansing you carried out – ensure you name the tools used (e.g. Excel, SQL or PowerBI) and state the reason for each change you made to the data.
(10 marks)

b. Report your findings/insights of the dataset given in Part1. Identify 3 separate findings from any of the datasets provided. Explain why each is interesting/significant and suggest possible causes/reasons/uses of this data. (30 marks)

c. Provide a step-by-step detailed account of how you accomplished one of your PowerBI or Excel visuals (choose the one you found most challenging). (10 marks)

d. In the appendices, include a copy/screenshot of your PowerBI report dashboard.

Marking scheme Marks
1. Dashboard 50
2. Written Report
a. Details of data cleansing work carried out. 10
b. Quality of data insights. 30 B8IS100 (Maria Barry)

c. Step by step details of how you achieved the most complex  visual.

✓ When finished submit a copy of your files into the relevant folder on Moodle. You must also keep the original copy of your assignment on your own device.

How should governments in advanced industrialized countries respond to the rise of automation?

Choose ONE of the following essay questions:

  1. Can boom and bust cycles be prevented in capitalist systems?
  2. To what extent are oligarchy and democracy compatible?
  3. “Climate change is a global problem, so only global solutions will work to prevent it.”

Discuss.

  1. Should we be worried about the potential for overpopulation?
  2. “Class struggle is being replaced by inter-generational struggle.” Do you agree?
  3. How new are ‘New Wars’?
  4. Has globalization made cities more or less important?
  5. How should new technologies be regulated? Answer with specific reference to two of the following technologies: food biotechnologies, reproductive technologies and technologies of human enhancement.
  1. How should governments in advanced industrialized countries respond to the rise of automation?

Analyze the usefulness of resources to the role group responsible for implementing quality and safety improvements.

This is a continuation of the assessments you worked on medication errors. In this is assignment you must pick 3 or 4 subcategories for eg showing ways to reduce medication errors, causes for errors, error reporting.
For each sub categories if its 4 you choose 3 sources for each subcategory and summarize them. If your pick 3 subcategories like the one mentioned above then you choose 4 sources and site. No matter the choice it needs to equal to 12 sources used equally.

In the instructions that i have attached, the professor gives an example of what the paragraph should say for each article (highlighted in green). i have also attached a sample from another student and you can follow the same subcategories as long as they apply to medication errors. The paper does not have to be that long. the paragraph summarizing the article should include the following :
• Identify necessary resources to support the implementation and continued sustainability of a safety improvement initiative.
• Analyze the usefulness of resources to the role group responsible for implementing quality and safety improvements.
• Analyze the value of resources to reduce patient safety risk.
• Present compelling reasons and relevant situations for use of resource tool kit by its target audience.

The sample highlighted in green and student sample should help guide you. Again each article summarized can be a paragraph as long as it answers what the professor wants.

Explain why additional funding for SCDC security initiatives is a wise investment for South Carolina.

Assignment: Essay 9010SWA200329 Why Allocating Additional Funding to the South Carolina Department of Corrections is STILL a Smart Investment for South Carolina Length: 6 pages (NOT including Title and Reference Pages) Spacing: Double-spaced Style:

Sources Needed:
APA Use page numbers in citations. Must include required sources; can include additional as desired, but must include all provided DO NOT FALSIFY CITATIONS; use page numbers within the in-text citations.

Required Sources:
 Waldron Article  Price of Prisons  Ch 5 Mikesell, Fiscal Administration 10ed  SC Budget Information (4 files)  SCDC News Information.

Additional Optional Sources Provided:
 Ch 6 Mikesell , Fiscal Administration 10ed  Ch 7 Mikesell, Fiscal Administration 10ed  Additional Articles.

1. Read Waldron Article as a basis/guide for the paper.

2. Review SC budget information provided and Price of Prisons comparison with other states.

3. Review the additional articles and information provided since the publishing of Waldron’s article.

4. Header: Introduction (1 page) Summarize Waldron’s relevant points in order to build upon them.

5. Header: SCDC Budget Analysis (2 pages) Analyze the funding for the Department of Corrections. Be sure to reference Chapter 5 of Mikesell at least.

6. Header: Justification for Allocation (3 pages) Explain why additional funding for SCDC security initiatives is a wise investment for South Carolina.

7. References

Is the sample size appropriate and, where applicable, justified (e.g. aware of concept of statistical power?)

POSTER PRESENTATION

Some factors that you should consider when preparing your poster are given below.

Title:

  • Does the title suitably reflect the proposed research?

Introduction, Aims and Objectives:

  • Is rationale clear, concise?
  • Is there suitable justification for the relevance of the study, and has sufficient background information been provided?
  • Have you investigated whether similar studies have already been published? (including previous research projects) – if yes, what new elements does this study merit to advance the work of this previous research?
  • Have a few key references for both methods justification and comparison or advancing of current evidence been cited?
  • Has a clear aim or question been identified?
  • Does it link with the project’s title?

Methods

  • Is there a clear description of the research design? e.g. using a flow diagram
  • Is it clear whether the study is a validation or an intervention study or elements of both?
  • How many participants have been proposed? and why?
  • Is the sample size appropriate and, where applicable, justified (e.g. aware of concept of statistical power?)

General participant issues

  • What will be the method(s) for identifying and recruiting potential participants?
  • From where, when and what type (age, gender, group) will the participants be recruited?
  • What selection or recruitment strategies will be employed?
  • If different groups (e.g. control or intervention or compared condition) are required.
  • How will they be allocated to those groups? e.g. randomisation; or pre-selected (e.g. gender, age, screened or assessed/tested Specific needs and considerations for the well-being and including of participants
  • Any potential benefits and risks of participation?
  • Is there clear justification for their inclusion and exclusion criteria?

Ethics and Confidentiality

  • Is there consideration of the potential ethical issues related to participation in the study?
  • How will informed consent will be obtained?
  • Is there sufficient consideration of issues regarding confidentiality: participant integrity; privacy and protection of data?
  • Is there sufficient indication of any special measures to be taken to safeguard the interests of any identified vulnerable groups?

Analysis and production of results and outputs

  • Is there consideration of the methodology for data analysis?
  • Will tests of differences or correlations/relationship measures be applied?
  • Is there consideration of which statistics (e.g. t-Test, ANOVA, post-hoc, correlation coefficient, agreement etc.), will be required to do this?
  • Feasibility – is the study feasible?
  • Has access and use of the data collection tools, equipment, facilities been considered?
  • Has the type of personnel needing to support the study been considered?
  • Have the costs of equipment and resources been considered?
  • Have appropriate time-frames for carrying out the project been considered?

Relevance

  • What is the relevance to practice?
  • Will the study impact on practice in the future?

What can – and do – school counselors do to assure that all children have an opportunity to develop their talents and skills? How can career counselors support adults in transition?

Follow the instructions EXACTLY!!!! Must use the book as one of the references. NO cover page or abstract.

There are two Parts. Answer them separately and label them Part I and Part II

My Career Information:
Age: 12-15 (Summers) Snack Bar at a pool (where I served hamburgers and hot dogs and ice cream, chips, etc.)
Age: 16 – (After School) File Clerk at copper selling office
Age: 16-18 (Summers) Life Guard

INFORMATION ABOUT ME: I didn’t know what I wanted to pursue (counselor) until I was in my 40s.
One of the law clerks that worked in our office at the courthouse with our Judge helped me decide to go to college in my 40s which lead my on the path to wanting to be a counselor.

ANSWER THESE QUESTIONS:
Part I: Describe your own career development from childhood through early adolescence using Super’s, Gottfredson’s, and other relevant theories. When did you know what you wanted to pursue? Who influenced you? What major turning points can you remember? Make sure you address role salience, work salience, and vocational self concept.

Part II: This week’s readings have a developmental theme including the ways in which Super applies his theory to adult development and choices, theories of transition, and – to use Gottfredson’s concepts – circumscription and compromise. In what way do people’s values, social expectations. stereotypes, and discrimination contribute to people’s career choices and development? What can – and do – school counselors do to assure that all children have an opportunity to develop their talents and skills? How can career counselors support adults in transition?