Category: Financial Management

Collect the daily stock prices over the past year from Yahoo! Finance for SPY, which is the symbol for the exchange traded fund that attempts to mimic the S&P 500 index, which is often used as the proxy for the market portfolio, and two other stocks of your choice that have been publicly traded firms for at least one year. Follow the guidelines in the “Obtaining Historical Returns from Yahoo Download Obtaining Historical Returns from Yahoo” document.
Use the Excel file I posted called M5 Project 1 Excel Class Download M5 Project 1 Excel Class to calculate the same statistics. See the formulas in the cells as a guide.
Better yet, try to match your return cells with my return cells so that everything automatically populates.
Follow the “Obtaining Historical Returns from Yahoo Download Obtaining Historical Returns from Yahoo” file to see what I mean by this.
Example: M5_Project_1_Excel_Solved.xlsx
Discuss your findings. This should include:
A discussion of the main statistics, such as
the expected return for each stock,
the standard deviation for each stock, the expected return of the portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%) provided in the sheet,
the standard deviation for each portfolio of the two stocks you selected using the various percentages allocated to each (50%-50%, 75%-25%, 25%-75%),
the beta of each stock,
the beta of a portfolio of the two stocks using the percentages allocated to each (50%-50%, 75%-25%, 25%-75%).

the paper need to be edited throughly to follow proffessional way of writing research the three parts need to be edited abstract, background of the study, problem statements and objectives..
be mindful of the findings to match with your correction.
also the conceptual framework and the way of presenting the findings according to regressinal analysis model.. the work is too long unecesarrily so shorten it.. i upload also the previous comments from supersors befor this (final revise )which you have to work on it work please take a look and respond them..
finaly be free to add anything you think will improve this work

the paper need to be edited throughly to follow proffessional way of writing research the three parts need to be edited abstract, background of the study, problem statements and objectives..
be mindful of the findings to match with your correction.
also the conceptual framework and the way of presenting the findings according to regressinal analysis model.. the work is too long unecesarrily so shorten it.. i upload also the previous comments from supersors befor this (final revise )which you have to work on it work please take a look and respond them..
finaly be free to add anything you think will improve this work

Dear Ladies and Gentlemen:
After you drew an ‘Org Chart’ in Term Project #1 (which fulfilled SLO#1 and CLO#1 & 4), and wrote Job Descriiption with competencies and training requirements in Term Project #2 (which fulfilled SLO#1 & 2, as well as CLO# 2, 4, 5, 6), you are now demonstrating your full achievement of SLO#1 and CLO#7 by managing a healthcare foodservice department’s finances in Term Project #3.
Term Project #3 fulfills SLO#1 & 2, as well as CLO# 2, 4, 7, and is worth up to 60 points for the complete and comprehensive solutions of the given budgetary and financial challenges given below. In order to assist you with this task, you are given several documents typical of a healthcare provider organization to review.
As you complete this task, please keep our Student Learning Outcomes and Course Objectives in mind
SLO#1 – Demonstrate basic knowledge of lines of authority and levels of responsibility in foodservice
SLO#2 – Demonstrate an understanding of the process of receiving food from delivery through preparation to service
CLO# 2 – Appraise timesheets, payroll and other employee records including forms typical of a health care provider organization
CLO# 4 – Assess staffing, labor policies, wages, security, employee services and benefits using evaluation strategies typical of a health care provider organization
CLO# 7 – Analyze a healthcare facility’s budgetary needs and employ sound financial reasoning while keeping food quality and customer satisfaction in mind

Introduction and Overview
Based on your textbook readings and after reviewing the Term Project (descriiption, incl. grading criteria)Links to an external site. page once more, please imagine that you are the Dietetics Services Supervisor (DSS), (or Certified Dietary Manager [CDM] or Registered Dietetic Technician [DTR]) employed as the full-time Director of Dietetic Services at Yellow Pines Healthcare, a 99-bed licensed Skilled Nursing Facility (SNF). Yellow Pines Healthcare has an average occupancy of 94 residents; approximately 90% of the residents are consuming daily meals and nourishments (including snacks and nutritional shakes)*.
Your Dietetics Services Department is staffed with the following full-time and part-time personnel: you are the full-time Director of Dietetic Services, there are also 3 cooks, 1 prep-cook, 3 diet aides, 2 dishwashers, and 1 person that helps with deliveries and other tasks as needed. Please review the attached staffing schedule for detail: YPHC Dietary Schedule SEPT 2020.pdf Download YPHC Dietary Schedule SEPT 2020.pdf.
However, healthcare facilities are not always full during the entire year as the census often fluctuates (some patients are discharged or transferred, other are newly admitted). As you learned in our textbook, healthcare facilities have budgets; those are often set under consideration of the ‘maximum of licensed beds’. Because Yellow Pines Healthcare is licensed for 99 beds, most corporations will establish budgets based on a full census of 94. If the resident census falls below 90, the reimbursement (or payments for services) will fall below projected income budgets. In order for facilities to stay within budget and avoid excess spending, wages are usually the first and highest cost to be reduced. Below are the current wages for your department staff:
Food Service Director $35.00 per hour @ 8 hours $280
AM Cook FT $17.50 per hour @ 8 hours $140
PM Cook FT $17.25 per hour @ 8 hours $138
Diet Aide AM FT $15.25 per hour @ 8 hours $122
Diet Aide PM FT $15.25 per hour @ 8 hours $122
Dishwasher AM PT $13.75 per hour @ 6 hours $82.50
Dishwasher PM PT $13.75 per hour @ 6 hours $82.50

Assignment 1:
Assume the current census is 94 residents, whereby 9 residents are exclusively receiving tube feedings (which are supplied by Pharmacy); meaning, only 85 patients are consuming 3 meals and snacks or nutritional shakes per day*; (a) Calculate the Meals per Labor hour, (b) calculate the meals per FTE (full time equivalent), (c) calculate the Labor Minutes per meal, and (d) calculate the labor cost for meals per patient day (PPD). Show your calculations and briefly explain. Worth 20 points.

Assignment 2:
Assume that the census fell to 85 residents (whereby 76 patients are consuming 3 meals and snacks or nutritional shakes per day); the Executive Director ordered that you (as the YPHC Food Service Director) to “Flex” Department Hours. The executive director states the staffing PPD is $10.30. The Food Service Director is salary exempt. Per employment contract, full-time employees are scheduled to work 32 hours or more per week (not counting vacation time). Determine (a) how many hours will be reduced for each shift of the essential workers, (b) which positions will be reduced and to how many hours per day each position will be reduced, (c) calculate the Labor Minutes per meal, and (d) calculate the labor cost for meals per patient day (PPD). Explain and support your findings with credible references. Worth 20 points.

Assignment 3:
Assume you generated the following Food & Supplies Spending Report Download Food & Supplies Spending Report for YPHC; please review it and consider that the month of December was at full expected census (94 residents, 90% are consuming 3 meals and snacks or nutritional shakes per day). Considering you are the Full-Time Food Service Director, Yellow Pines Executive Director/Administrator states they are renovating the facility during the month of January. With a projected temporary census of 85, you must reduce your spending accordingly with the facilities GL (General Ledger). Figure that your December spending was exactly at budget. Now, (a) you have to project (or ‘forecast’) your food spending for the month of January, and (b) calculate your projected Food PPD . Please show your work and explain your results. Worth 20 points.

Each of the 3 assignments is worth 20 points (if your results are correct, and you show your calculations as well as explain your results), for a total of 60 points if submitted by the due date.
Instructions
Please create a Word.doc(x), and provide ‘numbered answers’ as shown in the example below:
1.a. Calculations:
Explanation:
1.b. Calculations:
Explanation:
1.c. Calculations:
Explanation:
1.d. Calculations:
Explanation:

Once you checked your work for accuracy and completion, please submit it here into the assignment.
* please refer to page 386 in your textbook for ‘Meal Equivalents’, and assume that breakfast has a meal equivalent of 0.67 and nourishments (a.k.a snacks or nutritional shakes) have a meal equivalent of 0.33.

This assignment has to do with ABC analysis in inventory categorization. Questions in the Skopos Inventory guideline need to be answered in the provided excel sheet. I am attaching the lecture notes which provide more context and 2 audios that need to be listened to for context and support in analysis.

This assignment has to do with ABC analysis in inventory categorization. Questions in the Skopos Inventory guideline need to be answered in the provided excel sheet. I am attaching the lecture notes which provide more context and 2 audios that need to be listened to for context and support in analysis.

*Judge the reasonableness of results using estimation, logical processes, and a proper understanding of quantity.
• Differentiate between simple and compound interest and analyze the long-term effects of saving, investing, and borrowing.
• Analyze civic and/or societal issues and critique decisions using relevant mathematics.

3. Company Situation
Provide an introduction that characterizes the essence of the company situation and sets the stage for the analysis that follows. Calculate the past sales growth rate for the company if there is historical data. If the case has data on historical industry sales, calculate the sales growth rate and determine whether the industry is in the introduction, growth, maturity or decline phase of their life cycle. If there is information such as the revenue of the top 3 competitors for the last few years, combine their sales and calculate the change in sales growth to infer where the industry is in their life cycle. Then discuss this analysis in any of the sections where it is appropriate. Based on the conclusions from the preceding section and the case analysis, determine the stage of the industry life cycle (introduction, growth, maturity or decline). Identify the key company-specific issues with which the companies are dealing.
Financial Analysis. Be sure to distinctly address each of the four areas of financial analysis—profitability, liquidity, leverage and activity—identify each in the topical sentence for that paragraph. See pages 231-232 for the formulas and definitions of the ratios. The financial analysis must be thorough and accurate. Look at trends and compare the company’s performance to industry targets, if available. Evaluate the primary financial indicators, provide supporting data and interpret them to show how they affect the company regarding its present and future strategic performance.
Put the calculations of the ratios in a table in the APPENDIX.
Close this analysis by writing a paragraph that draws conclusion about the company’s overall financial situation, prospects and the impact of its financial condition on its potential strategic plans. The fundamental question you are trying to answer is, “What is the overall financial status of the company now, and what does its current financial status mean for its future strategic success or ability to grow sales?”
Common Errors
Incorrect computation of the ratio.
Incomplete computations of the ratios (trends, etc.).
Focusing on the definition rather than the strategic impact that the ratio implies.
SWOT Analysis. Discuss each of the four legs of the SWOT fully—strengths, weaknesses, opportunities and threats in this section. Be clear that events are not the same as attributes. SWOT is about attributes, not events. An attribute describes the characteristics of the company. For example, you might say, “The company isn’t profitable.” True, but what is its weakness attribute? What characteristics of the company drives its lack of profitability? A better way to express it is, “The company has not managed costs in its value chain. This is supported by the sustained increase in cost of goods sold accompanied by flat sales reflecting a weakness that must be overcome to improve profitability.”
Summarize the SWOT analysis in a one-page table and place in the APPENDIX. Discuss the table in the body of the paper.
SWOT is the “integrator” of the analysis. SWOT draws from the findings resulting from the Macroenvironment, Industry Analysis, and Financial Analysis. No new information is provided. Use the terminology in the previous sections. For example, “An opportunity identified in the discussion of the competitive analysis . . .” Another example, “The dumping of foreign products into this industry, identified earlier as a driving force, is a significant threat to incumbents.”
Common Errors
Not linking the findings to the previous analysis through the use of common terminology.
Omitting important findings discussed previously.
Focusing on historical events rather than inherent strengths and weaknesses.
Not recognizing obvious strengths and weaknesses in the business functions: financial analysis, marketing (product, price, place and promotion), human resource management, operations, etc.
excel sheet

The Investment Project involves research and analysis in order
to assess the characteristics and financial condition of actual
companies and industries for the purpose of investing. Each
student will be actively involved in the decision-making and
analysis of companies whose stock is publicly traded.

Write one paragraph discussing the interest rate risk exposure for your BHC. Is it asset or liability sensitive at the conclusion of each year? What are the implications of the changes occurring across the years? Using the following equation, discuss the effects on net interest income if market interest rates increase or decrease by one full percentage point. All needed information can be found in the attached files.