Create an 8-10 page 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.

GETTING STARTED Open the file IL_EX16_1a_FirstLastName_1.xlsx, available for download from the SAM website.Save the file as IL_EX16_1a_FirstLastName_2.xlsx by changing the “1” to a “2”.If you do not see the .xlsx file extension in the Save As dialog box, do not type it. The program will add the file extension for you automatically.With the file IL_EX16_1a_FirstLastName_2.xlsx still open, ensure that your first and last name is displayed in cell B6 of the Documentation sheet. If cell B6 does not display your name, delete the file and download a new copy from the SAM website. PROJECT STEPS Katherine owns two fast food restaurants, and she plans to invest in the one that is more profitable. Her Excel worksheet shows detailed financial information for each location. Enter the text Restaurant Comparison in cell A1.Enter the text Profit Analysis in cell A2. In cell A3, change the text “2015” to 2018 so that the cell contains the text “Pizza Palace 2018-2020 Profit”.In cell D10, enter the value 38900.Use the Fill Handle to fill the range E6:E10 with the formula in cell E5.In cell B11, enter a formula that uses the SUM function to total the range B5:B10. Use the Fill Handle to fill the range C11:E11 with the formula you created in cell B11.In cell A13, insert the text 2018-2020 Profit after the word “Shack” so that the cell contains the text “Burger Shack 2018-2020 Profit”.Enter the information shown in Table 1 below into the range B20:D20.Katherine wants to determine the total profit from each type of burger sold between 2018 and 2020. In cell E15, enter a formula that uses the SUM function to total the values in the range B15:D15.In cell B21, enter a formula that uses the SUM function to total the range B15:B20. Use the Fill Handle to fill the range C21:E21 with the formula in cell B21.Katherine wants to know the difference in total profits between her two restaurants.Hide the gridlines for the Profit Analysis worksheet.Change the orientation of the worksheet to Landscape. Select the Profit Analysis worksheet. Add a header to the worksheet by entering the text Restaurant Comparison into the center section of the header. Click on any cell and switch back to Normal view. Table 1: Values for the Range B20:D20 Cell B20 C20 D20 Value 25200 26410 25780 Use the Fill Handle to fill the range E16:E20 with the formula in cell E15. In cell B25, enter a formula that subtracts the value in cell B21 from the value in cell B11. Use the Fill Handle to fill the range C25:E25 with the formula in cell B25. Your workbook should look like the Final Figure on the following page. Save your changes, close the workbook, then exit Excel. Follow the directions on the SAM website to submit your completed project.

Part 1In a single Word document, prepare a professional trend review that would help prepare you for your professional future.A title pageTable of contentsAn official professional autobiographyA 250-word paper describing your career goals based on current trendsSummary including how the courses taken will help prepare you for current professional trendsClick here to download CTU Career Services Resources.Each student at Colorado Technical University has their own unique career needs. Whether you are just starting out on your chosen career path, advancing within your current career, or changing careers altogether, Career Services at CTU Online can assist you with your career planning and job search. They can help you identify the talents, skills, knowledge, and experience you could bring to a prospective employer, as well as help you to better understand your interests and how your personality type relates to work. They can also help you devise a career action plan, identify possible job opportunities, and provide feedback on how you can more effectively position yourself as a candidate for these opportunities. Contact CTU Career Services at 866-8136-1836 or careerservices@ctuonline.edu to connect with your dedicated career coach. CTU Career Services can also help you with the following: Build your professional brand, establish your digital identity and social media presence.Learn how to use LinkedIn® and other resources to develop your professional network.Craft a resume that effectively promotes your qualifications and speaks to the needs of your target employer.Enhance your interviewing skills by conducting mock interviews.Network with employers through CTU Career Snapshots and CTU Employer Profile webinars.Access potential career opportunities from employers who have posted available positions within CTU’s internal job board...and more!Deliverable for part 1: A Word document of at least 3-5 pages.