Create a report in which you examine a major public company and provide a recommendation on how shareholder value could be enhanced, with resulting impact on the firm's capital structure and stock value. Introduction This portfolio work project will illustrate what potential financial strategies can be employed by firms to impact company valuation and how they should be financed. This is a relevant concept for both large and small companies. You will have a chance to apply the skills expected of an MBA graduate; from the financial management perspective, you should be able to:  Utilize financial strategies that will increase the price of stock.  Calculate WACC and capital structure. Evaluate how financial strategies impact the capital structure. This assessment requires you to examine a major public company and provide recommendations on how shareholder value could be enhanced, with resulting impact on the firm’s capital structure and stock value. You will estimate the firm's current WACC.  Scenario Fast forward to when you have successfully completed the MBA program. You are now a Chief Financial Officer of a large, publicly traded company at (go ahead and insert your dream company here). Using your dream company, conduct extensive research on the current situation of the company using resources like the Wall Street Journal, Bloomberg, GuruFocus, Yahoo Finance, EDGAR, and the Capella library. As the CFO, you have been given a project by the CEO and Board of Directors to prepare a report on ways to financially engineer the company to increase stock price.  From the company’s website, go to the financial section and examine the financial statements (income statement, balance sheet, and statement of cash flows) and 10K and 10Q reports, and conduct a financial ratio analysis including the following: current ratio, debt to equity ratio, return on equity (ROE) ratio, dividend yield, earnings per share (EPS or the last 4 quarters), price to earnings ratio (P/E), and market to book ratio. Compare these ratios to those of the company's nearest competitor. Assume that the objective of upper management is to maximize shareholder value by increasing the price of the stock. Describe the subjective impacts (threats, opportunities, competitive edge) that are unique to the firm and its industry that you found in your research. Based on the ratio results and research, from the following list of ways to financially engineer an increase in stock price, evaluate each method, examine its pros and cons, and then select the best ways for the firm to increase the stock price. Be as specific as you can by using qualitative assessments without proprietary company information: Capital expenditures—new equipment, plant, machinery, marketing/advertising campaign, computer infrastructure (only choose if your research of the firm has discovered some specific opportunity here). Merger/acquisition of a competitor. Stock repurchases. Dividend policy change—increase, decrease, stock split, stock dividend. Reduction of debt. Expansion into a new geographic market. Introduction of new products/services. Your Role You are the Chief Financial Officer of your selected company.  Requirements The report you submit to the CEO should meet these expectations: Evaluate strategies used to increase stock prices and shareholder value.  Analyze strategies to employ cash to potentially increase shareholder value and the impact on financial risk of the entity, such as capital expenditures, mergers/acquisitions, stock buybacks, dividend increases, reduction of debt, expansion into a new geographic area, and introduction of new projects. Analyze financial statements and ratio analysis to determine the optimal strategies.  Describe the subjective impacts that are unique to the firm and its industry through ratio analysis of the financial statements and qualitative research. Relate the analysis to the strategies. Identify the pros and cons regarding each strategy. Use behavioral models and theories to support your analysis and evaluation. Determine the best strategies, and describe how earnings and stock price can be increased by these choices. Comment on how the efficient market hypothesis may impact stock price with the recommendations. Recommend the best strategies to gain the most optimal performance. Provide justification and rationale for your recommendation. Align your recommendation with analysis and data. Provide examples and analysis to defend recommended strategies. Connect the recommendation to methods and models of financing and investing.  Evaluate how the recommendation will be financed and how it will impact the capital structure and the risk of the company and the WACC. Calculate the firm’s current WACC and capital structure (percentage of assets financed by liabilities versus percentage of assets financed by shareholder equity).   Determine whether the firm has sufficient finances to fund your recommendation internally (with cash) or if it needs to raise funds externally. If external financing is required, decide between common stock and debt (bonds) and explain the rationale for your decision. Examine how your strategy recommendation will potentially impact WACC, capital structure, the overall risk of the company stock, and the effect on the stock price.

Hyde Pfiefer, a retired 70-year-old German American, has lived in the United States for the last 50 years. A widower of 5 years, Mr. Pfiefer prepares his own meals following his wife’s recipes from the old country. Nine months ago, Mr. Pfiefer was told that his cholesterol is elevated, and he was instructed about a low-fat diet. His most recent test results show his values to be unchanged.Discuss the meaning of food in the German culture.Using the predominant health beliefs of people of German ancestry, how might you help Mr. Pfiefer reduce his cholesterol level?Submission Instructions:Your initial post should be at least 500 words, formatted and cited in current APA style with support from at least 2 academic sources.

Project Deliverable 3: Database and Data Warehousing Design Due Week 5 and worth 110 points This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment. One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company. Section 1: Design Document Write a four to six (4-6) page design document in which you: Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to. Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes. Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of your E-R Diagram. Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.